ZipRecruiter

Log In

1

Professional Data Modeler Jobs in Illinois (NOW HIRING)

CSpring

Data Modeler

Springfield, IL · On-site +1

$54.25 - $70.25/hr

We're seeking talented professionals who are collaborative, curious, and committed to making a ... Lead data architecture, data modeling, and data movement initiatives to enhance the data warehouse ...

CSpring

Data Modeler

Springfield, IL

$54.25 - $70.25/hr

We're seeking talented professionals who are collaborative, curious, and committed to making a ... Lead data architecture, data modeling, and data movement initiatives to enhance the data warehouse ...

CSpring

Data Modeler

Springfield, IL · On-site

$54.25 - $70.25/hr

We're seeking talented professionals who are collaborative, curious, and committed to making a ... Lead data architecture, data modeling, and data movement initiatives to enhance the data warehouse ...

MSR Technology Group

IL EDW Data Modeler

Springfield, IL · Remote

$54.25 - $70.25/hr

Senior Health Data Modeler (Healthcare EDW) - Remote Remote (Must reside within the Continental U.S ... Collaborative team of data architects, engineers, and analytics professionals If you're passionate ...

Accenture

Knowledge Modeler / Ontologist Manager

Chicago, IL · On-site

$56.50 - $73.25/hr

We Are: Accenture is a global professional services and solutions company that helps leading ... Map traditional data structures (e.g., relational databases) into semantic frameworks * Build and ...

US Bank

Quantitative Modeler Manager - AML

Chicago, IL · On-site

$56.50 - $73.25/hr

Professional communication skills are crucial as this individual (and their work product) will ... data compilation, programming skills and qualitative analysis skills - Thorough knowledge of the ...

blueStone

Sr. Data Analyst

Chicago, IL · Remote

$88K - $111K/yr

... level IT professionals worldwide. We are seeking an experienced Sr. Data Warehouse / Business ... Data modeler/analyst must have good experience in rational database systems and architecture.

Socket.dev

Staff Data Architect

Chicago, IL · On-site

$157 - $192/hr

Establish enterprise data modeling strategies including conceptual, logical, and physical models ... Google Professional Data Engineer Certification. * Google Professional Cloud Architect ...

The Aspen Group

Manager, Data Engineering

Chicago, IL · On-site

$160K - $190K/yr

S. and has supported over 20,000 healthcare professionals and team members with close to 1,500 ... Set standards for data modeling, integration, and platform architecture across dbt, Airflow/Cloud ...

The Aspen Group

Manager, Data Engineering

Chicago, IL

$160K - $190K/yr

S. and has supported over 20,000 healthcare professionals and team members with close to 1,500 ... Set standards for data modeling, integration, and platform architecture across dbt, Airflow/Cloud ...

HUB International Limited

Data Engineer

Chicago, IL · On-site

$105K - $126K/yr

Develop, and support scalable data models and ETL/ELT pipelines using GCP technologies . * Build ... Certifications such as Google Cloud Professional Data Engineer , Cloud Architect , or HashiCorp ...

HUB

Data Engineer

Chicago, IL

$105K - $126K/yr

Develop, and support scalable data models and ETL/ELT pipelines using GCP technologies . * Build ... Certifications such as Google Cloud Professional Data Engineer , Cloud Architect , or HashiCorp ...

next page

Showing results 1-20

All JobsProfessional Data Modeler JobsProfessional Data Modeler Jobs in Illinois

Professional Data Modeler information

What is the difference between Professional Data Modeler vs Data Analyst?

AspectProfessional Data ModelerData Analyst
Required CredentialsBachelor's in Computer Science, Data Management, or related field; certifications like CDMPBachelor's in Statistics, Mathematics, or related field; certifications like CAP or Microsoft Data Analyst
Work EnvironmentDesigning data structures, creating data models, collaborating with database developersAnalyzing data sets, generating reports, providing insights for decision-making
Employer & Industry UsageUsed in data warehousing, database design, enterprise data managementUsed across finance, marketing, healthcare, and business sectors for data-driven decisions

The Professional Data Modeler focuses on designing and structuring data systems, while the Data Analyst interprets data to provide actionable insights. Both roles require strong analytical skills but differ in their primary responsibilities and work environments.

How much do data modelers make?

Data modelers typically earn a median annual salary between $80,000 and $120,000, depending on experience, location, and industry. Senior data modelers with advanced skills in database design and data management tools can earn higher salaries, especially in large organizations or tech hubs.

What are the most commonly searched types of Data Modeler jobs in Illinois?

The most popular types of Data Modeler jobs in Illinois are:

What are popular job titles related to Professional Data Modeler jobs in Illinois?

For Professional Data Modeler jobs in Illinois, the most frequently searched job titles are:

What job categories do people searching Professional Data Modeler jobs in Illinois look for?

The top searched job categories for Professional Data Modeler jobs in Illinois are:

What cities in Illinois are hiring for Professional Data Modeler jobs?

Cities in Illinois with the most Professional Data Modeler job openings:

Professional Data Modeler jobs near you

Data Modeler

CSpring

Springfield, IL • On-site, Remote

$54.25 - $70.25/hr

Full-time

Posted 10 days ago

Job description

Job Type
Full-time
Description
At CSpring, we believe in the power of data to drive decisions and real-world impact. We're a purpose-driven consulting firm specializing in data strategy, data engineering, and data analytics. Our clients span the public and private sectors, and our work helps them solve complex problems, gain insights, and achieve measurable results.
We're seeking talented professionals who are collaborative, curious, and committed to making a difference that thrive at the intersection of data, technology, and business strategy. Whether you're passionate about transforming public programs, enabling executive decision-making, or modernizing legacy systems, you'll find meaningful work and purpose here.
Why You'll Love Working Here
  • Purposeful Projects - Improve systems that serve real people by delivering smarter data, streamlined processes, and strategic insight.
  • People-First Culture - We're as committed to your growth as we are to delivering high-impact solutions. You'll find support, autonomy, and community here.
  • Strategic, Hands-On Work - From data architecture and documentation to client workshops and solution delivery, you'll influence every step of the process.
  • Collaborative Trust - Our clients rely on us to listen carefully, deliver consistently, and guide wisely. We partner with integrity, curiosity, and heart.

What You'll Do
Working closely with data architects, ETL/data engineers, BI developers, DBAs, and business subject matter experts, the Senior Health Data Modeler ensures data structures are scalable, standards-compliant, well-documented, and aligned to enterprise and regulatory requirements across the Health and Human Services ecosystem.
Data Architecture & Strategy
  • Develop and deliver long-term strategic goals for data architecture vision and standards in conjunction with data users, clients, and other key stakeholders.
  • Lead data architecture, data modeling, and data movement initiatives to enhance the data warehouse supporting analytics for Medicaid, Medicare, and Commercial healthcare data - including domains such as claims, provider, TPL, and member information subject areas.
  • Create an end-to-end vision for how logical design translates into one or more physical databases and how data flows through successive stages.
  • Document data architecture and the enterprise environment to maintain a current, accurate view that supports a single version of the truth and scales to future analytical needs.

Data Modeling & Design
  • Analyze and translate business needs into long-term solution data models; evaluate existing data systems and work with the development team to create conceptual data models and data flows.
  • Design and maintain conceptual, logical, and physical data models across staging, integration, and semantic/presentation layers.
  • Develop dimensional models (Kimball star/snowflake), normalized (OLTP/3NF), OLAP, and Data Vault patterns; implement Slowly Changing Dimensions, role-playing dimensions, dimensional hierarchies, surrogate keys, and data classification.
  • Define primary/foreign keys, indexes, partitioning, constraints, and referential integrity rules to ensure data quality and performance.
  • Produce and maintain entity-relationship diagrams (ERDs), data flow diagrams, and model documentation using Erwin or equivalent tools.

Governance, Quality & Compliance
  • Ensure data strategies and architectures are in regulatory compliance; identify where existing policies and procedures require change or where new ones are needed.
  • Oversee the mapping of data sources, data movement, interfaces, and analytics with the goal of ensuring data quality.
  • Create and maintain data model and metadata policies and procedures for functional design; maintain data dictionaries, business glossaries, and lineage documentation.
  • Support classification and protection of sensitive data (PII, PHI) in alignment with HIPAA, PHI, and SOX requirements.

Collaboration & Delivery
  • Provide technical recommendations and engage with ETL Architects, Business SMEs, and other stakeholders throughout the Solution/Data Architecture and implementation lifecycle to develop high-performance, highly scalable data solutions (data marts/warehouse, data mining, and advanced analytics).
  • Address data-related problems regarding systems integration, compatibility, and multiple-platform integration.
  • Develop and implement key components and testing criteria to guarantee the fidelity and performance of data architecture.
  • Communicate with the customer and project team in a timely manner and escalate issues and risks appropriately.

Modernization & Migration Support
  • Contribute to migration of legacy Teradata models to modern cloud platforms (Azure Synapse / Databricks Lakehouse, Snowflake).
  • Design target-state models leveraging medallion (Bronze/Silver/Gold) architecture, Delta Lake, and Parquet patterns.
  • Assess existing models for modernization opportunities, redundancy, and optimization; recommend improvements to architects.

Requirements
  1. Strong problem-solving, influencing, communication, and presentation skills; self-starter.
  2. 7+ years of Experience in data modeling, data strategy, and roadmap for large and complex health entities and systems; implemented large-scale, end-to-end Data Management & Analytics solutions for more than one large client.
  3. 5+ years of Strong knowledge of regulatory security requirements regarding HIPAA, PHI, PII, and other healthcare data security standards.
  4. 5+ years of Experience with Erwin Data Model (or comparable tools such as ER/Studio, SQL Developer Data Modeler).
  5. 5+ years of strong healthcare domain knowledge of Medicaid, Medicare, and Commercial healthcare data sets.
  6. Expertise with normalized OLTP, OLAP, MDM, and dimensional modeling techniques - star schemas, slowly changing dimensions, role-playing dimensions, dimensional hierarchies, and data classification.
  7. 5+ years of Expert-level SQL skills with direct experience writing complex analytic queries, stored procedures, DDL, DML, and DCL; thorough knowledge of query optimization and the ability to write to ANSI standards and review others' code.
  8. 5+ years of experience in Data Quality, Data Profiling, Data Governance, Data Security, Metadata Management, MDM, Data Archival, and Data Migration strategies using appropriate tools.
  9. Demonstrated ability to work in a fast-paced, changing environment with short deadlines, interruptions, and multiple concurrent tasks/projects.
  10. Ability to work independently with strong planning, strategy, estimation, and scheduling skills.

Preferred Qualifications
  1. Experience with Microsoft Azure cloud infrastructure and services (Azure Data Lake Storage, Azure Data Factory, Purview, Azure Maps, etc.).
  2. Experience with Snowflake DBMS, including object design and performance tuning.
  3. Experience with Power BI or Tableau.
  4. Experience supporting State Medicaid EDW, MMIS, or federal reporting programs (T-MSIS, PERM, MARS, Quality of Care).
  5. Exposure to Teradata Vantage 20 and modernization of Teradata workloads onto cloud platforms.
  6. Familiarity with Delta Lake / lakehouse architecture and Microsoft Fabric.
  7. Exposure to AI/ML and GenAI tools (e.g., GitHub Copilot, Microsoft 365 Copilot, Snowflake Cortex) for accelerating modeling, documentation, and metadata enrichment.
  8. Hands-on experience with ETL tools (e.g., Informatica, Azure Data Factory).
  9. Hands-on experience with BI tools and reporting software.
  10. Experience with a scripting language used for analytics such as Python or R.

Come Build With Us
At CSpring, we unlock the potential of people and data. If you're ready to lead meaningful projects, collaborate with passionate teams, and grow your career in a people-first consulting environment-apply today!

Apply