Business Intelligence Engineer

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

Job Posting Title Business Intelligence Engineer Agency 677 SUPREME COURT Supervisory Organization Supreme Court [JM]

Job Posting End Date Refer to the date listed at the top of this posting, if available. Continuous if date is blank. Note: Applications will be accepted until 11:59 PM on the day prior to the posting end date above. Estimated Appointment End Date (Continuous if Blank) Full/Part-Time Full time Job Type Regular Compensation Salary commensurate with education and experience. Applicants must be authorized to work in the United States without the need for employment-based visa sponsorship now or in the future. The employer does not provide visa sponsorship for current, continued, or future work authorization. Job Description ***PLEASE READ BEFORE APPLYING*** Applicants must be authorized to work in the United States without the need for employment-based visa sponsorship now or in the future. The employer does not provide visa sponsorship for current, continued, or future work authorization. All interviews are in-person. Travel expenses will not be provided for in-person interviews. All positions are in-person / in-office. Remote work is not authorized. Business Intelligence Engineer The Administrative Office of the Courts (AOC) is seeking a self-motivated person to join the organization as a Business Intelligence Engineer. The candidate should possess the skills necessary to provide development and operational support for the information systems of the Administrative Office of the Courts. Position Description: Reporting to the Data Systems Manager, this role is responsible for performing high-quality data migration, data integration, administering an enterprise reporting platform, and analytics. The role combines enterprise-grade ETL engineering with structured reporting and data governance practices. AI generative and agentic capabilities will be used to assist with data mapping and transformation, identify data quality issues and anomalies, and generate and validate reports and analytics. Salary: Commensurate with education and experience. FLSA Exemption: Exempt Responsibilities and Essential Functions will include (but not be limited to) the following: Data Migration, BI & Analytics Engineer 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 (ADF), 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 identification of 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 Business Intelligence (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 actionable reporting and analytics solutions, documenting report purpose, business logic, and dependencies. Develop data monitoring models and establish 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. Performs other related duties as assigned. Knowledge, Skills & Abilities Strong proficiency in SQL, database development, administration, performance tuning, troubleshooting, and security. Experience with ETL development, data migration, data warehousing, BI platforms, and large relational and dimensional data models. Experience with Microsoft BI technologies Power BI, and/or Azure Data Factory. 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, with 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 that meet current and future organizational needs. Experience with Azure cloud technologies. Advanced mathematics or statistical analysis skills. Education and Experience Requirements: 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, Master Data Services, Data Quality Services, PowerBI Enterprise). Three (3+) years utilizing agentic artificial intelligence analyzing data. Bachelors’ degree from an accredited college in Computer Science/Information Systems, math, engineering, or related technical field is preferred. Microsoft Certifications or equivalent is preferred. MCSA: SQL 2022+ Database Administration is preferred. Travel: All AOC positions have the potential to and expectation of requiring employees to travel for normal duties in support of the Judiciary, including and not limited to state Judicial events and national industry conferences. Work Environment: This job operates in a professional office environment. This role routinely uses standard office equipment such as laptop computers, photocopiers, and smartphones. All AOC positions are designated as “In-Person” at one of the authorized work locations. AOC offices are officially open for business from 8:00 AM to 5:00 PM, Monday through Friday. MIS employees have the expectation of being assigned on-call as defined in 26 CFR 553.221 (d) in support of judicial operations. Physical Demands: While performing the duties of this job, the employee is regularly required to talk, hear, comprehend, observe, and evaluate. Specific vision abilities required by this job include close vision and ability to adjust focus. This position requires the ability to lift files, open filing cabinets, operate standard office and computer equipment, and bend or stand on a step stool as necessary. Responsibilities and skills listed above are essential to the position. Inability to perform these responsibilities with or without an accommodation may result in disqualification from the position. Eligibility: Applicants must be authorized to work in the United States without the need for employment-based visa sponsorship now or in the future. The employer does not provide visa sponsorship for current, continued, or future work authorization. The State of Oklahoma has an excellent benefits package including 3 weeks of vacation, employee retirement and health benefit plans. Position open until filled. Criminal background check required. The Supreme Court of Oklahoma Administrative Office of the Courts 2100 N. Lincoln Blvd., Suite 3 Oklahoma City, Oklahoma 73105. http://www.oscn.net. The Supreme Court of Oklahoma is an Equal Opportunity Employer. Equal Opportunity Employment The State of Oklahoma is an equal opportunity employer and does not discriminate on the basis of genetic information, race, religion, color, sex, age, national origin, or disability. Current active State of Oklahoma employees must apply for open positions internally through the Workday Jobs Hub.

Industries: Government Administration Worker Size: 10,001+ Employees Headquarters: Oklahoma City, Oklahoma Utilizing the Office of Veterans Placement provides eligible veterans additional services and interview opportunities for State of Oklahoma employment.