Manager BIGCOE

This role will be part of the Business Intelligence COE, which is a global team that leverages technical expertise to enable Lilly to achieve our financial objectives. We support global Planning Forecasting and Reporting (PFR) to our executives, affiliates, hubs, regions, and corporate consolidations. Lilly has implemented SAP Analytics on Cloud (SAC) for financial planning transforming our current planning, forecasting, and reporting tools and technology to new cloud-based solutions.

This role requires a skilled SAP SAC (SAP Analytics Cloud) Planning Developer and User Support Specialist to join our dynamic team. The ideal candidate will have expertise in SAP SAC planning functionalities, strong analytical skills, and a deep understanding of financial planning and analysis processes. You will be responsible for designing, developing, and maintaining planning models, reports, and dashboards within SAP Analytics Cloud to support strategic decision-making and operational efficiency.

Key Objectives

• Model Development: Design and implement planning models in SAP SAC, including creating input forms, calculations, and integrations with other data sources.
• Data Integration: Configure and maintain data connections between SAP SAC and various data sources such as SAP ERP, SAP BW, and other external systems.
• Report and Dashboard Creation: Develop interactive reports and dashboards to provide actionable insights and facilitate data-driven decision-making for various stakeholders.
• Performance Optimization: Monitor and optimize the performance of planning models and reports to ensure timely and accurate data processing.
• Troubleshooting and Issue Resolution: Identify and resolve technical issues related to SAP SAC planning models and integrations.
• Documentation: Create and maintain comprehensive documentation for planning models, processes, and system configurations.
• User Training and Support: Provide training and effective support to SAC Planning users,
• Collaboration: Work closely with Business Stakeholder s and Business Intelligence teams to ensure seamless integration and optimal performance of SAC Planning solutions.
• Continuous Improvement : Identify areas for improvement in SAC Planning processes and provide recommendations for enhancements.
• Well versed with Microsoft suites like POWER Apps, Power flow, power BI.

Other Requirements

• Project Management: Lead SAC implementation project, overseeing timelines, budgets, and resources to ensure successful delivery within scope
• Data debugging and error resolutions for existing developed objects
• Microsoft suites knowledge in POWER Application, POWER BI Dashboarding.

Basic Qualifications:

• Bachelors degree in finance, Accounting, Business Administration, or equivalent work experience
• Relevant certifications in SAP SAC or SAP BI are a plus.
• Experience: Minimum of 3-7 years of experience in SAP SAC, with a focus on planning and analytics. Prior experience with SAP BW, SAP ERP, or other SAP modules is highly desirable.

Technical Skills:

• Proficiency in SAP Analytics Cloud (SAC) planning functionalities.
• Strong knowledge of data integration techniques and ETL processes.
• Experience with scripting languages such as SAC s scripting language, JavaScript, or SQL.
• Familiarity with financial planning processes and concepts .

Analytical Skills: Excellent analytical and problem-solving skills, with the ability to translate complex business requirements into effective planning solutions.

Communication: Strong interpersonal and communication skills, with the ability to work collaboratively with both technical and non-technical stakeholders.

Project Management: Ability to manage multiple projects simultaneously, with a focus on meeting deadlines and delivering high-quality solutions.

Additional Skills Preferences

• Demonstrated ability to work effectively cross-culturally and in a global team
• Strong organizational and interpersonal skills and the ability to be flexible in varying environments and with multiple customer groups
• Strong verbal reasoning, attention to detail, critical thinking, problem solving, and analytical abilities
• Demonstrated ability to influence both internal and external business partners and develop strong relationships
• Strong verbal reasoning, critical thinking, problem solving, and analytical abilities

Role: Database Manager

Industry Type: Pharmaceutical & Life Sciences

Department: Engineering - Software & QA

Employment Type: Full Time, Permanent

Role Category: DBA / Data warehousing

Education

UG: Any Graduate

PG: Any Postgraduate