Role: Data Engineer

Location: Tampa, FL Onsite

Duration: 6-12 month contract to hire

USC only

Duties & Responsibilities

• 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.

Knowledge & Abilities

• 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.
• 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.
• Proficiency in cleaning, merging, and reshaping data using Pandas, Polars, or SQL..