Business Intelligence Engineer

Bulletin

An equal opportunity employer fostering a workforce that embraces and reflects

the rich diversity of Los Angeles County

Business Intelligence Engineer

$121,812 - $150,912 Annually

Insurance

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

To Learn More, Visit

https://www.lacoe.edu

Online applications

Must Be Submitted By

7/22/26

11:59 P.M. (Pacific)

Retirement

PERS Defined Benefit Plan

Paid Time Off

24 vacation, 15 holidays, and 12 illness days.

Los Angeles County Office of Education (LACOE) is seeking highly qualified individuals with a strong background in business intelligence, data warehousing, data mining, Extract, Transform, and Load (ETL) processes, and data reporting to apply for the Business Intelligence Engineer position.

The Business Intelligence Engineer designs and develops data modeling for the data warehouse; monitors the Extract, Transform, and Load (ETL) processes; and provides technical support for the systems and Business Intelligence (BI) tools.

The Well Qualified Candidate Will Possess the Following

Knowledge

• Database programming languages
• Relational database SQL and non-relational database SQL
• Business Intelligence (BI), data lake, and data warehousing concepts and tools
• Components of business intelligence semantic model
• Databases, data queries, data mining, data acquisition, and ETL strategies and tools
• Data analysis and root cause analysis
• Software engineering principles and skills working on Unix/Linux/Windows Operating systems, Version Control, and Office software
• Data platform support in cloud platforms such as Microsoft Azure, Amazon Web Services, Google Cloud, etc.
• Reporting analytics and data visualization tools
• Principles and concepts of data design patterns for organizing data lakehouses such as Medallion Architecture

Competencies:

• Critical Thinking – Analytically and logically evaluating information, propositions, and claims
• Professional & Technical Expertise – Applying technical subject matter to the job
• Action & Results Focus – Initiating tasks and focusing on accomplishment
• Adaptability – Responding positively to change and modifying behavior as the situation requires
• Attention to Detail – Focusing on the details of work content, work steps, and final work products
• Innovation – Imagining and devising new and better ways of doing things
• Oral Communication – Engaging effectively in dialogue
• Customer Focus – Attending to the needs and expectation of customers
• Teamwork – Collaborating with others to achieve shared goals
• 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 objective
• Cultural Proficiency – Modeling communications and interactions that respect and include all individuals and their languages, abilities, religions and cultures

Required Education and ExperienceEducation: Bachelor’s degree with major coursework in computer science, data science, management information system, 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 business intelligence data and reporting experience including three years in designing and implementing data warehouses, including data mining, ETL, and BI.

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.

Hybrid remote schedules may be available.

Selection ProcessCandidates who meet the minimum requirements above will be invited to participate in an examination that may consist of a written multiple-choice exam, performance exam, and a structured interview.

Contact

For information about the examination process you may send an e-mail to

Hannah Gia at [email protected]

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

For complete application information, please go to https://www.lacoe.edu/pc

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 https://lacoe.edu/jobs/hr/classified. 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 562.803.8360 as early as possible.

This examination is authorized as Open, open to the public.

Recruitment ID: 27-LAC968

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. 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. 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.

• Yes
• No

02

What is your highest level of education?

Please Note: Proof of education will be required. Degrees must be earned from an institution of higher learning recognized by the Council for Higher Education. Foreign degrees and credit units require translation and equivalency established by an agency recognized by the Commission on Teacher Credentialing.

• No education
• High School Diploma or GED equivalent
• Some college coursework but no degree
• Associate's Degree
• Bachelor's Degree
• Master's Degree
• Doctorate Degree

03

Please list the field in which you obtained your degree. If no degree, list "n/a".

04

How many years of experience do you have in business intelligence data and reporting?

• No experience
• Less than 1 year
• 1 year but less than 2 years
• 2 years but less than 3 years
• 3 years but less than 4 years
• 4 years but less than 5 years
• 5 or more years

05

Please describe your experience in business intelligence data and reporting. For each related experience, please include: a) Your job title(s) b) Name of the organization(s) c) Job duties/responsibilities related to contract administration, and purchasing for a wide variety of services and/or materials d) Length(s) of employment If no experience in this area, list "n/a".

06

How many years of experience do you have designing and implementing data warehouses, including data mining, ETL, and BI?

• No experience
• Less than 1 year
• 1 year but less than 2 years
• 2 years but less than 3 years
• 3 years but less than 4 years
• 4 years but less than 5 years
• 5 or more years

07

Please describe your experience in designing and implementing data warehouses, including data mining, ETL, and BI. For each related experience, please include: a) Your job title(s) b) Name of the organization(s) c) Job duties/responsibilities related to contract administration, and purchasing for a wide variety of services and/or materials d) Length(s) of employment If no experience in this area, list "n/a".

• Required Question