Qlik Financial Reporting & BI Analyst
- Baltimore, United States
- $95K – $125K /yr
- Mid Level
- 3+ years
- Posted
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
