Reporting and Analysis Specialist II

Welcome to Aventiv! Please watch this brief video to find out if this is the place you want to be!

Job Purpose: The Reporting and Analysis Specialist II is responsible for preparation and distribution of various internal reports to the operational groups and ensuring that all Operation Leaders have the appropriate data and tools to run their business units.

• Produce and maintain metrics, reporting and analyses for the Support and Technical Operations organizations
• Fulfill ad-hoc and recurring requests for reports and presentations for business needs, utilizing tools such as Tableau, SSRS, SQL, Excel, and Power Point
• Analyze and identify data trends in KPIs involving trouble tickets, assignments, call platforms and financial impacts
• Attend/facilitate meetings with users regarding requirements
• Recommend system and process enhancements related to team or business line procedures
• Perform other assigned duties as needed

• Knowledge to design, develop, QA and deploy Tableau Dashboards and SSRS Reports
• Ability to build and maintain SQL queries, procedures, and jobs
• Capable of using Microsoft Excel to analyze and manipulate data, such as formatting, pivot tables, formulas, etc.
• Ability to manage workload within a fast paced and dynamic workplace
• Ability to gather, manipulate and analyze data from multiple sources
• Strong analytical, problem solving and critical thinking skills
• Attention to detail and ability to accurately follow procedures
• Self-motivated and able to work with minimal direction
• Ability to work well with multiple different personality types
• Capability and willingness to learn new applications and tasks

• High school diploma or GED
• 3+ years of experience in SQL (queries, stored procedures, SSRS)
• 2+ years of experience creating in Tableau
• Strong skillset with Microsoft Office Products (Excel, PowerPoint, Word, etc.)

• Bachelor’s Degree preferred or equivalent work experience
• Experience working remotely
• Experience with SharePoint, Salesforce, and Microsoft Teams

• While performing the duties of this job, the employee is regularly required to stand, sit, talk, hear, and use hands and fingers to operate a computer, telephone, and a variety of office equipment.
• Occasionally, this position may need to reach, stoop, or kneel.

At Aventiv, our salary and benefits are designed to fit you as a whole person. We offer a salary range based on experience and qualifications to ensure your unique contributions are met with our most competitive offer.

Aventiv is proud to be an equal opportunity employer. All decisions regarding recruiting, hiring, promotion, assignment, training, termination and other terms and conditions of employment will be made without regard to race, color, national origin, biological sex, sexual orientation, gender identity, gender expression, gender presentation, religion, age, pregnancy, disability, work-related injury, veteran status, genetic information, marital status, or any other factor that the law protects from employment discrimination.

We do not discriminate based on genetic information in accordance with the Genetic Information Nondiscrimination Act.

This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.