Apply on Employer Site

DealerOn · 1 month ago

Business Analytics & Insights Analyst

United States

Full-time

Remote

Mid Level

$78K/yr - $115K/yr

4+ years exp

DealerOn is an online marketing company providing website and agency services to automotive dealerships across North and South America. The Business Analytics & Insights Analyst will play a key role in supporting decision-making through data analysis, producing insights, and presenting findings to senior leadership.

Marketing

No H1B

Responsibilities

Conduct detailed analysis, cleaning and organizing large datasets, building ratio and trend analyses, and creating pivot-table benchmarks to assess industry performance and competitive positioning

Develop automated reports and analytical tools by designing dashboards, charts, and operational reporting workflows to enhance evaluation and decision-making

Conduct comprehensive market and company analyses by evaluating industry trends, competitive positioning, financial performance, and key operating metrics to increase customer retention and product offerings to install base

Implement "what-if" scenarios to demonstrate how variations in deliverables influence customer loyalty and guide strategic initiatives and decisions

Support strategic planning initiatives by analyzing business performance, evaluating market trends, and developing data-driven insights to guide long-term growth decisions, resource allocation, and organizational priorities

Perform data reconciliations by validating, matching, and troubleshooting discrepancies across multiple data sources using Excel functions (e.g., VLOOKUP/XLOOKUP, INDEX-MATCH, conditional formatting, and pivot tables) to ensure accuracy, consistency, and reliability of financial and operational datasets

Create efficiencies in reporting while leveraging business and financial systems to develop automated reporting

Work with leadership to identify actionable solutions based on financial data analysis and identified trends

Present analysis results, data models, and other projects to stakeholders

Recommend financial KPIs and targets that will generate meaningful insights for the business

Understand operational and financial business challenges and use advanced analytics capabilities to mine/query data, use statistical models, and recommend courses of action highlighting business impact

Qualification

FP&A conceptsFinancial modelingAdvanced ExcelSalesforce proficiencyAccounting conceptsBusiness intelligence toolsCommunication skillsPresentation skillsProject management

Required

Bachelor's degree in finance, accounting, economics, or statistics

4+ years of finance/accounting experience at a mid-sized company

3+ years of FP&A experience in corporate and/or GTM reporting

Advanced Excel and financial modelling skills

Proficiency in Salesforce (Einstein Analytics, Sales and Service Clouds, Reporting), Microsoft Office Suite (Excel, Visio, PowerPoint), HRIS systems, NetSuite

Excellent communication and presentation skills with ability to effectively influence and communicate cross-functionally with senior management

Proven ability to anticipate needs and provide viable solutions with minimal direction

Ability to juggle and prioritize simultaneous assignments

Ability to work independently, exercise discretion, and multi-task in a highly dynamic environment