Salary : $76,107.20 – $140,961.60 Annually
Location : Louisville, KY
Job Type: Full-Time
Job Number: 23-127
Division: Information Technology Division
Department: IT LOJIC
Opening Date: 07/18/2023
Closing Date: 8/10/2023 11:59 PM Eastern
Pay Grade: 20/22
Work days & hours: Monday-Friday day shift
Job Summary
This position will be filled as an Application Programmer Analyst II/III based on candidate qualifications. Salary ranges are as follows:
Application Programmer Analyst II $76,107.20-$118,976.00
Application Programmer Analyst III $88,816.00-$140,961.60
Application Programmer Analyst II
Performs design, coding, testing, implementation, maintenance, support and training of client/server/GUI, web-based, and mobile applications. Applies expertise in programming procedures to complex programs. Develops and supports secure applications, troubleshoots issues and performs root cause analysis to identify defects in applications and interfaces. Recommends the redesign of programs and applications to maintain currency and applications security from a cybersecurity perspective. Participates in and/or leads requirement gathering sessions with business and technical groups. Researches and proposes solutions for application defects, enhancements, security, disaster recovery (DR), and new mid-sized products. Creates/updates required functional and technical documentation. Develops client/server, web-based and mobile applications and interface solutions in accordance with departmental coding and security standards. Conducts unit and integration testing for all developed/modified interfaces and applications. Generates technical designs according to documented business needs. Performs and participates in design and code application security reviews. Provides ongoing maintenance support for integrated third-party applications and Enterprise Resource Planning (ERP) systems. Develops and alters database table designs following proper normalization and referential integrity. Serves as Subject Matter Expert in two or more business domains. Performs the role of Project Manager for small to mid-size projects. Coordinates and/or communicates with other organizations for joint efforts. Mentors junior team members and develops, teaches and helps enforce proper coding and security standards and methodologies. Prepares and delivers application presentations to management and end-users.
Application Programmer Analyst III
Performs design, coding, testing, implementation, maintenance, support and training of client/server/GUI and web-based and mobile applications. Applies expertise in programming procedures to complex programs. Recommends the redesign of programs to maintain currency and applications security from a cybersecurity perspective. Troubleshoots and performs root cause analysis of identified systems, applications and security defects. Leads requirement gathering sessions with business and technical groups. Researches and proposes solutions for code defects, security breaches, disaster recovery (DR), enhancements, and new products. Creates/updates required functional and technical documentation. Develops client/server, web-based and mobile applications, and interface solutions in accordance with departmental coding and security standards. Conducts unit and integration testing for all developed/modified interfaces and applications. Generates technical designs according to documented business needs and participates in design reviews. Performs and participates in design, code and application security reviews. Provides ongoing maintenance support for integrated third-party applications and Enterprise Resource Planning (ERP) systems. Designs and implements database schemas following proper normalization and referential integrity. Serves as Subject Matter Expert in two or more business domains. Performs the role of Project Manager or serves as IT representative on company and intra-organizational projects. Coordinates and/or communicates with other organizations for joint efforts. Provides system architecture guidance and team mentorship. Develops, teaches and helps enforce proper coding and security standards and methodologies. Plans, schedules and directs in-house developed and/or 3rd party system implementations. Prepares and delivers application presentations to management and end-users.
Essential Job Functions
Application Programmer Analyst II
Researches and gathers data about existing methodology, applications security, problem areas, desired features and enhancements and new system objectives. Designs, develops and tests applications, interfaces and database solutions. Customizes packaged software to increase application effectiveness and maintain security. Provides technical support, troubleshooting and problem resolution for production system operations, maintenance, interfaces and applications security, including on-call availability. Provides on-going maintenance support for specifically assigned systems including, but not limited to, upgrading to new releases and installation of patches and maintaining appropriate security. Plans, schedules and provides operational procedures and directs system implementation. Gathers and analyzes requirements producing functional and technical specifications and application security. Investigates and analyzes feasibility of program requirements and develops programming specifications. Assists in the development of requests for proposals. Evaluates, tests, implements, maintains, supports and trains end-users for procured software packages. Works on various project teams as IT representative or project leader as needed. Responsible for coordinating and monitoring the work of external consultants. Applies judgment in devising program logic and selecting and adapting standard programming and security procedures. Participates in training, seminars and professional meetings to improve technical skills and develop further knowledge and keep current with modern application development techniques. Creates and maintains all required document artifacts (functional, technical and user). Participates in MSD Project Management process and Change Management Process. Coordinates with business and external groups for project and IT related efforts. Mentors junior team members.
Application Programmer Analyst III
Researches and gathers data about existing methodology, applications security, problem areas, desired features and enhancements and new system objectives. Designs, develops and tests applications, interfaces and database solutions. Customizes packaged software to increase application effectiveness and maintain security. Provides technical support, troubleshooting and problem resolution for production system operations, maintenance, interfaces, applications security, and DR, including on-call availability. Provides on-going maintenance support for specifically assigned systems including, but not limited to, upgrading to new releases and installation of patches and maintaining appropriate security. Plans, schedules and provides operational procedures and directs system implementation. Gathers and analyzes requirements producing functional and technical specifications and application security. Investigates and analyzes feasibility of program and platform requirements and develops programming specifications. Assists in the development of requests for proposals. Evaluates, tests, implements, maintains, supports and trains end-users for procured software packages. Works on various project teams as IT representative or project leader as needed. Responsible for coordinating and monitoring the work of external consultants. Applies judgment in devising program logic and selecting and adapting standard programming and security procedures. Participates in training, seminars and professional meetings to improve technical skills and develop further knowledge and keep current with modern application development techniques. Creates and maintains all required document artifacts (functional, technical and user). Leads and participates in MSD Project Management process and Change Management Process. Functions as an IT representative with business and external groups. Mentors junior team members.
Knowledge, Skills and Abilities Necessary to the Work
Application Programmer Analyst II
Knowledge of relational databases (Oracle, SQLServer); knowledge of network environment; knowledge of SharePoint, Oracle and/or SAP ECC and/or SAP S/4HANA; skill in integrating applications with relational databases (Oracle, SQLServer); skill with application security and secure application development techniques; skill in Object Oriented development and languages such as VB.NET, C#, ASP.NET, JavaScript, Visual Studio.Net, .NET framework, etc.; skill in SAP Business Warehouse, Business Objects and Crystal Reports; skill in PL/SQL; skill in GIS/ESRI software and web services; skill in Web Development (HTML/5, CSS, JavaScript & 3rd Party JS libraries); skill in operating a PC and associated Windows environment software (e.g. Microsoft Office Suite); skill in oral and written communication; ability to utilize E-signature verification e.g. DocuSign; ability to utilize Razor/Blazor techniques, Angular, Classic ASP., Python, Java, MS Power Platform (PowerBi, Power Apps, Powershell, power automate, etc.); ability to develop, document and administer applications development life cycle; ability to design, deploy and administer resilient, fault-tolerant applications that are recoverable from systems disasters and hard failures; ability to design, deploy and administer responsive, device agnostic web applications; ability to perform feasibility studies and programming analysis; ability to train end-users; ability to adapt to changing work environment; ability to exercise judgment and discretion; ability to work in a team environment; ability to resolve problems; ability to maintain confidential information; ability to work under heavy surges in workload and deadline pressure.
Application Programmer Analyst III
Knowledge of relational databases (Oracle, SQLServer); knowledge of network environment; knowledge of SharePoint, Oracle and/or SAP ECC and/or SAP S/4HANA; skill in developing, documenting and administering applications development life cycle; skill in integrating applications with relational databases (Oracle, SQLServer); skill with application security and secure application development techniques; skill in designing, deploying and administering resilient, fault-tolerant applications that are recoverable from systems disasters and hard failures; skill in Object Oriented development and languages such as VB.NET, C#, ASP.NET, JavaScript, Visual Studio.Net, .NET framework, etc.; skill in SAP Business Warehouse, Business Objects and Crystal Reports; skill in PL/SQL; skill in GIS/ESRI software and web services; skill in designing, deploying and administering responsive, device agnostic web applications; skill in Web Development (HTML/5, CSS, JavaScript & 3rd Party JS libraries); skill in utilizing Razor/Blazor techniques, Angular, Classic ASP, Python, Java, MS Power Platform (PowerBi, Power Apps, Powershell, power automate, etc.); skill in operating a PC and associated Windows environment software (e.g. Microsoft Office Suite); skill in oral and written communication; ability to utilize E-signature verification, e.g. DocuSign; ability to architect software solutions utilizing purchased and in-house developed applications; ability to perform feasibility studies and programming analysis; ability to train end-users; ability to apply application security from a cybersecurity perspective; ability utilize Mobile Development, Web APIs with ASP.NET Core in latest .NET environment, RESTful API Development, .Net MVC environment, and web services; ability to utilize source code repository/version control; ability utilize application DR; ability to adapt to a changing work environment; ability to exercise independent thinking, judgment and discretion; ability to work in a team environment; ability to resolve complex problems; ability to maintain confidential information; ability to work under heavy surges in workload and deadline pressure.
Minimum Requirements
Application Programmer Analyst II
Bachelor Degree in Computer Science or a related field; four or more years of related experience; an equivalent combination of education and experience may be substituted. Must possess a valid driver’s license. Must have safe work and driving habits.
Application Programmer Analyst III
Bachelor Degree in Computer Science or a related field; ten or more years of related experience; an equivalent combination of education and experience may be substituted. Must possess a valid driver’s license. Must have safe work and driving habits.
EXEMPT
The following is a brief description of the major benefits that are provided to you as an Exempt employee of MSD. You will receive more detailed information on these benefits as they become effective. Please contact MSD’s Benefits Dept. at 540-6217 if you have any questions on any of the areas summarized below:
Group Health Care Plans:
Hospital/Surgical
MSD offers its employees and their dependents a health care plan that provides a wide variety of benefit coverage, including hospital, surgical, physicians, and prescription drugs. The company and employee share in the cost of this coverage. Coverage is effective 60 days after date of hire.
Dental Benefits
MSD’s dental program offers coverage for a range of dental services, including diagnostic, preventive care, and orthodontic benefits for children. The company and employee share in the cost of this coverage. Coverage is effective 60 days after date of hire.
Group Disability/Life Insurance Benefits:
Salary Continuation
From the first day of your employment, this plan provides you 100% of your salary for up to six (6) months of continuous absence due to a single illness or injury. Coverage is effective from the first day of employment.
Long-Term Disability
MSD offers a LTD plan which provides a replacement income of 66 2/3% of your insured pre-disability earnings in the event of an illness or injury that keeps a plan participant from work for more than six months. Coverage is effective from the first day of employment.
VOYA Personal Accident Plan
Benefits are payable for a covered employee’s or covered dependent’s injury caused by a covered accident that occurs on or off the job. Premiums are the responsibility of the employee and are payroll deducted. Coverage is effective 60 days after date of hire.
VOYA Critical Illness Plan
Benefits are payable for diagnosis of specified covered critical illnesses for the employee and dependents enrolled on the plan. Premiums are the responsibility of the employee and are payroll deducted. Coverage is effective 60 days after date of hire.
Basic/Supplemental Life Insurance
Basic Life & AD&D insurance is provided at no cost to the employees. The life amount is one times your base annual salary to a maximum of $300,000. Additional life insurance coverage, including dependent life is offered with the employee paying the premium cost. Coverage is effective 60 days after date of hire.
Retirement: County Employees Retirement System (CERS) – also referred to as Kentucky Public Pensions Authority
All employees participate in the CERS after one year of service. This one-year service requirement is waived in the event you have previously participated in CERS or one of the other Kentucky Public Pensions Authority (KPPA) programs. The plan is funded by joint contributions made by MSD and the employee. Plan members are required to contribute 6% of his/her gross salary through payroll deductions and MSD is required to contribute at an actuarially determined rate. Both MSD and employee contributions are set by the legislature and are subject to change. Vesting is achieved after 5 years of participation.
Employee savings plans (401(k)) and 457
MSD makes it easy for employees to plan for their retirement by offering a savings program that allows employees to accumulate savings through individual before-tax payroll contributions. MSD does not contribute any matching funds to either of the above plans. MSD’s financial involvement is assisting in the administration of both plans. Employees are eligible to participate in this plan from the first day of employment.
Mission Square Retirement (formerly ICMA-RC) and Kentucky Deferred Comp IRAs
Mission Square Retirement and the Kentucky Public Employees Deferred Compensation Authority both offer Traditional and Roth IRAs to MSD employees through individual payroll contributions. The Traditional IRA allows you to defer taxes on your earnings until they are withdrawn. Roth contributions and earnings are tax free if withdrawn after five years and after age 59 ½ or for a qualified purpose. Employees are eligible to participate in this plan from the first day of employment.
Paid Time Away From Work:
Holidays
An annual schedule of MSD’s eleven (11) paid holidays is posted each January. (Refer to Policies and Benefits Manual for complete listing.) Employees who are employed as of January 1 will also receive one (1) floating holiday for that year. Employees are eligible for holiday pay from the first day of employment.
Vacation
Vacation hours are accrued proportionately on a weekly basis beginning with the employee’s date of hire. Accrued vacation hours are available to the employee as they are accrued. Employees may request vacation time in accordance with current guidelines. The maximum amount of accrued vacation is 320 hours.
Other Benefits:
Flexible Spending Accounts (FSAs)
MSD offers two flexible spending accounts that allow employees to pay for certain dependent day care and health care expenses with pre-tax earnings. The dependent day care account may be used to pay for child care providers, day care facilities and certain other expenses related to the care of an employee’s dependent children while he or she is at work. It may also be used to pay for care provided to an individual with a physical or mental handicap who is the employee’s dependent, regardless of age. The health care account may be used to pay for IRS-allowable medical, dental, or vision expenses that are not covered by a health insurance policy. Employees are eligible to participate in this plan 60 days after date of hire.
Health Savings Account (HSA)
MSD offers a health savings account to coincide with the medical High Deductible Plan (HDHP). The account allows employees to pay for certain health care expenses not covered by the insurance policies. The HSA may be used to pay for IRS-allowable medical, dental, or vision expenses that are not covered by a health insurance policy. Employees are eligible to participate in this plan 60 days after date of hire.
Family Medical Leave Act (FMLA)
The Family and Medical Leave Act of 1993 (FMLA) entitles qualified employees up to twelve (12) weeks of unpaid leave per 12-month rolling period for the birth or adoption of a child, placement of a child for foster care, to care for a spouse or an immediate family member with a serious health problem or a serious health condition of the employee. The full text version of MSD’s Family and Medical Leave is available in the Employee Policy Manual.
Paid Parental Leave (PPL)
Paid Parental Leave of absence is offered to non-probationary, full time and part time employees who meet FMLA eligibility guidelines. The purpose of PPL is to enable MSD employees to care for and bond with a newborn or a newly adopted or newly placed child. This policy runs concurrently with Family and Medical Leave Act (FMLA) leave, as applicable.
Workers’ Compensation
MSD insures all employees for Workers’ Compensation in the event of a compensable injury. The administration of Workers’ Compensation benefits will be in accordance with the Kentucky Revised Statutes. Coverage is effective from the first day of employment.
Wellness Program – “Exercising Wellness”
MSD continues to expand its workplace wellness initiatives by providing employees with tools and incentives that will improve their health, help reduce medical cost and boost worker productivity. Initiatives such as free use of on-site fitness centers, wellness seminars, health-risk screenings at the annual health fair and a disease management program offered through the group medical plan, are just a few of the incentives available to MSD employees.
Travel Insurance
MSD provides travel insurance for employees in the amount of $150,000 per person or $500,000 per accident.
Private Parking
Each employee is provided free parking for their private vehicle. However, the employee is responsible for insuring against damage or theft.
Service Recognition
MSD shall recognize the length of time an employee has served MSD by awarding the employee a gift after each five (5) year period of service and at the time of retirement with ten (10) or twenty (20) years of service. This award will appear on the employee’s paycheck and is subject to tax withholdings.
Tuition Assistance
MSD shall reimburse employees for successful completion of approved classes/programs up to a maximum of $5,250 per fiscal year for education expenses related to tuition, books and fees (subject to the availability of funds). Current reimbursement is: 100% for an A, 85% for a B, and 70% for a C. Full-time and part-time employees who have successfully completed their probationary period (at the time the course begins) are eligible to participate in this program.
Employee Assistance
MSD offers a confidential counseling and referral service through an outside agency for employees and their families. This program also sponsors seminars on a variety of topics. This service is available to employees from the first day of employment.
01
What is your highest level of education completed?
- No H.S. diploma or GED
- High School Diploma or GED
- Some college, no degree
- Associate Degree
- Bachelor Degree
- Master’s Degree
- Other Graduate Degree
02
Do you have a valid driver’s license?
- Yes
- No
03
How many years of related experience do you have relevant to this position?
- None
- Less than 3 years
- 3 years to less than 5 years
- 5 years to less than 9 years
- 9 years or more
04
Have you supported large-scale, enterprise web application development for at least 4 years?
- Yes
- No
05
Do you have experience with developing applications with Javascript and HTML5?
- Yes
- No
06
Do you have experience deploying and maintaining ArcGIS Enterprise web applications?
- Yes
- No
07
Do you have knowledge of full SDLC and Agile development methodologies, application development life cycle, testing, performance tuning, and debugging?
- Yes
- No
Required Question