Purpose:
UPMC Enterprises (UPMCE) is the innovation, commercialization, and venture capital arm of UPMC, a $24 billion health care provider and insurer based in Pittsburgh, PA. With a mission to create products and businesses that make life-changing medicine happen, UPMCE invests financial and intellectual capital into developing solutions that benefit the entire health care industry with two broad focus areas: Digital Solutions and Translational Sciences. We have a diverse portfolio, supporting both early and growth stage companies with the wealth of expertise from UPMC.
Please note that this position is in-office 3 days per week.
The Team
The Technology & Data Services team offers technical and business services for UPMCE portfolio companies, investments, and strategic partners creating innovative healthcare solutions to drive clinical and financial outcomes. We support all stages of a healthcare technology venture’s lifecycle with strategic, implementation, and operational services. The Data Analytics and Informatics Service within the Technology & Data Services team provides key data-driven insights for both Digital Solutions and Translational Sciences focus areas to address critical business questions supporting investment and product development life cycles.
The Role
The Intermediate Data Analyst is an independent contributor who owns moderate-complexity analytics workstreams from intake through delivery. This role partners with clinical, business, product, and technical stakeholders to clarify requirements, develop reusable queries and analytic workflows, and deliver dependable insights that support investment, product, and operational decisions. The Intermediate Data Analyst builds analytics-ready datasets, develops interactive dashboards with appropriate access controls, and contributes to data dictionaries, lineage documentation, and reproducibility practices. The role is expected to participate in requirements gathering — including customer and pre-sales activities where appropriate — automate repetitive analytic tasks, and present concise readouts that translate findings into clear, actionable recommendations for technical and non-technical audiences.
Responsibilities:
- Data Sourcing, Quality Assurance & Analytics Delivery
- Own moderate-complexity data extracts and build reusable SQL queries, notebooks, and analytic workflows aligned to team standards.
- Implement automated QA checks, reconcile anomalies with subject-matter experts, and surface root causes for data quality issues.
- Contribute to data dictionaries, source-to-target mappings, and lineage documentation that support discoverability and reuse.
- Segment populations and design comparison groups in collaboration with subject-matter experts to support sound interpretation of results.
- Apply appropriate descriptive statistics, confidence intervals, and exploratory techniques to characterize cohorts and surface meaningful patterns.
- Build feature datasets, usage and retention analyses, and funnels that quantify product behavior and outcomes.
- Map data to standard healthcare vocabularies (OMOP or equivalent) where required, and validate definitions with stakeholders.
- Parameterize notebooks, manage version control of analytic assets, and publish results to team standards for reproducibility.
- Reporting, Visualization & Stakeholder Engagement
- Develop interactive dashboards with filters, drill-throughs, and row-level security appropriate to the audience.
- Optimize SQL and DAX, implement usage telemetry and alerting, and version-control BI artifacts with documented data lineage.
- Draft analysis plans, visualize impact trends, and produce concise readouts with visuals, caveats, and recommendations.
- Participate in requirements gathering sessions — including customer pre-sales activities where appropriate — to clarify data questions and confirm definitions.
- Develop stakeholder empathy through active listening, facilitation, and crisp visual storytelling that tailors content to the audience.
- Reproducibility & Continuous Improvement
- Publish reproducible notebooks and pipelines with clear readmes, lineage metadata, and tagged datasets.
- Participate actively in peer reviews and refactors, contributing to playbooks, shared libraries, and reusable analytic components.
- Automate repetitive analytic tasks to reduce toil and increase the team’s delivery capacity.
- Run small, well-scoped experiments to evaluate new techniques or tools, measure their impact, and share results with the team.
- Stay current on analytics practices, tools, and healthcare data standards, and contribute to team learning through demos, brown-bags, and shared examples.
Education & Experience
- Bachelor’s Degree (e.g., mathematics, statistics, economics, finance, computer science, or related field) plus 2+ years of relevant data analytics experience; or Master’s Degree plus 1+ year of relevant analytics experience.
- Equivalent combinations of education and experience may be considered in lieu of the above requirements.
- Demonstrated experience independently owning analytics workstreams from intake through delivery in a production setting.
- Exposure to electronic medical record, payer, claims, clinical, or similarly complex healthcare datasets is strongly preferred.
Technical & Analytical Skills
- Strong proficiency in SQL, including joins, window functions, and query optimization for moderately complex datasets.
- Working proficiency in Python or R for data analysis, including building reusable, version-controlled analytic workflows.
- Experience developing interactive dashboards with row-level security in tools such as Power BI or Tableau.
- Working knowledge of descriptive statistics and basic inferential techniques (e.g., t-tests, chi-square, confidence intervals), with the judgment to interpret and communicate results responsibly.
Project Delivery & Communication
- Ability to plan small workstreams, manage dependencies across teams, and consistently hit committed milestones.
- Strong written and verbal communication skills, with the ability to translate findings for both technical and non-technical audiences.
- Facilitation skills and crisp visual storytelling that drive shared understanding and decisions in working sessions.
- Demonstrated learning mindset, attention to detail, and adaptability in evolving healthcare and technology environments.
Preferred
- 2+ years delivering analytics in production contexts, with evidence of increasing scope and independence.
- Experience contributing to data dictionaries, lineage documentation, and reproducibility practices.
- Familiarity with healthcare vocabularies, payer/provider data models, OMOP, or related clinical and operational data standards.
- Experience with Agile delivery methods, version control, reproducible notebooks, and automation of repetitive analytic work.
- Exposure to customer-facing or pre-sales analytics activities in healthcare or health technology settings.
Licensure, Certifications, and Clearances:
- Act 34
*Current licensure either in the state where the facility is located or, if the facility is in a state covered by the multistate Nursing Licensure Compact (NLC) agreement, a multistate license issued by a participating NLC state. Hires and current employees working on an out-of-state NLC license who later change their residency to the state where the facility is also located will have 60 days upon changing their residency to apply for licensure within that state.
UPMC is an Equal Opportunity Employer/Disability/Veteran