Sr Software Engineer I

Job Summary


Responsibilities

• Design, develop, and maintain Power BI reports and interactive dashboards.
• Work with business stakeholders to understand reporting and analytical requirements and translate them into effective Power BI solutions.
• Develop and maintain data models within Power BI using appropriate modelling techniques.
• Develop and optimise DAX measures, calculated columns, and calculated tables.
• Develop and optimise Power Query transformations using M.
• Connect Power BI to a range of data sources, including SQL Server, Oracle, APIs, and other business systems.
• Work closely with Data Engineers to ensure appropriate data structures and datasets are available for reporting requirements, including demonstrating advanced-level SQL troubleshooting capabilities.
• Develop and maintain reusable datasets, semantic models, and reporting solutions.
• Implement appropriate data validation and quality checks to ensure accuracy and consistency of reporting.
• Apply Row-Level Security (RLS) and other Power BI security features where required.
• Publish, manage, and maintain reports and datasets within Power BI Service.
• Support Power BI workspaces, apps, scheduled refreshes, and deployment processes.
• Troubleshoot report, data refresh, performance, and connectivity issues.
• Optimise Power BI reports and data models to improve performance and usability.
• Use Performance Analyzer, DAX Studio, and Tabular Editor to troubleshoot and optimise Power BI solutions.
• Utilise the Power BI Capacity Metrics App to monitor and optimise capacity usage across multiple semantic models.
• Implement and manage incremental refresh across multiple semantic models.
• Implement and manage Power BI gateways, including associated configurations and data sources within Power BI Service.
• Work closely with the support team to quickly troubleshoot and resolve reporting issues raised in the Production environment.
• Apply Microsoft Fabric capabilities to support effective capacity management and configuration management.
• Contribute to solution design using Microsoft Fabric features and capabilities.
• Ensure dashboards and reports follow consistent visualisation and design standards.
• Maintain source code and Power BI development assets using GitHub and follow version control best practices.
• Produce technical and user documentation for developed Power BI solutions.
• Support users with Power BI reporting and provide guidance on best practices.
• Contribute to the continuous improvement of Business Intelligence and reporting standards and practices.

Requirements

Essential

• 3-5 years of commercial experience developing Power BI solutions.
• Strong experience with Microsoft Power BI, including:
• Power BI Desktop
• Power BI Service
• Power Query
• Advanced DAX
• Data modelling
• Dashboards and interactive reports
• Microsoft Fabric features and capabilities
• Reporting best practices
• Strong knowledge of DAX, including creating and optimising measures using a broad range of functions and calculated expressions.
• Strong experience working with databases, particularly Microsoft SQL Server and Oracle using SQL Developer.
• Strong SQL knowledge, including:
• Views
• Common Table Expressions (CTEs)
• RANK and other window functions
• Execution plans
• Indexing and keys
• Stored Procedures
• Query optimization and troubleshooting
• Experience developing data models using star schema and dimensional modelling principles, including large and complex models containing 30+ tables.
• Experience connecting Power BI to Oracle, SQL Server, and other data sources.
• Good understanding of Power Query and M for data transformation and preparation.
• Experience managing and publishing reports through Power BI Service.
• Experience configuring and troubleshooting scheduled data refreshes.
• Understanding of Power BI security, including Row-Level Security (RLS).
• Experience troubleshooting and optimising Power BI report and semantic model performance.
• Experience using GitHub or another source control system for version management.
• Strong analytical and problem-solving skills.
• Excellent communication skills, with the ability to work effectively with both technical and non-technical stakeholders.

Desirable

• Experience integrating Power BI with Salesforce.
• Experience working with REST APIs and API-based data sources.
• Experience working alongside Data Engineering teams and ETL processes.
• Knowledge of SSIS and/or Talend.
• Experience of working with web analytical platforms.
• Experience with Power BI deployment pipelines and application lifecycle management.
• Knowledge of AWS and/or Azure data services.
• Experience with Power BI gateway configuration and administration.
• Familiarity with Agile development methodologies.
• Experience supporting enterprise-level Business Intelligence environments.

Qualifications

• Degree in Computer Science, Information Technology, Data Analytics, Business Intelligence, or a related discipline, or equivalent commercial experience.

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.