Senior Analyst

Introduction to role: Are you ready to transform raw data into actionable insights As a Data Reporting and Analytics Developer youll 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:
At AstraZenecas Alexion division for Rare Diseases youll find an environment where innovation thrives! Our commitment to patients drives us forward every day. Here youll be part of a team that values diversity of thought as much as diversity of people. We believe in empowering our employees through tailored development programs that align personal growth with our mission. With a rapidly expanding portfolio in a dynamic biotech atmosphere combined with the resources of a global biopharma leaderyour career here is more than just a pathits a journey towards making a difference where it truly counts.

When we put unexpected teams in the same room we unleash bold thinking with the power to inspire life-changing -person working gives us the platform we need to connect work at pace and challenge perceptions. Thats why we work on average a minimum of three days per week from the office. But that doesnt mean were not flexible. We balance the expectation of being in the office while respecting individual flexibility. Join us in our unique and ambitious world.

Ready to make an impact Apply now!

Date Posted

Closing Date

Alexion is proud to be an Equal Employment Opportunity and Affirmative Action employer. 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 statuspregnancy (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 . Alexion participates in E-Verify.