Systems Specialist

Health Care Service Corporation • Nashville, TN

1d

About The Position

At HCSC, our employees are the cornerstone of our business and the foundation to our success. We empower employees with curated development plans that foster growth and promote rewarding, fulfilling careers. Join HCSC and be part of a purpose-driven company that will invest in your professional development. Job Summary Position Overview: The job profile for this position is Systems Analysis Sr. Advisor. The System Analysis Sr. Advisor role has the following major components: • Works with business partners to develop complete and accurate business requirements • Creates comprehensive functional requirements • Develops complex SSRS reports – new and updates • Executes functional and regression testing of code changes for ongoing break fixes and enhancements • Assists in User Acceptance Testing of code changes for ongoing breaks fixes and enhancements • Reviews all existing processes and data and recommends / documents / implements improvements Key Responsibilities: System Analysis team members within the Quality Apps Support team are responsible for the following: • Participate in end-to-end user requirements discussions • Coordinate with business partners to be able to translate business process/workflows to technical process/workflow • Coordinate with developers on technical delivery • Suggest design for and test code changes • Design ways to improve systems, reducing costs and maximizing opportunities • Documentation of all calls, business requirements and team items • Scrum Master – assist with leading scrum, entering items into Jira and assisting with management of projects (this year we had 21) Required Experience / Qualifications: • 3+ years of intermediate to advanced T-SQL (complex JOINs, subqueries, stored procedures, indexes, temp tables and CTEs, query optimization is a MUST). MS SQL is a must. TD SQL is desired but not required. • 3+ years of functional testing and regression/negative testing • 3+ years of Intermediate to advanced SSRS (hands on dev experience with drilldowns, drillthroughs, dynamic groupings, document maps, single dataset for multiple controls etc etc) • 3+ years of intermediate SSIS (must be able to review / debug / suggest design for SSIS packages, must understand SSIS metadata rules, various SSIS properties, etc) • 5+ years of data analysis and mining • 5+ years of requirements gathering in Agile environments • Excellent written and verbal communication skills • Logical, detail-oriented team player who learns quickly and has the ability to handle multiple, competing priorities in a fast-paced environment Required Job Qualifications  Bachelor Degree and 5 years Information Technology OR Technical Certification and/or College Courses and 7 year Information Technology experience OR 9 years Information Technology experience. Knowledge of application configuration Knowledge of Big Data Analytics - HAVeN / HADOOP/ Autonomy / Vertica Knowledge of Cloud computing / SaaS / IaaS / PaaS technologies Knowledge of Integration Technologies - Tibco/Informatica/CAS Knowledge of Mobile technologies - Phonegap / iOS / Android / Java / HTML5 Knowledge of Scripting Languages - BASH / PERL / PYTHON / RUBY Service Oriented Architecture - SOAP / REST Web Technologies - HTML/CSS/Java/ASP.Net/PHP/Ruby/C# Rapid prototyping Requirements definition & management SDLC Methodology - Agile / Scrum / Iterative Development System Performance management Conceptual thinking Creative thinking Problem solving and analytical thinking Strong oral/written communication skills

Requirements

• 3+ years of intermediate to advanced T-SQL (complex JOINs, subqueries, stored procedures, indexes, temp tables and CTEs, query optimization is a MUST). MS SQL is a must. TD SQL is desired but not required.
• 3+ years of functional testing and regression/negative testing
• 3+ years of Intermediate to advanced SSRS (hands on dev experience with drilldowns, drillthroughs, dynamic groupings, document maps, single dataset for multiple controls etc etc)
• 3+ years of intermediate SSIS (must be able to review / debug / suggest design for SSIS packages, must understand SSIS metadata rules, various SSIS properties, etc)
• 5+ years of data analysis and mining
• 5+ years of requirements gathering in Agile environments
• Excellent written and verbal communication skills
• Logical, detail-oriented team player who learns quickly and has the ability to handle multiple, competing priorities in a fast-paced environment
• Bachelor Degree and 5 years Information Technology OR Technical Certification and/or College Courses and 7 year Information Technology experience OR 9 years Information Technology experience.
• Knowledge of application configuration
• Knowledge of Big Data Analytics - HAVeN / HADOOP/ Autonomy / Vertica
• Knowledge of Cloud computing / SaaS / IaaS / PaaS technologies
• Knowledge of Integration Technologies - Tibco/Informatica/CAS
• Knowledge of Mobile technologies - Phonegap / iOS / Android / Java / HTML5
• Knowledge of Scripting Languages - BASH / PERL / PYTHON / RUBY
• Service Oriented Architecture - SOAP / REST
• Web Technologies - HTML/CSS/Java/ASP.Net/PHP/Ruby/C#
• Rapid prototyping
• Requirements definition & management
• SDLC Methodology - Agile / Scrum / Iterative Development
• System Performance management
• Conceptual thinking
• Creative thinking
• Problem solving and analytical thinking
• Strong oral/written communication skills

Nice To Haves

• Bachelor’s Degree
• Medicare / Medicaid
• Medical and coding terminology
• SNP Model of Care
• Health Services / Medical Management / Population Health
• Scrum master experience
• Bachelor Degree in Computer Science or Information Technology related
• Ability to execute

Responsibilities

• Participate in end-to-end user requirements discussions
• Coordinate with business partners to be able to translate business process/workflows to technical process/workflow
• Coordinate with developers on technical delivery
• Suggest design for and test code changes
• Design ways to improve systems, reducing costs and maximizing opportunities
• Documentation of all calls, business requirements and team items
• Scrum Master – assist with leading scrum, entering items into Jira and assisting with management of projects (this year we had 21)
• Works with business partners to develop complete and accurate business requirements
• Creates comprehensive functional requirements
• Develops complex SSRS reports – new and updates
• Executes functional and regression testing of code changes for ongoing break fixes and enhancements
• Assists in User Acceptance Testing of code changes for ongoing breaks fixes and enhancements
• Reviews all existing processes and data and recommends / documents / implements improvements

Benefits

• At Health Care Service Corporation, you will be part of an organization committed to offering meaningful benefits to our employees to support their life outside of work.
• From health and wellness benefits, 401(k) savings plan, pension plan, paid time off, paid parental leave, disability insurance, supplemental life insurance, employee assistance program, paid holidays, tuition reimbursement, plus other incentives, we offer a robust total rewards package for employees.
• Learn more about our benefit offerings by visiting https://careers.hcsc.com/totalrewards.
• This role aligns with an annual incentive bonus plan subject to the terms and the conditions of the plan.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level