Senior Consultant, Power BI Developer

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

Job summary

An established industry player is seeking a Senior Power BI Consultant to join their dynamic team. In this role, you will leverage your extensive experience with Microsoft Power BI to transform business needs into insightful reports and visualizations. You will collaborate with clients to gather requirements, design data solutions, and optimize Power BI environments. This position offers the opportunity to work on complex data challenges while fostering a culture of growth and innovation. If you are passionate about data and enjoy problem-solving in a collaborative environment, this role is perfect for you.

Benefits

Flexible Work Hours

Professional Development Opportunities

Health Insurance

Remote Work Options

Team Building Activities

Qualifications

• 5+ years experience in Power BI development and data solutions.
• Solid knowledge of DAX, M, and SQL for data manipulation.
• Experience with data warehousing and relational DBMS.

Responsibilities

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

Skills

Power BI Development

DAX

SQL

Data Visualization

Analytical Skills

Critical Thinking

Education

Bachelor's Degree in Computer Science

Bachelor's Degree in Software Engineering

Bachelor's Degree in Data Science

Tools

Microsoft Power BI

DAX Studio

SSRS

SSAS

Azure Data Platform

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.