Etl Manager

1 month ago


North York, Canada RPS Real Property Solutions Inc. Full time

**ETL Manager**

**About this role**:
This role will bring value by helping to architect, build and maintain large data pipelines that transform data into RPS standard format. From input, consumption, and output, you will be a key contributor to the end-to-end design and implementation of RPS data requirements

**Accountabilities**:

- Help scale IT functions and processes that support the continued innovation of RPS solutions
- Create an optimal and scalable data architecture to reduce solution processing time
- Participate in solutioning and design to help upgrade legacy data systems and processes to a new scalable platform using new technologies
- Help design, build and maintain data pipelines using substantially large datasets
- Align business data requirements with technology strategy
- Use your understanding of interdependencies between technology, operations, and business needs to drive innovation and automation
- Continually enhance systems to enable development of new and more sophisticated products
- Ensure the timely delivery of robust data pipeline solutions that meet internal and external requirements
- Maintain database integrity and optimization
- Manage data flow and its related ETL processes
- Identify root causes and resolve data related issues
- Ensure data security across Hosted Private and Hosted Public cloud environments
- Research new tools / technologies to ensure alignment with latest industry trend

**Work Experience/Skills**:

- 7-10 years working experience in IT, with proven track record in handling large complex datasets including building and optimizing ‘big data’ pipelines, architectures and datasets
- Ability to troubleshoot and solve complex technical problems
- Demonstrable experience scaling IT systems and architecture
- Experience with Azure or similar public cloud services
- Able to make implementation decisions about highly complex projects, including initiatives that require extensive research to complete / refine requirements
- Working knowledge of modern APIs such as REST & SOAP; experience in API design
- Excellent scripting skills using Python and PowerShell
- Proficient in database design and modelling, SQL query language and stored procedures
- Experience with NoSQL databases like MongoDB
- Familiarity with code repository (Git) and CICD pipeline

**Knowledge**:

- SDLC life cycle
- REST & SOAP APIs
- SQL Server & PostgreSQL relational databases
- NoSQL database
- Azure or related Public Cloud Platform
- Python
- PowerShell
- Git
- Azure DevOps
- MS Office365

**Education**:

- Degree in Computer Science, Engineering, or related field.

**Other Information**:

- Status: Full Time role
- Hours: 35 hours per week
- Location: 39 Wynford Drive, Toronto, ON M3C-3K5

**Job Types**: Full-time, Permanent

**Salary**: From $90,000.00 per year

**Benefits**:

- Employee assistance program
- Paid time off
- RRSP match
- Work from home

Flexible Language Requirement:

- French not required

Schedule:

- 8 hour shift
- Monday to Friday

Supplemental pay types:

- Bonus pay

Ability to commute/relocate:

- North York, ON: reliably commute or plan to relocate before starting work (required)

**Experience**:

- ETL: 5 years (preferred)

