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!
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
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