Back to Job Search

Data Integration Modeler

Posted 20 days ago

Our Healthcare Insurance client is seeking a Data Modeler to join their team for a contract to hire position!

Our client has more than 5,000 employees and is the number 1 health insurer in the state of North Carolina serving more than 3.89 million customers. Health care is changing, and our client is leading the way by provide innovative solutions that simplify the health care system, improve efficiency and outcomes, and help rein in costs. Our client is a not-for-profit with headquarters in Durham, NC.

Position: Data Integration Modeler
Location:  This position will be work from home until the end of October 2021. Then, they will evaluate when it is safe to return to work at the Durham, NC office again. Alternatively, if you live in one of the following states: Alabama, Arizona, Colorado, Florida, Georgia, Idaho, Maryland, Michigan, Pennsylvania, Tennessee, Texas, Virginia and South Carolina; you may work remotely.
Term: 6 Months, Contract to Hire is the intent

Requirements:

  • At least 3 years of Data Modeling, conceptual, logical, physical 
  • ER Modeling
  • NoSQL Modeling
  • SQL
Preferred:
  • Teradata
  • Healthcare
  • Snowflake
  • HL7 FHIR
  • Successful full life-cycle enterprise data warehousing - inception to implementation.
  • ERStudio
  • ER/Objects/Dimensional Modeling concepts

Day-to-Day Responsibilities: This job exists for the purpose of conceptually, logically and physically modeling data that exists either in transactional or data warehousing systems. Major Job Functions/Components:

Information Modeling

  • Creates fully attributed and documented conceptual, logical and physical models including both Entity-Relationship and presentation models (using star schemas and conformed dimensions) for source and destination.

Requirements Analysis

  • Analyzes data through screens, reports, and source extracts in order to verify assumptions that come out of dialog with the business
  • Communicates with mid-level business managers to confirm logical model based on data requirements
  • Interfaces with Project Manager and IS management to interpret data needs and provide input on impact of requirements and changes
  • Reviews business and analytic requirements in order to capture business rules for logical to physical mapping that will be used by IS to create code to transform raw data into useful information as well as validate and refine data requirements.

Architecture

  • Participates in IS project specific architectural working groups in order to provide expertise in modeling.

Mapping

  • Performs mapping between source and target data, as well as performing logical model to physical model mapping and mapping from third normal form to dimensional (presentation layer).

Standard Query Language

  • Generates first cut physical model DDL and SQL for views for implementation by the DBA. The SQL must be written to optimize views based on the database engine used.

Documentation

  • Captures business rules for logical to physical mapping in metadata (note - metadata is information about data) that will be used by IS to create code to transform raw data into useful information
  • Documents specifications for views that support the way the business will use the data in specific circumstances
  • Promotes logical data models to the production environment in order to capture the most current graphical representation of how the information relates to each other
  • Creates, validates and updates the data dictionary by interviewing IS implementers, business users, querying data directly and analyzing documentation to make sure that the information captured is correct

Standards & Process

  • Facilitates model review sessions in order to confirm that both IS and the business understand the business view of information
  • Escalates project issues in order to make others aware.

Knowledge Sharing

  • Interprets business speak into IS speak in order to allow IS to create solutions for the business knowing that the data structures support the business needs
  • Interfaces with Project Manager and ISDS management to interpret data needs and provide input on impact of changes and requirements requested.

 


 

Candidates will be responsible for following the client's COVID-19 protocols. Please refer to your MATRIX representative for specifics.

About Us

At MATRIX, we expertly match talented professionals with job opportunities to elevate careers. Since 1983, we have placed thousands of professionals at innovative clients across every industry ranging from small startups to Fortune 50 companies. It’s why we’re consistently in the top 25 of all U.S. IT staffing firms and why our consultants rate us well above the industry average, earning us ClearlyRated's Best of Staffing awards year after year. People come to us for a job, and stay with us because of our top-notch consultant care.

MATRIX is and Equal Employment Opportunity employer and provides reasonable accommodations for qualified individuals.  Supporting medical or religious documentation will be required where applicable. If you are a qualified individual with a disability, you may request a reasonable accommodation under the American Disability Act (ADA) by emailing MATRIX_HR@MatrixRes.com. To ensure a quick response to your request, please use the words “Accommodation request” as the subject line of your email.