Analytics Engineer 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.

Job Responsibilities:

• Collaborate with cross-functional teams, senior developers, and stakeholders to gather and define business requirements for technical projects.
• Extract, integrate, and analyze data from diverse sources, such as databases, spreadsheets, and APIs, to support data-driven decision-making and analytics initiatives.
• Partner with data engineering teams to acquire, clean, and transform data, ensuring optimal preparation for reporting and analytical purposes. Develop and maintain data models, including relationships and hierarchies, to enable efficient data visualization and analysis.
• Design, develop, and maintain interactive dashboards, KPIs, and paginated reports in Power BI, delivering actionable insights through optimized layouts, intuitive visualizations, and user-centric design elements.
• Write, debug, and optimize DAX formulas and calculations to enhance reporting capabilities and ensure analytical accuracy.
• Ensure adherence to data security and compliance standards when designing dashboards and reports, applying best practices throughout the process.
• Troubleshoot and resolve issues related to Power BI reports, ensuring data integrity and accurate visualizations. Help validate data against predefined business rules and ensure data quality.
• Utilize source control within Power BI Projects to collaborate effectively with other engineers and maintain version control.
• Leverage Azure DevOps for organizing, tracking, and managing User Stories and tasks within an Agile project management framework.
• Stay informed on the latest Power BI features and industry trends to continuously improve reporting capabilities and technical proficiency.
• Demonstrate self-motivation, creative problem-solving, and a proactive approach to addressing challenges and contributing to project and team success.

Education and/or Training:

• Bachelor's degree (BA/BS) required, preferably in a related field such as Data Analytics, Business Analysis, or a similar discipline. Relevant certifications or equivalent work experience with an analytics focus, particularly in Power BI or MS Fabric, is a plus.
• Basic knowledge of data analysis concepts and tools, including relational databases, star schema, SQL, and DAX, is essential.
• Proficiency in Microsoft Office, particularly Excel, with advanced skills in data manipulation and analysis.
• Proficiency in data visualization principles (e.g., charts, graphs, matrices, measures, and KPIs) with demonstrated experience in using Power BI or similar tools to transform data into actionable insights through effective reports and dashboards.
• Familiarity with project management concepts, ideally in Azure DevOps, including understanding of the product/engineering lifecycle, task and time management, Agile methodologies, and User Stories.

Relevant Work Experience:

• 1-3 years’ experience with relational databases and star schema design, with the ability to write and modify basic SQL queries for data extraction and analysis. Extracting data from various sources, such as databases, spreadsheets, or APIs.
• 1-3 years’ experience with data analytics tools such as Power BI, Tableau, or similar tools for creating reports, dashboards, and analytical models. Support the development of data models by creating or maintaining data relationships and hierarchies.
• 1-3 years’ experience in Power BI and/or advanced Excel techniques, including writing DAX measures, using Power Query for data transformation and cleaning, and designing data visualizations/dashboards in Power BI. Selecting appropriate visualizations for data presentation and formatting visuals for clarity and aesthetics.
• 1-2 years’ experience validating data against predefined business rules and ensure data quality, integrating data from multiple sources into Power BI, ensuring data consistency and accuracy.
• 1-2 years’ experience with project management and collaboration tools such as Azure DevOps, Jira, and Asana for tracking tasks, managing workflows, and supporting project timelines.
• 1-2 years’ experience with source control systems, preferably Git, and use of integrated development environments (IDEs) such as Visual Studio Code.

#LI-BS1

#LI-REMOTE

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:

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 HR@Holman.com

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.