Senior Data Reporting Analyst

Allegheny Clinic; Pennsylvania; Hybrid; USD 85,000 - 110,000; Full time

Job summary

Allegheny Clinic is seeking a data analytics professional to collect, analyze, and report on key performance indicators, dashboards, forecasting, and executive presentations to support operational excellence and decision-making.

The role collaborates with cross-functional teams to identify analytical needs, develop automated data processes, and deliver accurate, timely insights that drive business performance and strategic planning.

Qualifications

• 5 years of directly related work experience
• Bachelor's Degree in Math, Computer Science, Quantitative Business Analysis, or related field
• Strong SQL skills; Tableau; Dataiku; Google Cloud; Python

Responsibilities

• Collect source data from various departments and publish metrics dashboards and executive presentations.
• Design analyses, trending, forecasting reports using Excel or other technology.
• Identify, analyze, and interpret trends in complex data sets.
• Develop data collection systems and strategies that improve data quality.
• Present complex subjects to leadership in a clear, actionable way.

Skills

SQL skills

Tableau

Dataiku

Google Cloud

Python

Microsoft Office

end-user reporting

SDLC awareness

data-driven decisions

Education

Bachelor's degree in Math, CS, or quantitative field

Master's degree in IT/Math/Statistics/OR (preferred)

Tools

Tableau

Dataiku

Google Cloud

Python

Job description

JOB SUMMARY

CANDIDATE MUST BE US Citizen (due to contractual/access requirements)

This job drives and supports all activities related to collecting, analyzing, and reporting on key performance indicators including developing dashboards, scorecards, forecasting, trending, tracking results, and executive presentations for the purposes of supporting operational excellence, management intelligence for effective decision-making and overall tracking of business performance. This job consults with cross-functional groups and levels to identify data and analytical needs, conduct analyses, review analyses and findings with leadership, facilitate related process/data improvement efforts, and develop executive level presentations. This job may also prepare similar intelligence for customers.

ESSENTIAL RESPONSIBILITIES

On a regular basis and as needed, work with various departments to collect source data; design and build analyses/trending/forecasting reports using Excel or other technology; and publishes metrics dashboards and executive presentations. Identify, analyze, and interpret trends or patterns in complex data sets.

Develop processes, tools, and templates to enable efficient, accurate and standardized data analyses and related deliverables; leverage automation to greatest extent possible. Develop and implement data collection systems and other strategies that optimize statistical efficiency and data quality.

Ensure consistency and accuracy of information and reporting by identifying issues and fluctuations with core metrics/key performance indicators (KPIs), facilitate changes; research questions; participate and/or lead process and data improvement efforts.

Contribute to ensuring that all changes to reporting, processes, and procedures are reflected, appropriately documented and that consistency is maintained for team. Ensure the correct first time /quality review processes are utilized and that changes maintain data integrity control processes.

Maintain effective communication with internal organizations, external vendors/partners, and internal staff. Structure and present complex subjects in a meaningful and comprehensible manner.

Develop work plans to meet deadlines, accurately estimate completion dates, and communicate status.

Work closely with management to prioritize business and information needs.

Other duties as assigned or requested.

EDUCATION

Required

Bachelor's Degree in Math, Computer Science, Quantitative Business Analysis, or closely related field

Preferred

Master's Degree in Information Technology, Mathematics, Statistics, or Operations Research

EXPERIENCE

Required

5 years of directly related work experience

Preferred

• Strong SQL skills
• Tableau
• Dataiku
• Google Cloud
• Python

LICENSES/CERTIFICATIONS

Required

None

Preferred

None

SKILLS

• Proficient to master level with Microsoft Office products including Excel, Power Point, Word, and Access
• Basic understanding of SQL / querying capabilities
• Experience with end-user reporting tools
• Familiarity with the Software Development Lifecycle Process
• Strong written and verbal communication skills
• Strong analytical skills withthe ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
• Effective participation in team-based work
• Ability to find solutions and deliver results within a rapid, fast changing, entrepreneurial, technology-driven culture
• Capable of adjusting to changing priorities
• Ability to understand business needs to master new skills and technologies in a short period of time.
• Data driven decision maker can impact the bottom line and achieves goals with available resources and abilities
• Must have strong interpersonal skills and the ability to establish, develop and maintain cross-functional business relationships, as well as have excellent presentation and problem-solving skills
• Strong analytical skills
• Excellent Problem-solving capabilities
• Ability to investigate root causes and recommend solutions

PHYSICAL, MENTAL DEMANDS and WORKING CONDITIONS

Position Type

Office-based

Teaches / trains others regularly

Occasionally

Travel regularly from the office to various work sites or from site-to-site

Rarely

Works primarily out-of-the office selling products/services (sales employees)

Never

Physical work site required

Yes

Lifting: up to 10 pounds

Constantly

Lifting: 10 to 25 pounds

Occasionally

Lifting: 25 to 50 pounds

Rarely

Disclaimer: The job description has been designed to indicate the general nature and essential duties and responsibilities of work performed by employees within this job title. It may not contain a comprehensive inventory of all duties, responsibilities, and qualifications required of employees to do this job.

Compliance Requirement : This job adheres to the ethical and legal standards and behavioral expectations as set forth in the code of business conduct and company policies.