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 …