Senior Data Modeler
concordusa
- Location
- Multiple Cities/States, MN
- Employment type
- contracted
- Source
- jazzhr
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.
About Us
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.
About The Role
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.
What You Will Be Doing
- 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.
What We Are Looking For
- 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.
What We Offer (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!