Business Analysis & Controlling Data Visualization Expert

Job Profile: Business Analysis & Controlling Data Visualization Expert

• Location: Hyderabad, India

• Job type: Permanent, Full time

Opella is the self-care challenger with the purest and third-largest portfolio in the Over-The-Counter (OTC) & Vitamins, Minerals & Supplements (VMS) market globally.  

Our mission is to bring health in people’s hands by making self-care as simple as it should be. For half a billion consumers worldwide – and counting.

At the core of this mission is our 100 loved brands, our 11,000-strong global team, our 13 best-in-class manufacturing sites and 4 specialized science and innovation development centers. Headquartered in France, Opella is the proud maker of many of the world’s most loved brands, including Allegra, Buscopan, Doliprane, Dulcolax, Enterogermina, Essentiale and Mucosolvan.

B Corp certified in multiple markets, we are active players in the journey towards healthier people and planet. Find out more about our mission at www.opella.com.

About the job

We are looking for a Data Visualization Expert to join our expanding Business Analysis & Controlling team at Opella Healthcare. This role is primarily focused on the design and implementation of the interactive financial dashboards in Microsoft Power BI based on the data sourced from various corporate financial systems accessible through Snowflake data lake.

As a key member of the BA&C data Visualization team, you will be working very closely with data engineers, ETL developers, and business stakeholders to build standardized, scalable, and high-performing Power BI solution for Opella. You will be playing a central role in ensuring that Opella Finance data visualization meets the analytical and strategic needs of both Finance and non-Finance teams in the short-term as well as in the long-term perspective.

Main responsibilities:

1.    Power BI dashboards development

·        Design and implement interactive dashboards in the Foundation Power BI tool for financial and operational reporting needs based on the Finance Data Foundation from Snowflake.

·        In close collaboration with Opella business stakeholders, translate complex financial data into intuitive visual insights, enabling fast and efficient business decision-making.

·        Ensure high performance, usability, and consistency across all Power BI solutions.

·        Develop and support standardized report views and KPI’s, aligning them with both business and finance stakeholders.

2.    Partnering to Finance, Digital, and Business teams

·        Work closely with Finance, Digital, and Business teams to understand data visualization requirements and translate them into technical BI solutions.

·        Collaborate with data engineers and ETL developers to ensure data models are structured and optimized for reporting.

·        Act as a global point of contact for Business Analysis & Controlling (BA&C) and Finance Performance Lead (FPL) teams on all matters related to Power BI dashboards and templates.

3.    User enablement & governance

·        Maintain and enhance the Power BI user access matrix and related security configuration.

·        Support training and onboarding of the end-users, including documentation, creation of the informative guidelines and training materials.

·        Act as a Power User of the Foundation platform, contributing to dashboard lifecycle governance and best practices, continuously improving performance of Power BI dashboards.

4.    Opella Foundation improvement & automation

·        Lead efforts to automate Opella Foundation reporting, reducing manual effort and enabling real-time analysis.

·        Evaluate and implement new features to Opella Foundation (Smart Narrative, AI visuals, Power Automate, integration with Microsoft CoPilot, etc.) to improve reporting capabilities.

·        Ensure standardization and harmonization of Foundation Power BI dashboard views across functions, brands and geographies.

5.    Documentation & Quality Assurance

·        Document all dashboards in Statement of Work (SoW) and STTM (Source to Target Mapping) formats.

·        Test and validate dashboards to ensure data accuracy and alignment with the source systems.

Experience:

·         3+ years of experience in Power BI development, with a strong focus on Power BI in a finance or corporate reporting context.

·         Proven track record building intuitive and scalable dashboards, ideally using financial data from the systems like SAP, IBM Cognos TM1, and Snowflake.

·         Experience working in cross-functional teams and collaborating with data engineers and business stakeholders.

Soft skills:

·         Strong communication and storytelling skills through data visualization.

·         Proactive and detail-oriented approach with strong problem-solving capabilities.

·         Comfortable working in fast-paced, multicultural environments and engaging with senior stakeholders.

·         Ability to prioritize tasks and manage multiple deliverables effectively.

Technical skills:

·         Deep expertise in Microsoft Power BI including DAX, Power Query, and report/page optimization.

·         Good understanding of data modeling for BI purposes (star schema, relationships, KPIs).

·         Hands-on experience working with Snowflake or similar cloud data warehouses.

·         Knowledge of SAP and IBM Cognos TM1 data structures is a plus.

·         Familiarity with Python, SQL, and other analytics tools is desirable.

Education:

Bachelor’s or Master’s degree in Data Science, Computer Science, Finance, Business Analytics, or another related field.

Why us?

At Opella, you will enjoy doing challenging, purposeful work, empowered to develop consumer brands with passion and creativity. This is your chance to grow new skills and be part of a bold, collaborative, and inclusive culture where people can thrive and be at their best every day.

We Are Challengers.

We are dedicated to making self-care as simple as it should be. That starts with our culture. We are challengers by nature, and this is how we do things:

All In Together: We keep each other honest and have each other's backs.

Courageous: We break boundaries and take thoughtful risks with creativity.

Outcome-Obsessed: We are personally accountable, driving sustainable impact and results with integrity.

Radically Simple: We strive to make things simple for us and simple for consumers, as it should be.

Join us on our mission. Health. In your hands.

www.opella.com/en/careers