Data Architect

Data Architect

Job description

ESSENTIAL FUNCTIONS

  • Provide a consultative approach with business users, asking questions to understand the business need and deriving the data flow, logical and physical data models based on those needs

  • Responsible for leading the architectural development of Project/Metadata and reporting framework

  • Experience with Dimensional, Canonical, Rational and Physical data modeling

  • Develops long term portal roadmap and architectures, designs and builds the portal framework per the roadmap

  • Works with Business Analysts to document analytic requirements and translates into technical solutions

  • Works with the Data Warehouse Architect to perform source system analysis, identification of key data issues, and data profiling

  • Assists in ETL design, development, optimization, and support

  • Coordinates with Project Managers and participates in project planning

  • Works with business partners to review prototypes and develop iterative revisions

  • Leads coordination of the QA test process and migration of objects through the change control process

  • Oversees and performs troubleshooting and provides resolutions to reporting issues

    Desired Skills and Experience

  • Minimum of 10 years of experience designing large scale data models for data warehouse environments

  • Diverse experience with database technologies including MPP applicances (Teradata, Netezza, etc.)

  • Strong experience with large data sets (>50TB)

  • 10 years of Data Warehouse experience including demonstrated strong Logical, Canonical, Rational, Dimensional and Physical Data Modeling skills

  • Knowledge and appreciation of business concepts and requirements

  • Ability to apply policies and procedures to solve every day and/or complex company issues

  • Ability to gather business requirements, perform analysis and establish/recommend a data integration architecture

  • Ability to work in a team environment

  • Extensive background in database systems along with a strong knowledge of SQL

  • Excellent communication and documentation skills

  • Experience with agile/scrum is valuable

  • Experience with data modeling and data virtualization tools

  • Ability to exercise initiative, problem-solving and decision-making skills

  • Proven ability to work creatively and analytically in a teamwork-oriented environment

  • Superior interpersonal and communication skills, including the ability to be both directive and collaborative

  • Ability to travel 25%

  • A minimum of a Bachelor’s degree or comparable job-related experience is required

Return to previous page

Submit Resume