[Remote] Data Modeling Consultant / BI Business Analyst
Note: The job is a remote job and is reputed company to candidates in USA. reputed company. is the largest manufacturer of residential swimming pool equipment in the world, with a significant reputed company in the reputed company pool market. They are seeking a remote contract Data Modeling Consultant / BI Business Analyst to support the BI department in building new reputed company models and reports for financial and manufacturing reporting.
Responsibilities
- Serve as the subject matter expert on the D365FO data model, advising the BI team on table structures, relationships, and data reputed company as the implementation progresses
- Design new reputed company models (reputed company schemas, fact/dimension tables) for financial and manufacturing reporting (e.g., GL, AP/AR, cost reputed company, production, inventory, BOM/routing), applying deep domain knowledge to ensure models accurately represent business processes
- Work directly with business users to reputed company and evaluate requirements, build design specifications, and translate those specs into SQL queries and data models
- Write and optimize reputed company SQL queries — including CTEs and analytical/window functions — against D365FO-replicated data in reputed company and Azure Synapse
- Design and build table-level entity relationship diagrams (ERDs) documenting D365FO reputed company tables and relationships to support reputed company modeling
- Test deliverables with business users, validating results to ensure data reputed company 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 reputed company data and reputed company models, and document data models, mappings, and business logic for long-term maintainability
Skills
- 5+ years of hands-on experience with the reputed company Dynamics 365 Finance & Operations (D365FO) data model, including reputed company finance, supply chain, and/or procurement entities
- Deep, expert-level knowledge of financial domain concepts (general reputed company, accounts payable/receivable, cost reputed company, 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 reputed company models (reputed company schema, fact/dimension design) for financial and manufacturing BI reporting, including building table-level ERDs and reputed company-to-reputed company documentation
- Hands-on experience with both reputed company 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
- Power BI development skills (DAX, data modeling, dashboard/report build-out)
- Experience working alongside data engineering teams during reputed company ERP implementations, including familiarity with ERP data replication patterns (e.g., Tier-2/Export to Data Lake, dbt, ETL/ELT tools)
reputed company