Data Integration Specialist

1 month ago

Toronto, Canada ERIS Info. Full time

**One growing team. One single-minded goal.**

To innovate intuitive, responsive products to make environmental professionals' work lives easier.

ERIS has been providing critical risk and historical information on properties in Canada since 1999. In late 2013, ERIS launched in the United States, as the first and only company to provide environmental risk information for both countries. ERIS delivers accurate, comprehensive, and innovative on-demand database research services quickly and with a service-first attitude.

**Position Overview**

The Data Integration Specialist will be expected to complete data pipeline tasks including loads and peer-review checks of loads; support Data Team initiatives and projects; carry out data modelling and plan load strategies for complex data loads; and provide technical guidance and training to other team members. This is a full-time, hybrid position, with a 35-hour workweek.

**Specific Responsibilities and Daily Tasks**

Data pipeline tasks including loads and peer-review checks of loads:

- Modelling of complex data - determining relationships between tables; determining how to transpose multi-dimensional data onto our fixed-schema tables.
- Peer review checks of complex data loads.
- Loading data from staging into our QA environment to appropriately blend production data with new data in our staging environment.

Contribute to data team initiatives and projects, including, for example, but not limited to:

- Testing new code and/or processes.
- Other data tasks as required.

**What We Offer**
- A culture based on caring, ownership, accountability, and integrity. Our teams are agile, collaborative, innovative, and continually strive for excellence.
- We encourage a healthy work-life balance in a fast-paced expanding company.
- We treat others with respect and fairness and strive for clear and open communication at all levels.
- We are passionate about building an inclusive and diverse workplace that others envy.
- We offer a competitive salary, extended health benefits, and flexible workplaces and schedules.

If you’re excited about this opportunity and feel it aligns with your strengths, interests and aspirations, we encourage you to submit your thoughtful cover letter and resume.**Please note that only those selected for an interview will be notified. No phone calls please.**

**Required Experience, Knowledge & Skills**
- Experience using a variety of strategies, tools, and queries to assess problems and provide recommendations based on in-depth analyses of results.
- Advanced SQL skills and knowledge of relational databases.
- 2 or more years of experience in ETL and data integration.
- Experience reading, running, and troubleshooting SQL code for Oracle.

