Job Details

Data Architect - III

MINNEAPOLIS-55402, MN, US
01/15/2020

-


Required Skills

    SQL
Company

Infinity Consulting Solutions, Inc

Experience

5 to 8 Year(s)

Job Description

DATA ARCHITECT - III

Minneapolis, MN

1 Year Contract

ICS is hiring a Data Architect - III for our Client in the Minneapolis area! The succesful candidate will provide Data Modeling, Mapping, and Management support to the Organization.

WHAT YOU'LL DO:

Perform high-level requirements analysis to support application of data standards across the enterprise

Duties require a broad range of knowledge including information technology, requirements, technical architecture analysis (e.g., understanding data flow diagrams, system architecture diagrams, etc.), and an
understanding of functional and system analysis

Define and analyze data requirements, map legacy data stores and formats, create new data structures

Coordinate, meet, and hold Technical Peer Reviews with Subject Matter Authorities and Stakeholder communities to discuss and perform requirements and impact analysis to understand the data elements in their domains, relationships among those elements and interdependencies between models

Develop and maintain domain logical data model artifacts: Logical Data Models (LDM), Data Element
Dictionaries (DED), Physical Data Models (PDM), Interface Control Documents (ICD), data format specifications, model release documentation, user guides, data harmonization and mappings

Administer and manage ER/Studio application

Coach and train data staff

Translate business and data requirements into logical data models adhering to defined data modelling
standards and industry best practices

Consult with Database Administrators and Developers to translate Logical Models into a performant
Physical models

Provide guidance to data analysts in performance of analytic and data quality functions

Support analysis and profiling of the most complex data needs

Consult with Business Partners to understanding their business needs and recommend solutions

Translate complex technical concepts into something digestible by our business partners

Build relationships with Subject Matter Expert (SME) of the respective source system development teams

Assist in defining strategy in areas such as Data Integration, Architecture, Data Quality, Meta data
Management and Master Data Management

Act in a consulting capacity to the development team. Utilizing their extensive knowledge of the
application they will understand functional enhancements, consider all potential impact and provide
advice on the most appropriate solutions & potential problems

Ensures adherence to data management/data governance regulations and policies

To a certain degree, may be involved directly or indirectly in the technical build-out and/or support of databases, query tools, reporting tools, BI tools, dashboards, etc. that enable analysis, modeling, and/or data visualization

Develop, document, and maintain conceptual, logical and physical data models for data warehouse and
business intelligence solutions

Generate physical Data Definition Language (DDL)

Develop and maintain source-to-target mapping documentation

Provide technical consulting and advises teams and customers on the design of conceptual and logical data models resulting in an efficient and effective physical design for enterprise data solutions

Experience in data modeling for projects that use Oracle database technologies

Perform data model design reviews and evaluations to ensure that the group standards and best practices are being adhered to and the resulting physical databases meet project needs

Develop, maintain and enhance data modeling and database design documents, policies, procedures

Collaborate with the application developers, architects and project team on logical and physical database design and implementations

Provide expert level guidance on dimensional modeling, on maintaining data histories, and conformed dimensions

Prepare high quality documentation of design architecture database infrastructure documents

Assist in ad hoc projects, assignments and responsibilities as necessary

SKILLS / EXPERIENCE YOU NEED:

8+ years relevant work experience in database architecture that includes senior level experience in data modeling. 6+ years of SQL experience

5+ years of Metadata experience. Master level experience in ER/Studio including creation and use of macros to automate tasks and administering the application

An Associate's degree or higher is preferred

Solid understanding of relation database technologies as well as data warehouse architectures

Experience in data modeling in a financial services provider organization is a plus

Performance optimization and management for relational and dimensional models

Must have experience in managing metadata and supporting data governance initiatives

Must be self-motivated, able to work independently, and highly responsible in maintaining time critical projects schedule

Excellent verbal, written, and interpersonal communication skills

Knowledge and understanding of conversions, system analysis, data mapping, conversion reconcilement, validation and implementations

Ability to independently provide summary and recommendations on operational data

Knowledge and understanding of technical leadership including operations projects for complex
development or high architectural impact projects

Knowledge and understanding of data organizing or structuring complex data across varied data sources

Knowledge and understanding of data requirements management, modeling, or analysis

Knowledge and understanding of database architecture, design, and support

Knowledge and understanding of database design/modeling logical and physical

Knowledge and understanding of database management, reporting, and analysis functions

Knowledge and understanding of database views design and use

Ability to negotiate, influence, and collaborate to build successful relationships, including training staff

Proven experience in entity-relationship and/or dimensional modeling and relational database design with
knowledge of dimensional modeling and data warehousing


Data Architect
Information Technology

No Preference
Contract Only
Other
1

Candidate Requirements
-
Bachelors

Walkin Information
-
1/8/2020
-

Recruiter Details
Doug Klares
1350 Broadway, Suite 2205, NEW YORK-10018, NY
-