PivotX Advisors
As a Senior Power BI Engineer at PivotX Advisors, you will be responsible for designing, developing, and deploying business intelligence solutions using Microsoft Power BI. You will work closely with cross-functional teams, including business analysts, data engineers, and stakeholders, to transform data into actionable insights and interactive visualisations. This role requires advanced expertise in Power BI and a strong understanding of data modelling, DAX (Data Analysis Expressions), and SQL.
Responsibilities
Design, develop, and deploy Power BI dashboards and reports based on business requirements.
Implement data models, measures, and calculated columns using DAX to enhance report functionality.
Ensure visualisations meet user requirements and provide actionable insights.
Connect Power BI to a variety of data sources (SQL Server, Azure, Excel, etc.) and integrate data from multiple systems.
Develop and maintain data connections, dataflows, and scheduled refreshes to keep reports up-to-date.
Ensure data quality and integrity through data validation, cleansing, and transformation techniques.
Work closely with business stakeholders to understand their analytical needs and translate them into technical requirements.
Collaborate with data engineers and database administrators to ensure efficient data pipelines and storage.
Provide training and support to business users for self‑service reporting.
Optimise Power BI reports and dashboards for performance, ensuring scalability and efficient data processing.
Utilise Power Query, query folding, and other techniques to improve data refresh times and report load speeds.
Build and maintain complex data models that meet business needs while ensuring scalability and flexibility.
Ensure proper relationships, hierarchies, and metadata are incorporated into the Power BI solutions.
Create and maintain technical documentation for Power BI solutions, data models, and best practices.
Establish and enforce Power BI development standards and governance.
Leverage Power BI's advanced analytics capabilities, such as predictive modelling, AI insights, and R/Python integration.
Create interactive and dynamic reporting solutions that allow users to explore and drill down into data.
Provide guidance and mentorship to junior Power BI developers or business analysts.
Lead by example in adhering to best practices in data visualisation, reporting, and data governance.
Requirements
Experience: 5+ years of experience in BI/reporting, with at least 3 years focused on Power BI development.
Technical Skills: Advanced Power BI experience (DAX, Power Query, custom visualisations).
Strong SQL skills, with the ability to write complex queries for data extraction and manipulation.
Experience with data warehousing concepts and ETL processes.
Familiarity with Azure services, particularly Azure Data Factory, Azure Synapse, and Azure SQL.
Data Modelling: Strong expertise in data modelling, including star schema, snowflake schema, and data warehouse design principles.
Tools and Technologies: Experience with other BI tools (Tableau, Qlik) and ETL tools (SSIS, Informatica) is a plus.
Analytical Mindset: Ability to translate business problems into analytical solutions and visualise them effectively.
Soft Skills
Excellent communication, problem-solving, and team collaboration abilities.
Preferred Qualifications
Experience with Python or R for advanced analytics.
Microsoft Power BI certification (e. g., DA-100).
Familiarity with CI/CD pipelines for BI report deployment.
Knowledge of agile project management methodologies.
#J-18808-Ljbffr
Responsibilities
Design, develop, and deploy Power BI dashboards and reports based on business requirements.
Implement data models, measures, and calculated columns using DAX to enhance report functionality.
Ensure visualisations meet user requirements and provide actionable insights.
Connect Power BI to a variety of data sources (SQL Server, Azure, Excel, etc.) and integrate data from multiple systems.
Develop and maintain data connections, dataflows, and scheduled refreshes to keep reports up-to-date.
Ensure data quality and integrity through data validation, cleansing, and transformation techniques.
Work closely with business stakeholders to understand their analytical needs and translate them into technical requirements.
Collaborate with data engineers and database administrators to ensure efficient data pipelines and storage.
Provide training and support to business users for self‑service reporting.
Optimise Power BI reports and dashboards for performance, ensuring scalability and efficient data processing.
Utilise Power Query, query folding, and other techniques to improve data refresh times and report load speeds.
Build and maintain complex data models that meet business needs while ensuring scalability and flexibility.
Ensure proper relationships, hierarchies, and metadata are incorporated into the Power BI solutions.
Create and maintain technical documentation for Power BI solutions, data models, and best practices.
Establish and enforce Power BI development standards and governance.
Leverage Power BI's advanced analytics capabilities, such as predictive modelling, AI insights, and R/Python integration.
Create interactive and dynamic reporting solutions that allow users to explore and drill down into data.
Provide guidance and mentorship to junior Power BI developers or business analysts.
Lead by example in adhering to best practices in data visualisation, reporting, and data governance.
Requirements
Experience: 5+ years of experience in BI/reporting, with at least 3 years focused on Power BI development.
Technical Skills: Advanced Power BI experience (DAX, Power Query, custom visualisations).
Strong SQL skills, with the ability to write complex queries for data extraction and manipulation.
Experience with data warehousing concepts and ETL processes.
Familiarity with Azure services, particularly Azure Data Factory, Azure Synapse, and Azure SQL.
Data Modelling: Strong expertise in data modelling, including star schema, snowflake schema, and data warehouse design principles.
Tools and Technologies: Experience with other BI tools (Tableau, Qlik) and ETL tools (SSIS, Informatica) is a plus.
Analytical Mindset: Ability to translate business problems into analytical solutions and visualise them effectively.
Soft Skills
Excellent communication, problem-solving, and team collaboration abilities.
Preferred Qualifications
Experience with Python or R for advanced analytics.
Microsoft Power BI certification (e. g., DA-100).
Familiarity with CI/CD pipelines for BI report deployment.
Knowledge of agile project management methodologies.
#J-18808-Ljbffr