Reporting Analyst

Role Overview

• 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 and the work of your teammates.
• Identify, understand and document data issues in Holman databases when they arise in project work.
• 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.
• Use advanced analytic and quantitative tools, modeling techniques, and data mining procedures as needed.
• Apply visual and user interface best practices, accessibility standards, Holman branding, and in-tool help guides to all dashboards and 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: 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
• Familiarity with Automotive/Fleet data preferred

Tech Stack

• SQL
• Tableau

Benefits

• 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