Demo

Data Modeler

Next Level Business Services, Inc.
Madison, WI Full Time
POSTED ON 3/25/2025
AVAILABLE BEFORE 4/19/2025

Position Title : Data Modeler

Learn more about the general tasks related to this opportunity below, as well as required skills.

Location : Hartford / Windsor, CT

Hire Type : Full Time Only

Job Description :

  • Needs to know dimensional and / or operational / 3NF / transactional modeling.
  • Needs to be able to focus heavily on data dictionary and mapping document work.
  • Experience with XML schema designing skills (using ACORD framework) in addition to modeling.
  • Must be very good at profiling sources and mapping them into the target model.
  • Should have worked on any modeling tool like Erwin, Rational, etc.
  • Excellent communication skills to interact with business customers.
  • Property & Casualty Insurance domain experience is nice to have.
  • Leverage any Industry Data Models (Framework) e.g., IBM Insurance Model (IIW; IAA), Retail Data Warehouse.
  • Must know the industry standard logical naming methods, Metadata management process.

Experience Required :

7 years

Will be directly working with clients and offshore counterparts.

Generic Managerial Skills :

Need good verbal / written communication and analytical skills.

Prescreening Questions :

  • OLTP Design knowledge
  • ODS / 3NF Relational Modeling
  • Email ID
  • Leverage any Industry Data Models (Framework) e.g., IIW, IBM Retail Data Warehouse
  • Rate your Oracle / Erwin skills
  • Data profiling knowledge (Any tools : Trillium; Oracle DQ tool)
  • What kind of large projects have you been handling? Roles?
  • Relevant Experience (number of years)
  • Interaction / collaboration process with external (BA, Architect, Development) teams?
  • Tell me about data modeling in ODS?
  • Which subject areas have you worked on ODS subject area?
  • Availability for Interviews
  • Data analysis, normalized, 3NF
  • Transient database management account management, part day on a daily basis
  • Irrespective nature of data, how do you handle data loads?
  • How did you separate old records from new records to track the timing of the transaction?
  • How would you identify the latest transaction in an ODS atomic / OLAP dimension?
  • Time-variant / time-invariant surrogate keys? Link the latest single instance of the customer with history data in ODS?
  • Additional Information

    All your information will be kept confidential according to EEO guidelines.

    J-18808-Ljbffr

    If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
    Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

    What is the career path for a Data Modeler?

    Sign up to receive alerts about other jobs on the Data Modeler career path by checking the boxes next to the positions that interest you.
    Income Estimation: 
    $89,551 - $118,439
    Income Estimation: 
    $116,726 - $151,072
    Income Estimation: 
    $124,724 - $161,246
    Income Estimation: 
    $89,551 - $118,439
    Income Estimation: 
    $116,726 - $151,072
    Income Estimation: 
    $124,724 - $161,246
    Income Estimation: 
    $81,769 - $104,543
    Income Estimation: 
    $89,551 - $118,439
    Income Estimation: 
    $103,228 - $139,671
    Income Estimation: 
    $124,724 - $161,246
    Income Estimation: 
    $147,901 - $186,323
    Income Estimation: 
    $116,726 - $151,072
    Income Estimation: 
    $147,901 - $186,323
    View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

    Job openings at Next Level Business Services, Inc.

    Next Level Business Services, Inc.
    Hired Organization Address Atlanta, GA Full Time
    Transforming business requirements into conceptual / logical application architectures Determining feasibility & scalabi...
    Next Level Business Services, Inc.
    Hired Organization Address Atlanta, GA Full Time
    Responsibilities : Prioritizing, overseeing, and managing a diverse set of customer data use cases set forth by the ente...
    Next Level Business Services, Inc.
    Hired Organization Address Chicago, IL Full Time
    Contract Position || Sr. SAP WM / Shipping Consultant || Chicago, ILLooking for Green Card & US CitizenJob Responsibilit...
    Next Level Business Services, Inc.
    Hired Organization Address Houston, TX Full Time
    Others as in JD Solutions focus with rich experience spanning goto market & business development Customer Engagement Res...

    Not the job you're looking for? Here are some other Data Modeler jobs in the Madison, WI area that may be a better fit.

    Data & Privacy Analyst/Modeler

    IO Datasphere, Madison, WI

    AI Assistant is available now!

    Feel free to start your new journey!