Server Jobs in Oshawa, ON

Job Overview

The primary responsibility of this role is to convert existing SQL Server Reporting Services (SSRS) reports over to the Power BI environment. This position requires advanced proficiency with Power BI, a strong understanding of Structured Query Language (SQL), and expertise in data modeling best practices.

Responsibilities:

• Migrating existing SSRS reports over to the Power BI Platform
• Design and develop advanced interactive dashboards and reports using Power BIBuild and maintain data models using best practices to support efficient reporting and analytics.
• Publishing and maintaining Power BI reports on the Power BI Service
• Perform data extraction, cleansing, transformation, and loading from a variety of data sources, ensuring data quality and consistency
• Collaborate with stakeholders to gather requirements and ensure that reports meet business needs
• Working with Power Query (M language)
• Troubleshoot and resolve issues related to data queries, report accuracy, and performance for both legacy and new reports

Qualifications

• Bachelor’s degree in Information Technology, Computer Science, or a related field.
• Advanced experience designing, developing, and maintaining business intelligence reports and dashboards using Power BI and the Fabric platform
• Strong proficiency in structured query language (SQL) for querying, transforming, and managing data
• Expertise in data modeling, including designing efficient and scalable data models using best practices such as star schema
• Experience with data extraction, transformation, and loading (ETL) processes from a variety of data sources
• Strong analytical and problem-solving skills, with attention to detail and a commitment to data accuracy
• Excellent communication and interpersonal skills, with the ability to collaborate effectively with stakeholders and team members
• Experience collaborating in an agile environment using source control and ticketing systems for tracking tasks, managing issues, and monitoring project progress.
• Professional Designations or Licenses: Certifications in Power BI, business intelligence, or data analytics are considered an asset, but not required.

CPUS Engineering employs artificial intelligence (AI) tools as part of its recruitment process to enhance efficiency and consistency. These tools may assist with activities such as application screening, candidate evaluation, and summarization of interview feedback.

AI-generated outputs are intended to supplement, not replace, human judgment. All final hiring decisions are made by qualified human decision-makers who exercise professional discretion in reviewing and assessing candidate information alongside any AI-generated insights.

CPUS Engineering ensures that the use of AI in recruitment complies with all applicable employment laws, human rights legislation, and privacy regulations. The organization is committed to maintaining fairness, transparency, and non-discrimination throughout the hiring process.