Previous Job
Previous
Data Modeler
Ref No.: 17-00580
Location: Providence, Rhode Island
Position Type:Contract
Start Date: 11/01/2017
The Data Modeler position for our client primarily focuses on providing Data architecture and Design logical and physical model for data warehouse. They would interact extensively with cross-functional teams such as Technologists, Business, Release Management and Program Management and other engineering teams.

Role Overview
  • Understand and translate business needs into data models supporting reporting and ad-hoc analysis.
  • Work with the DW Development team to implement data strategies, build data flows and develop conceptual data models.
  • Create logical and physical data models using best practices to ensure high data quality.
  • Optimize and update logical and physical data models as needed.
  • Maintain conceptual, logical and physical data models along with corresponding metadata.
  • Develop best practices for standard naming conventions and coding practices to ensure consistency of data models.
  • Maintain change log for data models
  • Assist ETL and BI teams and end users to understand the data model
  • Create SQL code from data model and coordinate with DBAs to create non-prod and pre-prod databases
Requirements
  • 10+ years of relevant experience or equivalent combination of education and work experience
  • Undergraduate degree and 6-8 years relevant experience or Graduate degree and 4-6 years relevant experience
  • Experience in data modeling
  • Well versed in data architecture, understands how to interpret and integrate conceptual models, logical models, view models (snowflake, star-schema), object models.
  • Well versed and experience with the use of design artifacts and artifact tools, principles and standards for warehousing and BI applications.
  • Understands and has experience with using master data, reference data and meta data concepts for reusability of designs.
  • Sound database concepts (Oracle/Netezza/SQL Server)
  • Excellent in SQL skills
  • Knowledge of any one Data Modelling tool – ERWIN preferred
  • Knowledge of any one ETL tool – DataStage/Informatica
  • Knowledge of Any one BI tools – SAS preferred
  • Experience in implementing data quality and data governance in the application
  • Excellent verbal and written communication skills; ability to communicate at multiple levels, including: programmers, non-technical project managers, business analysts, and customers.
  • Strong problem solving and analytical skills.
  • Collaboration and team-building skills.

Preferences
  • Experience in Healthcare Payer domain
  • Experience in Netezza
  • Experience in IBM stack of Business Intelligence tools