Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Data Modeler

United IT

Data Modeler

Location: Chicago, IL (Onsite)

Exp: 10+ years

Must have: Experience in Insurance Industry, preferably in Property and Casualty Insurance (P&C).

Key requirements:

  • 8+ years of data modelling (conceptual, logical, dimensional)
  • Strong P&C Insurance domain experience

Tools: ERWIN, BigQuery, PostgreSQL, Data Lake & ETL/EDW experience

Job Description:

The Data Modeler role works with stakeholders across technology and product teams to build the data model for the enterprise data warehouse and analytics needs across areas such areas as Underwriting, Claims, Finance, etc.

Essential Duties & Responsibilities:

  • Lead design discussions and create conceptual and logical data models for the Enterprise Data Warehouse
  • Manage and maintain data models and define reporting strategies
  • Perform data quality analysis and propose solutions to identified issues
  • Guide product teams in creating physical data model designs and data dictionaries
  • Review design adherence to ensure standards and best practices are followed
  • Facilitate discussions to understand data sources and establish systems of record
  • Create information architecture roadmaps with current and future state data flows
  • Interact with stakeholders across diverse teams, both IT and business
  • Interprets model results and identifies potential model errors, such as overfitting

Reporting Relationship: Typically Reports to System Architect or above

Skills, Knowledge & Abilities:

  • 8+ years of data modeling experience with expertise in relational and/or dimensional analysis
  • Experience in Insurance Industry, preferably in Property and Casualty Insurance
  • Deep understanding of data modeling principles and architecture concepts
  • Knowledge of different database platforms (relational and NoSQL)
  • Experience with enterprise data modeling tools such as ERWIN
  • 3+ years of experience in a data lake environment
  • Experience with database technologies such as GCP Big Query, PostgreSQL, IICS, Composer, Github etc.
  • Understanding of ETL processes to load large data warehouses
  • Ability to work as an individual contributor
  • Strong communication and collaborative skills to work with agile teams in articulating the model and guiding the development
  • Advanced analytical, critical thinking and problem solving skills to effectively resolve complex situations and issues

Education & Experience:

  • Master's degree or equivalent work experience.
  • Typically a minimum of eight years of related work experience.
