Data Modeler / Architect
At a glance
Mid-level Data Architecture & Governance role at Mindlance. Bristol · contract.
Pay not stated Data Architecture & Governance salary
dataroles summary, based on the employer's posting.
What you'll do
- Build relational and dimensional structures with architecture, data development and application development teams
- Create and update subject-area models for warehouses, operational stores and data marts
- Map links between subject areas, trace data lineage and identify gaps in complex structures
- Profile source systems and define entities and attributes clearly
- Design and check data solutions against architecture standards and governance principles
What you bring
- At least five years working as a data warehouse modeler or architect
- A relevant undergraduate degree, or equivalent work experience; a BS is required
- Experience creating large logical models with Erwin, E/R Studio or another modeling tool
- Hands-on knowledge of relational and dimensional schemas, physical and logical modeling, and database design
Who this fits
This contract role is based onsite in Bristol, Connecticut. It suits a mid-level data modeler or architect with warehouse modeling experience.
From the employer
Mindlance is a national recruiting company which partners with many of the leading employers across the country. Feel free to check us out at http://www.mindlance.com.
Job Title: Data Modeler / Architect
Location: Bristol CT
Duration: 9 Months
Responsibilities:
- Partner with our architecture, data development and application development teams to create relational and dimensional data structures for data management solutions.
- Develop and maintain various data subject area data models for Data Warehouse, Operational Data Store and Data Marts.
- Define relationships and touch points between data subject areas.
- Data mapping /Data Lineage mapping.
- Gap analysis.
- Analyze complex data structures
- Compose accurate and complete definitions for entities and attributes
- Perform source system analysis and data profiling
- Design and validate data solutions which are achieved through the application of industry proven architectural principles, standards and governance.
Basic Qualifications:
- 5+ years of experience working as an Data Warehouse Data Modeler / Architect.
- Undergraduate degree in applicable area of expertise or equivalent work experience
- Experience in building complex, large scale logical data models with Erwin, E/R Studio, or another data modeling tool
- Experience in relational and dimensional schemas for Enterprise Data Warehouse
- Experience in data modeling (physical and logical), ER diagrams, data dictionary, data mapping
- Experience in Data Architecture and Database design
- Experience with database technologies (e.g. Oracle)
- Excellent analytical and communication skills
Preferred Qualifications:
- Exposure with the below technologies and / or skills will be considered a plus:
- Oracle 11G, Data movement architectural patterns, and a thorough understanding of system development lifecycles.
- Experience in data modeling, data mapping, and data architecture is desirable.
- Required Education BS
Thanks & Regards’
___________________________________________________________________________
Vikram Bhalla | Team Recruitment | Mindlance, Inc. | W: 732 504 6695
All your information will be kept confidential according to EEO guidelines.
Data Architecture & Governance work from LinkedIn, X, Reddit and Upwork, in one list.
Each morning you get everything that fits, strongest first.
Data Architecture & Governance
Find me workBy the team behind dataroles.