PowerBI Engineer - Tech Lead

Lumenalta; Calgary; On-site; CAD 80,000 - 100,000; Full time

Job summary

Join a leading company as a Power BI Engineer - Tech Lead, responsible for designing and deploying business intelligence solutions. Collaborate with stakeholders to deliver insightful dashboards and optimize data processes. Ideal for candidates with strong DAX and Power Query skills, and a passion for data-driven decision-making.

Qualifications

• Minimum of 5 years of experience in Power BI.
• Strong proficiency in DAX and Power Query.
• Ability to transform business requirements into visualizations.

Responsibilities

• Develop interactive Power BI reports and dashboards.
• Create and optimize data models and DAX calculations.
• Design and manage ETL processes for data integration.

Skills

DAX

Power Query

Data Modeling

Analytical Thinking

Problem Solving

Communication

Education

Bachelor’s degree in Computer Science

Bachelor’s degree in Information Technology

Bachelor’s degree in Business Analytics

Tools

SQL

Azure

SharePoint

Dynamics 365

Job description

Join to apply for the PowerBI Engineer - Tech Lead role at Lumenalta

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:

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

Required Qualifications:

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

Preferred Skills:

1. Experience with other BI tools (e.g., Tableau, Qlik) is a plus.
2. Knowledge of Azure Data Factory or similar ETL tools.
3. Understanding of data warehousing concepts and best practices.
4. 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