SQL Developer

Aquila; Ontario; Hybrid; CAD 80,000 - 100,000; Full time

Job summary

A leading software firm is seeking a SQL Developer to manage and optimize the database layer for housing management solutions. This fully remote position involves supporting data quality, diagnosing SQL issues, and collaborating in Agile teams. Ideal candidates will have strong SQL skills and experience with data migrations, ensuring the organization provides accurate and reliable housing data. Apply now to join a mission-driven team.

Benefits

Creative work environment

Opportunities for growth

Inclusivity and diversity focus

Qualifications

• Hands-on experience as an MS SQL Developer on enterprise-level projects.
• Proven ability to write, tune, and optimize SQL queries, stored procedures, and functions.
• Analytical mindset to address data challenges.

Responsibilities

• Support data quality and customer success.
• Diagnose and resolve SQL issues.
• Design and deliver reports.
• Lead data migrations and transformations.
• Collaborate in Agile teams.
• Drive performance and stability.

Skills

SQL query tuning

Data migration

Collaboration in Agile

SSRS and Crystal Reports

Tools

SQL Server

SSIS

Power BI

Job description

Overview

Aquila, a group within Constellation Software Inc., one of North America’s largest and most respected software companies, invests in category-defining B2B and B2G software businesses globally, providing long-term support and strategic guidance. Emphasys Software has been part of Aquila since 2008.

Operating across five specialized divisions, Emphasys provides mission-critical software that modernizes and streamlines complex processes for housing authorities, lenders, and government agencies in nearly every state. Through both products and services, Emphasys helps house roughly half of the families most in need in the country.

At Emphasys PHA (Public Housing Authority), a division of Emphasys, we build and support the only end-to-end financial software in the U.S. dedicated to affordable housing. As the largest full-service provider in this space, we enable State Housing Finance Agencies and other public organizations to administer programs that help families access affordable homeownership or rental housing. Our solutions power the financial backbone that processes funding, manages compliance, and ensures every dollar of support is tracked and maximized.

Who we need

Reporting to the Data and Reporting Manager, we are hiring a SQL Developer to manage and strengthen the database layer at the core of our housing management solutions. This role is hands-on with SQL Server, Report Development and Troubleshooting being the primary responsibilities of the job. You will also be involved with query and index optimization, data migrations, and troubleshooting. You will work closely with Developers, QA, and Business Analysts in an Agile team, ensuring that the database remains accurate, reliable, and high-performing as new features are delivered.

This is a full-time, fully remote position within the US or Canada.

Responsibilities

• Support data quality and customer success. You will work directly with customers to identify and correct data inconsistencies, ensuring housing data is accurate, reliable, and compliant. You will assist clients with custom data requests, from reconciling tenant records to building solutions that adapt to unique payment standards or property structures.
• Diagnose and resolve SQL issues. You will help identify, track, and repair SQL-based bugs, collaborating with application developers to ensure fixes integrate seamlessly into the product. You will conduct SQL diagnostics, troubleshoot performance issues, and provide on-call support when urgent problems arise.
• Design and deliver reports. You will build and maintain critical reports that housing authorities depend on, including government-mandated compliance reports and client-specific requests. You will work with tools such as SSRS and Crystal Reports to ensure outputs are accurate, timely, and actionable.
• Lead data migrations and transformations. You will participate in projects to migrate customer data from competitor systems into Emphasys products. You will perform custom data manipulation as needed to ensure successful adoption and smooth transitions for clients.
• Collaborate in Agile teams. You will actively contribute to Agile ceremonies, including daily stand-ups, sprint reviews, and retrospectives. You will work closely with Developers, QA, and Business Analysts to design, test, and deploy new features, ensuring the database layer fully supports the application.
• Drive performance and stability. You will monitor and tune SQL queries, indexes, and procedures to improve responsiveness and throughput. You will apply best practices for performance optimization, scalability, and data integrity, and verify that fixes and enhancements remain effective over time.
• Document and share knowledge. You will create and maintain clear documentation for database changes, migrations, troubleshooting steps, and permanent fixes. You will contribute to team knowledge sharing, ensuring consistent practices and repeatable success.

You bring:

• The technical experience. You bring hands-on experience as an MS SQL Developer on enterprise-level projects, with a strong foundation in SQL Server Development.
• The technical expertise. You demonstrate proven ability to write, tune, and optimize SQL queries, stored procedures, and functions. You are proficient with Crystal Reports and SSIS, and you bring exposure to, or interest in, Power BI and cloud technologies. You understand how to maintain performance, scalability, and security across complex systems.
• The analytical mindset. You approach data challenges with critical and logical thinking. You diagnose performance issues, track and resolve SQL-based bugs, and develop creative solutions under pressure. You are comfortable executing data migrations, transformations, and custom manipulations to meet client requirements.
• The collaboration. You contribute actively to Agile teams, working with Developers, QA, and Business Analysts to design, test, and deploy new features. You explain technical concepts clearly to non-technical stakeholders and ensure that solutions align with business needs.
• The ownership. You take initiative to see problems through from start to finish, verifying that fixes remain effective over time. You proactively monitor systems, identify potential issues before they affect customers, and take responsibility for outcomes.
• The reliability. You document findings, troubleshooting steps, and permanent fixes in a clear and accessible way, enabling teammates and customers to build on your work. You balance speed with quality by testing in controlled environments, validating outcomes in production, and safeguarding long-term stability.
• The interpersonal skills. You communicate professionally, translating complex technical processes for a non-technical audience. You build and sustain trusting, collaborative relationships with colleagues and customers alike.

Join us.

As an Aquila company, Emphasys Software brings together bright, talented people who aspire to excellence and share a commitment to upholding our mission: To be a company of outstanding people delivering vertical market software solutions through long-term partnerships with clients.

Our entrepreneurial culture, lean environment, and people come together to form a dynamic organization where purpose drives our growth. With the autonomy to be creative and curious, we collaborate and iterate to achieve real impact in the communities we support.

We spend our days asking questions and challenging the status quo, manipulating our structure, roles, and internal operations in order to stay ahead in a competitive landscape.

If you share our growth mindset, relationship-focused approach, and high moral fiber, you will thrive at Aquila.

Apply now.

Diversity and inclusion are not mere words on paper to us. We welcome and appreciate candidates with a range of backgrounds and experiences. If you have 70% of the qualifications we are looking for and want to play an integral role in changing an industry, apply to express your interest.

What you can expect from our interview process:

• A virtual interview with a Talent Advisor to discuss your interest in the role and share your experience.
• A virtual technical interview with the Team Lead, Development, the Director Development and a senior team member to share your experience and explore how it aligns with the team's needs. You will have the chance to ask questions about the tech stack and day-to-day work.
• A virtual interview with the General Manager, Emphasys, to understand how your background aligns with our culture and the bigger purpose of the company.

Aquila welcomes and encourages applications from people with disabilities. Accommodations are available on request for candidates taking part in all aspects of the selection process.

#LI-Remote
#LI-DNI