Sql jobs in Canada

Alberta, Canada

Posted Monday, January 26, 2026 at 9:00 AM

Legal Aid Alberta is seeking to fill a full-time Applications Systems Analyst (Full-Stack Developer) to join our IT Business Delivery team. This position will primarily focus on the design, development and enhancement of mainly custom business applications. The ideal candidate has hands-on experience building end-to- end solutions, is comfortable working in modern web frameworks and has a growing familiarity with AI developer tools. This position will appeal to an individual that likes to take initiative, is client focused and is exceptionally strong at delivering high-quality results.

* Note, although this is a remote opportunity, candidates must be able to travel to Edmonton and/or Calgary offices for meetings and workshops as required. Only Alberta residents will be considered.

Who We Are

As a publicly funded, non-profit organization, Legal Aid Alberta provides affordable legal services in family law,domestic violence, child welfare, immigration, and youth and adult criminal defense. We are Alberta-wide, with 300 staff and 1,200 private practice lawyers helping people overcome their legal challenges in more than 75 communities across the province.

Who You Are

You are motivated by making a difference and demonstrate empathy for people in challenging situations. You thrive in environments where collaboration, process improvement, and technology come together to deliver better outcomes for clients. With a strong technical delivery background, you can translate business requirements into meaningful technical solutions for business users. You love learning new things, solving problems, and can adapt to change quickly. Above all, you are committed to the success of your team and the mission of the organization.

Job Description

Reporting to the Manager IT Business Applications, key responsibilities include:

Primary Responsibilities

Full Stack Development

• Administer, configure, customize, and support Legal Aid Alberta’s key business applications including Dynamics CRM, Dynamics Business Central, Microsoft Power Portal, SharePoint and custom built applications
• Build and enhance custom web applications from front end to back end
• Develop clean, maintainable, and well-tested code
• Contribute to the architecture and development of a front end component library/design system
• Collaborate with business analysts, architects, infrastructure and other developers to create a practical solution to a business challenge
• Create and maintain back-end services, APIs, and integrations
• Troubleshoot, debug, and optimize existing applications
• Develop well-structured front-end components and back-end microservices
• Leverage AI-assisted coding tools (e.g., GitHub Copilot, Claude, Codeium) to improve productivity
• Participate in code reviews, adhere to coding and documentation standards, and contribute to continuous improvement
• Support the team’s progression towards continuous delivery including improving automated testing practices.

Secondary Responsibilities

IT Operations & Support

• Support day to day operations of our core business applications including triage of support tickets, maintenance, peer reviews, etc. Follow established escalation processes.
• Develop and maintain an understanding of the business processes that rely on the supported applications
• Apply knowledge and expertise in the delivery and support of information system solutions that achieve business goals and needs
• Clarify non-functional performance issues to the broader IT and business team, and work towards resolution with appropriate teams
• Requires full systems access to set-up, modify, suspend, or delete user access, including participation in systems audits or investigations regarding potential abuse or security violations by users
• Gather or create operational documentation for preparing and executing on deliverables as required
• Define best practices and methodologies used to support critical services
• Actively participate in maintaining IT department documentation

Collaboration & Stakeholder Engagement

• Collaborate with multiple stakeholders at all levels of the organization to deliver the most appropriate solutions
• Strong communicator with an ability to build relationships with colleagues, understand business needs, and convey complex solutions in an easily understood manner
• Provide consultation, advice, and recommendations to senior decision makers regarding issues, opportunities, and challenges associated with technology industry trends and developments

Business & Technology Strategy

• Participate in design discussions and help shape technical solution architecture
• Research and evaluate innovative uses of technology to determine the best approach to address issues, through resolution or acceptable workarounds
• Accountable to organize, plan, and execute activities independently or in teams
• Demonstrate a willingness to learn and adopt new ideas and technologies

Customer Service & Team Support

• Heavy focus on customer service, increasing the value add of the IT department and supporting the best interests of Legal Aid Alberta
• Support a positive work environment that promotes service to business partners, innovation, and teamwork

Other Responsibilities

• Perform other duties as assigned

Qualifications

Education and/or Experience:

• Minimum 5 years experience in a professional IT department - consideration will be given to a blend or combination of education, professional experience and formal training / certifications.
• Minimum of 2 years of full-stack development experience
• Knowledge of relational (ex. Azure SQL, Dataverse) and or NoSQL (ex. Azure Cosmos DB) databases
• Server-side experience with Node.js, .NET Core, Python (Django/FastAPI), or similar
• Experience developing custom applications (not just template based work)
• Post secondary degree or equivalent in Computer Sciences, Software Engineering, IT Information Systems, or related technical diploma

Knowledge and Skills:

• Familiarity with DevOps tools (Docker, GitHub Actions, Azure DevOps, etc.)
• Experience using AI‑assisted developer tools for code assistance and analysis, unit testing, debugging (e.g., GitHub Copilot, ChatGPT, Claude, or similar tools).
• Experience with modern DevOps practices and CI/CD pipelines using Git‑based source control, automated builds/tests, and deployment tools (e.g., GitHub, GitHub Actions, Azure DevOps, Docker).
• Experience with modern development practices such as automated testing, version control, peer code reviews, and building cloud‑ready applications using Azure Services (ex. Redis Cache, APIM, App Services, Functions)
• Experience working in agile or scrum teams
• Good communication and teamwork skills
• Experience with front end design system / component library skills including strong CSS fundamentals is an asset
• Utilize caching strategies (e.g., Redis) to improve application and API performance
• Experience with MS Dynamics or Dataverse would be considered an asset
• Strong observational, analytical and detail-oriented skills
• Comprehend complex, technical subjects

What We Offer

Perks of working with us

• Salary Range: $78,649.00 - $118,000.00.
• Health anddentalbenefits
• Health and wellness accounts
• Employee assistance program
• Remote work opportunities

How to Apply

If you got excited at the prospect of being a part of our team when you reviewed this posting and you meet the minimum qualifications, please select ‘Apply Now’ to create your candidate profile. This competition will remain open until a suitable candidate is found. Only those selectedfor an interview will be contacted.

Requirements

Successful candidate will be required to provide an acceptable criminal record check and social media screening.