Senior Consultant, Power BI Developer

Project Limited; Toronto; On-site; CAD 80,000 - 110,000; Full time

Job summary

An established industry player is seeking a Senior Power BI Consultant to leverage extensive experience in data visualization and reporting. This role involves collaborating with clients to understand their business needs and developing sophisticated Power BI solutions that provide actionable insights. You will utilize your expertise in SQL and DAX to create visually appealing reports and dashboards while ensuring data integrity through rigorous testing. Join a supportive culture that values innovation and teamwork, where your contributions will drive success and foster long-term client relationships. If you are passionate about data and enjoy solving complex problems, this opportunity is perfect for you.

Qualifications

• 5+ years of experience in Power BI development and data analysis.
• Solid experience with DAX, M, and SQL languages.
• Ability to create reports for Business Intelligence needs.

Responsibilities

• Develop and implement MS Power BI solutions from data sources.
• Build interactive reports and dashboards for clients.
• Conduct testing to ensure data integrity and quality.

Skills

Power BI

DAX

SQL

Data Visualization

Analytical Skills

Critical Thinking

Consultative Mindset

Education

Bachelor's degree in Computer Science

Bachelor's degree in Software Engineering

Bachelor's degree in Business Intelligence

Bachelor's degree in Data Science

Tools

Power BI Dataflows

DAX Studio

SSRS

SSAS

Azure Data Platform

ERWIN

Job description

About Project X

Project X Ltd. drives success by focusing on building teams of incredibly talented and client-focused people, who love to problem solve and work on tough data problems. We reward hard work and forward-thinking with recognition and a supportive culture that celebrates success and wants to see you grow.

Our team members are trusted advisors to our clients and offer innovative solutions that solve complex data problems. Collaboration, creativity, data knowledge and experience run deep in our veins. We are passionate about building long-term relationships with our clients and staying true to our values. When adding new members to our team, we also look for people that are aligned with our values.

We are also passionate about our people. Hiring and developing people that seek challenges, like to jump in and learn new things, and are happy to lend a helping hand to a peer is what makes us successful.

We understand that it’s our people that make us great.

Role Summary

As a Senior Power BI Consultant, you will bring extensive experience using Microsoft Power BI to translate business needs into easily understandable reports and visualizations. Working with clients and other team members, you will be responsible for gathering requirements from the client for development, testing and implementation. This work will give you a chance to leverage your experience using Microsoft Power BI and dig deep into various data sources to obtain a better understanding of any organization. You are often leading solutions and providing support to other team members.

Major Areas of Responsibility

1. Develop a deep understanding of the business needs and the data challenges of the clients’ organizations and their industries.
2. Conceptualize, design and implement MS Power BI solutions from the existing data warehouse, and other enterprise data sources.
3. Assist the BI Architect and often design logical and physical dimensional data mart models.
4. Utilize Power BI to build interactive and visually appealing reports and dashboards for deployment in Windows/ Web-based environments in accordance with predefined detailed report specifications.
5. Conduct unit & integration tests, assisting in test preparations to ensure data integrity, data quality, and program functional completeness & correctness.
6. Leverage and extend processes aligned to data visualization best practices (as defined or adopted by the client) and standards, ensure quality (Alignment to form, fit and function).
7. Perform detailed analysis on tested and deployed Power BI scripts.
8. Make essential technical and strategic changes to optimize Power BI environments.
9. SQL querying for better results.
10. Produce and maintain technical documentation for colleagues, as well as procedures for end users.
11. Participate in the development of project plans to establish appropriate workload expectations and schedules.

Required Knowledge, Skills and Abilities

1. 5+ years of experience in a Power BI Developer, or similar data-related role, developing sophisticated solutions and uncovering actionable insights.
2. Solid experience with DAX, M and SQL languages.
3. Experience with Ms Power BI Dataflows, DAX studio, SSRS and SSAS.
4. Ability to create reports with large data sets and visualization tables for Business Intelligence needs.
5. Practical knowledge in Ms Power BI service architecture design and administration, defining roles and security.
6. General knowledge in Data warehousing, including data source analysis and profiling, as well as Relational DBMS.
7. Excellent analytical skills and ability to present ideas and recommendations to various stakeholders.
8. Experience in programming, scripting, automation and customization initiatives.
9. Critical thinking capabilities and a consultative mindset.
10. Bachelor's degree in Computer Science, Software Engineering, Business Intelligence, Data Science, or related.

Nice to Have

1. Experience with other BI tools.
2. Experience with the Azure data platform (e.g., ADLS, Synapse, ADF, Databricks etc.).
3. Agile delivery methodology, DevOps, Continuous Integration/Continuous Deployment concepts and methods.
4. Prior experience in consulting.
5. ERWIN or another data modelling tool is an asset.

In our commitment to promote fair and equitable treatment of all employees and applicants, Project X Ltd. provides equal employment opportunities for all individuals regardless of age, sex, disability, race, ethnic origin, citizenship, creed, sexual orientation, marital status or any other ground as described in the Ontario Human Rights Code. In addition, accommodation will be provided during the hiring process.

Project X is an equal opportunity employer and welcomes and encourages applications from people with disabilities. Accommodations are available on request for candidates taking part in all aspects of the selection process.