Senior Data Engineer

On behalf of our client, Procom is currently seeking one Senior Data Engineer for SSIS ETL Documentation and Reverse-Engineering project. Senior Data Engineer - SSIS ETL Documentation and Reverse-Engineering
Job Details:

• MHSU MRR Dataset Data Flows Documentation:
• Map out and document all data flows within the SSIS packages related to the MHSU MRR dataset, including source and destination data stores, transformations, and conditional logic.
• Metadata Documentation for MHSU MRR Dataset:
• Document metadata for all SSIS objects related to the MHSU MRR dataset, including package configurations, variables, parameters, connections, and dependencies.
• Reverse-Engineering SSIS Packages for MHSU MRR Dataset:
• Decompile and analyze all SSIS packages related to the MHSU MRR dataset to understand the underlying logic and integrations.
• Document findings and recommendations for optimization or refactoring specific to the MHSU MRR dataset.
• Data Governance Compliance for MHSU MRR Dataset:
• Ensure all documentation and SSIS practices align with organizational data governance and data quality standards, with a specific focus on the MHSU MRR dataset.
• Knowledge Transfer for MHSU MRR Dataset:
• Develop comprehensive guides and training materials based on the documentation to facilitate knowledge transfer and training of new staff on the MHSU MRR dataset.

The deliverables for this project will include:

• Detailed documentation of SSIS data flows and metadata specific to the MHSU MRR dataset.
• A report on the findings from the reverse-engineering process of the SSIS packages for the MHSU MRR dataset, including potential areas for optimization.
• A set of best practices and recommendations for SSIS package development and maintenance with a focus on the MHSU MRR dataset.
• Training materials and guides for onboarding new team members on the MHSU MRR dataset.
• A final project report summarizing methodologies, findings, and recommendations for the MHSU MRR dataset.

Senior Data Engineer - SSIS ETL Documentation and Reverse-Engineering
Mandatory Skills: Plan and manage the technical design, development and implementation of new and/or enhanced business systems applications by:

• identifying and estimating required technical activities;
• defining technical work assignments and priorities;
• monitoring technical work; recommending/implementing solutions to scheduling, logistical and/or operational problems;
• ensuring involvement of all appropriate technical specialists to meet business requirements;
• lead unit, integration and system tests to evaluate development outcomes, ensure conformity with user client needs and compatibility with policies and standards;

7

• ensure quality control performed on all deliverables before handover to Business Consultant;
• ensure development of procedures to facilitate data conversions, data backup and systems security;
• monitor software development work and certify deliverables; and
• plan, lead, and otherwise undertake the development of integrated proof of concept solutions, to verify emerging technologies, products, services, and methodologies, to ensure government understands technical opportunities/exposures, and to ensure deployment minimizes associated risks and threats.

In addition to the skills and experience set out above, the Proponents should demonstrate that the proposed Consultant(s) have the following:

• Able to meet either physically on Vancouver Island, or remotely using virtual meetings utilizing Microsoft Teams,
• Be available during Island Health business hours, which are in Pacific Standard Time,
• Contractor will need to be able to work in a team environment.

Senior Data Engineer - SSIS ETL Documentation and Reverse-Engineering
Assignment Length August 15 2024 with possible extension/s Senior Data Engineer - SSIS ETL Documentation and Reverse-Engineering
Start Date May 15th 2024 Senior Data Engineer - SSIS ETL Documentation and Reverse-Engineering
Assignment Location This Requisition is fully remote, with availability Monday to Friday from 8:00am to 5:00pm Pacific Standard Time. (
two hundred fifty (250) billable hours with the possibility of adjusting if needed )