PowerBI Engineer - Senior

Lumenalta; Ottawa; On-site; CAD 80,000 - 120,000; Full time

Job summary

Lumenalta is seeking a Senior Power BI Engineer to join their team in Ottawa. In this role, you will design, develop, and deploy business intelligence solutions using Power BI to transform raw data into actionable insights. You will collaborate with stakeholders, optimize data models, and integrate data from various sources. Ideal candidates have a passion for data analytics and possess strong skills in DAX and data modeling.

Qualifications

• Minimum of 3 years of experience in designing and developing reports / dashboards using Power BI.
• Strong proficiency in DAX, Power Query, and data modeling in Power BI.
• Experience with SQL and relational databases for data extraction and manipulation.

Responsibilities

• Develop interactive and compelling Power BI reports and dashboards.
• Create and optimize data models, DAX calculations, and queries.
• Design and manage ETL processes to ensure data quality.

Skills

DAX

Power Query

Data modeling

Data integration

Analytical thinking

Problem-solving

Communication

Education

Bachelor’s degree in Computer Science

Degree in Information Technology

Degree in Business Analytics

Job description

Join to apply for the PowerBI Engineer - Senior role at Lumenalta .

Lumenalta is a forward-thinking company specializing in data-driven solutions that empower businesses to transform insights into strategic decisions. We are looking for a skilled Power BI Engineer to join our dynamic team and contribute to building impactful data solutions. If you have a passion for transforming raw data into meaningful visualizations and actionable insights, we want to hear from you!

Role Overview :

As a Power BI Engineer at Lumenalta, you will be responsible for designing, developing, and deploying business intelligence solutions using Microsoft Power BI. You will collaborate closely with data analysts, business stakeholders, and other IT professionals to ensure data accuracy, optimize performance, and deliver insightful dashboards and reports that support decision-making processes.

Key Responsibilities :

• Design & Development : Develop interactive and visually compelling Power BI reports, dashboards, and visualizations based on business requirements.
• Data Modeling : Create and optimize data models, DAX calculations, and queries to ensure efficient and reliable reporting.
• ETL Processes : Design and manage ETL processes to transform data from various sources into Power BI, ensuring data quality and consistency.
• Performance Optimization : Optimize report performance through proper data model design, query optimization, and report configuration.
• Collaboration : Work with business stakeholders to understand requirements, gather feedback, and iteratively enhance reports and dashboards.
• Data Integration : Integrate data from multiple sources, including databases, cloud services, and third-party APIs, ensuring seamless data connectivity.
• Documentation & Training : Create documentation for data models, processes, and reports. Conduct training sessions to empower users to leverage Power BI effectively.
• Troubleshooting : Address any issues related to data accuracy, visualizations, and report performance.

Required Qualifications :

• Bachelor’s degree in Computer Science, Information Technology, Business Analytics, or a related field.
• Minimum of 3 years of experience in designing and developing reports / dashboards using Power BI.
• Strong proficiency in DAX, Power Query, and data modeling in Power BI.
• Experience with SQL and relational databases for data extraction and manipulation.
• Knowledge of integrating Power BI with other platforms such as Azure, SharePoint, or Dynamics 365 is a plus.
• Ability to transform business requirements into technical specifications and intuitive visualizations.
• Strong analytical thinking and problem-solving skills.
• Excellent communication skills, with the ability to articulate complex data insights to non-technical stakeholders.

Preferred Skills :

• Experience with other BI tools (e.g., Tableau, Qlik) is a plus.
• Knowledge of Azure Data Factory or similar ETL tools.
• Understanding of data warehousing concepts and best practices.
• Familiarity with Agile development methodologies.

What's it like to work at Lumenalta?

Seniority level : Mid-Senior level

Employment type : Full-time

Job function : Consulting, Engineering, and Information Technology

Industries : Software Development and IT Services and IT Consulting