
Senior Systems Analyst
Kaplan Test Prep
full-time
Posted on:
Location Type: Remote
Location: United States
Visit company websiteExplore more
Salary
💰 $64,819 - $162,047 per year
Job Level
Tech Stack
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