ETL Developer

Trova; Oak Brook (IL); On-site; USD 110,000 - 150,000; Full time

Job summary

Trova is seeking a Data Engineer to design, develop, and optimize enterprise data pipelines and platforms using Azure, Databricks, Foundry, and Microsoft Fabric. You will collaborate with analytics, BI, and business teams to transform requirements into reliable data assets that support reporting, analytics, and operational needs.

The role emphasizes building scalable data lakes, lakehouses, and data warehouses, implementing ETL/ELT best practices, and automating workflows.

Qualifications

• 5–7 years of data engineering experience.
• Hands-on experience with ETL/ELT development in cloud environments.
• Strong SQL and Python skills; familiarity with data modeling.

Responsibilities

• Design, develop, and maintain scalable data pipelines and platforms.
• Build and optimize ingestion, transformation, and integration across sources.
• Develop and support data lakes, lakehouse, and data warehouse environments.
• Follow ETL/ELT best practices to ensure performance, reliability, and data quality.
• Automate data workflows and monitor pipeline health; resolve issues promptly.
• Collaborate with analytics, BI, and business teams to translate requirements into solutions.
• Contribute to documentation of data structures, transformation logic, and dependencies.
• Ensure pipelines align with reporting and operational needs and adhere to governance.

Skills

SQL

Python

ETL/ELT

Data modeling

Data governance

Education

Bachelor’s degree in Computer Science or related field

Tools

Azure Data Factory

Databricks

Microsoft Fabric

Synapse SQL

MSSQL

Job description

The Data Engineer is responsible for designing, developing, and optimizing enterprise data pipelines and data platforms. This role focuses on building scalable, efficient, and secure data solutions using modern cloud technologies. The engineer collaborates with analytics, BI, and business teams to transform requirements into reliable data assets that support reporting, analytics, and operational needs.

MUST LIVE IN THE CHICAGO/ OAKBROOK TERRACE AREA

• Design, develop, and maintain scalable data pipelines using Azure Data Factory, Databricks, Foundry, and Microsoft Fabric.
• Build and optimize data ingestion, transformation, and integration processes across structured and unstructured data sources.
• Develop and support data lakes, Lakehouse’s, and data warehouse environments using MSSQL and cloud-native platforms.
• Implement ETL/ELT best practices to ensure performance, reliability, and data quality.
• Automate data workflows and monitor pipeline health; identify and resolve issues promptly.
• Work closely with analytics, BI, and business teams to understand data requirements and translate them into technical solutions.
• Partner with cross-functional teams to support data-driven initiatives and ensure pipelines align with reporting and operational needs.
• Contribute to documentation of data structures, transformation logic, and system dependencies.
• Contribute to evaluating and adopting new tools, frameworks, and technologies that enhance data engineering efficiency and scalability.
• Follow standards for code quality, testing, version control, and documentation.
• Apply data governance, quality, and reliability principles in daily engineering work.

Business Intelligence & Analytics Support

• Build reusable data models and curated datasets to enable self-service analytics.
• Ensure downstream BI teams receive accurate, well-structured, and timely data.
• Transform business requirements into scalable and maintainable technical designs.

Compliance & Security

• Ensure data engineering solutions align with privacy regulations such as GDPR and HIPAA, as well as internal security requirements. Maintain proper data access controls and contribute to monitoring data quality and compliance metrics.

Required Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or a related field.
• 5–7 years of experience in data engineering, ETL/ELT development, or cloud data platforms.
• Hands-on experience with Azure Data Factory, Databricks, Microsoft Fabric, Synapse SQL, and MSSQL.
• Strong knowledge of data lake, lakehouse, and data warehouse architectures.
• Solid understanding of ETL/ELT processes, data modeling, and metadata management.
• Proficiency in SQL and Python; familiarity with cloud platforms and big data technologies.
• Ability to diagnose data issues, optimize performance, and work with cross-functional technical and business teams.
• MUST BE A US CITIZEN OR GREEN CARD HOLDER. NO C2C OR 3RD PARTIES.
• MUST LIVE IN THE CHICAGO/ OAKBROOK TERRACE AREA

Preferred Certifications

• Certifications related to data governance, risk, or compliance
• Master’s degree in Computer Science, Information Systems, or related fields