Hayward Holdings, Inc.

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. Hayward Flow Control, a division of Hayward Industries (NYSE "HAYW"), is a leading manufacturer of industrial thermoplastic valves, actuators, filters, strainers, pumps, bulkhead fittings and controllers for use in water & wastewater treatment, chemical processing, aquatics, and many other industrial process applications. With a rich history in thermoplastics manufacturing, Hayward Flow Control has been a leader in the industrial flow control sector for over 100 years, renowned for our commitment to quality, innovation, and customer success.

Data Modeling Consultant / BI Business Analyst

Location

EST (UTC-5)

Posted

3 days ago

Salary

0

Seniority

Mid Level

No structured requirement data.

Job Description

Data Modeling Consultant / BI Business Analyst

Hayward Holdings, Inc.

Role Description Hayward is implementing Microsoft Dynamics 365 Finance & Operations (D365FO) and is seeking a remote contract data modeling expert with deep expertise in financial and manufacturing domains to support the BI department in building new dimensional models and reports off the resulting data. This role requires availability during Eastern (EST) business hours. - Serve as the subject matter expert on the D365FO data model, advising the BI team on table structures, relationships, and data lineage as the implementation progresses. - 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. Qualifications - 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. - 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). - 5+ years of SQL experience, including CTEs, analytical/window functions, and query optimization across large datasets. - 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. - Hands-on experience with both Snowflake and Azure Synapse. - Business analyst experience supporting a D365FO (or D365 F&SCM) implementation — requirements gathering, stakeholder interviews, and translating business needs into technical specifications. - Working knowledge of Power BI, plus excellent communication and collaboration skills across distributed, cross-functional teams. Additional Preferred Qualifications - Power BI development skills (DAX, data modeling, dashboard/report build-out). - 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). Location - Remote (Eastern Time zone / EST required) Engagement Type - 1-year contract

Related Job Pages

More Business Intelligence Analyst Jobs

Sutton National Group logo

Statistical Reporting Analyst I/II

Sutton National Group

Sutton National Group Aligns Interests For True Value Chain Differentiation

Full TimeRemoteTeam 11-50H1B No Sponsor

• Responsible for the timely and accurate submissions of data calls and statistical data to state insurance departments. • Review and interpret regulatory reporting requirements and analyze the impact of such requirements. • Perform necessary data corrections when requested by a reporting entity. • Maintain detailed procedures for data calls, statistical reports, and all other processes completed. • Identify opportunities for improvements and efficiencies. • Respond to correspondence from Regulators, Partners, Third Party Administrators, and Internal Customers.

United States
$80K / year
IONITY logo

Working Student – Market & Business Intelligence

IONITY

We are Europe's high-power charging network for electric vehicles.

Part TimeRemoteTeam 51-200H1B No Sponsor

• Gather, synthesize, and analyze data from a variety of sources • Define data requirements and create dynamic, visually compelling dashboards using MS PowerBI • Work closely with cross-functional teams and report directly to the Head of Business Development & Market Intelligence • Support the development and implementation of advanced analytics and machine learning solutions

Germany
Cint logo

Director, Business Intelligence

Cint

Accelerating insights. https://www.cint.com/

Full TimeRemoteTeam 1,001-5,000Since 2004H1B No Sponsor

• Define and execute the BI strategy • Partner with senior stakeholders across Finance, Sales, Customer Experience, and others • Define and operationalize enterprise KPIs and executive-level dashboards • Oversee the evolution of our modern cloud data stack • Unify enterprise data models across the organization • Maintain ownership of data cataloging, quality, and governance standards • Establish rigorous data quality, observability, and reliability standards • Own vendor relationships and the BI budget • Oversee and ensure timely delivery of month-end data • Champion the use of AI and advanced analytics • Lead the transition to modern BI tools • Lead organizational change management and data literacy initiatives • Lead and mentor a global team of engineer and analyst professionals

United Kingdom
Cint logo

Director, Business Intelligence

Cint

Accelerating insights. https://www.cint.com/

Full TimeRemoteTeam 1,001-5,000Since 2004H1B No Sponsor

• Define and execute the BI strategy, shifting the organization from reactive reporting to a proactive, 'intelligence-first' mindset that drives faster and better business decisions. • Partner with senior stakeholders across Finance, Sales, Customer Experience, Trust & Safely, Marketing and Product to align the BI roadmap with global goals. • Define and operationalize enterprise KPIs and executive-level dashboards to ensure consistent measurement of business performance and accountability. • Oversee the evolution of our modern cloud data stack, ensuring it is optimized for high-performance querying, cost-efficiency, scalability and reliability. • Unify enterprise data models across the organization to eliminate fragmented silos and ensure a single, governed, and trusted 'Source of Truth.' • Maintain ownership of data cataloging, quality, and governance standards while ensuring BI platforms and data assets comply with security, privacy, and regulatory requirements across regions. • Establish rigorous data quality, observability, and reliability standards to build sustained trust in analytics and reporting. • Own vendor relationships and the BI budget, focusing on Total Cost of Ownership and Databricks compute efficiency. • Oversee and ensure timely delivery of month-end data while implementing automation to streamline processes and improve long-term efficiency. • Champion the use of AI and advanced analytics to automate insights, enhance forecasting, and surface proactive recommendations for the business. • Lead the transition to modern BI tools, empowering teams to explore data independently while maintaining governance. • Lead organizational change management and data literacy initiatives to drive adoption of self-service BI and analytics across the business. • Lead and mentor a global team of engineer and analyst professionals, transitioning the function from manual data processing to high-value strategic innovation.

Germany