Hayward Industries Inc

Data Modeling Consultant / BI Business Analyst

Charlotte, NC, US

Sponsorship not specifiedDetected 6 days ago

SQLSnowflakeAzuredbtData EngineeringData VisualizationFinancial AnalysisAccountingSupply ChainProcurementERPAR/VRCommunicationCollaborationFinancial ReportingAccounts Payable

About the role

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.
Headquartered in Charlotte, North Carolina, Hayward also has facilities in Tennessee, Arizona, and Rhode Island as well as Canada, Spain, France, Australia, and China.
This role requires availability during Eastern (EST) business hours.

Responsibilities

Design new dimensional models (star schemas, fact/dimension tables) for financial and manufacturing reporting (e.g., GL, AP/AR, cost accounting, production, inventory, BOM/routing), applying deep domain knowledge to ensure models accurately represent business processes.
Work directly with business users to gather and evaluate requirements, build design specifications, and translate those specs into SQL queries and data models.
Write and optimize complex SQL queries - including CTEs and analytical/window functions - against D365FO-replicated data in Snowflake and Azure Synapse.
Design and build table-level entity relationship diagrams (ERDs) documenting D365FO source tables and relationships to support downstream modeling.
Test deliverables with business users, validating results to ensure data quality and accuracy before release, and build or guide development of Power BI reports from the new models.
Identify data gaps or mapping issues between D365FO source data and target models, and document data models, mappings, and business logic for long-term maintainability.
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.

Requirements

5+ years of hands-on experience with the Microsoft Dynamics 365 Finance & Operations (D365FO) data model, including core finance, supply chain, and/or procurement entities.
5+ years of SQL experience, including CTEs, analytical/window functions, and query optimization across large datasets.
Hands-on experience with both Snowflake and Azure Synapse.
Experience working alongside data engineering teams during active ERP implementations, including familiarity with ERP data replication patterns (e.g., Tier-2/Export to Data Lake, dbt, ETL/ELT tools).
Required
Deep, expert-level knowledge of financial domain concepts (general ledger, accounts payable/receivable, cost accounting, financial reporting) and manufacturing domain concepts (production orders, BOM/routing, inventory, costing).
Experience designing dimensional models (star schema, fact/dimension design) for financial and manufacturing BI reporting, including building table-level ERDs and source-to-target documentation.
Business analyst experience supporting a D365FO (or D365 F&SCM) implementation - requirements gathering, stakeholder interviews, and translating business needs into technical specifications.
Power BI development skills (DAX, data modeling, dashboard/report build-out).
Engagement Type: 1-year contract

Nice to have

Working knowledge of Power BI, plus excellent communication and collaboration skills across distributed, cross-functional teams.
Additional Preferred Qualifications

Apply directly at Hayward Industries Inc →Create a free account for alerts like this View Hayward Industries Inc immigration profile

This listing is sourced directly from Hayward Industries Inc's careers page and normalized into a canonical job model.