Job Details

Email to Friend Save Back

Principal Data Architect

NEW YORK-10006, NY, US
12/06/2016

-

Required Skills

ETL tools

Company

Infinity Consulting Solutions, Inc

Experience

5 to 10 Year(s)

Job Description

Principal Data Architect

The Principal Data Architect will help build out our data warehouse and technical data structure across the firm. Our data capabilities & culture are still in early stages, so this is an opportunity to truly build something from the ground up.

Responsibilities:

Partners with product and engineering teams to develop scalable, extensible systems

Be the driving force behind the roadmap to normalize all of our transactional data, disparate systems, and transfer of data in way that creates a flexible and scalable data solution

Spearhead a broad-based data dictionary initiative to be implemented across the organization, and lead our efforts in cleaning our current & future datasets

Develop data governance policies & appropriate structures to ensure adherence to those policies

Ensure that solutions work well within our current code environment, that technical data initiatives are aligned effectively with development staff, and work to understand how other tiers in the technology stack influence data quality including ORM (Object
Relational Mapping) and User Interface

Responsible for managing the full life-cycle of the data warehouse solution; including the architecture, design, development, implementation, and support of the data warehouse

Participates in the design of the technical and information architecture for the data warehouse

Participates in creating the data design of all transactional data stores across business units and technology stacks

Creates logical and physical data models, mapping logical to physical

Designs, develops, tests, monitors, manages, and validates data warehouse activity,
including data extraction, transformation, movement, loading, cleansing and updating processes

Works with end users to translate business questions and requirements into applications that employ the appropriate reporting tools

Assists in monitoring and troubleshooting system performance, reliability, availability, and recoverability of all data stores

REQUIREMENTS

Bachelor’s degree in Computer Science or related field

10+ years overall experience working in development and enterprise data architecture

Minimum 5+ years of experience with enterprise data architecture/design

Minimum 5+ years of experience in software development with deep experience in Object-
Oriented, Functional, Object-Functional Language and one of the major SQL relational data
stores (we are a SQL Server and MySQL shop)

Experience in leadership roles a plus

Experience with Hadoop, Big Data technologies

Strong relational and dimensional data modeling and database design skills.

Hands-on experience using ETL tools

Ability to investigate complex business problems, develop effective recommendations, negotiate and/or present solutions, and resolve problems in a highly professional and tactful manner.