Qlik Financial Reporting & BI Analyst

MileOne Autogroup•Baltimore, MD

3d•$95,000 - $125,000

About The Position

MileOne Autogroup is hiring a Qlik professional who understands dealership finances and can transform DMS and financial data into useful, actionable reporting. The Qlik Financial Reporting & BI Analyst will design, develop, and maintain Qlik applications, dashboards, and custom reports for the finance team and dealership leadership. A significant part of the role is bringing financial data from multiple dealership entities and systems into a consistent, standardized structure, including supporting a common chart of accounts across stores. The analyst works with accounting, audit, operations, and IT to understand business needs and deliver reporting that is accurate, reconciled, easy to use, and reliable.

Requirements

At least 3 years of hands-on Qlik development experience.
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.
A detail-oriented, analytical mindset focused on accuracy and reconciliation, including checking work against source data.

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 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, converting 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 to support 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.