Analyst - Power BI

Job Title: Analyst - Power BI

Career Level - C3

Introduction to role

We are seeking a skilled and innovative Power BI Developer to join our Alexion team. In this role, you will focus on the design, development, and management of BI solutions using Power BI, with proficiency in Power Apps and Power Automate. This position requires a deep understanding of Power BI and its capabilities, as well as the ability to work with data and present it in a user-friendly manner. The ideal candidate will have a strong background in data analysis, proficiency in BI tools and technologies, and experience with digital marketing platforms.

Accountabilities

• Support the Alexion team with their digital marketing reporting by designing, developing, validating, and maintaining the Qlik Sense and Power BI dashboards + supporting model tiers that cater to various datasets for the omnichannel dashboard.
• Inclusive of cloud data, Google analytics, media data, 3rd party marketing campaigns, website-related data, rep-triggered emails, etc.
• Understand the business objectives, data sources, and key performance indicators (KPIs) to design effective solutions.
• Design, develop, and maintain data pipelines to extract, transform, and load (ETL) data from various digital marketing platforms and sources into a centralized data warehouse.
• Implement advanced analytics and predictive modeling techniques to identify trends, patterns, and opportunities in digital marketing data.
• Conduct ad-hoc analyses and deep dives into digital marketing data to address specific business questions and provide strategic recommendations for campaign optimization.
• Ensure data accuracy, consistency, and integrity by implementing data quality checks and validation processes.
• Identify and address performance bottlenecks in Qlik/Power BI applications; optimize data models, load scripts, and front-end visualizations to ensure fast and responsive user experiences.
• Conduct thorough testing of Qlik/Power BI applications to validate data accuracy, functionality, and usability.
• Communicate project status, challenges, and recommendations to stakeholders in a clear and concise manner.
• Instill a culture of continuous improvement, testing, and deployment of new capabilities for the business.

Essential Skills/Experience

• Expertise in Power BI Report development
• Advanced proficiency in Power BI, including data modelling, Power Query, and DAX.
• Knowledge of digital marketing principles, strategies, and performance metrics.
• Strong analytical and problem-solving skills, with the ability to translate complex data into actionable insights.
• Experience with web data and email marketing.
• Advanced understanding/experience with SQL, Snowflake, and Veeva CRM.
• Ability to create new rules and adjust existing rules.
• Recent project experience with Qlik/Power BI + experience with other BI tools

Desirable Skills/Experience

• Background in computer science, information systems, or related field.
• 2+ years of experience in digital marketing reporting
• Excellent analytical and critical thinking skills, with a keen attention to detail.
• Ability to work independently and collaboratively in a dynamic environment.
• Strong communication and interpersonal skills.

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

At AstraZeneca, our work has a direct impact on patients by transforming our ability to develop life-changing medicines. We empower the business to perform at its peak by combining cutting-edge science with leading digital technology platforms and data. Join us at a crucial stage of our journey in becoming a digital and data-led enterprise. Here you can innovate, take ownership, explore new solutions, experiment with leading-edge technology, and tackle challenges that might never have been addressed before. Our dynamic environment offers countless opportunities to learn and grow while making a meaningful impact.

Ready to make a difference? Apply now!

AstraZeneca embraces diversity and equality of opportunity. We are committed to building an inclusive and diverse team representing all backgrounds, with as wide a range of perspectives as possible, and harnessing industry-leading skills. We believe that the more inclusive we are, the better our work will be. We welcome and consider applications to join our team from all qualified candidates, regardless of their characteristics. We comply with all applicable laws and regulations on non-discrimination in employment (and recruitment), as well as work authorization and employment eligibility verification requirements.