Data Integration Specialist

2 weeks 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

    1 week ago

    Toronto, Canada Insight Global Full time

    This range is provided by Insight Global. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more. Base pay range CA$60.00/hr - CA$65.00/hr Role: Data Integration Specialist Type: 12 month contract Location: Hybrid 2x/week in Toronto, Mississauga, or Guelph, ON Rate: $60-65/hr Job Description Insight Global is...

  • Data Integration Specialist

    1 week ago

    Toronto, Canada Insight Global Full time

    This range is provided by Insight Global. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more. Base pay range CA$60.00/hr - CA$65.00/hr Role: Data Integration Specialist Type: 12 month contract Location: Hybrid 2x/week in Toronto, Mississauga, or Guelph, ON Rate: $60-65/hr Job Description Insight Global is...

  • Data Integration Specialist

    6 days ago

    Toronto, Canada Insight Global Full time

    This range is provided by Insight Global. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more. Base pay range CA$60.00/hr - CA$65.00/hr Role: Data Integration Specialist Type: 12 month contract Location: Hybrid 2x/week in Toronto, Mississauga, or Guelph, ON Rate: $60-65/hr Job Description Insight Global is...

  • Data Integration Specialist

    3 days ago

    Toronto, Canada Vector Institute Full time

    *** Reporting to the Manager, Business Computing, the Data Integration Specialist is responsible for implementing data integrations and optimizations across various business systems, automating workflows, and advancing a business analytics environment and a data warehouse. **KEY RESPONSIBILITIES** - Collaborate with various business units to identify, map,...

  • Data Integration Specialist

    1 week ago

    Toronto, Ontario, Canada Insight Global Full time

    JOB DESCRIPTIONInsight Global is seeking a Senior Data Integration Specialist for one of Canada's leading insurance companies. We're seeking an individual to support and enhance our Policy Center and Billing Center systems. This role involves maintaining and troubleshooting production issues, including month-end process failures, while implementing...

  • Senior Data Integration Specialist

    4 weeks ago

    Toronto, Canada Insight Global Full time

    Get AI-powered advice on this job and more exclusive features. This range is provided by Insight Global. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more. Base Pay Range CA$62.00/hr - CA$67.00/hr Direct message the job poster from Insight Global Hybrid model 2x per week onsite, in local office (Guelph,...

  • Senior Data Integration Specialist

    1 week ago

    Toronto, Canada Insight Global Full time

    Get AI-powered advice on this job and more exclusive features. This range is provided by Insight Global. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more. Base Pay Range CA$62.00/hr - CA$67.00/hr Direct message the job poster from Insight Global Hybrid model 2x per week onsite, in local office (Guelph,...

  • Data Integration Specialist

    1 week 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 Systems and Integration Specialist

    6 days ago

    Toronto, Canada CIS Ontario Full time

    Data Systems and Integration Specialist Full-Time Permanent The York School is a co-ed, independent school in midtown Toronto that offers the International Baccalaureate (IB) from Junior Kindergarten to Grade 12. We’re proud to be at the forefront of education excellence, attracting curious learners who thrive in belonging to an inclusive community of high...

  • Remote Data Entry

    3 days ago

    Toronto, Canada Environmental Career Center Full time

    A data-driven organization in Toronto, Ontario is seeking a detail-oriented Data Entry Specialist. This role is crucial for maintaining the accuracy and integrity of data systems, providing support to various departments through precise data input. The ideal candidate should possess strong organizational skills, have experience in data entry, and proficiency...