Lead BI Engineer – Data Warehousing & AI Analytics

Oklahoma AG; Oklahoma City (OK); On-site; USD 90,000 - 130,000; Full time

Job summary

The Administrative Office of the Courts in Oklahoma City is seeking a Business Intelligence Engineer to develop and operate enterprise BI solutions, ETL pipelines, data warehouses, and dashboards. You will map data, validate quality, and collaborate with the data systems team to support court operations.

The role requires deep MS SQL Server experience, Azure data tools, and strong governance. This is an opportunity to apply AI-assisted data mapping to ensure accurate reporting while maintaining

Qualifications

• 10+ years hands-on RDBMS administration and development.
• 5+ years leading BI platforms with Microsoft technologies.
• Experience with AI-assisted data mapping and quality checks.
• Strong data governance and security practices.

Responsibilities

• Analyze source and target data structures to map and transform data.
• Build and maintain ETL pipelines with SQL, SSIS, Azure Data Factory.
• Develop dashboards, reports, and analytical models.
• Ensure data quality, profiling, deduplication, and validation.
• Support migrations, dry runs, cutovers, and post-deployment stabilization.
• Maintain data dictionaries, lineage, and documentation.

Skills

SQL

ETL development

Power BI

Azure Data Factory

Python

Data modeling

Data governance

AI tools for data quality

Performance tuning

Security/compliance

Education

Bachelor's degree in Computer Science / Information Systems

MCSA: SQL 2022+ Database Administration

Microsoft Certifications or equivalent

Tools

SSIS

Azure Data Factory

Power BI

SSMS

GitHub / Azure DevOps

Job description

The Administrative Office of the Courts in Oklahoma City is seeking a Business Intelligence Engineer to develop and operate enterprise BI solutions, ETL pipelines, data warehouses, and dashboards. You will map data, validate quality, and collaborate with the data systems team to support court operations.

The role requires deep MS SQL Server experience, Azure data tools, and strong governance. This is an opportunity to apply AI-assisted data mapping to ensure accurate reporting while maintaining