ETL Developer

Quartech is an IT solutions and consulting company located in beautiful British Columbia, with offices in Victoria and Vancouver. With over 35 years of IT sector experience, we provide customized technology solutions, design and develop software, integrate technology, and deliver end-to-end Cloud Solutions on the MS Dynamics 365 platform. Quartech works in an Agile environment and is aligned with the DevOps philosophy. Constantly staying ahead of the changing market, we work with emerging technologies like IoT, Blockchain, and AI. We continue to experience significant growth year after year, focusing on building highly collaborative teams who work on a range of projects across multiple industries. At Quartech, you’ll have the opportunity to deliver meaningful work to communities across the province, with significant support for your professional development. As an ETL Developer on our team, you'll leverage your previous experience in hands-on ETL development using MSSQL, SSIS, and SSRS, while establishing testing and data validation frameworks and supporting data warehousing initiatives. We work with Git, Oracle, and Confluence—please highlight your experience with these tools, as well as any experience with Oracle BI or other reporting platforms, in your application. Due to the nature of our work, the successful candidate may need to pass security clearances and background checks. Location : This is a hybrid role, in our Victoria or Vancouver BC office. Salary: $80,000 - $120,000 annually. As an ETL Developer at Quartech, you’ll… Perform data migration scripting, development, and testing for implementations Develop and optimize SQL queries, stored procedures, and scripts to extract and transform data from source systems Assist with planning, coordinating, and executing the migration of data from legacy systems or existing databases to new systems or platforms Monitor ETL processes, troubleshoot performance issues, and handle data exceptions Work closely with clients on data migration, transformation and scripting, and understand their data mapping and data quality Collaborate with cross-functional teams to integrate new data sources, enhance existing ETL processes, and support business intelligence and reporting requirements Document technical specifications, ETL workflows, and data mappings to facilitate understanding, maintenance, and future enhancements Adhere to data governance policies, security standards, and regulatory compliance while handling sensitive and confidential data To be successful in this role you should bring the following… Degree or diploma in computer science, engineering, database administration, or an equivalent combination of education and experience At least 5 years’ experience in ETL development 5+ years of experience working with large Oracle databases, DB2, or similar relational database systems 5–7 years’ experience with Microsoft SSIS or a comparable toolset Extensive experience writing complex SQL queries and stored procedures Some experience with ETL testing Experience with version control tools such as Git or Azure DevOps Exceptional attention to detail and strong problem-solving skills A collaborative approach to work Comfort in presenting high-level information to various stakeholders, with the ability to drill into complex details Our values: Deliver WOW Do the rightthing Have fun What's exciting about working with us: Be part of a driven team focused on solutions that support social change and environmentalsustainability We offer competitive salaries, extended benefits, and our Employee and Family Assistance Program helps to support yourwell-being We supportyourwork-life balance and understand that flexibility is essential We are growing and have great opportunities for advancement and careerdevelopment We are passionate about educationand provide learningopportunities We are dedicated to building a diverse team where people feel a sense of belonging and are valued for their contributions andperspectives #J-18808-Ljbffr