Data Modeler

This position requires the successful candidate to work on a W2 directly with FDM. We cannot accept C2C, 1099 or employment sponsorship (e.g. H1-B) for this position.

FDM is a global business and technology consultancy delivering client and industry driven solutions through our 5 core specialist Practices; Software Engineering, Data & Analytics, IT Operations, Change & Transformation, and Risk, Regulation & Compliance.

FDM is seeking a Data Modeler located in Chicago to support a project in the mining and metals sector. Involvement in this project is anticipated to last initially 12 months but may be extended.

This role will be hybrid with requirements to be in office 3 days per week.

Data Modeler  

Overview

Client is seeking a Data Modeler to support the design and delivery of scalable data solutions across its global platform landscape. This role will focus on building robust, business-aligned data models that enable analytics, AI, and enterprise reporting across key domains.

The successful candidate will work closely with data engineers, platform owners, and business stakeholders across regions (e.g., Chicago, Montreal, Singapore) within a modern cloud-based data ecosystem.

Key Responsibilities

Data Modeling & Design

• Design and maintain conceptual, logical, and physical data models for enterprise data platforms
• Translate business requirements into scalable data structures supporting analytics, reporting, and AI use cases
• Define data standards, naming conventions, and governance practices

Platform & Engineering Collaboration

• Partner with data engineers to implement models in:
  • Azure Data Platform (Synapse, ADLS, Fabric)
  • Databricks / Lakehouse architectures
• Support integration across systems such as SAP S/4 HANA and other operational platforms
• Optimize data models for performance, scalability, and cost efficiency

Data Strategy & Governance

• Contribute to enterprise data architecture and modeling frameworks
• Ensure alignment with data governance, quality, and lineage standards
• Support metadata management and documentation

Stakeholder Engagement

• Collaborate with business stakeholders (finance, operations, supply chain) to:
  • Capture requirements
  • Drive clarity on KPI definitions and reporting needs
• Communicate technical concepts clearly to non-technical audiences

Required Skills & Experience

Core Technical Skills

• Strong experience in data modeling
• Proficiency in:
  • Dimensional modeling (Kimball) and/or Data Vault / normalized models
• Hands-on experience with:
  • Azure data services (Synapse, Data Factory, Fabric preferred)
  • Databricks / Spark-based environments
  • SQL and data transformation pipelines

Enterprise Systems

• Experience integrating data from:
  • SAP S/4 HANA (highly desirable)
  • ERP or operational mining/industrial systems

Tools & Practices

• Data modeling tools (e.g., ERwin, ER/Studio, PowerDesigner, or similar)
• Understanding of:
  • Data governance
  • Data quality frameworks
  • Metadata management

Preferred / Nice-to-Have

• Exposure to AI / Copilot-enabled analytics environments
• Experience with Palantir Foundry (nice to have, not required)
• Background in mining, energy, or heavy industry
• Experience working in global or distributed teams

About FDM  

FDM powers the people behind tech and innovation. We spot trends, find top talent, and help businesses stay ahead. 

With 35+ years of experience, we coach, mentor, and launch fresh thinkers from diverse backgrounds into world-class careers. Partnering with top global companies, we deliver the right talent at the right time—while guiding our people toward exponential growth. 

🌍 Global impact – 18 centers across North America, APAC, the UK, and Europe 
🚀 25,000+ careers launched – and counting 
🤝 300+ trusted client partners 

Committed to Equal Opportunities  

Tech careers should be for everyone. With 75+ nationalities represented, FDM thrives on diversity, fuels innovation through unique perspectives, and celebrates success together. As an Equal Opportunity Employer and FTSE4Good-listed company, we ensure every qualified applicant gets a fair shot—no barriers, just opportunities. 

Additional Considerations

FDM Group, Inc. is registered to operate and hire employees in select states within the US. We will consider employment applications exclusively from candidates who are either residing in one of the following states or willing to relocate to them: Arizona, California, Colorado, Delaware, Florida, Georgia, Illinois, Indiana, Massachusetts, Maryland, Minnesota, North Carolina, New Jersey, New York, Pennsylvania, Tennessee, Texas, Utah, and Virginia.