Data & Business Intelligence Analyst
Role Overview
Full-time, one-year contract based in Ottawa, reporting to the IT Manager.
Own and support an established Microsoft-based data, reporting, and analytics environment for internal users and external client-facing reporting.
Work across source systems and integrations, the SQL data warehouse, Power BI, SharePoint, Excel, and end-user solutions.
The expected salary range is C$70,000–C$80,000 annually, commensurate with experience and qualifications.
Key Skills for This Role
Full Job Posting
Role overview
Full-time, one-year contract based in Ottawa, reporting to the IT Manager.
Own and support an established Microsoft-based data, reporting, and analytics environment for internal users and external client-facing reporting.
Work across source systems and integrations, the SQL data warehouse, Power BI, SharePoint, Excel, and end-user solutions.
The expected salary range is C$70,000–C$80,000 annually, commensurate with experience and qualifications.
Work arrangement
- Hybrid arrangement with three days per week at the Ottawa head office.
Responsibilities
- Maintain and improve Power BI reports, dashboards, semantic models, DAX, row-level security, refresh processes, and embedded solutions.
- Develop and support SQL queries, database objects, the data warehouse, and reporting infrastructure.
- Maintain ETL/ELT processes, Azure Data Factory pipelines, scheduled integrations, and enterprise application connections.
- Support SharePoint Online, client portals, Power Automate workflows, and Power Apps.
- Troubleshoot data, refresh, authentication, connectivity, and integration issues; identify root causes and resolve or coordinate fixes.
- Protect data quality, integrity, consistency, security, and authorized access.
- Turn business and client needs into analytical solutions, process improvements, and workflow enhancements.
- Provide operational support and documentation; collaborate with stakeholders on system enhancements, upgrades, and reporting modernization.
Qualifications
- At least five years of experience in data analytics, business intelligence, data warehousing, reporting, or a related role.
- College diploma or university degree in Information Technology, Computer Science, Business Analytics, Data Analytics, or a related field.
- Expert Power BI experience, including dashboards, semantic modelling, DAX, row-level security, embedded reporting, and performance optimization.
- Advanced SQL and strong knowledge of data warehousing, data modelling, relational database design, ETL/ELT, and Azure Data Factory.
- Strong working knowledge of Azure, SharePoint Online, Power Automate, Power Apps, Excel, and Power Query, including connectivity, authentication, gateways, permissions, and security.
- Ability to troubleshoot complex data, reporting, refresh, connectivity, and integration issues across an end-to-end reporting environment.
- Analytical, organizational, problem-solving, and communication skills; able to manage competing priorities, work independently, and collaborate across technical and non-technical teams.
- Salesforce or similar integration tools, Azure SQL Database, REST APIs, migration or implementation projects, and real estate, property management, or financial reporting experience are assets.
Benefits
- Three weeks of starting annual paid vacation, three personal days, and five paid sick days annually.
- Benefits plan with health, dental, vision, and disability coverage, with costs shared by the company and employee.
- RRSP matching and up to two paid professional development courses per year.
- Holiday office closure between Christmas and New Year’s and summer hours, where position-dependent.
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career