Automotive Qlik Financial Reporting & BI Analyst

MileOne Autogroup•Baltimore, MD

About The Position

MileOne Autogroup is seeking a Qlik professional with automotive dealership experience to turn dealership management system (DMS) and financial data into useful reporting. The analyst will design, develop, and maintain Qlik applications, dashboards, and custom reports for the finance team and dealership leadership. The role includes combining financial data from multiple dealership entities and systems into a consistent structure and supporting a common chart of accounts across stores. The analyst will work with accounting, audit, operations, and IT to deliver accurate, reconciled, accessible, and reliable reporting. The position is onsite preferred, with remote candidates also considered. The listed salary range is $95,000–$125,000. MileOne describes employee benefits and programs including health and financial benefits, training and mentoring, an Employee Purchase Program, the MileOne Support Fund, the NextMile Scholarship Program, and an Employee Assistance Program.

Requirements

At least 3 years of hands-on Qlik development experience.
Automotive dealership experience is required.
Experience in automotive retail, ideally 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.
Detail-oriented and analytical, with a strong focus on accuracy and reconciliation.

Nice To Haves

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

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 mappings among DMS account structures, store-level charts of accounts, a standardized group chart of accounts, and OEM financial statement lines.
Create custom reports for finance, audit, and store management, and turn recurring requests into self-service reporting tools where possible.
Reconcile report outputs to the general ledger and source systems to ensure accuracy and consistency.
Document data sources, mapping logic, and report definitions for ongoing maintenance and audit requirements.
Partner with IT and system vendors on data extracts, refresh schedules, and access controls.
Train users and support effective adoption and use of Qlik across the organization.