ETL Developer-1228

Protective Industrial Products • $95K — $115K *
Latham, NY 12110In-Person
Information Technology
Less than 5 years of experience
Today
Be an Early Applicant
Job Overview by Ladders

Qualifications

  • Advanced SQL knowledge, particularly in T-SQL.
  • Experience with ETL tools like SSIS or Azure Data Factory.
  • Familiarity with relational and dimensional database concepts.
  • Understanding of data warehousing and star schema design.
  • Knowledge of data quality techniques such as cleansing and profiling.
  • Strong problem-solving skills for troubleshooting data issues.
  • Bachelor's degree in computer science or related field preferred.

Responsibilities

  • Design, develop, and maintain ETL pipelines for data extraction, transformation, and loading.
  • Implement incremental and full data load strategies to ensure data quality.
  • Build reusable components to standardize ETL processes.
  • Support data model development and optimization for data warehouses.
  • Ensure effective use of indexing and partitioning for performance.
  • Develop data validation and reconciliation processes for accuracy.
  • Collaborate with analysts to understand data requirements and translate them into technical specifications.

Benefits

  • Opportunity to work onsite in Latham, NY.
  • Engagement with diverse data sources and business stakeholders.
  • Potential for career development in data integration and management.
  • Involvement in optimizing data processes and workflows.
Full Job 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.

*This is an ONSITE position in Latham, NY*
Relocation assistance is not supported for this role.

JOB RESPONSIBILITIES
  • 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

CORE SKILLS/COMPETENCY REQUIREMENTS
  • 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

About Protective Industrial Products

Protective Industrial Products (PIP) is a global leader in hand protection and PPE (personal protective equipment) solutions. With a mission to keep people safe, PIP offers a wide range of products including gloves, safety glasses, hard hats, hearing protection, and more. The company serves a variety of industries including construction, oil and gas, food processing, and healthcare. PIP has a strong commitment to sustainability and social responsibility, with initiatives focused on reducing waste, conserving energy, and supporting local communities.
Learn more about Protective Industrial Products
Size
1,000 employees
Industry
Manufacturing & Automotive
* Ladders Estimates

Similar Jobs

Ad banner background

Get Ready For Your
Next Interview

More Jobs at Protective Industrial Products

More Information Technology Jobs

Find similar ETL Developer-1228 jobs:

NationwideLatham, NY