Data Warehouse Architect & Modeler

Mindlance, Inc.

Bristol (CT)

On-site

USD 90,000 - 120,000

Full time

14 days+

Get a reply from this recruiter

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

A national recruiting company is seeking an experienced Data Warehouse Data Modeler/Architect to create and maintain data structures for data management solutions. The ideal candidate will have over 5 years of experience and a strong background in data modeling. Responsibilities include developing data models and analyzing complex data structures. Join a fast-paced environment where you will utilize your analytical skills and knowledge of database technologies.

Qualifications

  • 5+ years of experience as a Data Warehouse Data Modeler/Architect.
  • Experience in building complex, large scale logical data models.
  • Excellent analytical and communication skills.

Responsibilities

  • Create relational and dimensional data structures for data management solutions.
  • Develop and maintain data subject area data models.
  • Design and validate data solutions based on architectural principles.

Skills

Data modeling
Data analysis
Communication skills
Database design
Analytical skills

Education

Undergraduate degree in applicable area
BS degree

Tools

Erwin
E/R Studio
Oracle

Job description

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 Description

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.
  • 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
Additional Information

Thanks & Regards’

________________________________________________________________________ ___

Vikram Bhalla | Team Recruitment | Mindlance, Inc. | W : 732 504 6695

All your information will be kept confidential according to EEO guidelines.

By clicking the link above or any third-party link within this posting, you are leaving this site and going to a third-party website where the third-party website's terms and privacy policy apply

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Modeler / Architect
Data Modeler / Architect

Mindlance • Bristol (CT)

On-site
USD 90,000 - 120,000
Senior Data Architect & Big Data Consultant (AWS/Talend)
Senior Data Architect & Big Data Consultant (AWS/Talend)

Mindlance, Inc. • Somerville (NJ)

On-site
USD 96,000 - 165,000
Data Modeler (mid-level)
Data Modeler (mid-level)

Spruce Infotech • Wilmington (DE)

On-site
USD 85,000 - 115,000
Qlik Sense Data Warehouse & BI Architect
Qlik Sense Data Warehouse & BI Architect

Mindlance, Inc. • Wayne (PA)

On-site
USD 90,000 - 120,000
BI Developer & Data Solutions Analyst
BI Developer & Data Solutions Analyst

Mindlance, Inc. • Oakbrook Terrace (IL)

On-site
USD 80,000 - 100,000
Data Architect (Permanent /Full time )
Data Architect (Permanent /Full time )

TecTammina • Richmond (VA)

On-site
USD 100,000 - 120,000
Senior .NET Architect & Applications Lead
Senior .NET Architect & Applications Lead

Mindlance, Inc. • Bristol (CT)

On-site
USD 100,000 - 120,000
Senior Data Modeler: Data Architecture & Metadata
Senior Data Modeler: Data Architecture & Metadata

Artech LLC. • McLean (VA)

On-site
USD 100,000 - 130,000
Senior BI/DW Modeler & Architect
Senior BI/DW Modeler & Architect

Usmsystems • Lexington (MA)

On-site
USD 90,000 - 120,000
Data Architect/ Data Analyst at MA
Data Architect/ Data Analyst at MA

Reliable Software Resources Inc • Framingham (MA)

On-site
USD 90,000 - 120,000