Reporting and Analysis Specialist II

Aventiv•Plano, TX

11d•$34 - $38

About The Position

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.

Requirements

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

Nice To Haves

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

Responsibilities

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.