Apply Now

Data Modeling Consultant / BI Business Analyst

Remote in Charlotte, NC, US • Posted 1 day ago • Updated 10 hours ago

Full Time

On-site

Fitment

Dice Job Match Score™

🔗 Matching skills to job...

Job Details

Skills

SPA
Lighting
Energy
GL
Affinity Propagation
Augmented Reality
Business Process
Modeling
Data Quality
Mapping
Microsoft Dynamics
Procurement
General Ledger
Accounts Payable
Financial Reporting
Production Orders
Bill Of Materials
Routing
Inventory
Cost Accounting
SQL
Analytical Skill
Query Optimization
Star Schema
Finance
Manufacturing
Business Intelligence
Documentation
Snow Flake Schema
Microsoft Azure
Supply Chain Management
Requirements Elicitation
Specification Gathering
Communication
Collaboration
Microsoft Power BI
DAX
Data Modeling
Dashboard
Reporting
Data Engineering
Enterprise Resource Planning
Replication
Tier 2
Data Lake
Extract
Transform
Load
ELT

SPA
Lighting
Energy
GL
Affinity Propagation
Augmented Reality
Business Process
Modeling
Data Quality
Mapping
Microsoft Dynamics
Procurement
General Ledger
Accounts Payable
Financial Reporting
Production Orders
Bill Of Materials
Routing
Inventory
Cost Accounting
SQL
Analytical Skill
Query Optimization
Star Schema
Finance
Manufacturing
Business Intelligence
Documentation
Snow Flake Schema
Microsoft Azure
Supply Chain Management
Requirements Elicitation
Specification Gathering
Communication
Collaboration
Microsoft Power BI
DAX
Data Modeling
Dashboard
Reporting
Data Engineering
Enterprise Resource Planning
Replication
Tier 2
Data Lake
Extract
Transform
Load
ELT

Summary

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.

D365FO Data Modeling Consultant / BI Business Analyst (1-Year Contract, Remote - EST)

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.

Responsibilities

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: Required

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

#LI-LS1

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: 10410799
Position Id: a38290f8e36d56bd8cafbb31689e21da
Posted 1 day ago

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Dynamics 365 Systems Analyst - 3631610

Charlotte, North Carolina

•

Today

Lighthouse Technology Services is partnering with our client to fill their Dynamics 365 Systems Analyst (Field Service) position! This is a 6 months contract-to-hire opportunity and will be hybrid in Charlotte, NC. This role will be a W2 employee of Lighthouse Technology Services. No C2C or subcontracting arrangements will be considered. What You'll Be Doing: Serve as the primary liaison between business stakeholders and technical teams, translating business needs into clear, actionable system

Full-time

USD 55.00 - 60.00 per hour

BI Analyst / Developer

Monroe, North Carolina

•

Today

ASSA ABLOY Entrance Systems, Pedestrian Door Solutions Join the industry leader in automated door solutions! ASSA ABLOY Entrance Systems is a global manufacturer committed to creating safe, secure, and efficient entrance systems for people worldwide. We specialize in automated pedestrian, industrial, and high-performance door solutions, operating in over 100 countries. Why Join ASSA ABLOY Entrance Systems? At ASSA ABLOY, we offer more than a job - we provide an environment for growth, innovat

Full-time

Dynamics D365 F&O SME

Remote

•

7d ago

Dynamics D365 F&O SME 100% Remote 16+ Months Please let me know these all details and send me your updated resume :- Visa :- Current location:- Notice Period :- Education Details:- LinkedIn Profile:- Required Skills 10+ years of Microsoft Dynamics AX/D365 Finance & Operations experience. Led multiple end-to-end Dynamics AX/D365 F&O implementations. Deep expertise in Fixed Assets, General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR), and Procurement. Strong experience in solution

Easy Apply

Contract, Third Party

Depends on Experience

Sr. BI Developer

No location provided

•

Today

Overview Join us as we Rise to the Challenge At KCI, we're building an enduring community that provides unparalleled value to our employee-owners. We make our mark designing and delivering our world-class solutions, so we invest deeply in supporting and developing our team. We reward integrity and commitment, and when we do well, you do well. Our employees have the freedom to innovate, unlimited growth, a voice that matters, a lifestyle that works, and skin in the game. Achievements are shared

Full-time

USD 140,000.00 per year

Search all similar jobs

Remote jobs at Hayward Industries