Sr. ETL Developer

Information Technology / Technologie de l’information Mississauga, Ontario


If you thrive in a team-oriented workplace that challenges your skills, to drive your career development, embraces diversity and rewards innovation, with competitive pay and great employee programs, join the Ainsworth team today!

Position Summary:

The Senior ETL role developer entails the timely delivery of high-quality technical support services for internal clients within the company or external clients who are deemed to require technical support services.  The successful candidate will require technical knowledge of the software, hardware, and services being supported.  This position will be responsible for contributing to both the overall enterprise data architecture and ETL design and development.  The ideal candidate will use a collaborative and adaptable approach to drive consensus in design and BI technology alignment with our overall business requirements as identified by key stakeholders.



  • Work with business analysts and team members to translate business requirements into a proposed solution, reviewing the design and requirements and build value-added solutions
  • Provide expertise in the development of data models, data warehouse design, ETL performance optimization and data quality
  • Research issues and identify the root causes to ultimately work with your Business Analysts to test solutions, ensuring that all solutions perform to expectations and meet all requirements for accuracy, clarity and ease of use
  • Partner with IT to manage, build and develop data warehouse ETL scripts. Hands-on collaborative development of analytical systems, strategies and best practices, production ETL processes and database models
  • Research issues and identify the root cause of information issues and design a solution that will prevent the problem from re-occurring
  • Analyze, design and introduce new opportunities and make appropriate recommendations to drive process improvements and productivity initiatives within the ETL function
  • Support new data source acquisition to promote self-serve capabilities
  • Improve ETL cycle time and standardize processes across the enterprise
  • Contribute to the development of predictive and data modelling frameworks in response to evolving business requirements
  • Travel to field offices intermittently to work with key stakeholders.
  • Document all ETL operations, processes and objects.
  • Ensure leading practices and standards are followed.



  • Required Education: College or University degree in Computer Science (or equivalent credits in management and Computer/Systems related)
  • Excellent knowledge of data modelling techniques in relational, dimensional, unstructured, and big data (7+ years’ experience) - Required
  • Experience in ETL design and development
  • Experience in Talend Integration Studio
  • Experience in MSSQL RDBMS
  • Expert understanding of SQL concepts and the ability to complex queries is required.
  • Hadoop experience preferred
  • End to End Data warehouse implementation experience is a must
  • Experience with enterprise application architecture and enterprise integration patterns
  • Ability to implement re-usable data-integration/ETL code in an enterprise data warehouse environment
  • Perform complex applications programming activities. Code, test, debug, document, maintain, and modify complex applications program
  • Examine and solve the performance bottlenecks in the ETL processes
  • Excellent interpersonal, verbal, and written communication skills are required
  • Ability to analyze and document business and system processes is required
  • Experience with Business Intelligence tools is preferred, Cognos is preferred (Controller, Planning Analytics and Analytics).
  • Ability to multitask and handle ambiguity is required
  • Ability to take charge and lead tasks to completion is required
  • Ability to work in a cross-functional organization and Ability to work in a team environment is required
  • Excellent decision making and problem-solving skills are required

Schedule: Full Time

Shift: N/A

Length of Contract: N/A

Work Location: Mississauga

While we appreciate all applications we receive, we advise that only candidates under consideration will be contacted.

Ainsworth is committed to building a diverse and inclusive workplace. Qualified designated group members are encouraged to apply as any reasonable accommodation of qualifications will be considered as per our Accommodation Policy, available upon request.

Ainsworth is an integrated multi-trade company, offering end-to-end services and solutions for all asset maintenance and refurbishment requirements of our customers. We are continually striving to create better and more advanced products as well as provide the highest quality service. We are rapidly growing and need talented professionals to help drive our vision at becoming the best multi-trade company in the country! Join us…. Make a difference.

l Team Oriented Environment l Competitive compensation l Performance-Based Bonuses l Paid Training Program l Group Benefits Plan l Promote-from-within Policy l Vacation Policy l State-of-the-Art Equipment and Tools l Exposure to Cutting Edge Technology l