Business Intelligence Architect Job in Downey, CA

Salary : $117,060.00 - $145,020.00 Annually
Location : Downey, CA
Job Type: Open
Remote Employment: Flexible/Hybrid
Job Number: 25-LAC313
Department: Technology Services
Division: Applications Development & Support
Opening Date: 01/23/2025
Closing Date: Continuous

Bulletin
An equal opportunity employer fostering a workforce that embraces and reflects

the rich diversity of Los Angeles County
Business Intelligence Architect$117,060 to $145,020 Annually

Insurance:
Your choice of several medical, dental, vision, and life insurance plans

To learn more, visit:

Online applications
must be submitted by:

Open until Filled
Retirement:
PERS Defined Benefit Plan

Paid Time Off:
24 vacation, 15 holidays, and 12 illness days.
Under general direction, researches, designs, implements, and maintains data architecture for systems and tools that manage various data assets used to support and improve business processes, leverage data, and increase efficiency; and provides strategic oversight and integration across the organization's data management and analytics framework.

The Well Qualified Candidate Will Possess the Following

Knowledge:

Advanced data warehousing concepts, methodologies, and best practices
Business intelligence tools and platforms (e.g., Power BI, Tableau, QlikView)
Data modeling techniques and dimensional modeling
SQL and other relevant query languages
Big data technologies
Data visualization tools and techniques
Cloud computing platforms for BI
Microsoft Power BI for data visualization and reporting
Microsoft Fabric, including its components for data integration, storage, and analysis
Oracle databases, including data extraction and integration techniques
Azure Synapse Analytics and its integration with Microsoft Fabric
Enterprise Resource Planning (ERP) systems
Data Analysis Expressions (DAX) for advanced calculations in Power BI
Data integration and ETL processes
Data privacy regulations and best practices (e.g., GDPR, CCPA)
Machine learning and AI concepts as they apply to BI

Competencies:

Analyzing & Interpreting Data - Drawing meaning and conclusions from quantitative and/or qualitative data
Critical Thinking - Analytically and logically evaluating information, propositions, and claims
Professional & Technical Expertise - Applying technical subject matter to the job
Oral Communication - Engaging effectively in dialogue
Presentation Skill - Formally delivering information to groups
Customer Focus - Attending to the needs and expectation of customers
Involving Others - Engaging others for input, contribution, and shared responsibility for outcomes
Teamwork - Collaborating with others to achieve shared goals
Business Process Analysis - Defining, assessing, and improving operational processes and workflow
Leveraging Technology - Applying technology for improvements in organizational efficiency and effectiveness
Project Management - Planning and tracking projects to ensure they are on-time, on-budget, and achieve their objectives
Cultural Proficiency - Modeling communications and interactions that respect and include all individuals and their languages, abilities, religions and cultures

Required Education and ExperienceEducation: A bachelor's degree with major coursework in computer science, data science, management information system, business administration or other fields closely related to the job requirements of this classification from an institution of higher learning recognized by the Council of Higher Education Accreditation. Foreign degrees and credit units require translation and equivalency established by an agency recognized by the Commission on Teacher Credentialing.

Experience: Five years of experience designing and implementing data warehouse architecture, including the use of relational databases, cloud platforms, and data modeling and visualization tools.

Additional Requirements: A valid California driver's license and the availability of private transportation or the ability to obtain transportation between job sites may be required. Experience with AI/ML applications in BI is preferred.

Hybrid remote schedules may be available. To ensure the health and safety of its staff, LACOE may require employees to provide evidence of full vaccination against COVID-19.

Selection ProcessCandidates who meet the minimum requirements above will be invited to participate in an examination that may consist of a Training & Experience (T&E) evaluation and a Technical Interview.

Contact
For information about the examination process you may send an e-mail to
Lizbeth Valenzuela at

For general inquiries please call (Mon- Fri 8:00 am - 5:00 pm)

For complete application information, please go to

LACOE Personnel Commission, 9300 Imperial Hwy, EC-Annex, Downey, CA 90242
Additional InformationMinimum qualifications must be met by the close of filing date. For more information, please go to For additional information on our testing procedures, please visit Applicant Resources on our website. Selection and promotion are based on a competitive examination process. Candidates who pass all exam parts are ranked according to overall exam score and placed on an eligibility (hiring) list. Vacant positions are filled from the top three ranks. Eligibility lasts for 12 months; however, additional recruitment may occur under a separate bulletin with additional candidates being merged onto the eligibility list. Some positions that involve public contact may require bilingual proficiency for which selective certification may apply (Education Code 45277.5). In addition, the eligibility list resulting from this examination may be used to fill vacancies in related job classifications for which no eligibility list exists (Education Code 45272). Veterans' Credit may be awarded for entry jobs.

Reasonable accommodations in completing an application, testing, and employment are available to individuals with disabilities. If you would like to request an accommodation, please call as early as possible.
This examination is authorized as Open, open to the public.

Recruitment ID: 25-LAC319

This announcement does not constitute an implied contract. Any part of this announcement is subject to change.
Based on full-time assignment:

Although new employees usually begin at the first salary step, advanced salary step placement may be requested
24 vacation days per year
15 paid holidays per year
12 paid sick days annually
Insurance includes health, medical, dental, vision and group life
Retirement CALPERS combined with Social Security, and pre-tax retirement savings account options

01

PLEASE READ THE FOLLOWING STATEMENT:Answer the following questions as truthfully and accurately as possible. You are not expected to answer at the highest level of each of these items to be qualified.The application will be evaluated for minimum qualifications. Your responses to the supplemental questions below may also be used to determine your qualifications beyond the minimum qualification requirements for this classification in a training and experience (T&E) evaluation. Referring to your application/resume, listing "see resume", or incomplete responses will NOT qualify as a response to any question. Questions that are answered in this method will be considered INCOMPLETE and may result in DISQUALIFICATION.You are required to answer ALL of the supplemental questions as truthfully and accurately as possible. Your responses to these questions are subject to verification and may be assessed in subsequent examination parts. All experience, education, training, and certification must be included in your application in order to be considered. Any sign of deliberate misinformation or intentional exaggeration will result in disqualification from this examination process and possible bar from future employment opportunities with the Los Angeles County Office of Education (LACOE).Select "Yes" if you have read, understood, and agree to the above statements.Select "No" if you have read, understood, and DO NOT agree with the above statements and voluntarily withdraw your application for this position.

02

What is your highest level of education?You must attach a copy of your degree or transcripts to your application for verification purposes. Failure to do so may cause the disqualification of your application for this process.Degrees must be from an institution of higher learning recognized by the Council of Higher Education Accreditation. Foreign degrees and credit units require translation and equivalency established by an agency recognized by the Commission on Teacher Credentialing.