Business Intelligence (BI) Analyst F&I Administrator
Location: Austin Texas Department: Business Intelligence / Operations
Job Summary: We are seeking a detailoriented and businesssavvy Business Intelligence (BI) Analyst to join our team within an F&I Administrator organization. In this role you will support performance analysis reporting and datadriven decisionmaking across our dealer network internal teams and external partners. Youll help improve visibility into product performance dealership activity and profitability through intuitive dashboards data models and insightful analytics. Key Responsibilities: - Build and maintain dashboards reports and KPIs related to F&I product sales cancellations claims chargebacks and retention.
- Manage and support the companys CRM and automation engine ZOHO which provides pipeline reporting and process management tools.
- Capture dealership performance across multiple F&I programs (VSC GAP maintenance etc.).
- Support the Operations Sales and Dealer Development teams with data that improves service and revenue growth.
- Translate business questions into data requirements and build scalable solutions using BI tools.
- Build and maintain ETL processes to move data from various source systems into a data warehouse or reporting environment.
- Write SQL queries to pull and validate data from core administration systems and CRMs.
- Support compliance auditing and regulatory reporting with accurate timely data.
- Work closely with crossfunctional teams including IT Finance Claims and Sales Enablement.
Required Qualifications:
- Bachelors degree in Business Analytics Finance or a related field or commensurate experience.
- Proficiency in SQL Excel and at least one BI platform (Power BI Tableau or Looker).
- Experience working with relational databases and large datasets.
- Familiarity with F&I administration systems or dealerfacing platforms is a strong plus.
- Strong business acumen with a focus on data accuracy and clarity.
Preferred Qualifications:
- 2 years of experience in BI data analysis or reporting preferably in insurance finance or automotive.
- Previous experience in an F&I Administrator thirdparty warranty provider or dealership environment.
- Understanding of F&I products lifecycle analytics and financial reserve tracking.
- Experience connecting data from CRMs admin platforms DMS systems or claims processing tools.
- Experience with ETL tools (e.g. Informatica SSIS Talend or cloudbased solutions) and best practices.
- Knowledge of data governance and compliance reporting.
Soft Skills:
- Strong attention to detail and a commitment to data integrity.
- Excellent communication skills; able to explain complex data to nontechnical audiences.
- Proactive curious and adaptable to a fastmoving environment.
- Strong organizational skills and ability to manage multiple projects simultaneously.
| Required Experience:
IC