Data Analyst/Data Architect

We are seeking Data Analysts/Data Architects for a regulation change project.

This position is responsible for producing and maintaining conceptual, logical and physical data models, and physical data architecture of data warehouses, data marts, operational data stores and OLTP application databases.

Responsibilities include:
Analyze business requirements and translate into technical specifications and data rules and transformations for ETL designs.
Review documentation on data and profile sample data to confirm documentation or gain further insight for the purpose of producing a relational or dimensional model of the data.
Develop new data models which adhere to client database standards
Enhance existing data models
Create, Maintain and promote DDL
Maintain Data dictionary and other metadata

The position is for a Data modeler/Data Architect. The ideal candidate will be local to one of the following 3 locations: St Louis, Charlotte, Minneapolis.

QUALIFICATIONS

- Must Have: 5+ years experience in dimensional and/or relational data modelling
- Strong analytical skills; especially experience in modelling based on analysis of documentation and profiling of sample data.
- Excellent verbal and written communication
- Excellent time management skills Ability to support multiple projects simultaneously
- Ability to work independently on a project or with a team
- Experience in data warehousing Significant experience with System Development Life Cycle (SDLC)
- Excellent SQL skills Preferred Skills
- Bachelors degree
- Experience in Financial Services (brokerage knowledge preferable)
- Experience with Oracle and/or DB2
- General understanding of how Informatica (or equivalent ETL) works to help inform Data Modeling designs

CLICK AND APPLY TO SUBMIT YOUR RESUME TO SOPHIA FOR IMMEDIATE CONSIDERATION.