Business Intelligence Engineer

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…