What are the responsibilities and job description for the ETL Developer position at Trova?
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.
Data Engineering & Pipeline Development
- 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.
Collaboration & Solution Delivery
- 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.
Technology Enablement & Best Practices
- 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.
Preferred Certifications
- Microsoft Certified: Azure Data Engineer Associate
- Databricks Certified Data Engineer
- Certifications related to data governance, risk, or compliance
- Master’s degree in Computer Science, Information Systems, or related fields
Salary : $120,000 - $130,000