Sr. Analytics Data Specialist, Waterloo

Do your areas of expertise include dimensional and relational data modeling, data quality, SQL programming, ETL development, metadata management and master data management?Is data lifecycle management second nature?Is your expertise in JSON, XML, and Databricks Parquet data structures and transformations going underutilized?If so, our Ottawa based client has a contract opportunity to consider... The position at hand is a Senior Data Analyst who will contribute to the detailed data analysis and design of a MDM solution.AdvantagesLong term contract opportunityPrestigious clientProviding strategic guidance. Responsibilities- Collecting, documenting, and analyzing MDM data requirements- Data profiling/analysis and data querying- Data cleansing, data transformation- Documenting/mapping business processes, SOPs- Building crosswalks and mapping tables for reference data- Analyzing source systems to find discrepancies/collisions for reference data- Working with team members to provide data analysis and design leadership and communicate about deliverables, schedule, possible risks, and appropriate contingencies- Working closely and collaboratively with management, stakeholders, and staff to optimize the overall MDM deliveryQualifications- Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.- Knowledge and demonstrated experience in data analysis and profiling, working with multiple data sources and stakeholder groups including end-user/business teams.- Demonstrated experience in data quality analysis and experience with reverse engineering the source to target mapping to gain data insights- 10+ years of broad experience in IM/IT solution design and delivery, including working knowledgewith infrastructure, database platform, middleware, and applications.- Well-rounded experience in the whole data lifecycle management and hands-on experience in the following data management domains: dimensional and relational data modeling, data quality, SQL programming, ETL development, metadata management and master data management, businessintelligence and database administration.SummarySenior Data Analyst who will contribute to the detailed data analysis and design of a MDM solution.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.

