Senior Power Bi Developer Job in Iqvia

Job Title: Business Intelligence (BI) Lead Life Sciences Sector

About the Role:

As the BI Lead, you will spearhead and develop Business Intelligence (BI) projects within the team, focusing on constructing an analytical data layer, developing custom BI reporting solutions, monitoring platform performance, and enabling self-serve reporting for Regional Business Units (RBU) and Global Business Units (GBU). Your primary responsibility is to deliver high-quality contributions to client projects in the life sciences sector. These tasks will range from basic analysis and problem-solving to assisting in the creation of more complex solutions. You ll demonstrate a comprehensive understanding of pharmaceutical data assets, including IQVIA, CRM, and MCM data, as well as country-specific variations. Key duties include training and upskilling Business Units (BUs) to use the self-serve layer effectively for report and dashboard creation, assessing data requirements for decision-making, and ensuring data accuracy. You ll work closely with engineering and data platform teams to improve data availability and reliability, while collaborating on client proposals and solution strategies. Additionally, you will contribute to documentation and specifications, design presentations, and actively engage in the consulting methodologies and life sciences market to continuously grow your knowledge.

Key Responsibilities:

• Lead BI projects, including building and maintaining an analytical data layer, and developing BI solutions for reporting and visualization.
• Deliver high-quality, timely contributions to life sciences client projects, ranging from basic analysis to complex solutions.
• Utilize pharmaceutical data assets (IQVIA, CRM, MCM) and understand regional data variations.
• Train Business Units (BUs) to efficiently use the self-serve reporting layer for creating reports and dashboards.
• Assess data requirements, identify suitable data sources, ensure data accuracy, and perform necessary transformations for decision-making.
• Establish and track business metrics, and perform in-depth process analysis to identify areas for improvement.
• Collaborate with engineering and data platform teams to enhance data availability and reliability.
• Review and analyze client requirements, contribute to proposal development, and create tailored client solutions.
• Create detailed documentation, including specifications and quantitative/qualitative analyses.
• Present client deliverables within established frameworks, adapting presentations to audience needs.
• Stay engaged in consulting methodologies, life sciences market trends, and professional development opportunities.
• Manage project-based responsibilities under the guidance of senior consultants and directors.

Desired Candidate Profile:

• Proficiency in SQL and BI platforms, particularly Power BI (Spotfire knowledge is a plus).
• Extensive experience with data transformation/ETL, data modeling, and a strong understanding of data platforms and ETL processes.
• Hands-on experience with Power BI, including the creation of reports, dashboards, and visualizations, and experience in environments such as Salesforce, Snowflake, or Azure.
• Skilled in migrating SSRS reports/Tabular reports to Power BI Paginated Reports.
• Advanced knowledge of Power Query M and experience building sophisticated DAX queries.
• Experience implementing static and dynamic Row Level Security, along with extensive knowledge in dataset design, data cleansing, and aggregation.
• Understanding of relational database structures, principles, and practices.
• Solid SQL skills, including the ability to write complex queries and create SQL views for custom datasets.
• Strong proficiency in Excel, PowerPoint, and Access, with VBA knowledge considered a plus.
• Proven ability to build relationships with multiple stakeholders (BI engineers, Data Engineers, Consulting teams, Product Managers).
• Familiarity with Software Development Life Cycle (SDLC) and Agile methodologies.
• Experience with technical project execution, including proposal writing, creating BRD, PDD, SDD, and user documentation.
• Excellent verbal and written communication skills.
• Previous experience in application or implementation support is required.
• Strong problem-solving skills and a macro-level approach to research and analytics.

Good to Have:

• Experience with other BI technologies (e.g., Tableau, Looker Studio, ThoughtSpot).
• Knowledge of Python/R.
• Experience with Microsoft Power Platform tools (e.g., PowerApps, Power Automate).
• Hands-on experience with Canvas App Configuration, Canvas App Functions, Power Portals, Power Automate Desktop, and custom connectors.
• Familiarity with Azure services, AI builder, Virtual Agents, and SharePoint list customization.
• Microsoft Power Platform certification is a plus.

Qualifications:

• Bachelor s or Master s degree in Computer Science, Information Technology, or a related field.
• 6-8 years of relevant experience.
• Demonstrated collaborative approach, working effectively across teams to achieve objectives.
• Knowledge of core business processes and their impact on decision-making and growth.
• Familiarity with consulting methodologies, tools, and techniques.
• Up-to-date with current industry trends and insights into competitors and marketplace dynamics.
• Proficiency in time management, Scrum methodologies, and agile working practices.