Software Developer

Dillon Consulting Limited•London, ON

26d•$90,000 - $120,000•Hybrid

About The Position

Are you a developer who brings equal confidence to a code editor and a query window? Do you take genuine interest in how data moves through systems, and what happens when it doesn't? If you solve problems independently, reach for emerging and AI-powered technologies from the start, and hold yourself to a high standard without being told to, this opportunity is for you. Your opportunity Dillon's IT Solutions team is looking for an Intermediate to Senior Developer with real depth on the database side, to fill an existing vacancy. This role carries significant database responsibility, including coverage of work normally handled by a dedicated DBA, alongside .NET application development and internal tooling. At Dillon, we operate as one team. This position is available at our office in London, Ontario on a hybrid basis.

Requirements

Demonstrable SQL Server depth: stored procedure development and optimization, query tuning, execution plan interpretation, and schema-level understanding
Experience maintaining and troubleshooting ETL pipelines, with the ability to diagnose failures and trace issues to their source
Working knowledge of data traceability practices, including audit trail design, change tracking, and data lineage documentation
Solid .NET development experience (C#, ASP.NET Core) with recent or active Blazor exposure; MudBlazor experience is a plus
Working knowledge of Crystal Reports
Experience with Qlik or comparable BI/analytics platforms
Comfortable reading and modifying existing scripts and automation tooling; able to assess what a script does, identify risks, and make targeted changes while maintaining full functionality
Demonstrated, practical use of AI-assisted development tools (such as GitHub Copilot or equivalent); expected to speak to specific workflows, prompt strategies, and quality control practices beyond the basic familiarity with AI tools
A track record of independent problem-solving; ability to scope, research, and work through unfamiliar technical challenges without direction
Proven ability to work autonomously on longer-horizon deliverables, managing priorities and progress without frequent supervision
Demonstrates practical, disciplined use of AI development tools by applying critical review before generated output reaches production, and sharing effective workflows and practices across the team
Strong communication skills, including the ability to connect technical work to business outcomes and articulate implications of decisions to both technical and non-technical stakeholders
Bachelor's degree or diploma in Computer Science, Software Engineering, or a related field — or equivalent practical experience demonstrating a strong foundation in software engineering principles.

Responsibilities

Authoring, optimizing, and maintaining SQL Server stored procedures, views, and ad hoc scripts
Troubleshooting and supporting ETL processes; diagnosing failures, tracing data lineage, and resolving root causes
Owning data traceability and audit trail requirements across business applications
Tuning queries and analyzing execution plans to address performance issues
Maintaining and modifying existing Crystal Reports
Contributing to Qlik dashboard development and maintenance
Applying AI-assisted tools where appropriate to accelerate query development, automate repetitive scripting tasks, and support error checking and code review in database work
Developing and maintaining internal web applications using .NET (C#) and Blazor (MudBlazor component library)
Working with stakeholders and teammates during planning to understand requirements, flag technical considerations, and shape solutions before code gets written
Writing and maintaining automation scripts and tooling (PowerShell, Python, or similar)
Participating in code reviews and contributing to technical standards across the team
Collaborating with database and data team efforts to ensure application logic and data layer work together cleanly
Supporting CI/CD pipelines and deployment processes, helping the team ship reliably and with confidence
Leveraging AI coding tools to improve development throughput, code quality, and test coverage; sharing effective approaches with the team rather than treating them as individual productivity gains