Our Central Ottawa based Federal Government client is looking for Bilingual and Unilingual Help Desk & Service Desk Agents to support their internalemployees and end-users. We are seeking qualified candidates who in pursuing careers in the IT support sector.This is a contractual position up to a 1-year team. There is the possibility of extension and renewal based on your performance!Your daily responsibilities will include:* Receiving, logging, and answering calls/emails from users about various technical requests surrounding one’s profile. (ex, password resets, onboarding new employees and granting system access as per group policies)Identify technical problems on a given interaction* Create service tickets or Incident tickets when required* Solving incident tickets when required* Closing Service tickets when required* Performing the initial level of problem identification and attempting to resolve when appropriate.* Documenting any troubleshooting efforts in a problem ticket and escalating to the appropriate channels of the organization.* Provide support to on-site technicians when required in an effort to resolve any deskside or kiosk solutions.* Assistance with monitoring and tracking incident tickets to ensure a resolution occurs within the service level agreements.* Performing follow-up on incident tickets to ensure end-user satisfaction.* Conducting tests on a given network to anticipate any outages and reporting accordingly.If you love helping others, solving problems, and have a demonstrated interest in technology, this might be your next career!Advantages:* An opportunity to work for the Federal Government. Need I say more?* Great Pay, Earn between $20 – 30 per hour * This is a chance to be recognized and develop your skills and knowledge by working directly with the latest technology and software used by multiple Federal bodies.* Enjoy working in a fully modern environment.* Benefits are available for purchase via Randstad Advantage.* Great hours! The work schedule is strictly during business hours. – No weekendsQualifications:* Must possess a valid Government Secret Clearance or be eligible to obtain one (we will sponsor you)* Minimum 2 years call center or previous Technical Support Experience is an asset.* Must have excellent communication skills Good problem solving and analytical skills.* Any completed IT-related education is considered a strong asset.* Must have knowledge of computers and have a technical mindsetYour new career starts here. Apply today at Randstad.ca - Ottawa Technologies Job Order 2201357PROENAdvantagesOur Central Ottawa based Federal Government client is looking for Bilingual and Unilingual Help Desk & Service Desk Agents to support their internalemployees and end-users. We are seeking qualified candidates who in pursuing careers in the IT support sector.This is a contractual position up to a 1-year team. There is the possibility of extension and renewal based on your performance!Your daily responsibilities will include:* Receiving, logging, and answering calls/emails from users about various technical requests surrounding one’s profile. (ex, password resets, onboarding new employees and granting system access as per group policies)Identify technical problems on a given interaction* Create service tickets or Incident tickets when required* Solving incident tickets when required* Closing Service tickets when required* Performing the initial level of problem identification and attempting to resolve when appropriate.* Documenting any troubleshooting efforts in a problem ticket and escalating to the appropriate channels of the organization.* Provide support to on-site technicians when required in an effort to resolve any deskside or kiosk solutions.* Assistance with monitoring and tracking incident tickets to ensure a resolution occurs within the service level agreements.* Performing follow-up on incident tickets to ensure end-user satisfaction.* Conducting tests on a given network to anticipate any outages and reporting accordingly.If you love helping others, solving problems, and have a demonstrated interest in technology, this might be your next career!Advantages:* An opportunity to work for the Federal Government. Need I say more?* Great Pay, Earn between $20 – 30 per hour * This is a chance to be recognized and develop your skills and knowledge by working directly with the latest technology and software used by multiple Federal bodies.* Enjoy working in a fully modern environment.* Benefits are available for purchase via Randstad Advantage.* Great hours! The work schedule is strictly during business hours. – No weekendsQualifications:* Must possess a valid Government Secret Clearance or be eligible to obtain one (we will sponsor you)* Minimum 2 years call center or previous Technical Support Experience is an asset.* Must have excellent communication skills Good problem solving and analytical skills.* Any completed IT-related education is considered a strong asset.* Must have knowledge of computers and have a technical mindsetYour new career starts here. Apply today at Randstad.ca - Ottawa Technologies Job Order 2201357PROENResponsibilitiesOur Central Ottawa based Federal Government client is looking for Bilingual and Unilingual Help Desk & Service Desk Agents to support their internalemployees and end-users. We are seeking qualified candidates who in pursuing careers in the IT support sector.This is a contractual position up to a 1-year team. There is the possibility of extension and renewal based on your performance!Your daily responsibilities will include:* Receiving, logging, and answering calls/emails from users about various technical requests surrounding one’s profile. (ex, password resets, onboarding new employees and granting system access as per group policies)Identify technical problems on a given interaction* Create service tickets or Incident tickets when required* Solving incident tickets when required* Closing Service tickets when required* Performing the initial level of problem identification and attempting to resolve when appropriate.* Documenting any troubleshooting efforts in a problem ticket and escalating to the appropriate channels of the organization.* Provide support to on-site technicians when required in an effort to resolve any deskside or kiosk solutions.* Assistance with monitoring and tracking incident tickets to ensure a resolution occurs within the service level agreements.* Performing follow-up on incident tickets to ensure end-user satisfaction.* Conducting tests on a given network to anticipate any outages and reporting accordingly.If you love helping others, solving problems, and have a demonstrated interest in technology, this might be your next career!Advantages:* An opportunity to work for the Federal Government. Need I say more?* Great Pay, Earn between $20 – 30 per hour * This is a chance to be recognized and develop your skills and knowledge by working directly with the latest technology and software used by multiple Federal bodies.* Enjoy working in a fully modern environment.* Benefits are available for purchase via Randstad Advantage.* Great hours! The work schedule is strictly during business hours. – No weekendsQualifications:* Must possess a valid Government Secret Clearance or be eligible to obtain one (we will sponsor you)* Minimum 2 years call center or previous Technical Support Experience is an asset.* Must have excellent communication skills Good problem solving and analytical skills.* Any completed IT-related education is considered a strong asset.* Must have knowledge of computers and have a technical mindsetYour new career starts here. Apply today at Randstad.ca - Ottawa Technologies Job Order 2201357PROENQualificationsOur Central Ottawa based Federal Government client is looking for Bilingual and Unilingual Help Desk & Service Desk Agents to support their internalemployees and end-users. We are seeking qualified candidates who in pursuing careers in the IT support sector.This is a contractual position up to a 1-year team. There is the possibility of extension and renewal based on your performance!Your daily responsibilities will include:* Receiving, logging, and answering calls/emails from users about various technical requests surrounding one’s profile. (ex, password resets, onboarding new employees and granting system access as per group policies)Identify technical problems on a given interaction* Create service tickets or Incident tickets when required* Solving incident tickets when required* Closing Service tickets when required* Performing the initial level of problem identification and attempting to resolve when appropriate.* Documenting any troubleshooting efforts in a problem ticket and escalating to the appropriate channels of the organization.* Provide support to on-site technicians when required in an effort to resolve any deskside or kiosk solutions.* Assistance with monitoring and tracking incident tickets to ensure a resolution occurs within the service level agreements.* Performing follow-up on incident tickets to ensure end-user satisfaction.* Conducting tests on a given network to anticipate any outages and reporting accordingly.If you love helping others, solving problems, and have a demonstrated interest in technology, this might be your next career!Advantages:* An opportunity to work for the Federal Government. Need I say more?* Great Pay, Earn between $20 – 30 per hour * This is a chance to be recognized and develop your skills and knowledge by working directly with the latest technology and software used by multiple Federal bodies.* Enjoy working in a fully modern environment.* Benefits are available for purchase via Randstad Advantage.* Great hours! The work schedule is strictly during business hours. – No weekendsQualifications:* Must possess a valid Government Secret Clearance or be eligible to obtain one (we will sponsor you)* Minimum 2 years call center or previous Technical Support Experience is an asset.* Must have excellent communication skills Good problem solving and analytical skills.* Any completed IT-related education is considered a strong asset.* Must have knowledge of computers and have a technical mindsetYour new career starts here. Apply today at Randstad.ca - Ottawa Technologies Job Order 2201357PROENSummaryOur Central Ottawa based Federal Government client is looking for Bilingual and Unilingual Help Desk & Service Desk Agents to support their internalemployees and end-users. We are seeking qualified candidates who in pursuing careers in the IT support sector.This is a contractual position up to a 1-year team. There is the possibility of extension and renewal based on your performance!Your daily responsibilities will include:* Receiving, logging, and answering calls/emails from users about various technical requests surrounding one’s profile. (ex, password resets, onboarding new employees and granting system access as per group policies)Identify technical problems on a given interaction* Create service tickets or Incident tickets when required* Solving incident tickets when required* Closing Service tickets when required* Performing the initial level of problem identification and attempting to resolve when appropriate.* Documenting any troubleshooting efforts in a problem ticket and escalating to the appropriate channels of the organization.* Provide support to on-site technicians when required in an effort to resolve any deskside or kiosk solutions.* Assistance with monitoring and tracking incident tickets to ensure a resolution occurs within the service level agreements.* Performing follow-up on incident tickets to ensure end-user satisfaction.* Conducting tests on a given network to anticipate any outages and reporting accordingly.If you love helping others, solving problems, and have a demonstrated interest in technology, this might be your next career!Advantages:* An opportunity to work for the Federal Government. Need I say more?* Great Pay, Earn between $20 – 30 per hour * This is a chance to be recognized and develop your skills and knowledge by working directly with the latest technology and software used by multiple Federal bodies.* Enjoy working in a fully modern environment.* Benefits are available for purchase via Randstad Advantage.* Great hours! The work schedule is strictly during business hours. – No weekendsQualifications:* Must possess a valid Government Secret Clearance or be eligible to obtain one (we will sponsor you)* Minimum 2 years call center or previous Technical Support Experience is an asset.* Must have excellent communication skills Good problem solving and analytical skills.* Any completed IT-related education is considered a strong asset.* Must have knowledge of computers and have a technical mindsetYour new career starts here. Apply today at Randstad.ca - Ottawa Technologies Job Order 2201357PROENRandstad 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.

