Lead Data Architect

Duties/Responsibilities: The Lead Data Architect works with business groups to gather Business Intelligence requirements and leads the effort in translating them into an effective Data Warehouse design using Dimensional Modeling techniques to maintain data flow for mission critical financial and business applications. Applies Dimensional Modeling techniques and design skills to integrate new data into the existing Warehouse as well as to continuously re-evaluate existing Data Warehouse and Data Marts to ensure optimal performance. Fully documents proposed solutions including data dictionary and related metadata elements. Assists in the design of an efficient, reliable ETL mechanism for updating the Data Warehouse, Data Marts and related objects. Assists the OLAP development team in gathering business requirements and defining supporting Multi-dimensional components of the Data Warehouse. Works closely with the user community, technical staff and team members to develop reporting and analysis specifications and design supporting Data Marts/Dimensional Models and to troubleshoot reported problems with Reporting, Dashboards, and other dependent systems. Works directly with Business and IS&T resources to develop strategies for implementing Data Warehouses. Assists the Systems Architecture and DBA teams in developing approaches to maintaining optimized Data Warehouse solutions, including strategies for aggregation and other derived structures. Works closely with Reporting/Analysis teams to educate end-users on the proper usage of Data Marts. Provides consultation on Data Warehousing design principles to teams developing OLTP applications. Provide input and recommendations on design/technical issues to project manager/senior managers. Minimum Education/Experience Required: Requires a BS or BA in Information Systems, Computer Science, or related course of study, 3-5 years of related experience, proven Data Warehouse design / deployment experience using Star Schemas, reporting and analytics for enterprise data warehouse implementations, and the ability to effectively prioritize and manage multiple assignments. Must be a skilled in communicating with Business users and skilled in listening and translating their requirements into an effective design specification. Demonstrated expertise in concepts underlying varied design techniques and the trade-offs required between the approaches. Extract, Transform, Load (ETL) tool experience required. Experience with Data Modeling tools, Microsoft Office Suite, Visio, and Microsoft Project required. Experience with Large Financial Data Warehouses and/or previous experience with financial reporting and data analysis in a high volume environment a plus. Seeking experience with OLTP and Multi-Dimensional Databases, Informatica, AIX and networking. ~cb~ Position Summary:Works in a data warehouse environment which includes data design, database architecture, metadata and repository creation. Translates business needs into long-term architecture solution. Defines, designs and builds dimensional databases. Responsible for developing data warehousing blueprints, evaluating hardware and software platforms, and integrating systems. Evaluates reusability of current data for additional analyses. Conducts data cleaning to rid the system of old, unused, or duplicate data. Reviews object and data models and the metadata repository to structure the data for better management and quicker access.