Business Systems Analyst 4

Req # 4182
Location : Sunnyvale.
Type: Full Time

Job Summary:

Reporting to Senior Manager Business Intelligence Operations the Business Intelligence Applications Service Lead will have full responsibility for the daily/weekly/monthly operational activities of the EDW Operations team. This role is a key IT position responsible for owning the EDW area in terms of level one support as well as metrics development, documentation management and production operations execution. The successful candidate will work closely with internal support team and third party managed service providers to close management of all EDW daily, weekly and monthly processing as well as prompt resolution of issues arising in the EDW area and the development of robust and scalable processes to enhance the productivity of the ETL (Extract, Transform, Load) aspect of the reporting environment. A background in the area of enterprise reporting is preferred including management of data extraction from a variety of source systems, employment of a tier one ETL tool and strong background in reporting systems.

Job Requirements:

- Manage the third party vendor providing level one support for the EDW application for internal sales users and employees.

- Enhance and modify per business requirements the processes to manage the ETL aspect of the EDW for daily, month end and quarter end close processes.

- Work closely with the level 2 support team to drive closure on any issues that arise in the course of normal ETL processing activity where published service levels are not met.

- Manage the ongoing monitoring of the production environments for the EDW including alert management as well as trend reporting to feed into the ongoing capacity planning exercises.

- Evaluate and select suitable tools to provide automated monitoring for the ETL area to increase employee efficiency and drive lower cost in this area.

- Monitor and manage the existing support tickets in the Help Desk call tracking system to ensure the timely closure of open tickets and provide weekly reporting metrics for the support area.

- Manage the enhancement of metrics reporting for the ETL area to provide automated dashboard provision on performance supported by available on-line metrics.

- Proven experience and track record supporting EDW platforms with good understanding of underlying ETL function to deliver data to the EDW.

- Experience working with one of the tier one EDW and ETL platforms.

- Large scale project and program management experience, including full-cycle tier-1 EDW system implementations.

- Production system support responsibility for a major high-tech company in a fast-paced, high growth, dynamic and global environment.

- Exceptional interpersonal and communications skills.

- Ability to make and own key decisions, while balancing input from key business stakeholders.

- Strong organization and facilitation skills.

- Ability to work under pressure and manage multiple tasks against set deadlines.

Education and Experience:

- BA or BS degree in Information Systems, Computer Science or Business Operations; MBA a plus.

- 5+ years proven leadership and relevant operational experience.

- Demonstrated success in collaborating with business units for strategic, large scale IT project implementations.

- Minimum 5-8 years in IT application development, project management, system deployment and production support with at least 5 years focused on the reporting functional area.