Senior Manager - Data Engineering

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. Visit tradercorporation.com to learn more..

Summary of Job:

The Senior Manager – Data Engineering for DealerTrack role is a conduit between the Data and Analytics team and the business product teams, sales teams and technical teams. This individual will be required to become very knowledgeable of the business needs and translate those needs to technical solutions in the context of data, BI and analytics. This individual will build a highly productive and successful team. Provide team leadership, team motivation, decision making and conflict resolution when needed. Manage tasks and delegation of tasks to team members. Create and present content to a variety of audiences, this can include but not limited to, executives, senior management, management, and staff.

Key Areas of Responsibility

Intake (request tickets): Manage, track, full fill all incoming requests (Kanban board)

- Conduct daily stand-up meetings to review, clarify, assign and update request tickets.

- Work with business to get clarity on the request and translate to a technical solution.

- Create and update tickets as needed. - Ensure all communications are tracked through tickets.

Business Opportunities: Work with the business product and sales teams to create new products and revenue streams as it related to data, BI, reporting and analytics.

- Meet with business to gather requirements. This may include reaching out to other business units.

- Putting together a proposal that includes but not limited to; complexity impact, time to deliver, financial impact, process creation/change impact, people impact, etc.

Architecture and Data Modelling: Working with Enterprise Architecture, provide consultation and delivery of larger initiatives.

- Architecture; architect, re-architect, design and solution. When needed, delegate to staff to deliver.

- Data Modelling; working with business to define requirements and deliverables, solutioning changes to databases, tables, data lake, etc.

- Create and update documentation, diagrams, process, procedures, etc.

- Provide Quality Assurance (QA) on delivered components.

Team Management: Build and lead a successful and productive team.

- Provide leadership and decisions to team.

- Task delegation, time management, career development of team.

- Team building, team meetings, and conflict resolution.

Reporting: Manage and maintain reporting capability for both external use and internal use. 

-Assist in preparation of requests from management around all sales operational metrics to deliver clear and concise reporting on specific areas of each business unit.

- QA all deliverables.

- Ensure all reports are being produced as schedule.

- Troubleshoot and resolve reporting issues.

Job Requirements: Please indicate if required (R), preferred (P) or asset (A)

· Post-secondary education in related field and/or 10+ years relevant work experience (R)

· Min. 5 years’ experience in a management/team lead role (R). · Advanced knowledge and use of Microsoft SQL, SSRS, SSIS (R) · Good understanding of workload management, schedulers, scalability and distributed platform architectures (R)

· Experience with high-volume, transaction processing software applications (R)

· Experience with Power BI and other Analytical Tools (R)

· Knowledge of Snowflake and MicroStrategy (P)

· 3+ years developing and supporting applications leveraging the Cloud technology stack (AWS, Azure, GCP) (P)

· 3+ of experience with data integration/ETL tools such as Databricks, DataStage or alternatives (P)

· Experience on handling data processing, delivering distributed and highly scalable application (P)

· Experience with building solutions in Cloud based environment (Azure, GCP experience preferred) (P)

· Experience with large scale domain or enterprise solution analysis development, selection and implementation (P)

· Experience on following tools: SQL, Scala, Python, Spark, Kafka, and other related languages (A)

Required Soft Skills and Competencies

· Leadership (R)

· Decision making (R)

· Excellent written and oral communication skills (R)

· Excellent organizational skills, marked ability to prioritize and multi-task (R)

· Team building and motivation (R)

· Delegation of tasks (R)

· Confidentiality and professionalism (R)

· Presentation skills (P)

What’s in it for you…

-We understand that there is life at work and life outside of work. Here are a few benefits we all benefit from that support us to be our creative best.

Fitness and wellness

-We provide discounts to nation-wide gyms, onsite gyms (when we’re in the office), an Employee and Family Assistance Program, as well as a virtual wellness program.

Benefits from Day 1

-Gym discounts

-Local in-office free gyms

-Employee and Family Assistance program

-Weekly virtual wellness events

-Conferences & training budget

-Regular internal training programs

Financial planning

-Let us help you invest in your future with 3% matching towards your pension and multiple forms of income protection.

Competitive salary

-Annual bonus structure

-3% CPP matching