Are you a skilled Application Designer/Developer seeking a dynamic opportunity to contribute to data transformation and integration processes? We're looking for a talented individual to join our Victoria government client for a Mental Health and Substance Use Reporting Initiative. If you're ready to make a meaningful impact on data efficiency and governance, join our client and be part of a transformative project. Apply now to seize this exciting opportunity!
...
Advantages
• Contribute to enhancing the efficiency and scalability of data integration processes, directly impacting the quality of mental health and substance use reporting.
• Gain valuable experience in documenting metadata, reverse-engineering SSIS packages, and ensuring compliance with data governance policies, enriching your skill set in data management and analysis.
• Thrive in a collaborative team environment where your expertise will be valued, and where you'll have the opportunity to work alongside talented professionals dedicated to achieving project goals.
• Take part in developing best practices and recommendations for SSIS package development and maintenance, contributing to the innovation and optimization of data integration processes.
Responsibilities
1. Data Flows Documentation:
• Map out and document all data flows within the SSIS packages related to the dataset, including source and destination data stores, transformations, and conditional logic.
2. Metadata Documentation for Dataset:
• Document metadata for all SSIS objects related to the dataset, including package configurations, variables, parameters, connections, and dependencies.
3. Reverse-Engineering SSIS Packages for Dataset:
• Decompile and analyze all SSIS packages related to the dataset to understand the underlying logic and integrations.
• Document findings and recommendations for optimization or refactoring specific to the dataset.
4. Data Governance Compliance for Dataset:
• Ensure all documentation and SSIS practices align with organizational data governance and data quality standards, with a specific focus on the dataset.
5. Knowledge Transfer for Dataset:
• Develop comprehensive guides and training materials based on the documentation to facilitate knowledge transfer and training of new staff on the dataset.
The deliverables for this project will include:
1. Detailed documentation of SSIS data flows and metadata specific to the dataset.
2. A report on the findings from the reverse-engineering process of the SSIS packages for the dataset, including potential areas for optimization.
3. A set of best practices and recommendations for SSIS package development and maintenance with a focus on the dataset.
4. Training materials and guides for onboarding new team members on the dataset.
5. A final project report summarizing methodologies, findings, and recommendations for the dataset
Qualifications
The successful applicant will have the following skills and past experience:
• 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;
• leading unit, integration and system tests to evaluate development outcomes, ensure conformity with user client needs and compatibility with policies and standards; ensure quality control performed on all deliverables before handover to Business Consultant;
• ensuring development of procedures to facilitate data conversions, data backup and systems security;
• monitoring software development work and certify deliverables; and
• planning, leading, and otherwise undertaking 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.
Summary
Join our client in this exciting opportunity to be at the forefront of transforming data integration processes for mental health and substance use reporting. Apply now via this job ad or reach out to your Randstad Digital representative immediately!
P.S. Don’t forget that when you update your profile on Randstad.ca it helps us find you faster when we do have roles that match your skills! So even if this role isn’t for you please update your profile so we can find you!
We look forward to supporting you in your job search!
Good luck!
Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.
Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.
show more
Are you a skilled Application Designer/Developer seeking a dynamic opportunity to contribute to data transformation and integration processes? We're looking for a talented individual to join our Victoria government client for a Mental Health and Substance Use Reporting Initiative. If you're ready to make a meaningful impact on data efficiency and governance, join our client and be part of a transformative project. Apply now to seize this exciting opportunity!
Advantages
• Contribute to enhancing the efficiency and scalability of data integration processes, directly impacting the quality of mental health and substance use reporting.
• Gain valuable experience in documenting metadata, reverse-engineering SSIS packages, and ensuring compliance with data governance policies, enriching your skill set in data management and analysis.
• Thrive in a collaborative team environment where your expertise will be valued, and where you'll have the opportunity to work alongside talented professionals dedicated to achieving project goals.
• Take part in developing best practices and recommendations for SSIS package development and maintenance, contributing to the innovation and optimization of data integration processes.
...
Responsibilities
1. Data Flows Documentation:
• Map out and document all data flows within the SSIS packages related to the dataset, including source and destination data stores, transformations, and conditional logic.
2. Metadata Documentation for Dataset:
• Document metadata for all SSIS objects related to the dataset, including package configurations, variables, parameters, connections, and dependencies.
3. Reverse-Engineering SSIS Packages for Dataset:
• Decompile and analyze all SSIS packages related to the dataset to understand the underlying logic and integrations.
• Document findings and recommendations for optimization or refactoring specific to the dataset.
4. Data Governance Compliance for Dataset:
• Ensure all documentation and SSIS practices align with organizational data governance and data quality standards, with a specific focus on the dataset.
5. Knowledge Transfer for Dataset:
• Develop comprehensive guides and training materials based on the documentation to facilitate knowledge transfer and training of new staff on the dataset.
The deliverables for this project will include:
1. Detailed documentation of SSIS data flows and metadata specific to the dataset.
2. A report on the findings from the reverse-engineering process of the SSIS packages for the dataset, including potential areas for optimization.
3. A set of best practices and recommendations for SSIS package development and maintenance with a focus on the dataset.
4. Training materials and guides for onboarding new team members on the dataset.
5. A final project report summarizing methodologies, findings, and recommendations for the dataset
Qualifications
The successful applicant will have the following skills and past experience:
• 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;
• leading unit, integration and system tests to evaluate development outcomes, ensure conformity with user client needs and compatibility with policies and standards; ensure quality control performed on all deliverables before handover to Business Consultant;
• ensuring development of procedures to facilitate data conversions, data backup and systems security;
• monitoring software development work and certify deliverables; and
• planning, leading, and otherwise undertaking 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.
Summary
Join our client in this exciting opportunity to be at the forefront of transforming data integration processes for mental health and substance use reporting. Apply now via this job ad or reach out to your Randstad Digital representative immediately!
P.S. Don’t forget that when you update your profile on Randstad.ca it helps us find you faster when we do have roles that match your skills! So even if this role isn’t for you please update your profile so we can find you!
We look forward to supporting you in your job search!
Good luck!
Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.
Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.
show more