Reporting Analyst I

Holman

3d•$72,950 - $103,955•Remote

About The Position

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

Requirements

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%).
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

Nice To Haves

Familiarity with Automotive/Fleet data preferred

Responsibilities

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