Job #: 2016-67
Title: Data Modeler – Whitehouse Station
Job Type: Contract to Hire
Region: Central New Jersey
Salary Range: $100,000 to $125,000
Contract Pay Rate: 60-75/hr
Function:
Specialty:
Degree:
Job Details:
The role of the senior data modeler is to develop conceptual, logical and physical data models for data marts. This role will involve in establishing data modeling best practices and installing/administering a data modeling tool.
· Communicate and collaborate with internal and external customers. Analyze/create requirements for incorporation into data models
· Design and develop conceptual, logical and physical data models for data marts. Co-ordinate with DBA team for the physical implementation.
· Responsible for establishing data modeling best practices. Implement and administer data modeling tool (Erwin)
· In collaboration with other data modelers, helps to establish a Master data model for MDM implementation
· Bachelor’s degree (or equivalent) in CS, IT or related field
· 5-8 years of experience in data modeling for data marts using Erwin or similar tools
· Experience in model creation for master data management (MDM) solution
· Expertise in dimensional data modeling and sound knowledge of data warehouse concepts
· Experience in installing and administering data modeling tools
· Microsoft SQL Server current and past versions to 2008 proficiency and stored procedure and function development experience
· Strong proficiency with SQL and experience with SQL query tuning and optimization
· Experience with MS Azure Technologies
· Database tuning experience
· Ability to work in an agile environment
· Knowledge to troubleshoot potential issues, and experience with best practices around database operations
· Excellent written and oral communication skills, ability to articulate and document data models and related documentation
· Working knowledge of ETL toolsets
· Ability to work independently as well as collaboratively
· Hands on experience on Big Data technologies and integrating it with Data Warehouse a plus