Data Analyst

DataJobs; Pittsburgh (Allegheny County); Hybrid; USD 70,000 - 95,000; Full time

Job summary

The Center for Organ Recovery and Education (CORE) in Pittsburgh, PA is seeking a Data Analyst to build and validate reporting, support performance understanding, and translate KPI definitions into consistent, decision-ready outputs.

You will develop Power BI dashboards, partner with executives and program teams, and ensure data accuracy while balancing confidentiality and regulatory requirements in a hybrid work setting.

Qualifications

• Bachelor’s degree in data analytics, business analytics, statistics, data science, information systems, healthcare administration, business, or a related field, or an equivalent combination of education and relevant experience.
• At least 3 years of relevant experience in data analysis, performance reporting, business intelligence, decision support, or a related field.
• Proficiency developing dashboards and visualizations in Power BI or a comparable enterprise analytics platform; experience with DAX and governed semantic models is strongly preferred.
• Working proficiency in SQL for data querying, investigation, reconciliation, and validation.
• Advanced Excel skills and the ability to analyze, organize, and explain complex quantitative information.
• Experience gathering and documenting reporting requirements, translating KPI definitions into specifications, and supporting user acceptance testing and report validation.
• Strong written, verbal, facilitation, data-storytelling, and customer-service skills for communicating with technical and non-technical audiences.
• Strong attention to detail, sound judgment, organizational skills, and the ability to work independently while protecting confidential and sensitive information.

Responsibilities

• Develop and maintain Power BI reports, dashboards, scorecards, and visualizations using approved data sources and governed semantic models.
• Create report mock-ups and organize information for executive, operational, clinical, and functional audiences.
• Analyze trends, variances, patterns, anomalies, segments, and performance drivers to surface what is happening and why.
• Perform descriptive and diagnostic analysis, and predictive analysis when appropriate to guide further investigation or action.
• Partner with the Performance Team and stakeholders to document business questions, approved KPI definitions, formulas, targets, dimensions, filters, reporting frequency, security needs, source-system context, and acceptance criteria.
• Translate reporting needs into specifications for reporting and technical development.
• Reconcile report outputs to approved source information by testing calculations and filters, coordinating user acceptance testing, investigating discrepancies, and working with the Data and Analytics Engineer and data owners to resolve defects or clarify business rules.
• Develop user guidance, report descriptions, metric documentation, and training materials.
• Demonstrate reporting solutions, gather feedback, monitor usage and usability, and recommend improvements that increase adoption and decision value.
• Participate in data governance, project, performance, and departmental meetings.
• Complete assigned action items and maintain current knowledge of analytics methods, reporting tools, data privacy, and emerging capabilities, including responsible AI-assisted analytics.
• Promote the Mission, Vision, and Core Values of CORE and maintain confidentiality of all employee and donor/recipient information.
• Provide backup support for select administrative reporting activities during staff absences.
• Serve on organizational committees, workgroups, or task forces as assigned, and represent CORE in external professional associations, conferences, or user groups when assigned.

Skills

Power BI

SQL

Excel

DAX

Data analysis

Data storytelling

Communication

Problem solving

Independent work

Education

Bachelor's degree or equivalent

Data analytics related field

Tools

SSRS

Python

R

Cloud analytics

MS SQL Server

Job description

CORE operates in a mission-driven, regulated environment where governed data must become clear, reliable information leaders can act on. As a Data Analyst for CENTER FOR ORGAN RECOVERY AND EDUCA, you will build and validate reporting, support performance understanding, and help translate KPI definitions into consistent, decision-ready outputs. The work is based in Pittsburgh, PA with hybrid options subject to approval.

What You’ll Do

• Develop and maintain Power BI reports, dashboards, scorecards, and visualizations using approved data sources and governed semantic models.
• Create report mock-ups and organize information for executive, operational, clinical, and functional audiences.
• Analyze trends, variances, patterns, anomalies, segments, and performance drivers to surface what is happening and why.
• Perform descriptive and diagnostic analysis, and predictive analysis when appropriate to guide further investigation or action.
• Partner with the Performance Team and stakeholders to document business questions, approved KPI definitions, formulas, targets, dimensions, filters, reporting frequency, security needs, source-system context, and acceptance criteria.
• Translate reporting needs into specifications for reporting and technical development.
• Reconcile report outputs to approved source information by testing calculations and filters, coordinating user acceptance testing, investigating discrepancies, and working with the Data and Analytics Engineer and data owners to resolve defects or clarify business rules.
• Develop user guidance, report descriptions, metric documentation, and training materials.
• Demonstrate reporting solutions, gather feedback, monitor usage and usability, and recommend improvements that increase adoption and decision value.
• Participate in data governance, project, performance, and departmental meetings.
• Complete assigned action items and maintain current knowledge of analytics methods, reporting tools, data privacy, and emerging capabilities, including responsible AI-assisted analytics.
• Promote the Mission, Vision, and Core Values of CORE and maintain confidentiality of all employee and donor/recipient information.
• Provide backup support for select administrative reporting activities during staff absences.
• Serve on organizational committees, workgroups, or task forces as assigned, and represent CORE in external professional associations, conferences, or user groups when assigned.

Required Qualifications

• Bachelor’s degree in data analytics, business analytics, statistics, data science, information systems, healthcare administration, business, or a related field, or an equivalent combination of education and relevant experience.
• At least 3 years of relevant experience in data analysis, performance reporting, business intelligence, decision support, or a related field.
• Proficiency developing dashboards and visualizations in Power BI or a comparable enterprise analytics platform; experience with DAX and governed semantic models is strongly preferred.
• Working proficiency in SQL for data querying, investigation, reconciliation, and validation.
• Advanced Excel skills and the ability to analyze, organize, and explain complex quantitative information.
• Experience gathering and documenting reporting requirements, translating KPI definitions into specifications, and supporting user acceptance testing and report validation.
• Strong written, verbal, facilitation, data-storytelling, and customer-service skills for communicating with technical and non-technical audiences.
• Strong attention to detail, sound judgment, organizational skills, and the ability to work independently while protecting confidential and sensitive information.

Technologies

• Power BI, DAX, SQL, Excel, Microsoft SQL Server, SSRS, cloud analytics platforms, Python, R

Work Environment and Physical Requirements

• Work is primarily performed in the office environment in Pittsburgh, with remote or hybrid work subject to approval.
• Frequent use of a computer, keyboard, mouse, telephone, and video conferencing; prolonged periods of sitting and viewing screens.
• Ability to communicate effectively, review detailed information, and manage multiple priorities in a deadline-driven environment.
• Occasional movement within office or operational areas may be required for meetings, training, or project support.
• Occasional schedule flexibility may be required to support critical reporting, validation, or organizational needs.

Compliance and Role Considerations

• OSHA category I and II: employees who are exposed regularly or occasionally to bloodborne pathogens while performing assigned duties require bloodborne pathogen protection.

Preferred Experience and Education

• Experience in healthcare, organ procurement, transplantation, clinical operations, or another regulated and mission-critical environment.
• Experience with Microsoft SQL Server, SSRS, cloud analytics platforms, statistical tools, Python, or R.
• Experience with enterprise KPI programs, balanced scorecards, data governance, metric catalogs, reporting certification, or performance-improvement initiatives.
• Experience with forecasting, predictive analytics, or the responsible use of AI-assisted analytics tools.
• Relevant Microsoft Power BI or analytics certification.