Analytics Engineer I

Holman Enterprises; New Jersey; Remote; USD 67,000 - 99,000; Full time

Job summary

An established industry player in automotive services is seeking a skilled Data Analyst to enhance data-driven decision-making. This role involves collaborating with cross-functional teams to gather requirements, analyze data from various sources, and create insightful dashboards using Power BI. You'll play a crucial part in ensuring data integrity and compliance while leveraging Azure DevOps for project management. If you're passionate about data analytics and eager to contribute to a collaborative team environment, this opportunity is perfect for you. Join us in driving innovation and excellence in the automotive sector!

Benefits

Health Insurance

Vision Insurance

Life and Disability Insurance

401(k) plan with Company Match

Paid Time Off (PTO)

Tuition Reimbursement

Qualifications

• Bachelor's degree required, preferably in Data Analytics or Business Analysis.
• Proficiency in SQL and data visualization principles is essential.

Responsibilities

• Collaborate with teams to gather and define business requirements.
• Design and maintain dashboards and reports in Power BI.

Skills

Data Analysis

SQL

DAX

Data Visualization

Problem Solving

Education

Bachelor's Degree in Data Analytics

Relevant Certifications

Tools

Power BI

Microsoft Office

Azure DevOps

Job description

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:

1. Collaborate with cross-functional teams, senior developers, and stakeholders to gather and define business requirements for technical projects.
2. Extract, integrate, and analyze data from diverse sources, such as databases, spreadsheets, and APIs, to support data-driven decision-making and analytics initiatives.
3. 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.
4. 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.
5. Write, debug, and optimize DAX formulas and calculations to enhance reporting capabilities and ensure analytical accuracy.
6. Ensure adherence to data security and compliance standards when designing dashboards and reports, applying best practices throughout the process.
7. 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.
8. Utilize source control within Power BI Projects to collaborate effectively with other engineers and maintain version control.
9. Leverage Azure DevOps for organizing, tracking, and managing User Stories and tasks within an Agile project management framework.
10. Stay informed on the latest Power BI features and industry trends to continuously improve reporting capabilities and technical proficiency.
11. 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.

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

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 [e-mail]

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.