ETL Developer

Summary:Reporting to the E-commerce & Data Analytics Manager, the ETL Developer is responsible for creating the appropriate programming scripts required to extract, transform, clean, and move source data into optimal data warehouse structures for analysis and reporting.Location:This position is a hybrid role that allows for 2 days of remote work and 3 days in the office. The office is located at 25 De Beats Street, Winnipeg, MB.Responsibilities:Develop and test extraction, transformation, and load (ETL) processes. Deliver source system data to the data warehouse in the appropriate format.Support the Data Analytics and Business Intelligence teams in developing an appropriate data warehouse structure for the various data sources required for new and existing business use cases in analytics and reportingDevelop and implement systems and tools to support and enable leaders and key stakeholders to take strategic action in a dynamic competitive retail environment.Work with data analysts to map source system data to data warehouse models. Develop transformation logic for source system loads to data warehouse.Improve productivity by automating routine tasks. Seek to eliminate the need for human intervention and proactively identify opportunities for eliminating inefficienciesAdapt ETL processes to accommodate changes in source systems and new business user requirements. Provide flexibility as source systems evolve and user requirements change. Organize scripts and produce documentation using Git and project management toolsOther duties as assigned.Qualifications:A bachelor's degree in Operations Research, Computer Science, Economics, Engineering, Applied Mathematics, or a similar disciplineAt least 1 year of proven work experience as an ETL Develop or equivalent experienceUnderstanding of database management systems, ETL (Extract, transform, load) framework, and dataflowsStrong proficiency in one or more of the following – SQL, Python, VBA, Data Warehouse Model DesignExperience with Snowflake and/or Microsoft Power BI/Fabric Semantic Modeling will be considered an assetExcellent communication and presentation skills and a unique ability to bridge the communication gap between executive and front-line audiencesHighly motivated, organized with the ability to work autonomouslySolid understanding of the underlying theory and principles of data science and data warehousingAbility to prioritize work with good time-management skillsProficient with Microsoft Office applications (Word, Excel, Outlook, Visual Basic)Benefits:Hybrid work-from-home options on Wednesdays & FridaysImmediate employee discountFun work environmentCompetitive wagesExcellent benefitsUnlimited career advancement opportunities