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.
Qualifications
Education:
- Bachelor's degree in Computer Science, Data Science, Information Systems, or a related field (or equivalent work experience).
Experience:
- 2-5 years of experience developing and maintaining ETL processes in a data-centric environment.
Technical Skills:
- SQL / T-SQL: Advanced proficiency in writing, optimizing, and troubleshooting complex queries.
- ETL Tools: Experience with one or more tools such as SSIS, Azure Data Factory, Informatica, Pentaho, or similar platforms.
- Databases: Strong understanding of relational and dimensional database concepts, query optimization, and schema design.
- Data Warehousing: Familiarity with star schema and dimensional modeling concepts.
- Data Quality: Knowledge of data cleansing, validation, and profiling techniques.
- Problem Solving: Ability to diagnose and resolve complex data issues with attention to detail and analytical rigor.
To see a full listing of all our open positions, please visit:
https://www.redshiftrecruiting.com/jobs-hiring-near-me
redShift Recruiting is the region's premier recruiting agency with over 100 years of combined experience in the recruiting field. We specialize in permanent, temporary, and temp-to-hire positions. Our superior service combined with our highly qualified and carefully selected bank of candidates sets us apart.