Reporting and Analysis Specialist II

Aventiv Technologies; Plano (TX); On-site; USD 46,232 - 52,706; Full time

Benefits offered by this job

Health Insurance

401(k)

Disability

Life Insurance

Paid Time Off

Voluntary Benefits

Job summary

A technology company is seeking a Reporting and Analysis Specialist II in Texas. This role involves producing metrics, analyzing KPIs, and providing support to operational leaders. Candidates should have strong SQL and Tableau skills, with at least 3 years of related experience. The position offers competitive hourly pay and various benefits including health insurance and paid time off.

Qualifications

• 3+ years of experience in SQL (queries, stored procedures, SSRS).
• 2+ years of experience creating in Tableau.
• Strong skill set with Microsoft Office Products (Excel, PowerPoint, Word, etc.).

Responsibilities

• Produce and maintain metrics, reporting and analyses for operations.
• Analyze data trends in KPIs involving trouble tickets and financial impacts.
• Attend meetings with users regarding requirements.

Skills

SQL

Tableau

Microsoft Excel

Analytical skills

Problem-solving skills

Attention to detail

Education

High school diploma or GED

Bachelor's Degree preferred

Tools

Tableau

SQL Server Reporting Services (SSRS)

Microsoft Office

Job description

Join to apply for the Reporting and Analysis Specialist II role at Aventiv Technologies.

Aventiv Technologies – Where your future awaits.

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 recurring requests for reports and presentations for business needs, utilizing tools such as Tableau, SSRS, SQL, Excel, and PowerPoint
• 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 related duties as assigned or required

Knowledge, Skills, and Abilities

• 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 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 skill set 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

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