ETL Architect

InnosphereRemote16 days ago

ETL Architect

The ETL Architect drives and determines the integration architecture necessary for the team to develop and implement large complex projects. They are responsible for improving the ETL technical infrastructure, maintaining development tools, documenting processes, and creating development standards.


Responsibilities and Duties

  • Identifying, recommending, and implementing integration process and architectural improvements
  • Developing solutions in a highly demanding environment
  • Working with team members, peers, and management to identify objectives and set priorities
  • Working directly with customers to gather requirements on new data integration services, assist in translating those requirements into actionable deliverables
  • Creating and maintaining document repository of mappings and processes
  • Ability to function at both the Architect and Developer level, joining and working alongside other developers as needed


  • University Degree in Computer Science or related program
  • A minimum of 5 years work experience as an ETL developer or architect
  • (Preferred) 3-year experience using Dell Boomi Atomsphere in development and support projects(Preferred) Experience with Boomi deployment within a private cloud
  • (Preferred) Experience with ETL capability as a product offering
  • Strong experience building Boomi processes, leveraging common frameworks such as message queuing, caching, complex mapping and scripting
  • Ability to guide the team in design and development activities
  • Knowledge of Boomi design and ETL best practices
  • Experienced with various data pipeline design patterns
  • Strong or advanced SQL skills


About Innosphere


Founded in 1997, Innosphere provides technology staffing solutions to clients across North America. We have specialized in remote work for over 15 years. Our staffing solutions include fully managed development teams coupled with expert consulting, full-time hiring, and flexible staffing.


Innosphere is a permanent remote company but we do have offices in Guelph and Kitchener-Waterloo to provide employees opportunities to work intermittently in an office environment. We have collaborative space for meetings, lunches, and company events. Our employees have the freedom to choose where they prefer to work.


Innosphere is committed to providing its employees with endless possibilities to learn new things and to work with the latest technologies.


When we hire, we look for people who embody our core values:


· Honesty - We believe in acting with authenticity and integrity—being candid and transparent in all that we do.

· Understanding – We value taking time and investing resources in order to deeply understand those that we interact with.

· Adaptability - If something is no longer working, we are not too proud to change. Our strength lies in our ability and willingness to grow, adjust, and try something new.

· Partnership - We believe in active collaboration, working together toward the same goals, and celebrating success together.


Life as an Innospherian


Who we are and how we work:


·       Work from home or office

·       Flexible work schedule

·       Open door policy

·       Team owned deliverables

·       Virtual water cooler talk

·       Open office floor plan

·       Team based strategic planning

·       Daily stand up

·       Group brainstorming sessions

·       Charity Initiatives

·       Promote from within

·       Casual dress


Some other perks:


·       Breakfast, pop, snacks, beer, and coffee always on tap in our kitchen

·       Frequent catered lunches

·       Generous time off

·       Free gym membership

·       Above average benefits (Dental, Health, Vision, STD, LTD, AD&D, Life, Dependant Life)

·       Yearly professional development budget

·       Regular company outings and family events (VR night, Raptors games, axe throwing and more)

·       Employee lotteries (for Raptors tickets, cool tech etc.)

·       Parking

·       Lunch and Learns


Innosphere welcomes and encourages applications from people with disabilities. Accommodations are available on request for candidates taking part in all aspects of the selection process. Only applicants meeting the criteria outlined above will be contacted as part of the shortlisting process. All applicants are subject to a criminal, educational, and employment history background check. Must be currently residing in Canada and legally permitted to work in Canada. Please reply directly to this post with a cover letter and resume. No phone calls please. 

Job Type: Full-time, Remote

Salary: $110,000.00 to $140,000.00 /year plus Benefits

Subscribe to Job Alerts