Reporting Analyst I

Holman is a family-owned, global automotive services organization anchored by our deeply rooted core values and principles that have enabled us to continue Driving What’s Right throughout the last century. Our teams deliver the Holman Experience by treating our customers and each other as we would like to be treated, and creating positive, rewarding relationships all around.

The automotive markets Holman serves include fleet management and leasing; vehicle fabrication and upfitting; component manufacturing and productivity solutions; powertrain distribution and logistics services; commercial and personal insurance and risk management; and retail automotive sales as one of the largest privately owned dealership groups in the United States.

Position Description:

• Use practical statistical techniques and logical reasoning to correctly design metrics and integrate multi-source data.

• Apply an understanding of structured, semi-structured, and unstructured data sources and different schemas to access and troubleshoot varied data sources. 

• Perform 'data sleuthing' to find what data is available and determine if ideas brought forward by user groups are technically feasible. 

• Write SQL data queries and learn advancing techniques on the job

• Use Tableau Creator, Power BI, Business Objects Web Intelligence (Bi4), SQL, DAX, and other tools to produce advanced reports, interactive dashboards, calculations, and projections for other analysts, internal business users, and occasionally self-serve clients. 

• Apply an understanding of business operations and asset/fleet management to design interactive content that will be meaningful to the relevant user groups.

• Perform intense quality assurance checks on your own work, the work of your teammates, and occasionally for our information management team with an understanding that our work will often be used hundreds or even thousands of times by SAMs, AEs who deliver the findings to clients to make critical financial decisions; mistakes must be found before user release.  

• Identify, understand and document data issues in Holman databases when they arise in project work and work with our partners on the Information Management team to research, test, and resolve them. 

• Identify and collaborate with subject matter experts and resources for cross-department projects such as driver safety dashboards and Holman supply chain logistics automated reports.

• Lead and collaborate on several high-visibility projects simultaneously, including scoping deliverables, designing custom interactive solutions, tracking work effort and project metadata, and establishing a timeline for project completion.

• Use advanced analytic and quantitative tools, modeling techniques, and data mining procedures as needed, sometimes taking on new technology or skills as project challenges advance.

• Apply visual and user interface best practices, accessibility standards, Holman branding, and in-tool help guides to all dashboards and analyst and department reporting tools.

• Develop communication that clearly describes tools and methodologies to promote understanding among user groups.

• Partner with training lead, Holman U, and others on user training content for your projects.

• Seek opportunities for innovations and enhancements to existing processes and tools to benefit clients and critical stakeholders.

• Respond to urgent requests for internal data related to RFPs, HSO strategy projects, and other urgent business needs. 

• Perform all other duties and special projects as assigned

Education and Training:

• BA/BS degree required. Preferably in the field of Data Science, Statistics, Mathematics, Computer Science, or Business degrees with an analytics component

• Ability to write SQL queries

• ​Knowledge of relational databases, schemas, and types of data

• Proficient use of at least one of the following as a content creator (not just end-user): Tableau, PowerBI

• Advanced Excel proficiency or Microsoft certified expert. 

• Valid Passport - Some travel may be required in Canada or US (up to 5%).

Relevant Work Experience:

• 2-4 years’ experience creating dashboards and KPIs for business users

• 2-4 years’ experience applying an understanding of basic descriptive statistics and financial data standards to dashboards or analytical models

• Minimum 1 year experience discussing and documenting scope/technical requirements

• Minimum 1 year experience applying design and user interface best practices to interactive dashboards.

• Minimum 1 year non-school experience in performing data analysis, financial calculations, and projections

• Advanced skills in Microsoft Office (Excel, Word & PowerPoint)

• Advanced proficiency in Business Objects, creating reports for other users

• Strong proficiency in Tableau or PowerBI creating content from scratch using database connections

• 3+ years’ experience in a professional environment

• 2+ years’ experience working with real-world data 

• Familiarity with Automotive/Fleet data preferred

#LI-REMOTE

#LI-BS1

At Holman, we exist to provide rewarding careers and better lives for employees and their families. We hire, train, empower, and reward exceptional people. Our journey is guided by our desire to get it right every time and the acknowledgement that we have an opportunity to be better. To be better, we have to do better, and to do better we must know better. That’s why we are listening, open to learning new things – about ourselves and each other. We will never stop striving for improved diversity, equity, and inclusion because we are successful together when we feel trusted and supported. It’s The Holman Way.

At Holman, your total compensation goes beyond your paycheck. To position you for success and provide a rewarding career and better life for you and your family, Holman is proud to offer you the benefits you deserve; including protection against illness, disability, loss of work, or preparation for retirement. Below is a brief overview of the programs available to full-time employees (programs may vary by country or worker type):

• Health Insurance
• Vision Insurance
• Dental Insurance
• Life and Disability Insurance
• Flexible Spending and Health Savings Accounts
• Employee Assistance Program
• 401(k) plan with Company Match
• Paid Time Off (PTO)
• Paid Holidays, Bereavement, and Jury Duty
• Paid Pregnancy/Parental leave
• Paid Military Leave
• Tuition Reimbursement

Benefits:

Regular Full-Time

We offer excellent benefits including health, vision, dental, life and disability insurance, and 401(k) with company match. Our time off benefits include Paid Time Off (PTO), paid holidays, bereavement, and jury duty. In addition, we offer paid pregnancy and parental leave, and supplemental paid military leave to eligible employees.

Click here for Washington State benefit information.

Temporary or Part-Time

In geographic areas with statutory paid sick leave, part-time and temporary employees will receive a paid sick leave benefit that meets the mandated requirements.

Click here for Washington State benefit information.

Pay:

We offer competitive wages that are commensurate with job-related skills, experience, relevant education or training, and geographic location, starting in the range of $72,950.00 - $103,955.00 USD annually for full time employees. The annual compensation range is comprised of base pay earnings.

Artificial Intelligence Statement

We recognize that applicants for positions at any organization may view AI tools for tasks such as drafting a resume or cover letter, provided the information is accurate and truthful. However, applicants should not use AI tools to:

• Answer interview questions on their behalf, or use AI tools in any way during the interview or other qualification process(es).

• Misrepresent or embellish qualifications, skills, or experience

• Create false or misleading representations of identity (e.g., deepfakes or altered images/videos)

Your application, whether an AI tool is used or not, should reflect your authentic abilities and experiences. Any use of AI that compromises honesty or integrity may result in disqualification from the process.

Equal Opportunity Employment and Accommodations:

Holman provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. 

If you are a person with a disability needing assistance with the application process, please contact [email protected]

This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.