Software Developer
Job Summary
Overview
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 doesnt 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
Dillons 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 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.
Responsibilities
What Youll Be Doing
Database and Data
- 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
Application Development
- Developing and maintaining internal web applications (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
Qualifications
What Were Looking For
Technical
- 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
- development experience (C# 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
Non-Technical
- 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
Experience
Education
- Bachelors degree or diploma in Computer Science Software Engineering or a related field or equivalent practical experience demonstrating a strong foundation in software engineering principles.
Compensation
$90000 - $120000
Dillon is including the salary range that we in good faith believe may offer for this position. It will be dependent on the successful applicants education experience and skills in addition to internal equity and geographic region. Dillon reserves the right to pay outside of the posted range contingent on factors unrelated to an applicants gender or other status protected by provincial and/or federal law.
Why choose Dillon
We live our core values:
- Achievement: do the work to hit the target;
- Continuous Development: always learning; always adapting; always growing;
- Creativity: discover new possibilities;
- Courage: do the things that matter especially when its hard;
- Inclusiveness: enabling belonging to draw strength from our differences;
- Reliability: words result in actions that build trust.
About Dillon
Dillon is a proudly Canadian employee-owned professional consulting firm specializing in planning engineering environmental science and management. We partner with clients to provide committed collaborative and inventive solutions to complex multi-faceted projects. With over 25 offices and more than 1100 employees across Canada Dillon offers a wide range of services related to building and improving facilities and infrastructure protecting the environment and developing communities.
Now operating for over 75 years we continue to strive for excellence in everything we do. Dillon has been listed as one of Canadas Best Managed Companies for 19 years in a row and has the distinction of being a Platinum Club member in this program.
Focus on Innovation
The ability to anticipate examine and adopt new and innovative solutions is a crucial driver for the continual and progressive advancement of our business our culture people are empowered to reflect and question current practices and seek forward looking solutions to todays problems and tomorrows opportunities.
Health & Safety at Dillon
Prospective employees are expected to fully align with Dillons core commitment to Health & Safety. This includes active ongoing engagement with our Health & Safety processes and platform and the active ongoing identification and reporting of health and safety hazards.
Employment Equity Diversity & Inclusion at Dillon
Dillon is committed to employment equity and an inclusive diverse workplace where opportunities are based on skills and abilities. If you require accommodation during the interview process please let us know. We look forward to hearing from you.
Technology Enablement and the Use of AI at Dillon
We invest in modern technologies to enable continuous improvement across the organization. Please be advised that Dillon Consulting utilizes artificial intelligence (AI) assisted tools to support parts of our recruitment process to increase efficiency and fairness. While AI supports this process all hiring decisions are made by our human recruiting team. By applying you acknowledge and consent to this use.
Required Experience:
IC
About Company
Offering a wide range of solutions related to building and improving facilities and infrastructure, protecting the environment, and developing communities.