City: Ottawa
Salary: N/A
Added: June 09, 2026
Business Systems & Data Analyst - Permanent - 19148
About the Opportunity
Join a well-established Crown Corporation dedicated to shaping informed strategic direction through optimized enterprise systems, robust data insights, and structured information governance. Reporting to the Manager of Applications Services within our thriving Technology & Data group, you will join a close-knit, collaborative team.
This unique role beautifully blends day-to-day operational support, application administration, and business data analysis. You will act as a key bridge between technology and business insight, not only configuring and maintaining enterprise applications but also leveraging modern data environments to extract, query, and analyze information to build impactful business solutions.
They offer a hybrid work model requiring three days a week in either of their Ottawa or Toronto offices. Because of this, we are only considering candidates currently residing in these two regions.
Duties include but are not limited to:
Business Data Analysis & Reporting: Write and optimize SQL queries to extract data, conduct analysis, and build/maintain dynamic reports and dashboards (primarily in Power BI).
Data Initiatives & Platform Support: Contribute to broader data and analytics projects, including utilizing Azure Databricks to interface with cloud data environments, manage data structures, and support analytics workflows
Systems Administration & Access Controls: Provide technical configuration and administration services across core systems. This includes managing user access (provisioning/de-provisioning), maintaining site/application structures, and supporting periodic access reviews through reporting
Day-to-Day Operational Support: Troubleshoot user issues, investigate incidents, and apply fixes across diverse enterprise systems, desktop applications, and data reporting tools. Act as the primary point of contact for ticket escalation
SaaS & Business Application Configuration: Support the configuration, maintenance, and ongoing optimization of various SaaS platforms and Microsoft ecosystem tools (such as the Power Platform and SharePoint) to streamline workflows
Stakeholder Engagement & Requirements Gathering: Work closely with business stakeholders to understand their operational and reporting needs, document technical requirements, and translate them into functional solutions
Standards, Governance & Delivery: Participate in the evaluation of new technologies and the development of Information Governance/Information Management (IG/IM) standards, utilizing system metrics and data to monitor performance
About You
The successful candidate will have the following
Experience: 4+ years of hands-on experience in a Business Systems Analyst, Data Analyst, or IT Operations role with a strong track record of mixing system support with data-driven workflows
Data & Business Intelligence Expertise: Strong proficiency with SQL Server (writing and troubleshooting queries) and Power BI (developing dashboards, data modeling, and reporting)
Cloud Data Platform Exposure: Hands-on experience or strong familiarity working within Azure Databricks to support data analysis, ETL/ELT workflows, or data project initiatives
The Microsoft Stack & SaaS: Deep technical background configuring and leveraging Microsoft ecosystem tools, specifically the Power Platform (Power Apps, Power Automate), SharePoint, Dynamics, and Active Directory, alongside general corporate SaaS administration
Education & Certifications: A degree or diploma in Data Analysis, Computer Information Systems, Information Technology, Computer Science, or a related discipline (or an equivalent combination of education and experience). Relevant Microsoft or cloud certifications (e.g., Power BI Data Analyst, Azure Data Fundamentals) are a strong asset
Soft Skills: Exceptional troubleshooting skills and the ability to translate complex data and technical concepts into user-friendly, non-technical insights for diverse stakeholders
About the Job
Salary is commensurate of experience ($85,000 to $105,000) and is in addition to a government pension/benefits plan, four weeks of vacation, annual bonus, and an annual wellness allowance.
Location: Hybrid (3 days/week in-office) | Downtown Ottawa or Downtown Toronto, ON
Position Type: Full-time, Permanent
Clearance: Must be eligible for Level II (Secret) Clearance
LROIT
How to Apply
Please apply by clicking the “” button below and follow the instructions to submit your résumé. You can also apply by submitting your résumé directly to
[email protected]. If you are already registered with us, please contact your Senior Recruiter. Please quote job 19148.
LRO Staffing values fairness, confidentiality, and human judgment in every stage of our hiring process. We do not use automated or AI-driven screening tools to assess applications. Each submission is reviewed by an experienced recruiter to ensure a thoughtful and equitable evaluation of every candidate.
Thank you for your interest in this role. One of our Recruiters will be in touch with you if your profile meets the requirements for the role and the expectations of our clients. Please note that all candidates must be permitted to work in Canada to be considered for this opportunity.
#LI-Hybrid
