Automotive Qlik Financial Reporting & BI Analyst

MileOne Autogroup

Baltimore (MD)

Hybrid

USD 95,000 - 125,000

Full time

6 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Health benefits (Employee Advantage)
Employee Purchase Program
MileOne Support Fund
NextMile Scholarship Program
Employee Assistance Program

Job summary

MileOne Autogroup is seeking a Qlik BI Analyst to design, develop, and maintain Qlik Sense dashboards that translate DMS and financial data into actionable reporting for finance and leadership.

You will standardize charts of accounts across stores, map data from various DMS sources, and collaborate with IT to ensure accuracy, security, and adoption across the organization.

Qualifications

  • 3+ years of hands-on Qlik development experience.
  • Automotive Dealership experience REQUIRED.
  • 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.

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

Skills

Qlik Sense development
SQL
Excel
Data mapping

Tools

Qlik Sense
CDK
Reynolds & Reynolds
Dealertrack
Tekion

Job description

Job Description** Automotive Dealership expereince REQUIRED**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.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.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.** Automotive Dealership expereince REQUIRED**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.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.MOAGCC_950 Atlantic HoldingSalary Range$95,000 - $125,000MileOne Corporate OfficePost Internally and ExternallyZip Code21204
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Automotive Qlik Financial Reporting & BI Analyst
Automotive Qlik Financial Reporting & BI Analyst

Griffith Auto Group • Baltimore (MD)

Hybrid
USD 95,000 - 125,000
Health benefits
Training and mentoring
Employee Purchase Program
+3
Automotive Qlik BI & Financial Reporting Analyst
Automotive Qlik BI & Financial Reporting Analyst

Griffith Auto Group • Baltimore (MD)

Hybrid
USD 95,000 - 125,000
Health benefits
Training and mentoring
Employee Purchase Program
+3
Associate HR Business Partner
Associate HR Business Partner

Mileone • Baltimore (MD)

On-site
USD 65,000 - 80,000
Medical coverage
Mental health programs
Career growth programs
+1
Onsite Internal IT Systems and Security Engineer
Onsite Internal IT Systems and Security Engineer

MileOne Autogroup • Baltimore (MD)

On-site
USD 85,000 - 125,000
Health benefits
Training and mentoring
Employee Purchase Program
+1
Luxury Automotive Finance Manager-Herb Gordon/ MileOne Luxury Division
Luxury Automotive Finance Manager-Herb Gordon/ MileOne Luxury Division

Mileone • Washington

On-site
USD 150,000 - 200,000
Automotive Finance / F&I Manager - BMW
Automotive Finance / F&I Manager - BMW

Mileone • Creve Coeur (MO)

On-site
USD 60,000 - 100,000
401(k)
401(k) matching
Dental insurance
+12
Senior Data Analyst
Senior Data Analyst

automotiveMastermind Inc. • New York (NY)

Hybrid
USD 115,000 - 125,000
Health and wellness benefits
Retirement savings plan
Hybrid work model
Senior Data Analyst
Senior Data Analyst

Mobility Global Inc. • New York (NY)

Hybrid
USD 115,000 - 125,000
Health benefits
Retirement plan with company match
Incentive opportunities
Automotive Warranty Administrator
Automotive Warranty Administrator

Mileone • Baltimore (MD)

On-site
USD 50,000 - 85,000
Health benefits
Training and mentoring
Employee purchase program
+1
Automotive Finance / F&I Manager - BMW Creve Coeur
Automotive Finance / F&I Manager - BMW Creve Coeur

Missouri Automotive Ventures LLC • Creve Coeur (MO)

On-site
USD 70,000 - 100,000
Health benefits
Financial benefits
Training & mentoring
+2