Position Title: ETL Developer
Location: Near Albany, NY (onsite)
Employment Type: Full-Time
Salary: $85,000 - $100,000
Overview
Our client is seeking a skilled ETL Developer to design, build, and maintain data integration solutions that support business intelligence and operational reporting. This role is responsible for developing and optimizing ETL (Extract, Transform, Load) processes, ensuring data integrity, and collaborating with technical and business teams to deliver high-quality, reliable data pipelines.
The ideal candidate has a strong background in SQL, data modeling, and performance tuning, along with hands-on experience using modern ETL tools and techniques.
Key Responsibilities
ETL Development & Integration
- Design, develop, and maintain ETL pipelines to extract data from multiple structured and unstructured sources.
- Implement both incremental and full data load processes while maintaining high standards for data quality and consistency.
- Build reusable ETL components to improve efficiency and standardization across data workflows.
Data Modeling & Performance Optimization
- Support the development and optimization of data warehouse and operational data store models.
- Apply indexing, partitioning, and other performance techniques to ensure efficient data access.
- Monitor and fine-tune ETL performance through query optimization, parallel processing, and process automation.
Data Quality & Validation
- Develop and implement data validation, error handling, and reconciliation procedures to ensure data accuracy and completeness.
- Collaborate with data governance and analytics teams to support data quality and compliance initiatives.
Collaboration & Documentation
- Partner with analysts, developers, and business stakeholders to gather data requirements and translate them into technical specifications.
- Maintain detailed documentation for ETL workflows, data mappings, and system dependencies.
- Contribute to knowledge sharing and cross-functional collaboration within the data engineering team.
