Job Description
Job Description
JOB SUMMARY
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.
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
- Excellent communication, interpersonal, and organizational skills.
- Strong leadership capabilities, with the ability to motivate and manage teams effectively.
- Ability to analyze support metrics and implement process improvements.
- Proactive problem-solving and decision-making skills.
- Ability to manage multiple priorities and handle stressful situations professionally.
- Commitment to providing high-quality customer service.
- Strong understanding of IT support processes and incident management.
- Experience with IT Service Management (ITSM) tools, preferably ServiceNow, Jira Service Management, or similar.
- Familiarity with ITIL frameworks and practices (ITIL certification preferred).
- Experience working within hybrid environments utilizing Active Directory and Entra ID.
- Proficiency in Microsoft Office 365 suite and related cloud-based services
Protective Industrial Products (PIP) is an equal opportunity employer that is committed to diversity and inclusion in the workplace. We prohibit discrimination and harassment of any kind based on race, color, sex, religion, sexual orientation, national origin, disability, genetic information, pregnancy, or any other protected characteristic as outlined by federal, state, or local laws.
This policy applies to all employment practices within our organization, including hiring, recruiting, promotion, termination, layoff, recall, leave of absence, compensation, benefits, training, and apprenticeship. PIP makes hiring decisions based solely on qualifications, merit, and business needs at the time. For more information, you may request access to our EEO policy.
At PIP Global Safety, we are committed to fostering a diverse and inclusive workplace where all individuals are respected and valued. We do not tolerate discrimination or harassment of any kind, and we strive to ensure that employment decisions are based on qualifications, merit, and business needs. Employment practices and policies may be subject to variation based on applicable laws and regulations in different countries and jurisdictions.
This commitment applies to all aspects of employment, including hiring, recruiting, promotion, termination, compensation, benefits, training, and development opportunities. We believe that a diverse team strengthens our global success and enriches our culture