**Skills**
- Demonstrates sound judgement and professionalism in interactions with others.
- Diplomacy and professionalism in communication; precise and concise communication.
- Excellent collaboration and interpersonal skills.
- Quick and enthusiastic learner.
- Strong problem solving and analytical skills.
- Detail oriented.
- Strong organizational skills, ability to multi-task and work under pressure.

  • Data Integration Specialist

    3 months ago

    Toronto, Canada Vector Institute Full time

    **DATA INTEGRATION SPECIALIST** *** Reporting to the Systems Operations Manager, the Data Integration Specialist is responsible for designing and implementing data integrations and optimizations across various business systems, automating workflows, and establishing a data warehouse and business analytics environment. This role collaborates closely with...

  • Data Integration Specialist

    3 months ago

    Toronto, Canada Vector Institute Full time

    Reporting to the Systems Operations Manager, the Data Integration Specialist is responsible for designing and implementing data integrations and optimizations across various business systems, automating workflows, and establishing a data warehouse and business analytics environment. This role collaborates closely with the Business Analyst, project managers...

  • Qlik Data Integration Specialist

    3 weeks ago

    Toronto, Ontario, Canada Nova Tribes Inc Full time

    Job Title: Qlik Data Integration SpecialistAbout the Role:We are seeking an experienced Qlik Data Integration Specialist to join our team at Nova Tribes Inc. As a key member of our data integration team, you will be responsible for designing, implementing, and maintaining data models in Qlik Compose, integrating multiple data sources into a data warehouse,...

  • Data Integration Specialist

    1 day ago

    Toronto, Ontario, Canada Hard Rock Digital Full time

    Job OverviewWe are seeking an experienced Data Integration Specialist to join our team at Hard Rock Digital. As a key member of our corporate analytics platform, you will play a crucial role in supporting and enhancing our data infrastructure.

  • Qlik Data Integration Specialist

    3 weeks ago

    Toronto, Ontario, Canada Nova Tribes Inc Full time

    Job Title: Qlik Data Integration SpecialistAbout the Role:We are seeking an experienced Qlik Data Integration Specialist to join our team at Nova Tribes Inc. As a key member of our data integration team, you will be responsible for designing, implementing, and maintaining data integration solutions using Qlik Compose, Qlik Replicate, and Qlik Cloud.Key...

  • Senior Data Integration Specialist

    3 weeks ago

    Toronto, Ontario, Canada CB Canada Full time

    Senior Data Integration SpecialistAt CB Canada, we are seeking a highly skilled Senior Data Integration Specialist to join our team. The ideal candidate will have expertise in designing and implementing complex data integration solutions using Azure Cloud, HiveQL, PySpark, SAS, and Unix Shell Scripts.Key Responsibilities:Design and develop ETL software...

  • Qlik Data Integration Specialist

    3 weeks ago

    Toronto, Ontario, Canada Nova Tribes Inc Full time

    We are seeking a highly skilled Qlik Data Integration Specialist to join our team at Nova Tribes Inc. This role involves data modeling, integrating multiple data sources, and building data marts on top of a data warehouse.Key Responsibilities:Qlik Tools: Utilize Qlik Compose, Qlik Replicate, and Qlik Cloud to support data integration.Data Modeling: Design...

  • Qlik Data Integration Specialist

    2 weeks ago

    Toronto, Ontario, Canada Nova Tribes Inc Full time

    We are seeking a highly skilled Qlik Data Integration Specialist to join our team at Nova Tribes Inc. This role involves data modeling, integrating multiple data sources, and building data marts on top of a data warehouse.Key Responsibilities:Data Integration: Utilize Qlik Compose, Qlik Replicate, and Qlik Cloud to support data integration.Data Modeling:...

  • Data Integration Specialist

    3 weeks ago

    Old Toronto, Ontario, Canada Blanc Labs Inc. Full time

    Blanc Labs is a leading partner for global enterprises, driving digital transformation and innovation. We are seeking an experienced Data Integration Specialist to lead our ETL development efforts and work closely with a prestigious banking client. The ideal candidate will have a proven track record in leading ETL projects, driving data integration...

  • Data Integration Specialist

    3 weeks ago

    Old Toronto, Ontario, Canada Scotiabank Full time

    Job SummaryWe are seeking a highly skilled Data Integration Specialist to join our team at Scotiabank. As a key member of our Business Intelligence team, you will be responsible for designing, developing, and deploying large-scale data warehouse projects from end to end.Your primary focus will be on building best-in-class ETL solutions using MS SQL Server BI...

  • Data Integration Specialist

    5 months ago

    Toronto, Canada Healthcare of Ontario Pension Plan (HOOPP) Full time

    Why you’ll love working here: - high-performance, people-focused culture- our commitment that equity, diversity, and inclusion are fundamental to our work environment and business success, which helps employees feel valued and empowered to be their authentic selves- learning and development initiatives, including workshops, Speaker Series events and access...

  • Data Strategy Integration Specialist

    3 hours ago

    Old Toronto, Canada Sun Life Financial Full time

    Job OverviewSun Life Financial is seeking a highly skilled Data Strategy Integration Specialist to join our team.This role will play a critical part in shaping our data strategy, driving business growth, and enhancing customer experience.

  • Automation Specialist

    5 months ago

    Toronto, Canada McRae Integration Full time

    06.07.2022 Automation Specialist An automation specialist with McRae Integration is a dedicated and professional PLC specialist with experience in industrial automation.

  • Data Integrity Specialist for Surgical Program

    3 weeks ago

    Greater Toronto Area, Canada www Full time

    Data Integrity Specialist for Surgical ProgramAt Humber River Health, we are seeking a highly skilled Data Integrity Specialist to join our Surgical Program team. As a Data Integrity Specialist, you will be responsible for ensuring the accuracy and completeness of data in our National Surgical Quality Improvement Program (NSQIP). This is a critical role that...

  • Senior Data Integration Specialist

    3 weeks ago

    Old Toronto, Ontario, Canada Blanc Labs Inc. Full time

    Blanc Labs is a leading partner for global enterprises, driving digital transformation and innovation. We are seeking an experienced Senior Data Integration Specialist to lead our ETL development efforts and work closely with a prestigious banking client. The ideal candidate will have a proven track record in leading ETL projects, driving data integration...

  • Data Analyst

    4 weeks ago

    Toronto, Ontario, Canada ECF Data, LLC Full time

    Unlock Your Potential as a Data AnalystAt ECF Data, LLC, we're committed to creating an inclusive and supportive work environment that empowers neurodivergent individuals to thrive. As a Data Analyst, you'll play a vital role in helping us achieve this goal.Key Responsibilities:Conduct ongoing process reviews to identify and resolve issues, ensuring seamless...

  • Data Analyst

    4 weeks ago

    Toronto, Ontario, Canada ECF Data, LLC Full time

    Unlock Your Potential as a Data AnalystAt ECF Data, LLC, we're committed to creating an inclusive and supportive work environment that empowers neurodivergent individuals to thrive. As a Data Analyst, you'll play a vital role in helping us achieve this goal.Key Responsibilities:Conduct ongoing process reviews to identify and resolve issues, ensuring seamless...

  • Data Integration Specialist

    3 weeks ago

    Toronto, Ontario, Canada KPMG Canada Full time

    About the RoleAt KPMG Canada, we're seeking a skilled Data Integration Developer to join our Operation Team. As a key member of our team, you'll play a crucial role in delivering high-quality services and solutions to our clients.Key ResponsibilitiesDesign and implement data integration solutions to meet client needsCollaborate with cross-functional teams to...

  • Data Integration Specialist

    1 month ago

    Toronto, Ontario, Canada KPMG Canada Full time

    About the RoleAt KPMG Canada, we're seeking a skilled Data Integration Developer to join our team of dedicated professionals. As a key member of our Operation Team, you'll play a crucial role in delivering high-quality services and solutions to our clients.Key ResponsibilitiesDesign and implement data integration solutions to meet client needsCollaborate...

  • Data Integration Specialist

    1 month ago

    Toronto, Ontario, Canada KPMG Canada Full time

    About the RoleAt KPMG Canada, we're seeking a skilled Data Integration Developer to join our team of dedicated professionals. As a key member of our Operation Team, you'll play a crucial role in delivering high-quality services and solutions to our clients.Key ResponsibilitiesDesign and implement data integration solutions to meet client needsCollaborate...