This is a hands-on position that requires both technical understanding of the DW/BI development process and solutions and strong business communication skills.
Data Architects must have expertise in the areas of relational theory, data normalization and entity-relationship modeling as well as dimensional modeling.
They must also have broad data warehousing experience
Facilitate the creation of the Enterprise Data Model
Participate in analysis phase of BI projects
Create logical and physical data models for all BI projects
Perform source system data quality analysis
Establish data quality requirements
Oversee development of data definitions for assigned subject area(s)
Works with end users, and business analysts to design Business Intelligence Solutions
Demonstrated data modeling experience, including strong relational and dimensional data model design skills, applying enterprise data architecture considerations when designing and developing solutions for individual projects.
Demonstrated management of the full lifecycle of database development process from logical model to physical model through to implementation and maintenance of that model in production.
Bachelors degree in Computer Science, Engineering, or related field, a Masters degree preferred
4 to 6 years experience in database design, data flow definition, data modeling, and canonical modeling.
4 to 6 years experience working with Oracle and in one of the MPP databases (Greenplum, Teradata, Vertica), specifically including designing and performance tuning.
3 to 6 years experience integrating data from multiple disparate systems.
3 to 6 years experience in BI Applications
3 to 6 years experience in Multi-dimensional databases
Possess excellent verbal and written communication skills.
Is a solid team player with demonstrated successes in a group environment and ability to lead technical projects in addition to being a technical resource.
Demonstrate strong skills in customer satisfaction.
Solid team player with demonstrated successes in a group environment and ability to lead technical projects in addition to being a technical resource