Sr. Software Engineer in Test (SDET) - Data & BI

at  autoTRADERca

TRADER Corporation is a trusted Canadian leader in online media, dealer and lender services. The company is comprised of AutoTrader.ca, AutoSync and Dealertrack Canada. AutoTrader.ca (AutoHebdo.net in Quebec) offers the largest inventory of new cars and used cars in Canada, receiving over 25 million monthly visits to its marketplace. With over 3,500 subscribers and counting, AutoSync is the largest and fastest growing dealer and OEM software provider in Canada. The platform’s suite of connected automotive software solutions brings advertising, conversion and operational support together, synchronizing the entire retail process. AutoSync’s diverse range of offerings includes: vAuto, EasyDeal, xtime, Motoinsight, Activix, TAdvantage and TRFFK. Dealertrack is Canada’s largest automotive financing portal, enhancing efficiency and profitability for all major segments of the automotive, marine, recreational vehicle, motorcycle and powersport retail industries. Over 6.5 million credit applications are submitted via the Dealertrack Canada portal each year. Collateral Management is a national, end-to-end, managed technology solution that offers industry insight and multi-channel collection strategies to maximize funds recovered. Collateral Management helps you remain compliant in all jurisdictions, alleviating your exposure to reputational and financial risks. Visit tradercorporation.com to learn more..
The Sr. SDET will be working closely with product lead, delivery lead, and other agile team members to ensure that the desired result for our projects is achieved. This role will translate business requirements into test case scenarios. The Sr. SDET will ensure that data engineering best practices are applied. This role will be responsible for validating the data sources, extraction of data, applying transformation logic, and loading the data in the target tables.

KNOWLEDGE, SKILLS, AND ABILITIES:

• 3+ years of experience in executing all aspects of testing
• 2+ years of experience with testing ETL, Data, and BI solutions
• Nice to Have: International Software Testing Qualifications Board (ISTQB®) Certified Tester program
• Strong knowledge of database design and data structures (e.g. OLAP, Dimensional, Snowflake)
• Intermediate SQL skills, including the ability to create complex SQL queries on large data sets with complex data models with little or no guidance
• Proficiency with report writing applications required; experience with MS SQL Server, Azure Databricks, Azure Analysis Services, and Power BI is preferred
• Proficiency with Test Management Systems
• Excellent communication skills, both written and verbal, with the ability to understand and execute appropriate levels of technical and non-technical data and analysis
• Able to effectively manage multiple requests and priorities in a fast-paced, quick turnaround environment, while maintaining attention to detail and accuracy
• Strong communication, team, and customer service skill
• Proficiency in Microsoft Office suite, particularly Excel
• Preference is given to experience with Python

• Build and maintain QA automation frameworks
• Execution of test cases for both backend ETL and front-end applications
• Creation of test plans, test scenarios, and test cases for backend ETL and front-end applications
• Work closely with Project Managers / Scrum Masters, Architects, BI, and Data Engineering Developers in both Agile and Waterfall work settings to deliver solutions against a deadline that meet the requirements of the business and product stakeholders
• Adherence to the best practices and standards throughout the testing phases
• Create an execute reports that measure and monitor QA activities