jobapplier

Qlik Financial Reporting & BI Analyst

Mileone

Skills

Required

  • Qlik development
  • dealership accounting data
  • DMS
  • CDK
  • Reynolds &
  • Reynolds / Dealertrack / Tekion
  • financial statements
  • F&I

Preferred

  • Qlik
  • financial statement formats
  • composite reporting
  • Python
  • Power BI
  • BI/ETL
  • DMS account structures

MileOne Autogroup is hiring a Qlik professional who understands how dealerships make money and knows how to turn DMS and financial data into meaningful, actionable reporting that people across the organization actually use.

Responsibilities

  • The 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.
  • 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.

Requirements

  • 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.
  • 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

  • Familiarity with OEM financial statement formats and composite reporting.
  • Experience with Python, Power BI, or other BI/ETL tools.
  • Accounting or finance background.

Benefits

  • $95,000–$125,000 Our 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.

Work environment

Onsite preferred; remote candidates will also be considered.

MileOne Autogroup is an equal opportunity employer, and we maintain a drug-free work environment. By applying for this job, you agree to receive email communication, as well as telephone and/or SMS text communications using an autodialer or otherwise, at the number you have provided. Message and data rates may apply; text STOP to opt out after receiving text communications. Certain positions require the use of mobile-based authentication to access MileOne systems, applications, or information. Employees in these positions must be able to meet MileOne's applicable technology and information security requirements, including access to a compatible mobile device and the use of MileOne-approved authentication or security applications. MOAG CC_950 Atlantic Holding Salary Range $95,000 - $125,000 MileOne Corporate Office Post Internally and Externally Zip Code 21204