Senior Data Modeler

Concord USA

Minnesota

On-site

USD 96,000 - 117,000

Full time

6 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Health insurance
Dental insurance
Vision insurance
HSAs & FSAs
Life insurance
EAP

Job summary

Concord USA is seeking a Data Modeler to design and implement core data models for clients across healthcare, financial services, manufacturing, and retail. You will lead requirements discussions, define model standards, and collaborate with data engineers to deploy models on Snowflake and Databricks.

The role combines hands-on modeling with client-facing engagements, requiring strong SQL, dimensional modeling expertise, and experience with modeling tools such as Erwin or equivalents.

Qualifications

  • Minimum 9+ years of data modeling experience across transactional and dimensional models.
  • Strong knowledge of normalization, star/snowflake schemas, SCDs, and fact/dimension design.
  • Hands-on experience with ER modeling tools such as Erwin/ER/Studio/PowerDesigner/SqlDBM.

Responsibilities

  • Design conceptual, logical, and physical data models across client domains.
  • Build OLTP/3NF and dimensional (star/snowflake) models for ops and analytics.
  • Lead requirements sessions with business and tech stakeholders.

Skills

Data modeling
SQL
Snowflake
Databricks
Erwin
Client-facing
Consulting
Industries exp

Tools

Erwin
ER/Studio
PowerDesigner
SqlDBM

Job description

Job Information
  • Location: Prefer candidates located in the Minneapolis/St. Paul area to visit our HQ, but open to candidates in other locations. All candidates must be based in the US.
  • Compensation: $70 - $85/hr W2 Hourly. Open to a contract-to-hire option. Compensation will be determined based on relevant experience, skills, and overall qualifications.
  • Requirements: Must be authorized to work legally in the US without sponsorship, now or in the future.
AboutUs

Concord isn't your typical consulting firm; we're an execution company. We help organizations move technology and AI initiatives from concept to measurable capability, working alongside our clients from the initial definition of success through full implementation and adoption.

Our team brings expertise across artificial intelligence and data, digital experience, and platform engineering, enabling the organizations we serve to build lasting internal capability. We operate as a global team, with a presence across the United States, Latin America, Europe, and India, giving our clients access to specialized talent and continuous coverage across time zones.

AboutTheRole

We're looking for a Data Modeler to join Concord's data practice and design the models that sit at the foundation of our clients' data and AI initiatives. You'll work across client engagements in industries such as healthcare, financial services, manufacturing, and retail, building transactional and dimensional models on modern cloud data platforms. This is a hands-on, client-facing role: you'll lead requirements conversations with business stakeholders, own model design from conceptual through physical implementation, and help shape the modeling standards our teams use across engagements.

WhatYouWillBeDoing
  • Design conceptual, logical, and physical data models across client domains such as claims and membership, financial transactions, orders and inventory, and supply chain and production.
  • Build and maintain transactional (OLTP/3NF) and dimensional (star/snowflake schema) models to support operational and analytical use cases.
  • Lead requirements sessions with client business and technical stakeholders and translate them into model designs and data definitions.
  • Partner with data engineering teams to implement models in Snowflake and/or Databricks.
  • Create, manage, and version models in Erwin or comparable modeling tools, including forward and reverse engineering.
  • Maintain data dictionaries, mapping documents, and modeling standards, and contribute reusable patterns to Concord's data practice.
  • Assess existing client models and recommend improvements for performance, consistency, and scalability.
  • Move between engagements and industries as client needs change.
WhatWeAreLookingFor
  • 9+ years of data modeling experience across both transactional and dimensional modeling.
  • Strong understanding of normalization, star and snowflake schemas, slowly changing dimensions, and fact/dimension design.
  • Hands-on experience with Erwin or a comparable data modeling tool (ER/Studio, PowerDesigner, SqlDBM).
  • Strong SQL skills.
  • Experience with Snowflake and/or Databricks.
  • Client-facing experience: running requirements sessions, explaining modeling decisions in plain language, and pushing back when needed.
  • Consulting or professional services experience across multiple clients (strongly preferred).
  • Data modeling experience in two or more of the following industries: healthcare, insurance, financial services, manufacturing, and/or retail.
WhatWeOffer (W2 Benefits)
  • Health, Dental, and Vision Insurance: Comprehensive coverage to support your well-being.
  • Employer Contributions to Health Savings Accounts (HSA): Helping you save for medical expenses.
  • Flexible Spending Accounts (FSA): Options for healthcare and dependent care expenses, plus a $200 Lifestyle Spending Account (LSA).
  • Disability Insurance: Short- and long-term coverage, fully paid by the employer.
  • Life and AD&D Insurance: Employer-provided coverage, with options for additional voluntary coverage.
  • Employee Assistance Program (EAP): Access to personal and professional support resources.
  • Career Growth Opportunities: Pathways for advancement and skill development.
  • Team Engagement Activities: Regular team-building events and company-sponsored activities to foster collaboration and connection.
  • Paid Time Off and Holidays (Only W2 Salary*): PTO policy and paid company holidays.

***

Concord is an execution partner helping organizations drive digital transformation, modernization, and scalable technology solutions. We deliver results that solve real business challenges. We operate globally and are growing fast, shaping the future of technology. Join a team trusted by top companies to drive strategic growth and operational excellence!

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Modeler
Senior Data Modeler

Concord • Minneapolis (MN)

On-site
USD 96,000 - 117,000
Health, Dental, and Vision Insurance:
Employer Contributions to Health SAV
Flexible Spending Accounts (FSA) with
+6
Data Scientist
Data Scientist

Concord • United States

Remote
USD 90,000 - 125,000
Health, Dental, Vision insurance
HSA contributions
FSA options + $200 LSA
+6
Data Scientist II
Data Scientist II

Concord USA • United States

Remote
USD 90,000 - 125,000
Health, Dental, Vision insurance
HSA contributions
FSA options
Principal Software Engineer - Python/AWS
Principal Software Engineer - Python/AWS

Concord USA • Minnesota

Hybrid
USD 160,000 - 180,000
Health, Dental, Vision Insurance
401(k) Matching
PTO & Holidays
Data Scientist II
Data Scientist II

Concord • Kansas City (MO)

Remote
USD 90,000 - 125,000
Health, Dental, Vision Insurance
HSA contributions
FSA options
+6
Join Our Talent Network - Openings USA
Join Our Talent Network - Openings USA

Concord USA, LLC • United States

Hybrid
USD 60,000 - 150,000
Health, Dental, and Vision Insurance
Flexible Spending Accounts (FSA)
Career Growth Opportunities
+1
Senior Scrum Master - Retail/E-commerce (Temporary)
Senior Scrum Master - Retail/E-commerce (Temporary)

Concord USA • Texas

Hybrid
USD 120,000 - 130,000
Health, Dental & Vision Insurance
401(k) with employer match
PTO & Holidays (8 holidays + 1 float)
Senior Scrum Master - Retail/E-commerce (Temporary)
Senior Scrum Master - Retail/E-commerce (Temporary)

Concord • Texas

Hybrid
USD 120,000 - 130,000
Health, Dental, and Vision Insurance
HSA employer contributions
FSA options
Senior Data Modeler
Senior Data Modeler

Hydrogen Group • United States

Remote
USD 96,000 - 124,000
Data Modeler
Data Modeler

OP • Plano (TX)

On-site
USD 90,000 - 120,000
401(k)
Dental Insurance
Health insurance
+1