Systems Analyst - Intermediate (Hybrid)- Pittsburgh, PA

Socket.dev; Pittsburgh (Allegheny County); Hybrid; USD 70,000 - 110,000; Full time

Job summary

UPMC Health Plan is seeking an experienced Systems Analyst, Intermediate for a hybrid role. The candidate will analyze business and technical needs, develop and enhance reporting solutions, and partner with stakeholders to deliver effective data-driven outcomes.

Strong skills in Power BI, SQL, Power Platform (Power Apps), SSIS, Snowflake, Tableau, and advanced Excel are essential. The role requires hands-on problem solving, building dashboards, and driving process improvements while leveraging

Qualifications

• Must have a strong background in business intelligence reporting and analytics.
• Experience with Tableau and advanced Excel is required.
• Proven ability to develop and optimize dashboards and reports.

Responsibilities

• Analyze business and technical needs to design reporting solutions.
• Document system builds and maintain up-to-date documentation.
• Develop dashboards and reports leveraging Microsoft technologies.
• Coordinate with stakeholders to deliver effective data solutions.
• Support SDLC processes and project initiatives.
• Provide end-user training and assist with user adoption.

Skills

Problem solving

Data analysis

Communication

Tools

Power BI

SQL

Power Platform

Power Apps

SSIS

Snowflake

Tableau

Excel

Job description

UPMC Health Plan is seeking an experienced Systems Analyst, Intermediate to join our team in a hybrid role, working Monday through Friday during standard daylight hours. The ideal candidate will have a strong background in Power BI, SQL, Microsoft Power Platform (including Power Apps), SSIS, Snowflake, and query languages, along with experience using Tableau and advanced Excel.

This position will be responsible for analyzing business and technical needs, developing and enhancing reporting solutions and applications, initiating and supporting technology projects, and partnering with stakeholders to deliver effective solutions. The successful candidate will be a hands-on problem solver who can build programs and dashboards, work with data, identify opportunities for process improvement, and effectively leverage Microsoft technologies to meet business needs.

Responsibilities

• Complete documentation/flow charting of system builds and maintain team's existing documentation independently.
• Responsible for validating current documentation.
• Extract and document customer/business requirements and needs for use by enterprise architecture and engineering teams (network, system, and software).
• Second and Third Level Support (Including Maintenance Activities).
• Independently triage and resolve level 1 and level 2 support issues.
• Escalate level 3 support issues accordingly.
• Project ManagementCreate and contributes to project tasks and milestones.
• Update all project management and time tracking tools accordingly.
• Ability to take full ownership of a project.
• SDLC (System Development Life Cycle)c.
• Have an intermediate understanding of the application development life cycle.
• Ability to apply those principles to day-to-day work.
• Data Confidentiality/Security.
• Maintain confidentiality of sensitive information at all times.
• Data Quality Maintain data quality at all times.
• Vendor Relationships Interact with vendors (technical issues, project initiatives) under the direction of more experienced team members as necessary.
• Assist with issue escalation where applicable.
• Report Writing/AnalysisWrite, analyze and make modifications to reports either independently for basic requests or under the direction of more experienced team members for more complex requests.
• End User TrainingCreate and review existing training documentation.
• Facilitate high-level user training sessions independently.
• Process Improvement.
• Create and update processes.
• Ability to contribute to process improvement efforts.
• Application Upgrades and ImplementationReview and validate functionality of application upgrades and implementations.
• Report back on any problems.
• Identify new functionality and/or hardware requirements as assigned.
• Ability to create test plans.
• System IntegrationComplete assigned tasks related to system integration.
• Validate testing.
• Ability to modify existing test plans.
• Responsible for demonstrating appropriate, clear, concise, and effective written and oral communications in all interactions to build relationships and accomplish day to day work and projects.
• Successfully completes projects, tasks, and initiatives by embracing a team-first approach.
• Works in collaboration with team and offers feedback, where appropriate, to complete individual and group efforts.
• Shows the ability to adjust and be flexible to change by adapting approach when necessary.
• Mentors less experienced staff.
• Responsible for continuous self-study, trainings, partnering with more senior members of team, and/or seeking out opportunities to broaden scope to stay up to date with industry and organizational trends.
• Seeks feedback from senior team members for development and effectively incorporates feedback into work and behaviors.
• Performs in accordance with system-wide competencies/behaviors.
• Performs other duties as assigned.

• Typically has 2+ years experience with modern technology and application support through education or practical experience.
• Highly driven and self-motivated to meet expectations.
• Ability to work independently and in a team based environment.
• Demonstrates thorough understanding of information technology fundamental tools and concepts (SDLC) of one of the information technology professional disciplines and applies that understanding to make independent practical contributions to IT work within a UPMC department or function.
• Completes on-going training on-the-job, through courses, self-study, certifications and/or advanced degrees to maintain and enhance technical and business capabilities.
• Additionally, this position may be required to maintain a stand by status as part of a rotation within the team.
• This requires 24 hours per day, 7 days per week availability during the stand by period. T
• The frequency varies based upon the number of colleagues in the rotation.

Must be legally authorized to work in the United States, without requiring, now or in the future, sponsorship for employment visa status. UPMC does not participate in STEM OPT.

Licensure, Certifications, and Clearances

UPMC is an Equal Opportunity Employer/Disability/Veteran