Manager - 1

Job Title:

Data Analyst

Job Grade

Manager 1 / Manager 2

Function:

IT

Sub-function:

Power BI, MS Fabric, Azure Cloud

Manager s Job Label:

G9A

Location:

Sun House, Mumbai

Key Responsibilities

Create your own sunshine

Are You Ready to Create Your Own Sunshine

As you enter the Sun Pharma world, you ll find yourself becoming Better every day through continuous progress. Exhibit self-drive as you Take charge and lead with confidence. Additionally, demonstrate a collaborative spirit, knowing that we Thrive together and support each other s journeys.

Job Summary:

As a Data Visualization Analyst, a person should be passionate about Analytics and its use in extracting insights from data. This role is required to develop corporate visualization solutions derived from multiple data sources using state-of-the-art tools to enable insight and decision-making at various levels.

As a data and analytics developer, a person will play a key role in working on projects that may span a broad range of systems, providing subject matter support and technical inputs.

A person should have experience in MS Power Platform / fabric, Tableau, Qlik with focus on report design, data model design, best practices, administration, report design, mashup design, mobility application and have good understanding of visualization aspects.

A person should have experience in multiple sources system connectivity. Ex: SAP, Cloud applications, Oracle, APIs, RDBMS etc.

Handling BI/Analytical requirements at SUN Pharma Global. The resource will work with IT and Business team on the new developments, enhancements & support requirements.

Key Responsibilities:

A professional at this position level has the following responsibilities. Around 5 years of experience in data and analytics platform and technology with strong fundamental knowledge on visualization aspects.

Mandatory Skills:

Power BI , Tableau , Strong knowledge of SAP and Non-SAP Connectors and source system mapping, Basic of design principles and analytical capabilities, Admin

Good to have Skills:

Basic knowledge on SAP BW4HANA, SAP ERP, Azure , Cloud APIs and RDBMS systems.

Duties & Responsibilities:

• Experienced in developing dashboard wireframes.


• Experienced in Microsoft Power platform and tableau development & administration.


• Experienced in complex data model design with data and analytics tool using SAP and Non-SAP sources.


• Experience in report development


• Experience in roles and authorizations


• Extensively worked with business users on data and analytics requirement gathering and KPI design.


• Excellent team player, interfacing across business and technical groups and ability to work independently and highly motivated. Exceptional ability to quickly master new concepts and applications.


• Experienced in Client End User training for domestic and international clients.

Analytics & Reporting:

• Support & Enhancement of available report & dashboard


• Participate in full development lifecycle from system design, development, and testing and production implementation following best practice


• Extract, transform and load data from multiple sources into required data warehouse


• Perform data and systems analysis to translate business needs into technical piece


• Troubleshoot issues with existing data model and dashboards


• Modify existing reports & dashboards creating the next major release that incorporates new features from user feedback


• Handle the system administration, upgrade, migration and authorizations


• Create new dashboards from scratch based on requirements provided from Business Analysts and end users.


• Perform initial QA tests on dashboard changes comparing old versions to new versions. Help gather requirements from the users guiding them to the right decisions by getting to the real business requirements


• Build knowledge repository with IT team members & Power users


• Monitor and address data quality issues. Create and maintain technical & functional design documentation


• Adhere to and help set standards for design and coding, source control and documentation


• Designing authorization matrix


• Created complex Dashboard using Info chart, Icons, Check Box Group, Grid Layout & others components in MS Fabric


• Resolving the complex issues which are arising during the developing the dashboard


• Server sizing & performance tuning

Travel Estimate

As per project need

Job Scope

Internal Interactions (within the organization)

With Business Project stakeholders

External Interactions (outside the organization)

With SMEs , CoEs , Project teams

Job Requirements

Educational Qualification

BSc. IT, BSc. CS, BE.

Specific Certification

Good to have Power BI , Fabric

Experience

Around 5 years

Your Success Matters to Us

At Sun Pharma, your success and well-being are our top priorities! We provide robust benefits and opportunities to foster personal and professional growth. Join us at Sun Pharma, where every day is an opportunity to grow, collaborate, and make a lasting impact. Let s create a brighter future together!