Lead ETL ArchitectPosted: November 22, 2009
A client of ours in King of Prussia, PA is looking to bring on a Lead ETL Architect to be a key member of an enterprise-wide project.
Our client is embarking on a strategic project to build a next generation Business Intelligence Platform that will serve internal and external data consumers on a global scale. A key component of this project is the ETL data integration foundation. This architecture will be constructed on best-of-breed tools and be designed with the following in mind: flexibility, scalability, strong process run control, audit and offshore development/supportability.
This senior lead position will be in the Products and Technology Group and will play a key role in the design of the new ETL data integration architecture as well as the phased implementation. Strong coordination with the current data warehouse operations team will be required to understand the current state and then jointly define a migration path from old code to new code from a development and support perspective.
This position is ideal for a candidate who has a good mix of senior level communication and planning experience combined with a strong desire to provide hands-on design and problem solving support to project teams as they build out the next generation product on a daily basis.
Responsibilities include:
• Working with current data warehouse operations team to understand the current DW architecture state and challenges experienced
• Defining a roadmap/design document for the new data integration architecture (ETL) that ensures flexibility, scalability, offshore development/support capability, and strong principles of audit, balance and control.
• Developing an architecture standards document for future code design, team based-development and code release management in the new architecture.
• Working with current data warehouse team to define a phased migration path from the old architecture/ETL code to new architecture/ETL product.
• Working with the project team to validate the scope and requirements for the incremental releases of the new and converted existing ETL jobs.
• Serving as a primary thought leader on the data integration tool (IBM Data Stage) and its capabilities.
• Working with the Lead Business Intelligence Architect to ensure that the next generation ETL architecture provides the data required to meet downstream business intelligence requirements for both internal users as well as external consumers.
• Working with portfolio development and sales teams to understand evolving market place requirements for data and ensure that the phased data integration rollout approach is aligned to meet those requirements.
• Working with department management to prioritize work and allocate funding on an annual basis to support each incremental phase of development and required capital expenditures for dev/test/production capacity.
• Ensuring vision, design and projects are in alignment with company business strategy and Product Management vision.
• Working closely with product development project managers to define resources, estimates, project plans needed for future phases.
• During the execution of each phase, assume an active project roll and support development team leads during requirements, design, testing and implementation rollout.
• Providing hands-on problem-solving assistance with data integration and data profiling tools to team leads and developers.
• Working closely with the data warehouse operations team to ensure a smooth transition from new product development to production operation and support.
Qualifications:
Requirements:
• 10+ years of full life-cycle experience in Data Warehousing and ETL/Data Integration
• A successful track record of delivering complex data integration projects on time.
• Significant experience providing technical design review, development plan critique, code review, test plan/results review
• Deep experience with IBM DataStage is required - setup, configuration, design best practices, performance optimization, team based development approaches.
• Global data integration platform rollout experience (e.g. data integration from multiple regions in different time zones, character sets, and business rules)
• Interaction with senior executives to convey technical concepts and assist in messaging about benefits of next generation platform.
• Strong understanding of relational database concepts - data modeling (dimensional/snowflake), SQL, query optimization, data warehouse architecture
• Strong understanding of various data staging approaches for integrating data, persisting data for recovery/audit and loading a data warehouse.
• Strong experience with relational database technology supporting data warehouses/BI reporting (specific Oracle experience is preferred but not required)
• Some level of experience with reporting and analytics tools - OLAP tools, Business Objects, Cognos, Microstrategy
• Experience with Datastage on Linux/Unix platform.
• Knowledge of metadata technologies, techniques and approaches for capturing ETL metadata
• Knowledge of data profiling technologies, techniques and approaches for utilizing as part of upfront analysis and production control operations.
• Knowledge of service-oriented architecture and familiarity with using services to capture upstream events passed via an enterprise service bus into a data warehouse.
• eCommerce, Retail, Supply Chain Management experience preferred, but not required
• Experience estimating ETL development work and creating a matching resource plan.
• Strong leadership, communication and collaboration skills
• Ability to coordinate across multiple infrastructure groups and assist in deployment planning.
• BA/BS in Computer Science, Business or related field Please refer to job code 1888 when responding to this ad.
|
