Developer - SQL Server Integration Services

Job Description

On behalf of our public sector client, Affinity is looking for a Developer - SQL Server Integration Services to work with technical leads and architects to interpret and implement business logic within database solutions. The role involves contributing to data‑repository infrastructure design, developing application components, and performing ETL activities including data migration, cleansing, and transformation.

Responsibilities

• Work with the architects and leads to analyze and clarify technical specifications to implement business logic;
• Help develop the infrastructure requirements for a data repository;
• Participate in application development and/or configuration activities to meet business requirements;
• Participate in data migration, cleansing and transformation (ETL) activities – such as the design, development and deployment;
• Analyze functional requirements and transform into transformational code;
• Adhere to Guiding Principles and Developer Technical principles;
• Develop and version control SSIS packages for data migration activities
• Develop data views from a data repository as identified during the project
• Participate in defect triage meetings.

Required Requirements

• 7 years IM/IT experience.
• University degree in Computer Science or Information Technology preferred, or equivalent education/experience.
• Experience with data migrations (Extract‑Transform‑Load).
• English communication skills (verbal and written).
• Resume limit of 5 pages focused on scored requirements and deliverables.

Scored Requirements

• 5 years designing, developing, testing, and deploying SSIS packages.
• 5 years SQL experience including complex query design.
• 5 years working with multiple development methodologies (Agile, Scrum, Waterfall).
• 5 years working effectively in fast‑paced, team‑focused environments with strong prioritization and time‑management skills.
• 5 years understanding, following, and contributing to team processes and improvements.
• 5+ years working within multi‑vendor teams.

Affinity Earn

Know someone who’s great for this, or any of our open roles? Earn up to $4,000/year for each successful referral through Affinity Earn. You can also earn up to $50,000 for helping us find new clients. Learn about our referral program at https://affinity-group.ca/earn/ or browse our jobs & follow us at https://www.linkedin.com/company/affinity-staffing/jobs/

About Affinity

Affinity Group is a technology and business consulting and services company. We believe in creating long term relationships between clients and consultants that foster a mutually beneficial partnership. Affinity is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. All employment is decided on the basis of qualifications, merit and business need.

For more information on Affinity, please visit www.affinity-group.ca

Job Number: 13242