Senior Systems Analyst I

Job Title 

Senior Systems Analyst I

Job Description

For more than 80 years, Kaplan has been a trailblazer in education and professional advancement. We are a global company at the intersection of education and technology, focused on collaboration, innovation, and creativity to deliver a best-in-class educational experience and make Kaplan a great place to work.

The future of education is here and we are eager to work alongside those who want to make a positive impact and inspire change in the world around them.

The Senior Systems Analyst I is responsible for supporting, troubleshooting, planning, developing, implementing, and improving Kaplan’s business systems applications. He/she works with business stakeholders, subject matter experts, business analysts, tech operations teams, and vendor support teams to provide advanced software support, analysis, and development.  They also ensure systems are functioning at optimal performance and projects are successfully implemented.  Duties also include application administration, SQL coding, and application testing.

Key Job Responsibilities:

• Perform analysis and advanced support/troubleshooting for reported issues on business systems applications. 

• Write SQL scripts to fix complicated data issues in production systems. 

• Write and modify SQL stored procedures, views, triggers, and functions. 

• Write data extract scripts. 

• Perform performance tuning of long running SQL code, reports, or scripts. 

• Identify and document application defects and enhancements. 

• Test and validate resolutions of defects/enhancements and document test results. 

• Execute Business Requirement Documents(BRDs) and Functional Requirement Documents(FRDs) to implement new projects within the business systems applications. 

• Participate in testing of new software releases, system maintenance, and upgrades. 

• Support business user acceptance testing. 

• Work with business stakeholders and understand their needs to translate them into technical requirements and solutions. 

• Prepare code deployments through standardized change management processes. 

Minimum Qualifications:

• Bachelor’s/Master’s Degree in a relevant field (Computer Science, Engineering)

• 6+ years of experience

• Strong communication skills

• Understanding of Microsoft T-SQL and database principals

• Microsoft T-SQL

• Microsoft SQL Server Management Studio (SSMS)

• Microsoft SQL Profiler

• Ability to write operational and application documentation

Preferred Qualifications:

• Background in higher education

• Knowledge of Anthology Student or other SIS systems

• Knowledge of Brightspace or other LMS systems

• Experience with back office applications

• Microsoft SQL Server Integration Studio (SSIS)

• Microsoft SQL Server Reporting Services (SSRS)

• Crystal Reports development and maintenance.

• SSIS package development and maintenance.

Beyond base salary, our comprehensive total rewards package includes:

- Remote work provides a flexible work/life balance
- Comprehensive Retirement Package automatically enrolled in The Company Contribution Plan (8-10% annual company contribution based on tenure)
- Our Gift of Knowledge Program provides tuition assistance and substantial discounts for our employees and close family members
- Comprehensive health benefits new hire eligibility starts on day 1 of employment
- Generous Paid Time Off includes paid holidays, vacation, personal, sick paid time-off, plus one (1) volunteer day and one (1) diversity and inclusion day to participate and give back to our local communities

We are committed to providing a supportive and rewarding work environment where every employee can thrive. You can learn more about our full benefits package and total rewards philosophy here.

At Kaplan, we believe in attracting, rewarding, and retaining exceptional talent. Our compensation philosophy is designed to be competitive within the market, reflecting the value we place on the skills, experience, and contributions of our employees, while taking into account labor market trends and total rewards.

For full-time p