> Markdown version of [/jobs/ext/1498247-etl-developer-1228](https://www.wearedevelopers.com/jobs/ext/1498247-etl-developer-1228). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# ETL Developer-1228

- **Company:** PIP Global Safety
- **Location:** Latham, NY, United States
- **Salary:** $85,000.0 - $115,000.0
- **Contract:** Permanent contract
- **Skills:** Databases, Data Validation, Data Cleansing, Data Governance, Data Integration, Extract Transform Load (ETL), Data Profiling, Data Warehousing, Database Design, Database Theory, Dimensional Modeling, Operational Data Store, Pentaho Data Integration, Performance Tuning, Query Optimization, Standard Sql, SQL Server Integration Services, Data Streaming, Transact-SQL, Azure Data Factory, Informatica Powercenter, Parallel Computation, Star Schema, Programming Languages
- **Published:** July 30, 2026
- **Apply:** https://www.indeed.com/viewjob?jk=a4dab255f9a08123

## About the Role

* Programming Languages: Advanced knowledge of SQL, with proficiency in T-SQL.
 * ETL Tools: Experience with industry-standard ETL tools (e.g., SSIS, Azure Data Factory, Informatica, Pentaho, etc. )
 * Database Management: Understanding of database concepts (relational and dimensional), including database design, query optimization, and performance tuning
 * Data Warehousing: Knowledge of data warehouse concepts, dimensional modeling, and star schema design
 * Data Quality Techniques: Familiarity with data cleansing, data validation, and data profiling methods
 * Problem-solving: Ability to troubleshoot complex data issues, identify root causes, and implement effective solutions
 * Bachelor's degree in computer/data science or similar field of study preferred

## Description

Responsible for developing and maintaining ETL processes to extract data from various sources, transform it based on business requirements, and load it into target databases or data warehouses. This role involves ensuring data accuracy, optimizing performance, and collaborating with team members and stakeholders to support reliable and efficient data integration workflows., * ETL Process Development

 + Design, develop, and maintain ETL pipelines to extract, transform, and load data from various structured and unstructured sources.
 + Implement both incremental and full data load strategies, ensuring data quality and consistency.
 + Build reusable components to standardize and streamline ETL processes.
 * Data Modeling & Integration
 + Support the development and optimization of data models for data warehouses and operational data stores.
 + Ensure appropriate use of indexing, partitioning, and other techniques to improve performance.
 * Data Quality & Validation
 + Develop and implement data validation, error handling, and reconciliation processes to ensure accuracy and completeness.
 + Collaborate with data governance teams to support data quality and compliance initiatives.
 * Performance Tuning
 + Monitor ETL job performance and implement improvements such as query tuning and parallel processing to optimize efficiency.
 * Collaboration
 + Work closely with analysts and business users to understand data requirements and deliver appropriate solutions.
 + Translate business needs into technical specifications and deliverables.
 * Documentation
 + Maintain clear documentation for ETL processes, data flows, and technical specifications to support ongoing maintenance and knowledge transfer


## Related Videos

- [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases)
- [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt)
- [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases)
- [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering)
- [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works)
- [Branch your database like your code:  How schema changes and pull requests go hand in hand](https://www.wearedevelopers.com/videos/350-branch-your-database-like-your-code-how-schema-changes-and-pull-requests-go-hand-in-hand)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market)
- [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)