Business Intelligence Engineer

State of Oklahoma•Oklahoma City, OK

2d•Onsite

About The Position

The Administrative Office of the Courts is seeking a self-motivated Business Intelligence Engineer to provide development and operational support for its information systems. Reporting to the Data Systems Manager, the position performs data migration and integration, administers an enterprise reporting platform, and delivers analytics. The role combines enterprise ETL engineering with structured reporting and data governance. Generative and agentic AI capabilities are used to assist with data mapping and transformation, identify data quality issues and anomalies, and generate and validate reports and analytics. The position designs, develops, deploys, and maintains secure, highly available data warehouses, data marts, and BI solutions using Microsoft BI technologies. It builds and maintains ETL pipelines, database objects, dashboards, reports, analytical models, and visualizations; supports migration planning and deployment; monitors database performance and security; and maintains data documentation and governance practices. The role also supports database administrators and application developers and ensures data integrity, confidentiality, retention, and compliance with MIS standards and court privacy requirements. This is an in-person position in a professional office environment. AOC offices are open Monday through Friday, 8:00 AM to 5:00 PM. The role may require travel for Judiciary duties, including state Judicial events and national industry conferences, and MIS employees are expected to be assigned on-call in support of judicial operations. Salary is commensurate with education and experience. The position is open until filled and requires a criminal background check. Applicants must be authorized to work in the United States without current or future employment-based visa sponsorship.

Requirements

At least 10 years of hands-on administration or development experience with MS SQL Server, PostgreSQL, Oracle Database, or an equivalent RDBMS.
At least 5 years of hands-on lead-role experience designing, developing, deploying, and maintaining a BI platform using Microsoft technologies, including MS SQL Server, SSIS, SSAS, SSRS, Master Data Services, Data Quality Services, or Power BI Enterprise.
At least 3 years of experience utilizing agentic artificial intelligence to analyze data.
Strong proficiency in SQL, database development and administration, performance tuning, troubleshooting, and security.
Experience with ETL development, data migration, data warehousing, BI platforms, and large relational and dimensional data models.
Ability to use AI tools to improve data quality; develop and troubleshoot transformations using SQL, Python, Power Query/M, and DAX; perform exploratory and statistical analysis; and enhance data modeling, visualization, and reporting.
Knowledge of conceptual, logical, and physical data modeling, including indexing, aggregation, and query optimization.
Experience with version control and development collaboration tools such as Azure DevOps or GitHub.
Strong analytical, problem-solving, documentation, and communication skills, including the ability to translate technical findings into clear business insights.
Ability to work independently and collaboratively, demonstrate initiative, and adapt to changing priorities.
Ability to understand complex, multi-system data environments and design scalable solutions for current and future organizational needs.
Advanced mathematics or statistical analysis skills.
Must be authorized to work in the United States without the need for employment-based visa sponsorship now or in the future.
Ability to perform the listed responsibilities and physical demands, with or without accommodation.

Nice To Haves

Bachelor’s degree from an accredited college in Computer Science/Information Systems, mathematics, engineering, or a related technical field.
Microsoft Certifications or equivalent.
MCSA: SQL 2022+ Database Administration.

Responsibilities

Analyze source and target systems, data structures, constraints, and business requirements to develop data mappings and transformation logic.
Develop, execute, and maintain ETL pipelines using SQL, SSIS, Azure Data Factory, or equivalent tools to migrate data and populate data warehouses and data marts.
Perform data profiling, cleansing, deduplication, quality checks, reconciliation, and pre- and post-migration validation, including identifying county-specific anomalies.
Support migration planning, dry runs, cutovers, incremental data loads, rollback procedures, and post-deployment stabilization.
Design, develop, deploy, and maintain secure, highly available data warehouses, data marts, and BI solutions using Microsoft BI technologies.
Develop and maintain dashboards, reports, analytical models, SQL queries, stored procedures, and data visualizations that support operational and business needs.
Translate business requirements into reporting and analytics solutions, documenting report purpose, business logic, and dependencies.
Develop data monitoring models and strategies for data acquisition, transformation, warehousing, reporting, and analytics.
Design, develop, and maintain database objects, including tables, indexes, views, stored procedures, functions, ETL packages, analytical models, and reports.
Monitor and optimize database performance, reliability, scalability, and security across development, testing, staging, and production environments.
Manage database deployments, updates, and migrations across environments while maintaining data integrity and operational standards.
Provide guidance and support to database administrators and application developers on database design, development, deployment, and performance tuning.
Maintain data dictionaries, mappings, lineage, database architecture, and implementation documentation.
Ensure data accuracy, integrity, confidentiality, security, retention, and compliance with MIS standards and court privacy requirements.
Perform other related duties as assigned.
Travel as needed for normal duties in support of the Judiciary, including state Judicial events and national industry conferences.
Participate in on-call assignments in support of judicial operations.