Demo

Data Modeler

Next Level Business Services, Inc.
Madison, WI Full Time
POSTED ON 1/24/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 Chicago, IL Full Time
    Test programs or databases, correct errors and make necessary modifications. Modify existing databases and database mana...
    Next Level Business Services, Inc.
    Hired Organization Address San Jose, CA Full Time
    Role : UX DesignerLocation : San Jose, CADuration : Full TimeJob Description : Experience working in a dynamic UX practi...
    Next Level Business Services, Inc.
    Hired Organization Address Atlanta, GA Full Time
    Develop solid and supportable modular designs for data streaming, Cloud transformation / migration, and API product deve...
    Next Level Business Services, Inc.
    Hired Organization Address Chicago, IL Full Time
    Job Details Level of Hiring: Director Location: Central (Chicago, Dallas) Mandatory: Hunting sales experience/new logos ...

    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 Modeler (insurance Domain)

    Atria Group LLC, Madison, WI

    Lead Data Modeler

    Quartz Health Solutions, Madison, WI

    AI Assistant is available now!

    Feel free to start your new journey!