Kaplan Test Prep

Senior Systems Analyst

Kaplan Test Prep

full-time

Posted on:

Location Type: Remote

Location: United States

Visit company website

Explore more

AI Apply
Apply

Salary

💰 $64,819 - $162,047 per year

Job Level

About the role

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

Requirements

  • 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
Benefits
  • 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
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
SQLSQL scriptsSQL stored proceduresSQL viewsSQL triggersSQL functionsdata extract scriptsperformance tuningapplication documentationbusiness analysis
Soft Skills
communication skillsproblem-solvingcollaborationdocumentationstakeholder engagement
Certifications
Bachelor’s DegreeMaster’s Degree