BI & Back Office Applications Specialist

Ontario /
Digital – Digital /
Temporary Full-Time
/ Hybrid
TRADER Corporation is a trusted Canadian leader in online media, dealer and lender services. The company is comprised of, AutoSync and Dealertrack Canada. ( 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 to learn more..

The BI and Office Application Specialist role provides technical expertise to IT Senior Manager for Customer and Billing, Project Managers and BI Director throughout the lifecycle of BI and Back office projects and will be responsible for overseeing the development and maintenance of a common development methodology and processes (standardize on tools such as JIRA), including BI data warehouse, Billing and invoicing (AVUS), Salesforce (CRM), Great Plains (GP) etc., that will be used across multiple back office platforms.
Responsible for consulting on specifications with impacts to BI and Back office applications.  This will also be the case for BI or Back office led projects.  Responsible for assessment and estimations of effort and timeline estimates for review by the Architect BI and Back office, Sr. Manager Customer and Billing and Project Managers
Responsible for establishing the technical feasibility of design proposals produced by IT Senior Manager (Customer and Billing), BI Director and/or external consultants by reviewing the technology required to deliver such designs.

Responsible to outline the detailed application level architecture and design for review and approval by the Enterprise Architect team.  Responsible for liaising with the architect team to ensure architectural integrity and consistency between systems and business processes thereby ensuring a scalable, high performing environment.

Key Areas of Responsibility
· Lead the definition, design and implementation of common methodology and processes for BI and Back office applications.  This can include testing methodology, refresh frequency and methodology for sandbox and non-production environments to enable accurate regression testing, using tools like JIRA for ticketing and workflow between development teams.

·Lead solution designs and fully document architecture proposals and high-level design documents for approval by the Architect team as per Trader governance policies and standards.  Help design coding standards along with the Architect team and ensure consistent adoption by developers in BI and Back Office.
·Ensure architectural consistency and coherence between systems and business processes through systems analysis & design, modeling, integration planning, technology and component selection.  Conduct configuration and code reviews mentoring and coaching the team’s internal resources or providing objective feedback to consultants and development partners to ensure proper execution of projects.
·Support the technology to be used in Trader BI and Back office Project, and BAU activities, managing a clear technology roadmap to ensure platforms stay current and in line with market force skills.
·Provide assistance to the IT Senior Manager, Project Managers and BI Director in the estimation process for effort required for business deliverables and provide input into the development of Business Cases.
Required Skills:

·      Ability to interface with technical experts in Online and Mobile platforms
·      Ability to work with managers and other business stakeholders in Marketing Intelligence, Sales and Finance teams
·      Must be able to analyze and translate data for non-technical audience
Required Experience:
·      University Degree or equivalent in Computer Science related subject
·      8+ years of experience in software industry; strong knowledge of database design, and data warehouse technologies
·      Strong skills in troubleshooting and designing software systems to support back office applications (e.g. Billing, Finance, CRM, etc.)
·      Hand on experience in C#, .Net, .NET API and legacy platforms
·      Knowledge of object-oriented design principles and ability to design software systems at an abstract/conceptual level as well as at a detailed level
·      Experience in coding T-SQL, complex stored procedures, functions, and views (We are looking for somebody that will assist with development across the entire Microsoft SQL stack)
·      Strong knowledge of SQL Server Database Adminstration, and relational database concepts
·      Experience in fine-tuning procedures, indexes for performance improvement
·      Project Management experience would be an asset
·      Good written & spoken English communication skills
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
-In addition to in-house training, we provide an annual lifestyle allowance of $1500 so you can grow your skills.
-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