Analyst – Power BI Developer

Job Title: Analyst – Power BI Developer

Career Level - C

Introduction to role

Are you passionate about transforming data into actionable insights? As a Power BI Developer at AstraZeneca, you will design, develop, and manage BI solutions using Power BI, Power Apps, and Power Automate. This role requires a deep understanding of Power BI capabilities and the ability to present data in a user-friendly manner. You will also need leadership and project management skills to interface with direct stakeholders, particularly within the Business Systems Team.

Accountabilities

Power BI Reporting and Analytics:
- Build interactive dashboards and visualizations to communicate key metrics and insights.
- Perform advanced data modeling, implement RLS (Row-Level Security), and develop robust DAX calculations.
- Integrate data from multiple sources into cohesive Power BI datasets.
- Proficient in SQL & Data warehousing concepts.
- Knowledge of other Power platform tools.

Power Apps Development:
- Design and implement user-friendly applications using Power Apps.
- Ensure seamless data connectivity with SharePoint, SQL Server, and other data sources.
- Enable low-code/no-code solutions for business workflows.

Workflow Automation with Power Automate:
- Automate recurring tasks and workflows, improving process efficiency.
- Develop custom connectors and flow logic tailored to business needs.
- Monitor and troubleshoot workflow automation for reliability.

Testing & Documentation:
- Experience in SIT & test case documentation.
- SOP & TDD document creation.
- Presentation and storytelling skillset.

Stakeholder Collaboration:
- Partner with business teams to gather requirements and deliver solutions.
- Document methodologies, workflows, and best practices for internal reference.

Essential Skills/Experience
- Expertise in Power BI Report development.
- Advanced proficiency in Power BI, including data modeling, Power Query, and DAX.
- Knowledge of Power Apps and ability to develop scalable applications.
- Workflow design and troubleshooting experience with Power Automate.
- Proficiency in SQL for data extraction and transformation.
- Familiarity with SharePoint, cloud-based services (Azure, AWS, etc.), and their integration.
- Strong problem-solving and analytical skills with attention to detail.
- Excellent written and verbal communication skills.

Desirable Skills/Experience
- Professional experience in Business Intelligence with at least 4 years hands-on experience with Power BI.
- Proven track record of different Power BI use cases. A certification is desired.
- A very good knowledge of user experience design for BI solutions allowing to suggest possible design options in the prototyping phase.
- Ability to understand and translate business ideas into dashboard solutions as well as to appropriately communicate with business stakeholders directly.
- Knowledge and usage of neighboring Microsoft applications – like Power Apps and Power Automate - is of advantage.
- First team lead experience / playing the role of senior point of contact among multiple BI developers required.
- In-depth knowledge of working with different data sets under best practice approaches required (master keys, key linkage, star schema, etc).
- Advanced SQL skills for data exploration and data testing.
- An ability to detect challenges early and to raise it.
- Attention to detail to ensure any reports released have accurate data.
- A proactive approach and focus on team success.
- A strong command of English and effective communication skills.
- Excellent analytical and logical thinking.
- Highly motivated self-starter, driven for results, effective at prioritizing and managing multiple tasks concurrently.
- Good communication and presentation skills.
- Ability to work independently.
- Ability to manage multiple tasks simultaneously.

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, you'll be part of a team of specialists essential to our growth. We value entrepreneurial thinking and innovation, empowering you to make an impact in a dynamic environment. Our global network fosters collaboration, ensuring we leverage our combined expertise to drive change. We invest in your growth, offering opportunities to deepen your expertise or explore new areas. Here, your work contributes to patients' lives, society, and our planet.

Ready to make a difference? Apply now!