Here is a chance to really show your talents in planning and collaborative team work. The ETL Developer will design solutions for extracting large data sets from the analytics data stores, supporting delivery of data products to our clients partners. The data sets could exceed one billion records and will require full documentation, testing, automation, and optimization.. Working in a fast paced, innovative and forward thinking environment is going to spark your abilities even more.
...
The successful candidate will work closely with data scientists, platform and application specialists, and data source owners to deliver foundational data sets, enabling analytics solutions driving successful business outcomes. This role will provide leadership defining and implementing best practices for efficiently sourcing and extracting data from data stores.
Advantages
Work for a major company who is diverse, collaborative and cutting edge in what they do and deliver.
Responsibilities
• Work closely with the Advanced Analytics team, business partners, and other stakeholders to define analytics processing requirements for data sets
• Develop robust data models and ETL scripts for data products
• Develop data models for SQL and noSQL data sources
• Develop transformation scripts for converting non-Structured and semi-Structured data sets into structured models
• Develop scripts to automate validation, logging, and alerting
• Identify next generation opportunities for acquiring data from SQL, non-SQL, streaming, batch, pub/sub, and request/response sources of data
• Transform data to support the needs of advanced analytics modeling including Machine Learning, and AI processing.
• Thrive in an innovative environment that is guiding entry into advanced analytics and technologies
• Work collaboratively across teams to put models into production
Qualifications
• 8+ years’ relevant industry experience with a focus on data engineering preferred
• Undergraduate degree in a field linked to data engineering, business analytics, applied mathematics, computer science, IT, computer applications, engineering or related field is required; advanced degree is preferred
• Good understanding of multiple database technologies and the ability to define optimal processes and scripts
• Experience in core data engineering activities:
• Database optimization (partitioning, group and sort keys, indexes, query optimization)
• Data cleansing, loading, transfer, and management tools
• Familiarity with a broad base of analytical methods (one or more of the following):
• Data modeling (variable transformation & summarization, algorithm development)
• Data processing:
• Programming and/or scripting experience:
Summary
Randstad Canada is committed to fostering a workforce reflective of all Canadians. As a result, we are committed to developing and implementing strategies to increase equity, diversity, and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including 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); 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 emailing accessibility@randstad.ca to ensure they can fully participate in the interview process.
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
Here is a chance to really show your talents in planning and collaborative team work. The ETL Developer will design solutions for extracting large data sets from the analytics data stores, supporting delivery of data products to our clients partners. The data sets could exceed one billion records and will require full documentation, testing, automation, and optimization.. Working in a fast paced, innovative and forward thinking environment is going to spark your abilities even more.
The successful candidate will work closely with data scientists, platform and application specialists, and data source owners to deliver foundational data sets, enabling analytics solutions driving successful business outcomes. This role will provide leadership defining and implementing best practices for efficiently sourcing and extracting data from data stores.
Advantages
Work for a major company who is diverse, collaborative and cutting edge in what they do and deliver.
Responsibilities
• Work closely with the Advanced Analytics team, business partners, and other stakeholders to define analytics processing requirements for data sets
...
• Develop robust data models and ETL scripts for data products
• Develop data models for SQL and noSQL data sources
• Develop transformation scripts for converting non-Structured and semi-Structured data sets into structured models
• Develop scripts to automate validation, logging, and alerting
• Identify next generation opportunities for acquiring data from SQL, non-SQL, streaming, batch, pub/sub, and request/response sources of data
• Transform data to support the needs of advanced analytics modeling including Machine Learning, and AI processing.
• Thrive in an innovative environment that is guiding entry into advanced analytics and technologies
• Work collaboratively across teams to put models into production
Qualifications
• 8+ years’ relevant industry experience with a focus on data engineering preferred
• Undergraduate degree in a field linked to data engineering, business analytics, applied mathematics, computer science, IT, computer applications, engineering or related field is required; advanced degree is preferred
• Good understanding of multiple database technologies and the ability to define optimal processes and scripts
• Experience in core data engineering activities:
• Database optimization (partitioning, group and sort keys, indexes, query optimization)
• Data cleansing, loading, transfer, and management tools
• Familiarity with a broad base of analytical methods (one or more of the following):
• Data modeling (variable transformation & summarization, algorithm development)
• Data processing:
• Programming and/or scripting experience:
Summary
Randstad Canada is committed to fostering a workforce reflective of all Canadians. As a result, we are committed to developing and implementing strategies to increase equity, diversity, and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including 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); 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 emailing accessibility@randstad.ca to ensure they can fully participate in the interview process.
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