> Markdown version of [/jobs/ext/1333940-data-modeling-consultant-bi-business-analyst](https://www.wearedevelopers.com/jobs/ext/1333940-data-modeling-consultant-bi-business-analyst). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Data Modeling Consultant / BI Business Analyst

- **Company:** Hayward Industries, Inc.
- **Location:** Charlotte, NC, United States (Remote available)
- **Experience:** Expert
- **Salary:** $104,000.0 - $124,800.0
- **Contract:** Temporary to permanent
- **Skills:** Data Analysis, Business Logic, Big Data, Information Engineering, Extract Transform Load (ETL), Document-Oriented Databases, Entity Relationship Models, Routing, Query Optimization, Power BI, SQL Databases, Freeform SQL, Snowflake, Build Management, Data Lakes, Data Lineage, Star Schema, Microsoft Dynamics 365 Finance & Operations, Azure Synapse Analytics
- **Published:** July 18, 2026
- **Apply:** https://www.careerjet.com/job/us60de1a8110e80df940baae20cef220eb/eaa

## About the Role

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).

## Description

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., As a Business Operations & Analytics Specialist, you will play a crucial role in enhancing business performance through data-driven insights and operational analysis. Your expertis…

 + 8 days ago


## Related Videos

- [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag)
- [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology)
- [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works)
- [Creating a routing app with Google Maps API from scratch](https://www.wearedevelopers.com/videos/831-creating-a-routing-app-with-google-maps-api-from-scratch)
- [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents)
- [REST, GraphQL, gRPC, and more: A comparison of modern API styles](https://www.wearedevelopers.com/videos/100247-rest-graphql-grpc-and-more-a-comparison-of-modern-api-styles)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)
- [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland)