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!

Aventiv Technologies – Where your future awaits - YouTube

**Associate Referral Reward Eligible**

 

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.

Essential Duties:

• Produce and maintain metrics, reporting and analyses for the Support and Technical Operations organizations
• Fulfill ad-hoc and reoccurring request for report and presentations for business needs, utilizing tools such as Tableau, SSRS, SQL, Excel, and PowerPoint
• Analyze and Identify data trends in KPI’s involving trouble tickets, assignments, call platforms and financial impacts
• Attend/Facilitate meetings with users regarding requirements
• Recommend system and process enhancement related to team or business line procedures
• Perform other assigned duties as needed
• Perform other related duties as assigned or required.

 

Knowledge, Skills, and Abilities:

• Knowledge to design, development, 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 manipulated data, such as formatting, pivot tables, formulas, etc.

• Ability to manage workload within a fast paced and dynamic workplace
• Ability to gather, manipulating 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 can work with minimal direction
• Ability to work well with multiple different personality types
• Capability and willingness to learn new applications and tasks

 

Minimum Qualifications:

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

 

Preferred Qualifications:

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

 

Physical Requirements:

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

 

Salary and Benefits:

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.

• $33.56 - $38.26/hr
• Health Insurance
• 401(k)
• Disability
• Life Insurance
• Paid Time Off
• Voluntary Benefits

Aventiv Privacy Policy:

www.aventiv.com/privacy

Equal Employment Policy:

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.

Equal Opportunity Employer
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.