Job Description

Job Summary

We are seeking a talented and motivated Software Engineer to join our dynamic development team. The ideal candidate will be responsible for designing, developing, and maintaining high-quality software solutions across various platforms. This role offers an exciting opportunity to work on innovative projects utilizing a broad range of technologies including web development, application development, and cloud services. The Software Engineer will collaborate closely with cross-functional teams to deliver scalable and efficient software products that meet business needs.

Security Requirement:

Enhanced Security Clearance (Criminal Record + Credit Check)

Project Overview:

The TrustConnect modernization initiative is revamping a 30+ year-old legacy financial management system responsible for handling $600M across 19,000 client accounts. The Application Developer will lead and execute critical ETL development, legacy data migration, and technical integration to ensure clean, accurate, and secure transition of complex datasets into the new platform.

Key Responsibilities:

Design, develop, and test end-to-end

ETL processes

for legacy data extraction, transformation, and loading using tools like

SSIS

or

Azure Data Factory

. Analyze fragmented, inconsistent, and unstructured legacy data to ensure data integrity and usability in the target system. Develop scalable, secure application components using

.NET (C#)

and integrate with relational databases (

SQL Server

,

Oracle

). Create technical documentation including data flow diagrams, transformation rules, and database designs. Perform system-level troubleshooting, root cause analysis, and issue resolution. Collaborate with cross-functional teams and stakeholders to gather business requirements and ensure alignment with project goals. Conduct code reviews, ensure secure coding practices, and optimize system performance. Contribute to DevOps processes using

Azure DevOps

, including CI/CD pipelines and version control.

Required Technical Skills:

ETL Development

: SSIS, Azure Data Factory, or equivalent

Programming

: .NET (C#), PowerShell, Python (for automation/scripts)

Databases

: SQL Server, Oracle, experience with large datasets

Scripting & Data Cleansing

: T-SQL, PL/SQL, PowerShell

Cloud & DevOps

: Azure environment, Azure Virtual Desktop (AVD), Azure DevOps, Git

Data Visualization (Nice to Have)

: Power BI or Tableau

Security & Compliance

: FOIP, secure data handling practices

Additional Requirements:

Must supply own computer (Windows OS preferred) compatible with Azure Virtual Desktop Availability to attend in-person meetings within Alberta if requested (travel not reimbursed) Completion of mandatory FOIP and Security Awareness training upon onboarding Must provide

three professional references

with submission Must include

detailed resume

showing required experience with dates in the format MMM/YYYY to MMM/YYYY
Job Types: Full-time, Fixed term contract
Contract length: 12 months

Pay: $51,482.71-$125,659.26 per year

Work Location: In person