The Reporting Analyst will be responsible for the development and maintenance of operational, financial and sales reporting across all segments of the Heavy Equipment line of business.  The position will create complex reports leveraging PowerBI and SSMS that will assist management in making business decisions based off clearly illustrated visual analytics.  This role will work closely with leadership across the Heavy Equipment line of business and IT support staff.

Primary Job Accountabilities/
Responsibilities

Reporting

Development and maintenance of reporting across various platformsImprove the Data Warehouse through data analysis and providing feedback to the DW ownersDocument and write user stories and requirements, participate in PI planning sessions on identified enhancements/fixesParticipate in brainstorming sessions in the development of new solutionsManage data through various reporting tools for data analysis to support various projectsManages and documents assigned projects and maintains current project list that includes status, milestones & deadlines, accessible to managerExecutes on multiple projects with varying deadlines; communicates status to manager regularlyas neededAssists with training junior level staff for specific tasks identified by managerPerform all other duties and participate in special projects assigned

Insurance Processing

Ability to understand complex insurance forms to allow accurate updating to the client’s database so clients can meet complicated regulatory obligations and to ensure the equipment has insurance coverage at all times.Identify and interpret terminology from complex insurance forms and determine action needed.Validate documents in accordance with established client procedures.Learn and process more than one client, if the opportunity is available.

Basic Qualifications Required - Experience, Skills, and Knowledge

Bachelor’s degree4+ years of overall professional experienceTravel Required: None

Preferred Experience, Skills, and Knowledge

4+ years of overall professional experienceStudents of IT, data analytics, business administration or relatedPrevious PowerBI experience (Required)SSMS SQL experience (Required)Power Query (Preferred)Power Pivot (Preferred)Strong analytical and problem-solving skillsStrong attention to detailAdvance proficiency in MS Office Applications including Excel, PowerPoint, Word, Outlook, SharePointAdvance understanding of database theory and experience working with databases is preferredSelf-driven with a desire to successfully take on new challenges and additional responsibilitiesCan work on multiple projects with varying deadlines and prioritizesAsks questions to clarify and seeks out informationUnderstands how to accurately produce reports, memorandums, and other communications needed for internal and external requests by following specifications in placeDemonstrates competent analytical skillsHas strong organizational skillsDemonstrates an effective balance between working through challenges independently and asking for guidance