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 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!

• Fun work environment

• Competitive wages

• Excellent benefits

• Unlimited career advancement opportunities

• Bass Pro Cares Fund

Cabela's

About Bass Pro Shops

Bass Pro Shops (http://www.basspro.com/) is North America’s premier outdoor and conservation company. Founded in 1972 when avid young angler Johnny Morris began selling tackle out of his father’s liquor store in Springfield, Missouri, today the company provides customers with unmatched offerings spanning premier destination retail, outdoor equipment manufacturing, world-class resort destinations and more. In 2017 Bass Pro Shops joined forces with Cabela’s (http://www.cabelas.com/) to create a “best-of-the-best” experience with superior products, dynamic locations and outstanding customer service. Bass Pro Shops also operates White River Marine Group (http://www.whiterivermg.com/) , offering an unsurpassed collection of industry-leading boat brands, and Big Cedar Lodge (http://www.bigcedar.com/) , America’s Premier Wilderness Resort. Under the visionary conservation leadership of Johnny Morris, Bass Pro Shops is a national leader in protecting habitat and introducing families to the outdoors and has been named by Forbes as “one of America’s Best Employers.”