Senior Analyst

Alexion Pharmaceuticals, Inc.; India; On-site; INR 2,500,000 - 4,000,000; Full time

Job summary

Alexion Pharmaceuticals, Inc. in Bangalore is seeking a Senior Analyst as a Data Reporting and Analytics Developer.

You will design, develop, and maintain data reporting solutions and analytics platforms to empower data-driven decision making across the organization. You will build dashboards in Qlik Sense and Power BI, model data in Snowflake, and collaborate with business partners to translate requirements into robust data models and reporting logic.

Qualifications

• 8+ years of professional experience with SQL, Snowflake, and BI tools.
• Experience building dashboards in Qlik Sense and Power BI.
• Ability to translate business rules into data models.
• Strong communication and collaboration with business teams.

Responsibilities

• Design, develop, validate, and maintain dashboards and data models.
• Collaborate with stakeholders to gather reporting requirements.
• Create SQL-based reporting layer for Power BI/Qlik dashboards.
• Optimize Snowflake queries and data structures.
• Maintain documentation of data models and mappings.

Skills

SQL

Snowflake

Qlik Sense

Power BI

Data modeling

ETL concepts

Data warehousing

SQL scripting

Tools

Snowflake

Job description

Job Title: Senior Analyst

Grade : D1

Shift: 2 pm to 11 pm IST

Role: Individual contributor role.

Location: Manyata Tech Park, Bangalore.

Introduction to role: Are you ready to transform raw data into actionable insights? As a Data Reporting and Analytics Developer, you'll be at the forefront of driving informed decision-making and strategic initiatives within the Alexion Commercial Reporting team. Your expertise in designing, developing, and maintaining data reporting solutions and analytics platforms will empower data-driven decision-making across the organization. Ideal for candidates with strong data analysis skills, proficiency in data visualization tools, database management experience, and superb communication skills.

Accountabilities:

• Support the Alexion Commercial Reporting team by designing, developing, validating, and maintaining Qlik Sense/Power BI dashboards and supporting data models and reporting layer development for various business units and indications.


• Understand business objectives, data sources, and key performance indicators (KPIs) to design effective solutions.


• Collaborate with business collaborators to gather, interpret, and document business rules and logic requirements for reporting use cases.


• Design and implement logical and physical data models in Snowflake that embody the agreed business rules and facilitate easy reporting.


• Create and manage SQL-based tables and views to serve as the reporting layer for Power BI/Qlik dashboards and reports.


• Monitor and tune the performance of Snowflake queries, tables, and views to ensure efficient data retrieval and reporting.


• Carry out data validation, testing, and post-production checks to ensure data accuracy and completeness across the reporting platform.


• Bridge the gap between business customers and technical developers, encouraging clear communication on data requirements and logic implementation.


• Provide timely responses to ad-hoc business queries and investigative requests.


• Maintain up-to-date documentation on data models, business rule mappings, and reporting logic.


• Proactively find opportunities to enhance data processes, optimize models, and improve reporting efficiency.

Essential Skills/Experience:

• 8+ years of professional experience. Advanced understanding/experience with SQL, Snowflake, and Veeva CRM.


• Hands-on experience with Snowflake, SQL, and data warehousing in a reporting environment.


• Ability to create new rules and adjust existing rules in table/view creations.


• Work on creating ER diagrams and Logical data models.


• Familiarity with ETL processes and data integration concepts.


• Proven expertise in translating business requirements into technical specifications and robust data models.


• Develop and maintain comprehensive user documentation for data processes, SQL queries, and data-related workflows.


• Expertise in SQL scripting, data modelling concepts, including related skills in:


• Data warehouse


• Data architecture


• Data visualization


• Security & compliances


• Recent project experience with Qlik/PBI + experience with other BI tools.


• Experience in documenting data processes, data lineage, and reporting frameworks.

Desirable Skills/Experience:

• 6-8 years of experience in developing Data models and Architect schemas.


• Experience with database performance tuning and optimization.


• Knowledge of ETL processes and data integration workflows.


• Excellent analytical and problem-solving skills, with a keen attention to detail.


• Ability to work independently and multi-functionally in a fast-paced environment.


• Good communication and interpersonal skills.


• Snowflake Certified Data Architect

Why AstraZeneca:Here, analytics directly supports teams devoted to people with rare and devastating conditions. You will work with brand new tools and real-world data. The environment blends the energy of a nimble biotech with the reach of a global biopharma. Expect unexpected teams in the same room unleashing bold thinking, where data experts collaborate with clinicians, operations, and commercial leaders to answer the next question faster. We value kindness alongside ambition, and we invest in your growth with opportunities to lead, learn, and see your work change lives in ways you can feel.

Alexion is proud to be an Equal Employment Opportunity and We are committed to fostering a culture of belonging where every single person can belong because of their uniqueness. The Company will not make decisions about employment, training, compensation, promotion, and other terms and conditions of employment based on race, color, religion, creed or lackthereof, sex, sexualorientation, age, ancestry, national origin, ethnicity, citizenship status, marital status,pregnancy, (including childbirth, breastfeeding, or related medical conditions), parental status (including adoption or surrogacy), military status, protected veteran status, disability, medical condition, gender identity or expression, genetic information, mental illness or other characteristics protected by law. Alexion provides reasonable accommodations to meet the needs of candidates and employees. To begin aninteractive dialogue with Alexion regarding an accommodation, please contact [e-mail]. Alexion participates in E-Verify.