Work Location: Hybrid remote in North York, ON



  • North York, Canada Randstad Canada Remote Work Freelance Full time

    This is a contract position for a Software Developer - ETL for our public sector client.Work location: North YorkDuration: Twelve Months7.25 hours/dayThis is a Hybrid role that requires the candidate to be onsite 3 days of the week (This is a mandatory requirement of the role and is non-negotiable outside of exceptional circumstances.)AdvantagesGood...

  • ETL BI Developer

    4 weeks ago


    East York, Canada Maarut Inc Full time

    Resource ProfileThis requirement is for a ETL and BI Developer to work with technology and business teams to provide technical leadership in planning, analysis, building, configure, testing, and post implementation support data solutions with experience with enterprise ETL and data integration and reporting tooling such as IBM Infosphere Information Server...

  • RQ07285 CDT

    2 weeks ago


    North York, Canada Randstad Canada Remote Work Freelance Full time

    This is a contract position for a Senior ETL Developer for our public sector client.Work location: 21 College Street, TorontoDuration: 11 months7.25 hours/dayThis is a Hybrid role that requires the candidate to be onsite 3 days of the week (This is a mandatory requirement of the role and is non-negotiable outside of exceptional circumstances.)AdvantagesGood...


  • North York, Canada Randstad Canada Remote Work Freelance Full time

    Our client, a leader in the Healthcare industry, is looking for a Senior ETL developer for doing product updates, operations and maintenance on a series of ETL products. This Senior Developer must be knowledgeable and experienced in the following technologies to be able to support the related portfolio of products: Informatica DEI and shell scripting,...


  • North York, Canada Mevotech Full time

    **Take your Career to the next Level with MEVOTECH.** **JOB PURPOSE** Reporting directly to the Director Enterprise Architecture, the Manager, Data Governance will be responsible for managing and optimizing our data warehouse infrastructure, ensuring its reliability, scalability, and efficiency. This individual will be working closely with our finance and...


  • North York, Canada R Systems Full time

    7 + years of experience in Python programming languages Experience with big data technologies like Spark, and KafkaExpertise in Datawarehouse design/implementation, dimensional modelingKnowledge of database management systems, both relational (e.g., SQL, PostgreSQL)Familiarity with data integration and ETL tools, such as Talend, Glue, Azure ADF etc)Project...

  • Senior Data Engineer

    8 hours ago


    North York, Canada R Systems Full time

    7 + years of experience in Python programming languages Experience with big data technologies like Spark, and Kafka Expertise in Datawarehouse design/implementation, dimensional modeling Knowledge of database management systems, both relational (e.g., SQL, PostgreSQL) Familiarity with data integration and ETL tools, such as Talend, Glue, Azure ADF etc)...


  • North York, Canada Ministry of Health Full time

    **Bring your IT leadership to the Ministry of Health!** Are you passionate about making a difference? Are you ready for your next leadership opportunity? The Business Intelligence and Business Analytics Unit within the Corporate I+IT Solutions & Integration Management Branch in the Health Services Information and Information Technology Cluster is seeking an...

  • Senior Data Engineer

    16 hours ago


    North York, ON, Canada R Systems Full time

    7 + years of experience in Python programming languages Experience with big data technologies like Spark, and KafkaExpertise in Datawarehouse design/implementation, dimensional modelingKnowledge of database management systems, both relational (e.g., SQL, PostgreSQL)Familiarity with data integration and ETL tools, such as Talend, Glue, Azure ADF etc)Project...

  • Senior Data Engineer

    6 hours ago


    North York, ON, Canada R Systems Full time

    7 + years of experience in Python programming languages Experience with big data technologies like Spark, and KafkaExpertise in Datawarehouse design/implementation, dimensional modelingKnowledge of database management systems, both relational (e.g., SQL, PostgreSQL)Familiarity with data integration and ETL tools, such as Talend, Glue, Azure ADF etc)Project...


  • North Bay, Canada Resonaite Full time

    Our client in the public health sector is looking for a Data Management Lead on a fulltime permanent basis. The role driving including defining and implementing a cloud-based data storage structure to enable analytics and reporting and implement data integration solutions across systems to streamline business processes. The successful candidate will also be...


  • North Bay, Canada Resonaite Full time

    Our client in the public health sector is looking for a Data Management Lead on a fulltime permanent basis. The role driving including defining and implementing a cloud-based data storage structure to enable analytics and reporting and implement data integration solutions across systems to streamline business processes. The successful candidate will also be...


  • North Bay, Canada Resonaite Full time

    Our client in the public health sector is looking for a Data Management Lead on a fulltime permanent basis. The role driving including defining and implementing a cloud-based data storage structure to enable analytics and reporting and implement data integration solutions across systems to streamline business processes. The successful candidate will also be...

  • Data Scientist

    2 days ago


    North York, Canada 247 Labs Full time

    We are seeking a skilled and experienced Senior Data Analyst to join our team. The ideal candidate will be proficient in handling datasets, possess strong analytical skills, and recommend and implement tools to streamline data management processesResponsibilities:Data Analysis and Modeling:Perform data analysis, feature engineering, and model development to...


  • North York, Canada Viscor Inc. Full time

    Centrally located in Toronto, Canada, Viscor is a division of Leviton Manufacturing's Lighting Business Unit operating in Canada for over 70 years. We are proud to have a diverse team of Engineering and Manufacturing professionals dedicated to the development of lighting products. We are currently looking for a test and compliance focused Engineer to join...

  • Data Management Lead

    2 weeks ago


    North Bay, ON, Canada Resonaite Full time

    Our client in the public health sector is looking for a Data Management Lead on a fulltime permanent basis. The role driving including defining and implementing a cloud-based data storage structure to enable analytics and reporting and implement data integration solutions across systems to streamline business processes. The successful candidate will also be...


  • North Bay, ON, Canada Resonaite Full time

    Our client in the public health sector is looking for a Data Management Lead on a fulltime permanent basis. The role driving including defining and implementing a cloud-based data storage structure to enable analytics and reporting and implement data integration solutions across systems to streamline business processes. The successful candidate will also be...


  • North Bay, Canada Resonaite Full time

    Our client in the public health sector is looking for a Data Management Lead on a fulltime permanent basis. The role driving including defining and implementing a cloud-based data storage structure to enable analytics and reporting and implement data integration solutions across systems to streamline business processes. The successful candidate will also be...

  • Data Management Lead

    4 weeks ago


    North Bay, Canada Resonaite Full time

    Our client in the public health sector is looking for a Data Management Lead on a fulltime permanent basis. The role driving including defining and implementing a cloud-based data storage structure to enable analytics and reporting and implement data integration solutions across systems to streamline business processes. The successful candidate will also be...

  • Data Management Lead

    4 weeks ago


    North Bay, Canada Resonaite Full time

    Our client in the public health sector is looking for a Data Management Lead on a fulltime permanent basis. The role driving including defining and implementing a cloud-based data storage structure to enable analytics and reporting and implement data integration solutions across systems to streamline business processes. The successful candidate will also be...