Our Client in the Ontario Public Sector is looking for a ETL Developer with heavy Azure experience on a 8 month contract. 5+ Years ofDemonstrates experience designing, developing, and implementing ETL solutions using Azure Data Factory.Demonstrates development and solution design experience in an environment where Azure Data Factory, and PowerBI are used togetherExperience in designing data warehouses and data marts for databases such as Oracle, SQL ServerAzure SQL Database as well as having a strong understanding of the architectural implications associated with each platform in regard to ETLDemonstrates experience developing application code package using Azure DevOpsDemonstrates development experience with SQL Server 2016+, Azure Blob and Azure SQL Database, Oracle 12.Demonstrates experience developing application code package using Azure DevOpAdvantagesPayment every weekLong Term ContractWorking in Ontario Public Sector RQ03071 Responsibilities Demonstrates 5 - 10 years of experience designing, developing, and implementing ETL solutions using Azure Data Factory.· Demonstrates development and solution design experience in an environment where Azure Data Factory, and PowerBI are used together· Experience in designing data warehouses and data marts for databases such as Oracle, SQL Server, Azure Blob, Azure SQL Database as well as having a strong understanding of the architectural implications associated with each platform in regard to ETL· Experience in debugging mappings, transformations, mapplets, source qualifier files and queries· Demonstrates experience with developing ETL solutions to populate data warehouses and create data extracts for the purpose of business intelligence reporting· Demonstrates experience developing star schema multi-dimensional models· Experience with developing, debugging and enhancing the performance of complex SQL queries· Demonstrates experience developing Unix shell scripts· Demonstrates experience using Power Designer to review data models, as well as make changes and generate DDL scripts· Demonstrates experience developing application code package using Azure DevOps· Demonstrates development experience with SQL Server 2016+, Azure Blob and Azure SQL Database, Oracle 12.x· Demonstrates experience with documenting code changes, creating release packages and deployment instructions· Experience with performing unit testing and conducting System Integration Testing and User Acceptance TestingDemonstrated Experience with Informatica and Powercenter would be an assetQualificationsKnowledge and experience in gathering requirements and business process knowledge in order to transform the data in a way that’s geared towards the needs of end usersKnowledge and experience maintaining and improving already existing processes.Knowledge and experience ensuring that the data architecture is scalable and maintainableKnowledge and experience working with the business in designing and delivering correct, high quality dataExperience investigating data to identify potential issues within ETL pipelines, notify end-users and propose adequate solutionsExperience preparing detailed documentation for further referenceDesirable Skills:Knowledge and experience with programming Internet-ready applicationsKnowledge and experience in rapid application development (RAD) methodologiesKnowledge and understanding of Information Management principles, concepts, policies and practicesExperience with middleware and gatewaysExperience reviewing, analyzing, and modifying product installation scripts including encoding, testing, debuggingAbility to provide post-implementation support and resolve any post-implementation technical issuesExperience conducting design walkthrough sessions with project teamKnowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standardsAbility to provide user and system documentation as requiredSummaryDesign, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities.Required to translate technical systems specifications into working, tested applications. This includes developing detailed programming specifications, writing and/or generating code, compiling data-driven programs, maintaining, and conducting unit tests.Resolves and troubleshoots technical problems which arise during the use and operation of software packages, including technical assistance in implementation, conversion and migrations.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.