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.
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)