Business Intelligence Engineer

With a commitment to the employee experience, operational excellence and the customer experience, the Orange County Clerk of Courts has an opportunity for a talented individual to join our award-wining 400+ employee organization as a Business Intelligence Engineer. Known as the “information hub of the justice system”, the Orange County Clerk of Courts has a strong culture rooted in work-life balance, professionalism, trust, collaboration and employee wellbeing. We are looking for someone who can thrive in an efficient and customer-oriented environment and contribute to our success.

The highly qualified Business Intelligence Engineer we seek would have:

Ability to design, create and maintain SQL Server Analysis Services Cubes (SSAS) tabular model.
Database project lifecycle development using SQL Server Data Tools in Visual Studio.
Source control using Visual Studio and GitHub.
Understanding of data warehouse dimensional modeling techniques and star schema design. (Kimball Methodology preferred).
Understanding of ETL strategies for loading slowly changing dimensions of type 1 and type 2.
Ability to design, create and maintain SQL Server Master Data Services models.
Expert level in TSQL queries optimization for using Power BI in direct query storage mode.

Requirements for the Business Intelligence Engineer:

A Bachelor’s degree in Science, Computer Science, Statistics, Mathematics, or a directly related area.
Minimum of five (5) years of overall IT experience to include three (3) years of experience in a direct role as a Data Engineer.

For consideration and more detailed information about the Business Intelligence Engineer position please visit our website at www.myorangeclerk.com/careers to apply.

At OCCC, equal talent will always get equal opportunity.

DFWP / Background Checks Required.

Orange County Clerk of Courts jobs

Business Intelligence Engineer