Data Warehouse Principal Architect

Position Description:

Data Warehouse Principal ArchitectFox Interactive Media (FIM), a start-up division of News Corporation, is seeking a Data Warehouse Principal Architect for the FIM Audience Network group. The Data Warehouse Principal Architect is a critical role within Fox Audience Network Group that will be responsible for designing, implementing, and maintaining an infrastructure that provides data to the FIM Audience Network product and ad operations and management functions, as well as potentially other units within FIM, in an efficient and cost effective manner, leveraging existing data sources within the organization, and utilizing the most appropriate technologies.The Data Warehouse Principal Architect will develop robust risk data and control environment that facilitates accuracy, integrity, timeliness, consistency, completeness, validity, and efficient accessibility of data. This will involve ensuring that proper controls, standards, and governance structures are in place over all data related activities, and that controls are tested regularly to ensure they are operating effectively.The Data Warehouse Principal Architect will manage a team of resources responsible for all aspects of the data function, including:•Data Architecture – Implementing an enhanced data architecture that meets the needs of all of the ERM functional areas, and maintaining / updating this architecture (including maintenance of the persistence layer – i.e., operational data store, reporting warehouses, metadata management, etc.) as needed. Implementation of the enhanced architecture will involve determining the effectiveness of existing technologies in relation to the new architecture design, creating a phased migration plan, and recommending which existing technologies need to be replaced or whether new technologies are required. •Data Stewardship – Developing and implementing a clear framework of data governance/ownership and data management policies. Develop data governance framework, clearly delineating data ownership and responsibilities of ERM and all other parties that ERM interacts with. As part of this, single source ownership of data across AIG should be identified in order to minimize duplicate activities and data reconciliation.•Development / Integration Management - The production, identification, and extraction of data from source systems, the transformation and loading of data into databases, and the management and maintenance of tools (i.e., ETL) used to perform these activities. A key objective will be to design and implement processes and technology to vastly improve the speed and efficiency by which data is secured and made usable.•Data Operations/Maintenance - The continual process of monitoring and maintaining data quality including data validation, cleansing/scrubbing, etc.•Data Delivery / Business Intelligence - All the activities involved in making data available to end users and ensuing that it meets their needs. This will involve understanding the reporting requirements of the Data Warehouse functional areas, and creating a central Business Intelligence function that satisfies those requirements in an efficient and user-friendly manner.Required Skills / Experience-A Bachelor’s degree in computer science or a related field is highly desired. Masters is preferred. Specialization/training in data management preferred. -10+ years of experience in enterprise data warehouse architecture principles, methods, techniques and technologies and three years experience with data/information management-related components of large, complex data solutions.-Strong technical understanding of data modeling, design and architecture principles and techniques across master data, transaction data and derived/analytic data; strong technical expertise in data storage/management technologies for both OLTP and DW solutions -Deep knowledge of best practices through relevant experience across data-related disciplines and technologies, particularly for enterprise-wide data architectures, data management and data warehousing/BI-Demonstrated ability to manage senior technology staff, define and execute deliverables on time and in budget.-Able to lead/drive teams to consensus decisions on complex business and technical data challenges -Ability to integrate/synthesize broad and diverse inputs and large amounts of information to formulate cohesive data architecture strategies/solutions -Ability to adapt quickly in a rapidly changing dynamic environment-Detail oriented with excellent follow through. -Excellent verbal and written communication skills.-Ability to prioritize and multi-task across numerous work streams-At Least 10 Years of Experience with a wide variety of databases in the data warehouse environment-Excellent Experience in the conception, creation and manipulation of very large data warehouse (multi-terabyte) and Data Marts-Excellent understanding of various relational database design concepts for VLDB (Terabyte databases)-Excellent knowledge of data modeling tools (e.g. Erwin)-Extensive experience in Data Modeling & Architecture-Familiarity with one of the leading market ETL tools-Excellent ANSI SQL skills and advanced knowledge of OLAP functions-Experience in online advertising desired -Experience with MicroStrategy is a strong plus

To Apply Visit Fox