Minimum Requirements:
Advanced understanding of data model design principles and first-hand experience working in Kimball star schema methodology
Advanced/expert understanding of ETL and data transformation techniques and tools with demonstrable, first-hand experience on large-scale data cleansing and integration projects (this last part is really critical, in case the italics don't make it clear)
*At least 3 years* as either a senior data architect on a large-scale data warehouse OR as the overall data warehouse technical manager (if the latter, this person must have several years of direct experience as a database developer
Description:
· 10+ years of progressive experience in data analysis and architecture
· *At least 3 years* as either a senior data architect on a large-scale data warehouse OR as the overall data warehouse technical manager (if the latter, this person must have several years of direct experience as a database developer)
· advanced understanding of data model design principles and first-hand experience working in Kimball star schema methodology
· advanced/expert understanding of ETL and data transformation techniques and tools with demonstrable, first-hand experience on large-scale data cleansing and integration projects (this last part is really critical, in case the italics don't make it clear)
· solid knowledge of BI and visualization methods and technologies
· experience working in Siebel CRM database technology is a plus but not a requirement
· Participate in all phases of the enterprise data warehouse SDLC
· Establish, maintain and enforce data model design principles, techniques, standards and best practices. Analyze requirements package and architect a data architecture/integration solution that is flexible, highly performing, scalable and correctly manages business data/information.
· Understand data architecture, data integration and infrastructure related risks and develop mitigation plans. Create and maintain conceptual, logical and physical data models, and associated versioning, within a multi modeler repository environment. Establish and maintain comprehensive data architecture and model documentation, including detailed business entity descriptions, attribution, relationships, as well as data capacity, integrity and archival planning. Create and maintain project plans, using work breakdown structures (WBS), as well as establishing LOE and timelines for all activities.
· Interact closely with Business Analysis team, ETL/ELT team and BI Reporting teams to ensure understanding of proper use of data architecture
· Conduct data architecture and data integration design review sessions.
· Assist in source to target mapping activities, in conjunction with the data analysis team.
· Participate as key member of MDM, metadata and data governance design, implementation and maintenance activities
· Participate in performance tuning triage and resolution activities
· Develop data models and integration for MDM related software tools
· Participate in requirements gathering and refinement interviews.