Job Description

Job Title: Systems Analyst-Technical Lead (Data Manager)
Job ID: 180000SY
Status: Full-Time
Regular/Temporary: Regular
Shift: Day Job
Department: HCMS0 - Data Warehouse
Location: 415 West 17th Street, Cheyenne WY 82001


HCMS Group LLC (Cheyenne, WY) is seeking a Senior Data Manager to be responsible for the setup and maintenance of HCMS client databases as well as processes to support data warehouse functions. Duties include programming, testing and debugging all data loading scripts as well as the implementation of online service product applications. Demonstrated technical competence with databases and database engines is required. Scripting and database knowledge should include Oracle Database platform, SQL Server, PL/SQL, VB Script or similar scripting languages


Under the general direction of the management team and Senior staff, the Systems Analyst - Specialist requires a high degree of experienced analytical and solid project management experience. This role requires the ability to perform and lead tasks such as: defining requirements, developing and/or maintaining computer applications/systems, and providing services to meet client IT and business needs within budget and targeted deadlines. Serves as the lead of complex technical projects overseeing the design, development, testing and installation of IT solutions within a client group. Serves as a mentor for other analysts.

  • Documentation - Complete detail-oriented documentation for new and complex processes. Responsible for quality and validity of documentation. Extract and document customer/business requirements and needs for use by enterprise architecture and engineering te
  • Second and Third Level Support (Including Maintenance Activities) - Independently triage and resolve Level 2 and Level 3 issues. Act as a mentor for associate-senior level staff in resolution of Level 2 and Level 3 issues. Manage complex support events. Pr
  • Project Management - Manage multiple, complex projects. Facilitate the full project management life cycle. Mentor team members on aspects of project management. Ability to prioritize projects and assign tasks to team members. Update all project manageme
  • SDLC (System Development Life Cycle) - Ability in defining how to use different System Development Life Cycles, ability to establish processes around SDLC's.
  • Data Confidentiality/Security - Maintain confidentiality of sensitive information at all times.
  • Data Quality - Maintain data quality at all times.
  • Vendor Relationships Interact with vendor (technical issues, project initiatives) independently, as necessary. Ability to act as the point person for issues escalation.
  • Report Writing/Analysis - Write and analyze complex reports. Make modifications to complex reports. Mentor less experienced team members. Communicate effective with business, act as business analyst. Ensure data governance is involved when necessary.
  • End User Training - Create training content. Manage onboarding programs for super users, as necessary. Facilitate training sessions as necessary. Ability to be responsible for training content.
  • Process Improvement - Manage process improvement. Provide framework for needed processes. Ability to own process improvement through successful implementation. Recognize opportunity for process improvement in existing work flows.
  • Application Upgrades and Implementation - Identify new functionality and/or hardware requirements. Creates test plans. Responsible for review and validation of functionality. Report back any problems. Create and/or manage cutover plans including downtim
  • System Integration - May be responsible for coordination of tasks and resources related to system integration, validation of testing and implementation.
  • Communication - 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.
  • Interactions with Others - 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 ad
  • Self-Development - Responsible for continuous self-study, trainings, partnering with management and more senior members of team, and/or seeking out opportunities to broaden scope to stay up to date with industry and organizational trends.
  • Data warehouse build

  • Loading, investigation, manipulation of data and reconciliation of data

  • Management and communication of ongoing data quality

  • Ability to load multiple data types into database environment (i.e. flat, XML, data exports)

  • Ability to create data extracts and exports

  • Ability to work thru large and complex data warehouse builds in an efficient manner with quality results

  • Analysis, design, test and development of data ETL processes

  • Query tuning and partnering with application developers to produce online reporting

  • Troubleshooting of complex queries to decrease execution runtimes

  • Implementation of complex quality checks across a variety of data metrics


  • Typically has 7+ years experience with modern technology and application support through education or practical experience. 
  • Highly driven and self-motivated to exceed expectations. 
  • Ability to work independently and in a team based environment. 
  • Effective in mentoring and leading less experienced team members. 
  • 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. 
Preferred Experience:
  • 3-5 years experience with SQL and relational databases

  • Degree in CS, CIS/MIS, Statistics, Mathematics or a similarly quantitative field

  • Excellent verbal and written communication skills

  • Consistent customer-service focus

  • 3-5 years (or more) experience with human capital, HR, and/or healthcare data (Medical, Pharmacy, and Workers’ Compensation data)

Salary Range: $37.47 to $60.83 / hour

Union Position: No

Apply Current Employee?


At UPMC, our shared goal is to create a cohesive, positive, experience for our employees, patients, health plan members, and community. If you too are driven by these values, you may be a great fit at UPMC!


UPMC provides a total rewards package that can help you achieve the goals you have for your career and your personal life. Whether you want to learn a new skill through a training course, reach personal health and wellness targets, become more involved in your community, or follow a career path that provides you with the right experience to be successful, UPMC can help you get to where you want to be.


Now more than ever, YOU can help us shape our communities and UPMC into a better place for everyone to work, study, play, and thrive.

Learn more about working here and check out our policies and recent updates.

UPMC Ranked #17 Best Places for Women & Diverse Managers in 2018

Talent Network