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 Industrys 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..Key Skills
Apache Hive,S3,Hadoop,Redshift,Spark,AWS,Apache Pig,NoSQL,Big Data,Data Warehouse,Kafka,Scala
Employment Type : Full Time
Experience : years
Vacancy : 1