NOTICE: There has been an increase in online scammers falsely representing recruiting and staffing agency representatives, including Recruiting in Motion professionals. At RIM, we never request payments or personal information via unsolicited messages. Please be diligent and avoid clicking on unverified links and, if in doubt, contact us directly.

Skip to main content

Submit Your Resume and Grow Your Career

We're here to help set your job search in motion.

Senior Systems Analyst (SQL)

Gatineau, QC

Posted: 01/26/2026 Employment Type: Full-Time Specialization: Information Technology Job Number: 34557 Salary / Pay Rate: $100,000.00 - $115,000.00 per year

Job Description

Position Title: Senior Systems Analyst
Salary & Benefits: $100,000-$115,000, 10% bonus, pension, benefits, 3 weeks vacation
Position Status: Existing Vacancy
Location: Ottawa/Gatineau, ON/QC
Work Model: Hybrid - 4 days per week onsite
Additional Notes:
Our client is seeking is seeking two Senior Systems Analysts for their Digital Insights team to play a critical role in designing, building, and optimizing cloud-based data solutions that enable high-quality analytics and reporting across the organization. Reporting to the Director, Digital Insights, these roles will focus heavily on advanced SQL development and data modeling while leveraging Microsoft Fabric, Fabric Data Factory, DevOps, and related cloud technologies. The Senior Systems Analysts will collaborate closely with internal teams, external vendors, and business stakeholders to deliver scalable, secure, and reliable data solutions that meet business requirements and align with established standards and best practices.

Responsibilities:
  • Design and implement robust data models to support enterprise analytics and reporting requirements.
  • Develop, optimize, and maintain data ingestion pipelines within Microsoft Fabric, ensuring efficient, secure, and reliable data flows.
  • Build and maintain complex SQL queries, scripts, stored procedures, and database structures using T-SQL and PL/SQL for optimal performance, data integrity, and reliability.
  • Develop and support cloud-based systems and integrations leveraging Microsoft Fabric, Data Factory, SQL, and DevOps.
  • Conduct thorough testing to validate system performance, stability, and reliability.
  • Collaborate with internal teams and external vendors to configure and implement new features and applications.
  • Analyze functional and non-functional requirements and provide accurate development estimates.
  • Stay up-to-date with evolving Microsoft Fabric features and enhancements, proactively recommending improvements and optimizations.
  • Engage with Citizen Developers and Power Users, providing guidance on best practices to support effective platform usage.
  • Document technical processes, ensuring clear, accurate, and up-to-date system documentation.

The ideal candidate is an experienced Senior Systems Analyst with a strong foundation in SQL development and data modeling, bringing a minimum of five (5) years of hands-on experience delivering data-driven solutions in complex environments. You will possess a solid understanding of modern data architectures, integration patterns, and the full Software Development Life Cycle, and consistently apply development best practices to produce high-quality, reliable, and well-documented solutions. Comfortable working with Microsoft Fabric and related tools, they combine technical depth with practical data analytics knowledge to support informed decision-making. A collaborative and communicative professional, the ideal Systems Analyst is curious by nature, eager to learn new technologies, and able to manage competing priorities while meeting tight deadlines in a fast-paced, stakeholder-driven environment.

What will make you stand out:
  • Deep, hands-on expertise in advanced SQL development, particularly T-SQL, including complex stored procedures, performance optimization, and data modeling at an intermediate to senior level.
  • Demonstrated experience delivering end-to-end solutions using Microsoft Fabric, Power BI, Purview, and DevOps, supported by relevant Microsoft certifications is a huge asset.
  • A strong data analytics mindset, with experience using analytics tools such as Alteryx to translate data into actionable insights.
-------------------------------------------------------------
At Recruiting in Motion Ottawa, AI-powered tools may be used to support various administrative aspects of our recruitment process. We do not use AI for screening or decision-making. All applications are reviewed, and all hiring decisions are made by qualified recruitment professionals and hiring managers to ensure fairness, transparency, and consistency.
Apply Online

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.

About Gatineau, QC

Ready to embark on an exciting career journey in Gatineau, Quebec? Explore our job opportunities in this dynamic region just across the river from Ottawa, Canada's capital city. Gatineau boasts a captivating blend of historic charm and modern vibrancy, offering job seekers a unique mix of cultural experiences, from the stunning Canadian Museum of History to the theatrical performances at the Théâtre de l'Île. Indulge in the local cuisine at charming bistros, or take a leisurely stroll through the scenic Jacques Cartier Park. With endless growth opportunities, including a booming tech sector and proximity to the Gatineau Park for outdoor enthusiasts, Gatineau is the perfect place to take your career to new heights. Join us in discovering the career possibilities that await you in Gatineau!