Job Description :
Title: Data Modeler
Location: Boston, MA
Title: Data Modeler
Basic Company Info: Investment Management
Location: Prudential Center (only accessible via T – close to both orange/green line 111 Huntington Ave, Boston
Team: Unsure
Team Size: Unsure
Why Open: Growing team, additional help
Start: ASAP
Duration: 3-6 month with possibility of extensions
Important Skills
Interview Process: Phone screen to in person. Candidates must come onsite for an interview, manager will not hire from Skype.
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
Minimum Requirements:
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)