Analytics Engineer II

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, including business analysts, stakeholders, and end-users, to gather, refine, and translate business requirements into robust technical solutions. Serve as a bridge between technical and non-technical stakeholders to ensure alignment and clarity.
• 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, cleanse, and transform data, developing and maintaining sophisticated data models. Manage complex data integrations, including configuring data source connections, handling intricate data structures, and performing advanced data transformations.
• Independently design, develop, and optimize visually compelling and interactive Power BI reports and dashboards. Leverage advanced Power BI features such as bookmarks, drill-through navigation, and custom themes to enhance user experience.
• Perform advanced data analysis using DAX to create calculated measures, solve complex business challenges, and support in-depth financial, statistical, or performance analyses.
• Implement and enforce data governance practices, including role-level security, data access controls, and documentation of data lineage. Ensure compliance with data security, privacy, and regulatory standards throughout the development lifecycle.
• Troubleshoot and resolve Power BI-related issues, ensuring high data accuracy, integrity, and visualization quality. Optimize report and dashboard performance by improving data queries, data model design, and rendering speed.
• Utilize source control systems within Power BI projects to maintain version control and foster effective collaboration with other developers.
• 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.

Relevant Work Experience:

• 3-5 years of experience working with relational databases and star schema design, including advanced SQL query development, optimization, and the use of Common Table Expressions (CTEs), window functions, and PySpark/Spark SQL for data extraction and transformation.
• 3-5 years of experience using Power BI for creating sophisticated dashboards, reports, and data models, with expertise in writing advanced DAX calculations, optimizing Power Query for complex transformations, and implementing row-level security and contextual filtering within reports. Demonstrated ability to independently design and create interactive and visually compelling reports and dashboards using Power BI.
• 3-5 years of experience developing and maintaining complex data models, including establishing relationships, hierarchies, and calculated columns in Power BI. Manage data integration tasks, including data source connections and data transformation processes.
• 3-5 years of experience Handling complex data transformation and ETL processes, including handling data from multiple sources and dealing with complex data structures.
• 2-4 years of experience in project management using Azure DevOps, with a proven ability to manage workflows, timelines, scoping, documentation, and cross-functional collaboration independently.
• 1-2 years of experience using version control systems (Git) and integrated development environments (IDEs) such as Visual Studio Code, with experience managing code repositories, conducting code reviews, and applying version control best practices.

Relevant Work Experience:

• 3-5 years of experience working with relational databases and star schema design, including advanced SQL query development, optimization, and the use of Common Table Expressions (CTEs), window functions, and PySpark/Spark SQL for data extraction and transformation.
• 3-5 years of experience using Power BI for creating sophisticated dashboards, reports, and data models, with expertise in writing advanced DAX calculations, optimizing Power Query for complex transformations, and implementing row-level security and contextual filtering within reports. Demonstrated ability to independently design and create interactive and visually compelling reports and dashboards using Power BI.
• 3-5 years of experience developing and maintaining complex data models, including establishing relationships, hierarchies, and calculated columns in Power BI. Manage data integration tasks, including data source connections and data transformation processes.
• 3-5 years of experience Handling complex data transformation and ETL processes, including handling data from multiple sources and dealing with complex data structures.
• 2-4 years of experience in project management using Azure DevOps, with a proven ability to manage workflows, timelines, scoping, documentation, and cross-functional collaboration independently.
• 1-2 years of experience using version control systems (Git) and integrated development environments (IDEs) such as Visual Studio Code, with experience managing code repositories, conducting code reviews, and applying version control best practices.

#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:

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

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.