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 reporting
Develop 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 inefficiencies
Adapt 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 tools
Other duties as assigned.
Qualifications :
A bachelor's degree in Operations Research, Computer Science, Economics, Engineering, Applied Mathematics, or a similar discipline
At least 1 year of proven work experience as an ETL Develop or equivalent experience
Understanding of database management systems, ETL (Extract, transform, load) framework, and dataflows
Strong proficiency in one or more of the following – SQL, Python, VBA, Data Warehouse Model Design
Experience with Snowflake and / or Microsoft Power BI / Fabric Semantic Modeling will be considered an asset
Excellent communication and presentation skills and a unique ability to bridge the communication gap between executive and front-line audiences
Highly motivated, organized with the ability to work autonomously
Solid understanding of the underlying theory and principles of data science and data warehousing
Ability to prioritize work with good time-management skills
Proficient with Microsoft Office applications (Word, Excel, Outlook, Visual Basic)
Benefits :
Hybrid work-from-home options on Wednesdays & Fridays
Immediate employee discount
Fun work environment
Competitive wages
Excellent benefits
Unlimited career advancement opportunities
Bass Pro Shops & Cabela’s welcomes applications from people with disabilities.
Accommodations are available upon request during the assessment and selection process.
Benefits
Enjoy discounts on retail merchandise, our restaurants, world-class resorts and conservation attractions!