Operations Data & Reporting Associate

Who We Are: Hyundai Capital Canada (HCCA) is the Canadian captive finance business for Hyundai Motor Group. We go to market under the service brands Hyundai Motor Finance, Kia Finance and Genesis Finance. Through a network of over 450 Hyundai and Kia dealerships and 30 Genesis distributors nationwide, we provide indirect vehicle financing and leasing solutions to consumers and commercial customers.

Employee Value Prop and Culture: Our employees contribute every day to a culture that is fast-paced, dynamic, energized, agile, and collaborative. From our employee programs to the unique design of our offices, we strive to create a connected, fun, positive, and rewarding workplace where employees feel appreciated, proud of their company, and deeply invested in HCCA’s success.

Global One Company: Many countries. One identity. Hyundai Capital has offices around the world, including South Korea, the United States, China, the United Kingdom, Germany, and Brazil. Our work environments follow consistent themes that represent our global values: simplicity, collaboration, symmetry, and elements of nature.

Position Details: This role will be responsible for delivering management reporting and analysis for the Operations department. As part of the reporting scope, you will prepare monthly reporting to headquarters and monitor key metrics across various Operational functions. You will proactively develop and manage dashboards by working closely with cross-functional teams to help them monitor performance easily. You will analyze and interpret large datasets and leverage visualization and data analysis to drive transformation and automation in the business. 

Duties and Responsibilities:

• Prepare monthly reporting requirements for HQ, which comprise of metrics for Credit, Funding, Customer Care, Collection, and back office operations.
• Develop and optimize various SQL and SAS codes of operation team to improve accuracy and clarity.
• Automate manual reporting to increase reporting efficiency when possible.
• Support the design and strengthening of operational reports and statistics.
• Design, develop, and deploy business analytics dashboards and operational reports using Tableau, Salesforce, or Excel to enable automated self-service productivity and performance reporting.
• Convert raw data into interactive, easy-to-understand dashboards and reports.
• Analyze large data sets using advanced statistical techniques and tools such as SAS, Rapid Miner, and task mining tool to uncover trends, automation opportunities, process improvements and insights.
• Assist with data quality assessment, data clean-up and data mapping from database tables to applications such as LOS, V8, CRM, and AWS.
• Assist Manager in UAT testing on automation projects such as RPA and eFunding or data projects.
• Perform all other duties as assigned.

• 2-3 years of experience in data analysis using SQL and Tableau. 

Education & Certification:

• Bachelor’s degree required in Computer Science, Business Analytics, Statistics or related field.

Knowledge, Skills & Abilities:

• Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
• Excellent verbal and written communication skills.
• Advanced SQL skills and Tableau is a must 
• Strong PC skills: Microsoft Word, Power Point, Excel.
• Experience with SAS is preferred.
• Ability to facilitate collaboration with diverse groups.
• Team oriented, but able to work independently and manage multiple tasks.
• Strong problem solving, analytical, organizational/planning skills.
• Experience with Python and Salesforce is an asset.
• Aptitude to learn business applications and to understand how that connects to the data.
• Willingness to work in a fast paced, frequently changing environment.

Hyundai Capital Canada Inc. is committed to acknowledge applications from people with disabilities. Accommodations are available on request for candidates taking part in all aspects of the selection process.

This posting is for an active, existing vacancy. Hyundai Capital Canada is currently hiring for this role and applications are being reviewed as part of a live recruitment process.