This list contains only the countries for which job offers have been published in the selected language (e.g., in the French version, only job offers written in French are displayed, and in the English version, only those in English).
Data Engineer (BI/ETL) focused on building and optimizing ETL/ELT pipelines, migrating/cleaning data between internal, vendor, and legacy systems, and improving data quality. SQL is absolutely required, and this role leans heavily into backend data movement — not dashboarding.
Job Responsibility:
Build and maintain business intelligence solutions to include law enforcement, detention, human resources, finance, and integration of data from agency criminal justice partners
Design and develop BI solutions
Gather user requirements, develop technical and functional requirements, produce reporting solutions, and document the design and development process, metadata, and business rules
Model, implement, and maintain databases and data marts to support BI reporting
Develop extract, transform, load (ETL) to support the loading of data into data marts
Monitor the data quality of existing databases and data marts and recommend governance and control around self-service BI/Analytics considering the evolution of the BI Industry’s best practices
Perform other related duties as required
Requirements:
Strong SQL (non negotiable)
Experience designing and maintaining ETL / ELT pipelines using frameworks such as Apache Airflow, DBT (Data Build Tool), or equivalent orchestration systems, with the ability to schedule, monitor, and recover complex multi-stage jobs
Experience moving data across multiple systems
Knowledge of building automated data validation and reconciliation checks to ensure data accuracy, integrity, and completeness
Knowledge of designing data warehouses and data marts that support analytics, ML, and dashboard reporting
Knowledge of dimensional modeling and star/snowflake schemas
Basic understanding of secure coding principles and CJIS data protection guidelines
Working knowledge of office policies and procedures
Proficiency in C# or Python
Proficient in writing optimized SQL queries, functions, and stored procedures for SQL Server and PostgreSQL
Proficiency in cleaning, merging, and reshaping data using Pandas, Polars, or SQL
Strong debugging and troubleshooting skills in both application and database layers
Effective communication and interpersonal skills for interacting with users and technical staff
Ability to dissect complex problems, experiment methodically, and find practical, innovative solutions
Ability to prioritize and manage multiple tasks in a dynamic environment
Ability to perform exploratory data analysis to detect trends, anomalies, and data quality issues
What we offer:
Medical benefits are also 100% covered after onboarding period
medical, vision, dental, and life and disability insurance