Bounteous x Accolite makes the future faster for the world’s most ambitious brands. Our services span Strategy, Analytics, Digital Engineering, Cloud, Data & AI, Experience Design, and Marketing. We are guided by Co-Innovation, our proven methodology of collaborative partnership.
Bounteous x Accolite brings together 5000+ employees spanning North America, APAC, and EMEA, and partnerships with leading technology providers. Through advanced digital engineering, technology solutions, and data-driven digital experiences, we create exceptional and efficient business impact and help our clients win.
Job Title: Senior IT Specialist - Database/ETL/Data Warehouse
Location: Montreal (Office attendance day 1 – Hybrid Mode 3x per week)
Job Description:
Join our dynamic Finance Technology team supporting the Investment Management (IM) business as a Senior IT Specialist specializing in Database (DB), Extract, Transform, Load (ETL), and Data Warehouse (DW) technologies.
Responsibilities:
1. Design, develop, and maintain robust database systems (e.g., DB2, Sybase, Teradata, Snowflake) to meet the evolving needs of the Investment Management division.
2. Implement and enhance cross-platform ETL processes for efficient data extraction, transformation, and loading, ensuring data accuracy and integrity.
3. Collaborate with cross-functional teams to understand data requirements and contribute to the design and development of Data Warehouse solutions, optimizing across various DB technologies.
4. Performance tuning of database queries, ETL processes, and Data Warehouse components to optimize system efficiency without redundant technology mentions.
5. Monitor and troubleshoot issues related to databases, ETL jobs, and Data Warehouse, ensuring timely resolution across multiple platforms.
6. Work closely with data architects and analysts to implement data modeling best practices, ensuring adherence to data governance standards.
7. Participate in the planning and execution of data migration projects, ensuring seamless transitions between diverse systems.
Qualifications:
1. Bachelor’s degree in Computer Science, Information Technology, or related field.
2. Proven experience in designing, implementing, and managing relational databases (e.g., DB2, Sybase, Teradata, Snowflake), with a focus on Teradata, Snowflake.
3. Proficiency in SQL and scripting languages for data manipulation and automation.
4. Expertise in ETL tools and processes, with hands-on experience in tools such as Informatica, Talend, or similar.
5. Solid understanding of Data Warehouse concepts, architecture, and implementation across multiple database technologies.
6. Strong problem-solving skills with the ability to analyze and resolve complex database and ETL-related issues.
7. Excellent communication and interpersonal skills for effective collaboration within a diverse team environment.
EEO
Bounteous x Accolite is proud to be an Equal Employment Opportunity and Affirmative Action employer. We do not discriminate based upon race, religion or belief, color, ethnic or national origin, marital or domestic relationship, sexual orientation, gender identity, age, citizenship, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics.
Accommodation
Accolite is committed to providing reasonable accommodations for qualified individuals with disabilities and disabled veterans in our job application procedures. If you need assistance or accommodation due to a disability, you may contact us at
NA.TalentAcquisition@accolitedigital.com.