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 implementationsDevelop and optimize SQL queries, stored procedures, and scripts to extract and transform data from source systemsAssist with planning, coordinating, and executing the migration of data from legacy systems or existing databases to new systems or platformsMonitor ETL processes, troubleshoot performance issues, and handle data exceptionsWork closely with clients on data migration, transformation and scripting, and understand their data mapping and data qualityCollaborate with cross-functional teams to integrate new data sources, enhance existing ETL processes, and support business intelligence and reporting requirementsDocument technical specifications, ETL workflows, and data mappings to facilitate understanding, maintenance, and future enhancementsAdhere to data governance policies, security standards, and regulatory compliance while handling sensitive and confidential dataTo 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 experienceAt least 5 years’ experience in ETL development5+ years of experience working with large Oracle databases, DB2, or similar relational database systems5–7 years’ experience with Microsoft SSIS or a comparable toolsetExtensive experience writing complex SQL queries and stored proceduresSome experience with ETL testingExperience with version control tools such as Git or Azure DevOpsExceptional attention to detail and strong problem-solving skillsA collaborative approach to workComfort in presenting high-level information to various stakeholders, with the ability to drill into complex detailsOur 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