Role: Developer – SQL Server Integration Services (SSIS)
Client: Service New Brunswick (SNB), Government of New Brunswick
Position Overview
As an SSIS Developer, the resource will support the ERP Business Transformation Project, focused on enabling data-driven decision-making across Human Resources, Financial Management, and Procurement domains. The role involves designing and implementing robust data migration (ETL) solutions using SQL Server Integration Services (SSIS) while collaborating with cross-functional and multi-vendor teams including internal SMEs and implementation partners.
Requirements
Mandatory Requirements (M1–M5)
M1 – Education
The candidate holds a Bachelor’s degree in Computer Science, supplemented with certifications in data engineering and Microsoft SQL technologies. Equivalent hands-on experience across enterprise-level government and private sector projects further strengthens qualifications.
M2 – IM/IT Experience (7+ Years)
Senior IT professional with 8+ years of experience in data engineering, database development, and enterprise data migration projects.
Example Engagements:
Government Sector Client (Jan 2021 – Present | 5+ years)
Role: SSIS Developer / Data Engineer
Worked on large-scale ERP data migration initiatives
Delivered high-performance ETL pipelines
Improved data processing efficiency by 35%
Financial Services Organization (Jun 2017 – Dec 2020 | 3.5 years)
Role: SQL Developer
M3 – Data Migration (ETL) Experience
Extensive experience in Extract, Transform, Load (ETL) processes:
Designed ETL pipelines migrating legacy data into modern ERP systems
Performed data cleansing, validation, and transformation
Ensured data integrity across multiple source systems
Delivered secure and scalable migration solutions aligned with enterprise standards
M4 – Communication Skills
M5 – Resume Compliance
Scored Requirements (S1–S6)
S1 – SSIS Design, Development, Testing & Deployment (5+ Years)
Experience Summary:
Project Example: Government ERP Data Migration (2021–Present)
Designed and deployed 100+ SSIS packages for HR, Finance, Procurement data
Built reusable ETL frameworks
Implemented logging, error handling, and performance tuning
Managed large datasets (>10M records)
Achievements:
S2 – SQL & Complex Query Design (5+ Years)
Experience Summary:
Project Example: Financial Data Warehouse (2017–2020)
Developed complex queries for reporting and analytics
Optimized query performance (reduced execution time by 50%)
Designed data models and indexing strategies
S3 – Development Methodologies (Agile, Scrum, Waterfall)
Experience Summary:
Project Example: Agile ERP Implementation
Participated in sprint planning, stand-ups, retrospectives
Delivered incremental ETL components
Adapted to hybrid Agile-Waterfall environments
S4 – Fast-Paced, Team-Oriented Environment
Experience Summary:
Project Example: Multi-Release ERP Program
Worked across concurrent data migration streams
Coordinated with business and technical teams
Delivered milestones within strict timelines
Achievements:
S5 – Process Adherence & Continuous Improvement
Experience Summary:
Project Contributions:
Followed coding, version control, and deployment standards
Introduced automation for ETL validation
Suggested improvements to data quality processes
Achievements:
S6 – Multi-Vendor Team Experience (5+ Years)
Experience Summary:
Project Example: ERP Implementation with Implementation Partner
Worked alongside vendors (e.g., system integrators, consultants)
Coordinated integration activities across teams
Ensured alignment between business requirements and technical delivery
Responsibilities:
Liaison between internal teams and vendors
Participate in joint design sessions
Support integration testing and deployment
Key Roles & Responsibilities (Aligned with SoW Deliverables)
Analyze technical and functional requirements to implement business logic
Design, develop, and maintain SSIS packages for ETL processes
Support data migration, cleansing, and transformation activities
Develop and maintain data repositories and views
Collaborate with architects, SMEs, and vendors
Participate in defect triage and troubleshooting
Ensure adherence to development standards and guiding principles
Contribute to continuous improvement and process optimization
Support ERP implementation and data strategy execution
Value Proposition (Account Manager Summary)
This candidate brings:
Strong technical expertise in SSIS & SQL
Proven success in large-scale ERP data migration projects
Ability to thrive in complex, multi-vendor government environments
A track record of delivering high-quality, scalable data solutions
Send resume & documents to / / recruitmail.ca
Call:
