Sr. Data Engineer - job 2 of 2

Hayward Holdings Inc. (NYSE "HAYW") is the largest manufacturer of residential swimming pool equipment in the world, with a significant presence in the commercial pool market that is continuously growing. Hayward designs, manufactures and markets a full line of residential and commercial pool and spa equipment including pumps, filters, heating, cleaners, salt chlorinators, automation, lighting, safety, flow control and energy solutions at our company owned facilities. Headquartered in Charlotte, North Carolina, Hayward also has facilities in Tennessee, Arizona, and Rhode Island as well as Canada, Spain, France, Australia, and China. We are continuing to grow so jump in and join the team in Charlotte, NC!

The Global Data and Analytics organization uses cloud-base technology for data integration and data warehouse using Talend and Snowflake. This role will be supporting the senior executive team globally with their Data and Analytics data ingestion and transformation needs utilizing the existing technologies. This role is full-time midlevel role focusing on analyzing, building, and designing business intelligence models and solutions.

The role is key in synthesizing and distilling meaningful and accurate data for the decision makers at Hayward. Responsibilities include building and supporting BI solutions using Talend, Matillion, Snowflake, and other exciting technologies of data integration. This role also provides accurate level-of-effort estimates for data integration, creates data integration solutions, develops documentation to support production deployments, and supports data solutions maintenance.

Location:

• Clemmons, NC (Piedmont Triad Area - Winston Salem, Greensboro, High Point) area with the ability to work remotely part of the time
• Charlotte, NC area with the ability to work remotely part of the time

This position is not open to sponsorship at the time.

Responsibilities:

• Design, develop, implement, and support new and existing data integration jobs using modern technologies.
• Ingest data from multiple sources including transactional and operational databases, implement complex business logic, and produce 3rd normal form and dimensional model database objects in Snowflake.
• Migrate datasets between existing and future database platforms.
• Understand and implement best practice solutions per development standards.
• Produce ad-hoc data extracts to answer business questions quickly and thoroughly.
• Collaborate with Project Managers, IT Architecture, Business Analysts, and Report Developers to achieve business objectives.
• Develop technology documentation to support production deployments as well as ongoing maintenance of reporting and data solutions.
• Troubleshoot, diagnose, and resolve data quality and performance issues related to data integration and transformation.
• Communicate complex topics and analyses to non-technical business personnel.
• Present and participate in Architecture Review Board meetings. Review solutions presented by other IT architects and provide constructive feedback.
• Provide accurate level of effort estimates for data integration development to management.

Qualifications:

• Bachelor’s degree in computer science, information technology, or related field. Equivalent working experience in-lieu of a bachelor’s degree would be considered
• 5+ years advanced hands-on experience building data integration, ingestion and transformation solutions using tools such as Matillion, Nifi, Kafka (Confluent Cloud), Talend, dbt and Airflow
• 4+ years advanced SQL skills, preferably in Snowflake or similar cloud data warehouse
• 3+ years hands-on experience in data warehousing, and particularly in star-schema architecture
• 3+ years working in a DevOps environment. Assist with production support issues by acting as a subject matter expert in resolving incidents and problem tickets
• 2+ years object-oriented programming language development (Python, Shell scripting, Scala/Java)
• 2+ years API and Web Services integration (REST/SOAP/Bulk)
• 1+ year experience with AWS and related products (such as Lambda, ECS, EC2, App Gateway and similar)
• Experience developing production solutions with distributed architectures and processing technologies
• Experience in implementing CI/CD (e.g. Github Pipelines, AWS cloud build)
• Hands on experience working in a public cloud environment and on-prem infrastructure
• Extensive experience in multiple operating systems: Unix, Windows, Linux
• Ability to analyze and apply critical thinking to resolve complex issues
• Strong problem solving and collaboration skills
• Commitment, technical curiosity, and relentless pursuit of practical knowledge

Preferred Qualifications:

• Experience in global company
• Experience in manufacturing environment
• Exposure to leading BI reporting tools, preferably cloud based, such as Tableau, Power BI, and Cognos
• Understanding of statistical concepts and intuition
• Comprehension of data science concepts including Machine Learning and Artificial Intelligence
• Experience building data software in microservices-oriented architecture and extensible REST APIs
• Experience with containerized environments (Kubernetes and Docker) for database pipeline applications
• Experience with observability tools and frameworks such as Grafana, Prometheus, and Cloudwatch
• Technical writing skills
• Certification in Snowflake or similar Cloud Data Warehouse platform
• Familiarity with Agile development methodologies such as Scrum and Kanban

Job Type: Full-time

Pay: $120,000.00 - $150,000.00 per year

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Flexible schedule
• Flexible spending account
• Health insurance
• Health savings account
• Life insurance
• Paid time off
• Tuition reimbursement
• Vision insurance

Compensation package:

• Bonus pay
• Yearly bonus

Experience level:

• 2 years
• 3 years

Schedule:

• Day shift
• Monday to Friday
• No weekends

Supplemental pay types:

• Bonus pay

Ability to commute/relocate:

• Charlotte, NC 28203: Reliably commute or planning to relocate before starting work (Required)

Experience:

• Snowflake: 1 year (Required)
• DBT: 1 year (Required)
• Data warehouse: 1 year (Required)

Work Location: Hybrid remote in Charlotte, NC 28203