Vacancy posted 2 days ago
Similar jobs that could be interesting for youBased on the Data Modeler in Chicago, IL vacancy
  • ## Data Modeler / Analyst - HealthcareUnited States · Full-time · Intermediate#### About The Position**Department:** Client Delivery Team - Empower**Industry:** Information Technology & Services, Computer Software, Management Consulting**Location:** Chicago/New Jersey/... 
    Suggested
    Full time
    Remote work
    Flexible hours

    Exusia

    Chicago, IL
    4 days ago
  •  ...Data Modeler Design and develop data models that effectively support the financial firm's data management, analytics, and reporting goals. Should have strong data modeling skills in data analytics space and experience in working with business areas, done conceptual... 
    Suggested

    Omni Inclusive

    Chicago, IL
    2 days ago
  • $110k - $160k

     ...largest, integrated dataset of multimodal healthcare and clinical data. At Tempus, products are owned and developed by small,...  ...confidence, and at scale. What You’ll Do Manage an enterprise data model in collaboration with clinicians, data scientists, engineers, product... 
    Suggested

    Tempus AI

    Chicago, IL
    3 days ago
  • Tempus AI, Inc. is seeking a Data Model Manager in Chicago, Illinois, to lead the integration of clinical data from various systems. You'll work with a team of clinicians, data scientists, and engineers to establish data modeling best practices and ensure data quality.... 
    Suggested

    Tempus AI, Inc.

    Chicago, IL
    4 days ago
  • $100k - $120k

    Data Modeler - BI Analytics - Onsite (Full Time) Base pay range $100,000.00/yr - $120,000.00/yr This range is provided by The Dignify Solutions, LLC. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more. Overview Data... 
    Suggested
    Full time

    The Dignify Solutions, LLC

    Chicago, IL
    1 day ago
  • Tempus AI in Chicago is looking for a Data Manager to oversee enterprise data modeling and integrate clinical data across various complex domains. The role requires collaboration with clinicians, data scientists, and engineers, demanding strong SQL skills and experience... 

    Tempus AI

    Chicago, IL
    4 days ago
  • A technology solutions provider is seeking a Data Modeler specializing in BI Analytics for an onsite full-time position. The ideal candidate will have over 5 years of data modeling experience, expertise with BI reporting tools, and proficiency in database technologies.... 
    Full time

    The Dignify Solutions, LLC

    Chicago, IL
    3 days ago
  •  ...focused on different domains - Customer, Loyalty, Search and Browse, Data Integration, Cart. Current overriding priorities are new brands...  ...(3+ years). Strong expertise in designing and implementing data models, including conceptual, logical, and physical data models, to... 

    Luxoft

    Chicago, IL
    1 day ago
  • $95k - $105.25k

    DATA ARCHITECT ANALYST Position Details Position Number: 8100402 Work Modality: Hybrid - 3 In-Person Job Category: University Staff Job Type: Full-Time FLSA Status: Exempt Campus: Rogers Park-Lake Shore Campus Department: TECHNOLOGY SERVICES Location Code: INFRASTRUCTURE... 
    Full time
    Work experience placement
    Local area

    Loyola University Chicago

    Chicago, IL
    3 days ago
  •  ...-to-end design, administration, and management of databases and data warehouses. The ideal candidate will have an associate's degree...  ...role, with a current MCSE certification. Strong knowledge of data modeling and ETL tools is required for this position. #J-18808-Ljbffr... 

    InfoBeans

    Chicago, IL
    1 day ago
  • $67.5k - $112.5k

     ...Team Overview This position will report into a Senior Manager Data Science and Analytics. You will apply your analytical skills to...  ...a diverse set of clients, ranging from marketing and propensity models for customer acquisition and retention, credit risk models for acquisition... 
    Full time
    Temporary work
    Work experience placement
    Work at office
    Flexible hours
    2 days per week

    Transunion

    Chicago, IL
    3 days ago
  • $112.48k - $146.54k

     ...today! Job overview and responsibilities The Senior Analyst, Data Protection, is responsible for advancing enterprise data...  ...actions that reduce real-world risk, beyond traditional egress-only models. Detection & Prevention Alignment: Partner with Insider Threat... 
    Hourly pay
    Remote work

    United Airlines

    Chicago, IL
    17 days ago
  • $162k - $262.2k

    84.51° is a retail data science, insights and media company. We help The Kroger Co., consumer packaged goods companies, agencies, publishers...  ...data architectures for the KPM portfolio, including data modeling, integration patterns, pipeline design, and cloud‑native storage... 
    Work at office

    84.51°

    Chicago, IL
    3 days ago
  • $87.5k - $145k

     ...at Alter Domus at careers.alterdomus.com Job Description You will define the logical blueprint for a new commercial data platform — owning the data model, schema governance, taxonomy structures, lineage documentation, and master data strategy. You are the authority on... 
    Local area
    Flexible hours

    Alter Domus

    Chicago, IL
    3 days ago
  • Cuesta Partners is looking for a Data Architect to engage with us on transformational data programs with companies looking to take their...  ...to the next level. Key Areas of Focus: Business data modeling Trade-offs between different modeling philosophies - dimensional... 
    Work experience placement
    Flexible hours
    Shift work

    Cuesta-Partners

    Chicago, IL
    3 days ago
  • $93.6k - $154.44k

    Data Architect I Location: Simpson Querrey Biomedical Research Center Job Description Will be responsible for designing, creating, deploying...  ...Teams applications. Microsoft Azure experience. Advanced data modeling design experience. Experience in overall data solutions (ETL,... 
    Work at office
    Flexible hours

    10 HOSP Ann & Robert H. Lurie Children's Hospital of Chicago

    Chicago, IL
    3 days ago
  • $131k - $178.5k

     ...better solutions and fuels our culture of energy and camaraderie. Data Architect - Role Overview As a Data Architect, you will design...  ..., integrating structured and unstructured data into unified models. Build and optimize enterprise data platforms, including data lakes... 
    Temporary work

    Inspire11 Ranks No. 110 on Inc

    Chicago, IL
    3 days ago
  • $154k - $278.8k

    The challenge The BI data architect will be responsible for helping design and build data solutions to support the $2B+ Digital Media...  ...design and implement the necessary database tables and Tabular models. In this role, you will be working with a complex assembly (100... 
    Temporary work

    Adobe

    Chicago, IL
    3 days ago
  • $150k - $190k

    Data Architect Hybrid / Full Time / Wayne, PA or Portsmouth, NH At Novocure, we’re working to extend the lives of patients battling...  ...MDM, ODS, and other enterprise platforms Develop enterprise data models, integration patterns, and architecture standards that support... 
    Full time
    Local area

    Novocure

    Chicago, IL
    3 days ago
  • Senior Cloud Integration Architect Responsibilities Canonical event and data models Integration contracts between systems Data modeling approaches (including event‑based and relational patterns, and data vault where it makes sense) Design Azure‑based services for ingestion... 
    Worldwide

    Dexian

    Chicago, IL
    3 days ago
  •  ...Chicago, IL Responsibilities Responsible for ensuring that the data management and governance frameworks are in place and adhered to...  ...AWS services. Responsible for developing and optimizing database models to store and retrieve company information. Responsible for... 
    For contractors
    Work experience placement

    TechDigital Group

    Chicago, IL
    4 days ago
  • $159.8k - $188k

    Are you ready to make an impact? As a Data Architect at West Monroe, you will lead the design, implementation, and optimization of data...  ...technical documentation, including architecture diagrams, data models, and operational procedures. Incident Management: Lead... 
    Local area
    Flexible hours

    Dormont Manufacturing Company

    Chicago, IL
    5 days ago
  •  ...leverage advanced technology, quantitative research, and sophisticated models to capitalize on opportunities in global markets. Our culture is...  ...succeed. Position Overview We’re seeking an Architect (On-prem) Data Engineer to define and build the firm’s data strategy and core... 
    Flexible hours

    MA CAPITAL U.S. LLC

    Chicago, IL
    1 day ago
  • $110.8k - $184k

    Sr Data Warehouse ArchitectSkip to main contentThis Shirley Ryan AbilityLab (“SRAlab”) Career Site is hosted externally by Workday. Workday...  ...into technical data warehouse architecture, implementable data models, and data pipeline strategies. Key Responsibilities: Data... 
    Work at office

    Shirley Ryan AbilityLab

    Chicago, IL
    2 days ago
  • Payline Data creates solutions that deliver exceptional payment experiences - solutions that make payments faster, easier and more secure. Our company is built on the foundation of empowering our employees, customers and partners to achieve their greatest potential, while... 
    Work from home

    Payline Data

    Chicago, IL
    3 days ago
  •  ...Senior Project Architect to join our Industrial architecture team in Chicago. In this role, you will oversee the architectural design of data center projects, ensuring the highest standards of quality and innovation. The successful candidate will have a professional degree... 

    Arcadis

    Chicago, IL
    3 days ago
  • Shirley Ryan AbilityLab is seeking a Senior Enterprise Data Warehouse Architect to design, implement, and optimize enterprise data warehouse...  .... You will translate business requirements into scalable data models and data pipeline strategies, collaborating with data engineers,... 

    Shirley-Ryan-Ability-La

    Chicago, IL
    2 days ago
  •  ...Analytica is seeking a Senior Data Architect to design, implement, and optimize enterprise data solutions in support of federal government...  ...teams to ensure alignment with mission objectives. Develop data models, pipelines, APIs, and integration strategies across multiple... 
    For contractors
    Local area
    Remote work

    GrabJobs

    Chicago, IL
    1 day ago
  • $112k - $160.4k

     ...solutions. Domain expertise in Client Services and Client reporting data for Asset Management Build and manage end to end data analysis...  ...informed decision making. Design and maintain logical data models (i.e., system agnostic models), ensuring alignment with business... 
    Work experience placement

    TIAA

    Chicago, IL
    5 days ago
  •  ...responsible for leading the design, integration, and optimization of data solutions while collaborating with various stakeholders....  ...business analysis and data architecture roles. Strong SQL and data modeling skills are required, alongside a background in customer loyalty... 
    Contract work

    Akkodis

    Chicago, IL
    3 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Data Modeler. Be the first to apply!