Senior BI Engineer: Court Data & Analytics Leader

677 SUPREME COURT; Oklahoma City (OK); On-site; USD 95,000 - 140,000; Full time

Job summary

677 SUPREME COURT, Administrative Office of the Courts, seeks a self-motivated Business Intelligence Engineer to lead data migration, ETL, and BI analytics. You will build and maintain data warehouses, dashboards, and reports using MS BI technologies, aligning with governance and security requirements.

The role emphasizes AI-assisted data mapping and validation, collaboration with the Data Systems Manager, and ensuring data integrity across environments in a ...

Qualifications

• Ten (10+) years hands-on administration/development experience with MS SQL Server, PostgreSQL, Oracle Database, or equivalent RDBMS.
• Five (5+) years hands-on lead-role experience designing, developing, deploying, and maintaining a BI platform using Microsoft technologies (MS SQL Server, SSIS, SSAS, SSRS, Power BI).
• Three (3+) years utilizing agentic artificial intelligence analyzing data.

Responsibilities

• Develop and maintain ETL pipelines using SQL, SSIS, Azure Data Factory (ADF) or equivalent tools.
• Design, develop, deploy, and maintain data warehouses, data marts, and BI solutions using Microsoft BI technologies.
• Develop dashboards, reports, analytical models, SQL queries, stored procedures, and data visualizations.
• Monitor data quality, governance, and security across development, testing, staging, and production environments.

Skills

SQL

ETL development

Data warehousing

BI platforms

Power BI

Azure Data Factory

AI for data quality

Data modeling

Data governance

Python

Education

Bachelor's degree in Computer Science/Information Systems, math, engineering, or related technical field

Tools

MS SQL Server

SSIS

SSAS

SSRS

Power BI

Azure Data Factory

Master Data Services

Data Quality Services

Azure DevOps

GitHub

PostgreSQL

Oracle Database

Job description

677 SUPREME COURT, Administrative Office of the Courts, seeks a self-motivated Business Intelligence Engineer to lead data migration, ETL, and BI analytics. You will build and maintain data warehouses, dashboards, and reports using MS BI technologies, aligning with governance and security requirements.

The role emphasizes AI-assisted data mapping and validation, collaboration with the Data Systems Manager, and ensuring data integrity across environments in a ...