Randstad Data Modeler in Boston, Massachusetts
salary:$65 - $70 per hour
date posted:Thursday, October 12, 2017
Rates will vary based on experience.
Data modeler builds data models that describe data and its relationships in a consistent way to support business and technical objectives.
Create, document, and maintain logical and physical database models that are compliant with enterprise standards
Facilitate data requirements meetings with business and technical stakeholders resolving conflicts to drive decisions and consensus.
Assist in establishing, maintaining, and enforcing data model design principles, techniques, and standards
Establish and maintain comprehensive data model documentation including detailed descriptions of business entities, attributes, and data relationships as well as the definition of business rules governing the integrity, archiving, and audit requirements of the data
Analyze existing systems using manual or automated data analysis/profiling to reverse engineer data requirements.
Determine suitable data modeling approach for each project based on business requirements for data capture and access
Ensure the proposed data models follow Data Architecture guidelines and best practices
Assist developers with complex query development and performance optimization
Performs additional duties as required
Bachelor's Degree with a major in Computer Science, Business Data
Processing, Computer Information Systems or related field is required.
Minimum three - five (3-5) years data modeling experience, understanding of enterprise and reporting modeling concepts, including dimensional modeling, snowflakes, slowly changing dimensions, irregular dimensions, and surrogate, compound and intelligent keys, good understanding of modeling techniques used build models for OLTP, OLAP and Schema on Read scenarios.
Experience with Embarcadero ER/Studio (preferred)