Job DescriptionThe Qlik Financial Reporting & BI Analyst will design, develop, and maintain Qlik applications, dashboards, and custom reports supporting the finance team and dealership leadership.
A significant part of this role involves bringing financial data from multiple dealership entities and systems into a consistent, standardized structure, including supporting a common chart of accounts across our stores. You'll work closely with accounting, audit, operations, and IT to understand business needs and deliver reporting that is accurate, reconciled, easy to use, and reliable.
Key Responsibilities:- Build, enhance, and maintain Qlik Sense dashboards and applications covering financial performance, departmental gross, inventory, and operational KPIs across all stores.
- Develop and maintain data mappings between DMS account structures, store-level charts of accounts, and a standardized group chart of accounts, including OEM financial statement line mappings.
- Create custom reports for finance, audit, and store management, turning recurring requests into self-service reporting tools whenever possible.
- Reconcile report outputs to the general ledger and source systems to ensure accuracy and consistency.
- Document data sources, mapping logic, and report definitions to support ongoing maintenance and audit requirements.
- Partner with IT and system vendors on data extracts, refresh schedules, and access controls.
- Train users and support the adoption and effective use of Qlik across the organization.
Qualifications & Experience:- 3+ years of hands-on Qlik development experience.
- Experience in automotive retail, ideally working with dealership accounting data and a DMS such as CDK, Reynolds & Reynolds, Dealertrack, or Tekion.
- Working knowledge of dealership financial statements and departmental structures, including new and used vehicles, F&I, service, parts, and body shop.
- Experience mapping charts of accounts or financial data across multiple entities or systems.
- Strong SQL skills and advanced Excel proficiency.
- Ability to translate business questions from non-technical users into clear, useful reporting solutions.
- A detail-oriented, analytical mindset with a strong focus on accuracy and reconciliation. You check your work against the source and care when the numbers don't tie.
Preferred Qualifications:
- Familiarity with OEM financial statement formats and composite reporting.
- Experience with Python, Power BI, or other BI/ETL tools.
- Accounting or finance background.
Work environment: Onsite preferred; remote candidates will also be considered.Compensation: $95,000-$125,000Our MileOne Employee Advantage:MileOne believes that taking care of our employees is the most important step in creating a positive workplace and a successful company. We offer a variety of exclusive benefits and programs designed to help our employees and their families succeed both at home and in the workplace.
MileOne Employee Advantage includes health and financial benefits, training and mentoring, an Employee Purchase Program, the MileOne Support Fund: By Employees, For Employees, the NextMile Scholarship Program, an Employee Assistance Program, and more.
MOAG
CC_950 Atlantic Holding
Salary Range
$95,000 - $125,000
MileOne Corporate Office
Post Internally and Externally
Zip Code21204
