Business Data Analyst

Job Description

LRS Consulting Services is seeking a Business Analyst - Power BI for a contract opportunity with our client in Bedford, TX. We are looking for an experienced Business Analyst with expertise in Power BI report and dashboard development to support reporting and analytics initiatives in an auto finance environment.

This is a hands-on contract role requiring an individual who can quickly understand business processes and data, perform meaningful analysis, and independently develop effective Power BI reporting solutions.

The ideal candidate combines strong Power BI and analytical capabilities with practical auto finance knowledge. Experience analyzing vehicle remarketing, lease maturities, maturity billing and collections, lease extensions, vehicle returns, and disposition activity within an auto captive, bank, or auto finance company would be particularly valuable.

The individual should be comfortable working independently with business stakeholders, understanding the underlying business question, analyzing the appropriate data, and delivering accurate and useful reporting solutions within a defined contract period.

Key Responsibilities:

• Design, develop, and enhance Power BI reports, dashboards, and management scorecards.
• Work with business stakeholders to understand reporting and analytical requirements.
• Analyze financial and operational data and translate findings into actionable business insights.
• Develop and maintain Power BI data models, DAX calculations, Power Query transformations, and visualizations.
• Query and validate data using SQL and other available data sources.
• Improve and automate existing Excel or manually produced reports.
• Document reporting logic, business definitions, and data requirements.

Prior auto finance remarketing & end-of-lease experience is highly desired, particularly experience working for an automotive captive finance company, bank, independent auto finance company, or vehicle remarketing organization including familiarity with:

• End-of-lease and vehicle maturity processes
• Vehicle grounding, disposition and sales performance
• Auction, vendor, and channel performance
• Maturity receivables and collections
• Auction performance and Inventory aging / days-to-sale
• Residual values and vehicle valuations
• Loss severity and net recovery analysis

Qualifications

• 3+ years of Business Analysis, Data Analysis, Financial Analysis, or Business Intelligence experience.
• Demonstrated experience developing professional Power BI dashboards and reports.
• Strong working knowledge of Power BI, DAX, Power Query, and data modeling.
• Working knowledge of SQL and relational databases.
• Advanced Microsoft Excel skills.
• Strong analytical and problem-solving abilities.
• Ability to work independently and become productive quickly in a contract environment.

Preferred Technical Environment

• Microsoft Power BI / Power BI Service
• Microsoft SQL Server
• Microsoft Excel
• Relational databases and data warehouses
• AWS or other cloud-based data environments

The base range for this contract position is $65.00 - $75.00 per hour, depending on experience. The range displayed on each job posting reflects the minimum and maximum target for new hires of this position across all US locations. Within the range, individual pay is determined by work location and additional factors, including job-related skills, experience, and relevant education or training.

LRS is an equal opportunity employer. Applicants for employment will receive consideration without unlawful discrimination based on race, color, religion, creed, national origin, sex, age, disability, marital status, gender identity, domestic partner status, sexual orientation, genetic information, citizenship, status or protected veteran status.

In some cases, LRS Consulting uses generative artificial intelligence ("AI") in support of our hiring processes. LRS takes steps to ensure the use of AI does not result in discrimination based on protected class(es). AI may be used in the hiring process solely in support of the assessment of candidate qualifications. All decisions in the hiring process are made by LRS employees. If AI will be used in the hiring process for the position for which you are applying, you will be notified and will have the opportunity to opt out. Please contact [email protected] with any questions.