DE&A - Core - Advanced Visualization & Cloud Reporting - Power BI

Overview Of Position:

As a Senior Power BI Developer, you will be responsible for designing, developing, and maintaining scalable and interactive business intelligence solutions using Power BI and the Microsoft BI stack. You will transform complex datasets into actionable insights through visually compelling dashboards and reports that support strategic decision-making across the organization.

This role demands strong proficiency in SQL for data modelling, transformation, and performance optimization. You will manage data preparation, data gateways, and data warehousing processes, ensuring high data integrity and consistency. You will also collaborate with cross-functional teams to understand business requirements and translate them into technical specifications. Your ability to work in a geographically distributed team and communicate effectively is essential.

You will also be expected to stay current with emerging technologies such as Microsoft Fabric and Copilot capabilities, integrating them into BI solutions to enhance automation, productivity, and user experience.

Key Responsibilities:

• Design and develop advanced Power BI dashboards, reports, and visualizations tailored to business needs.
• Create and maintain reusable report components, templates, and themes to ensure consistency and scalability.
• Perform data extraction, transformation, and loading (ETL) using SSIS and complex SQL queries.
• Develop and optimize data models using Power BI and SQL Server Analysis Services (SSAS).
• Implement DAX expressions for calculated columns, measures, and KPIs.
• Ensure data accuracy, completeness, and consistency across all reporting layers.
• Debug and resolve issues in reports, data models, and ETL pipelines.
• Configure and manage Power BI gateways, scheduled refreshes, and row-level security.
• Collaborate with business stakeholders to gather requirements and deliver BI solutions aligned with business goals.
• Participate in Agile ceremonies, sprint planning, and code reviews.
• Maintain documentation for report logic, data sources, and business rules.
• Support ad-hoc reporting needs and mentor junior developers on BI best practices.
• Integrate Microsoft Fabric capabilities into BI workflows, including Copilot features for enhanced automation and user interaction.
• Work with diverse data sources including SQL Server, SharePoint, PostgreSQL, Salesforce, Excel, and cloud-based APIs.

Required Knowledge & Skills:

Experience: 6–10 years in BI development, with a strong focus on Power BI and SQL.

• Proficient in Power BI Desktop and Power BI Service.
• Strong command of DAX for complex calculations and performance tuning.
• Experience with Power Query (M language) for data transformation.
• Familiarity with Power BI REST API and embedding reports in applications.
• Knowledge of Power BI Premium features including deployment pipelines and dataflows.
• Hands-on experience with Microsoft Fabric, including Copilot integration for report generation and data exploration.
• Experience working with multiple data sources including SQL Server, SharePoint Lists and Libraries, PostgreSQL, Salesforce CRM, Excel/CSV files, RESTful APIs and cloud connectors
• Advanced SQL for data manipulation, joins, subqueries, indexing, and performance optimization.
• Experience with stored procedures, views, functions, and triggers.
• Ability to work with large datasets and optimize query performance.
• Understanding of Agile/Scrum practices and tools like Jira or Azure Boards.
• Experience working within enterprise frameworks and release procedures.
• Familiarity with development environments, staging, and production workflows.
• Strong analytical and troubleshooting skills.
• Excellent time management and multitasking abilities.
• Effective communication and stakeholder engagement

Personal Attributes:

• Good communication skills.
• Ability to easily fit into a distributed development team.
• Customer service oriented.
• Enthusiastic/High initiative.
• Ability to manage timelines of multiple initiatives.