RQ08575 Business Intelligence Specialist

Advantages
- Competitive salary and benefits package.
- Work on exciting public-sector projects with real-world impact.
- Opportunities for professional growth and development.
- Collaborative and inclusive team environment.

Responsibilities
Work with project teams to ensure the successful release of Business Intelligence reporting using Power BI. The resource(s) will be responsible for:
- Use Power Query to extract data from different data sources and choose a storage mode and connectivity type;
- Profile, clean, and load data into Power BI;
- Design data models that are intuitive, high-performing, and simple to maintain;
- Use M and DAX language to create measures;
- Ensure high performance of Power Query data retrieval tasks;
- Create Power BI report designs and report formatting, including report navigation;
- Examine, sort and present data cohesively using Power BI;
- Leverage statistical summaries of data and facilitate the export of data from Power BI when required;
- Apply and perform advanced analytics on reports for deeper and more meaningful data insights;
- Leverage workspaces in the Power BI service;
- Deploy Power BI artifacts to workspaces and enable sharing to users;
- Connect Power BI reports to on-premise data sources;
- Configure automatic refresh for Power BI datasets;
- Enable Row-level security;
- Understand the report users needs and their requirements;
- Develop reports all the way into production;
- Work with the project team in completing all relevant and required documentation in alignment with OPS standards.

Deliverables:
- Create Power BI report(s), data models;
- Undertake special assignments/sub-projects as assigned;
- Conduct, assess, evaluate and document stakeholder interests and business needs;
- Ensure alignment and adherence to IT processes and standards;
- Support the testing team during system and UAT testing; and
- Participate in Knowledge transfer.

Qualifications
General Skills and Knowledge:
- Proven experience as a Microsoft Power BI developer, building Business Intelligence reports and dashboards;
- Demonstrated experience with M, DAX and Power Query;
- Knowledge of Microsoft Azure ecosystem;
- Proven experience with SQL Server and other database technologies;
- Proven, demonstratable experience in data modelling and data visualization, working with different data schemas and BI implementation methodologies;
- Knowledge of data analysis, and data management;
- Proven ability to partner with internal/external stakeholders and liaise with technical experts and non-technical colleagues;
- Experience in understanding, capturing, and analyzing complex and sometimes competing business requirements to develop Power BI and Business Intelligence products;
- Excellent verbal and written communication skills, interpersonal and facilitation skills;
- Strong written, presentation and interpersonal communication skills with special attention to correct use of tense, grammar/spelling and terminology; and
- Demonstrated effective time management and organizational skills, including the ability to plan and prioritize workload, ensure timelines are met and respond to demands of a dynamic environment.

Mandatory Requirements:
- Use Power Query to extract data from different data sources and choose a storage mode and connectivity type;
- Profile, clean, and load data into Power BI;
- Design data models that are intuitive, high-performing, and simple to maintain;
- Create Power BI report designs and report formatting, including report navigation;
- Examine, sort and present data cohesively using Power BI; and
- Connect Power BI reports to on-premise data sources.

Summary
This position offers an opportunity to drive organizational success by delivering innovative BI solutions. Join a collaborative team that values creative problem-solving, data-driven decision-making, and technical excellence.

P.S. Don’t forget that when you update your profile on Randstad.ca it helps us find you faster when we do have roles that match your skills! So even if this role isn’t for you please update your profile so we can find you!

We look forward to supporting you in your job search! Good luck!

Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.