PIP Global Safety · 2 days ago
ETL Developer
Latham, NY
Full-time
Onsite
Mid LevelPIP Global Safety is focused on developing and maintaining ETL processes, and they are seeking an ETL Developer to extract data from various sources, transform it based on business requirements, and load it into target databases or data warehouses. The role involves ensuring data accuracy, optimizing performance, and collaborating with team members and stakeholders to support reliable data integration workflows.
Consumer GoodsManufacturing
Responsibilities
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
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
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
Monitor ETL job performance and implement improvements such as query tuning and parallel processing to optimize efficiency
Work closely with analysts and business users to understand data requirements and deliver appropriate solutions
Translate business needs into technical specifications and deliverables
Maintain clear documentation for ETL processes, data flows, and technical specifications to support ongoing maintenance and knowledge transfer
Qualification
Required
Advanced knowledge of SQL, with proficiency in T-SQL
Experience with industry-standard ETL tools (e.g., SSIS, Azure Data Factory, Informatica, Pentaho, etc.)
Understanding of database concepts (relational and dimensional), including database design, query optimization, and performance tuning
Knowledge of data warehouse concepts, dimensional modeling, and star schema design
Familiarity with data cleansing, data validation, and data profiling methods
Ability to troubleshoot complex data issues, identify root causes, and implement effective solutions
Preferred
Bachelor's degree in computer/data science or similar field of study preferred
Company
PIP Global Safety
As the new independent global leader in safety, PIP Global Safety™ is redefining what it means to be protected on the job.
Founded in 1984
1001-5000 employees
Funding
Current Stage
Late StageTotal Funding
unknownKey Investors
Audax Private Equity
2020-12-15Acquired
2018-02-01Private Equity
Leadership Team
Curt Holtz
President & CEO
Joseph Milot
Member Board of Directors
Recent News
MarketsandMarkets Research Pvt. Ltd.
2025-08-13
Research and Markets
2025-06-11
Company data provided by crunchbase