SQL Developer at Aquila Software Group

Toronto, Ontario, Canada -

Full Time

Start Date

Immediate

Expiry Date

18 Dec, 25

Salary

0.0

Posted On

19 Sep, 25

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

SQL Server, Report Development, Troubleshooting, Query Optimization, Data Migrations, Agile, Crystal Reports, SSIS, Power BI, Cloud Technologies, Data Quality, Compliance Reporting, Performance Optimization, Data Transformations, Documentation, Interpersonal Skills

Industry

Software Development

Description

We are excited to speak to you about this opportunity. If you are interested in joining our growing team, please apply to this link directly. Who we are 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. What is in it for you Purpose with impact. Your work will enable public and affordable housing programs to operate effectively by providing housing authorities with accurate, timely data to manage operations, meet compliance requirements, and serve residents. The reports you develop will help agencies demonstrate compliance and secure millions in federal funding. A mission-critical role. You will maintain the database backbone behind systems that support rent collection, subsidy tracking, and compliance reporting. Your contributions will directly influence the reliability and performance of platforms that housing agencies depend on every day. Technical breadth and depth. You will expand your SQL expertise while working across Crystal Reports, SSIS, SQL Server Development, and Power BI. You will also gain exposure to cloud technologies and broaden your toolkit through hands-on experience, mentoring, and participation in enterprise-scale projects. Long-term stability and growth. As part of Constellation Software Inc., one of North America’s largest software companies, you will have access to mentorship, career development, and opportunities for mobility across a global network of specialized software businesses—all while building a long-term career in a stable and growing environment. As our new SQL Developer, you will: 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. We are excited to speak to you about this opportunity. If you are interested in joining our growing team, please apply to this link directly.

Responsibilities

The SQL Developer will manage and strengthen the database layer for housing management solutions, focusing on SQL Server, report development, and troubleshooting. Responsibilities include query optimization, data migrations, and collaborating with Agile teams to ensure database performance and reliability.