PowerShell and SQL Developer at Jet Support Services

Mountlake Terrace, Washington, United States

Jet Support Services Logo
Not SpecifiedCompensation
Junior (1 to 2 years), Mid-level (3 to 4 years)Experience Level
Full TimeJob Type
UnknownVisa
HealthcareIndustries

Requirements

  • Bachelor’s degree in Computer Science, Information Systems, OR equivalent experience in a related field
  • 4+ years of working experience with SQL (Transact-SQL), PowerShell and JavaScript
  • 4+ years of experience as a data engineer, data analyst, solution engineer, software developer, application developer, or similar role
  • 2+ years of experience with safe change management processes including end-to-end testing
  • The ability to independently work and maintain code in SQL, PowerShell and JavaScript
  • Solid understanding of data structures, database principles, and ETL/data pipeline development
  • Experience developing and maintaining custom applications and backend logic (e.g., stored procedures, automation tools, SQL databases)
  • Familiarity with Azure tools and services (e.g., Logic Apps, Azure Functions, Data Factory)
  • Strong analytical and proactive problem-solving skills, especially in relation to mapping and understanding business processes

Responsibilities

  • Write and maintain clean, efficient code in SQL, PowerShell, and JavaScript
  • Lead development efforts including creating custom scripts, stored procedures, PowerShell scripts
  • Work with new APIs to automate processes and design secure and efficient data pipelines
  • Build and maintain stored procedures and custom queries to support reporting and operational workflows
  • Utilize Azure tools for cloud-based development and solution deployment
  • Scope and plan technical initiatives, estimating time, effort, and required resources
  • Establish and maintain detailed, standardized documentation for all custom-built tools and workflows
  • Propose improvements to existing systems and processes, driving innovation across the business
  • Knowledge of data modeling, warehousing, and governance
  • Create and maintain ETL processes to extract, transform, and load data from various sources into data warehouses or databases
  • Write and optimize SQL queries for data manipulation, reporting, and analysis

Skills

PowerShell
SQL
JavaScript
stored procedures
data pipelines
automation scripts

Jet Support Services

Provides aircraft maintenance and financial services

About Jet Support Services

Jet Support Services, Inc. (JSSI) specializes in providing maintenance support and financial services for the business aviation sector, catering to owners and operators of jets, turboprops, helicopters, and piston aircraft. The company’s main product is the Hourly Cost Maintenance Program (HCMP), which allows clients to manage their maintenance expenses with predictable, fixed hourly rates covering everything from routine inspections to major overhauls. JSSI also offers parts leasing services, enabling clients to efficiently order necessary parts for their aircraft, and advisory services that provide expert guidance on maintenance and management. What sets JSSI apart from competitors is its comprehensive suite of services designed to enhance the efficiency and reliability of aircraft maintenance, along with its strong focus on customer support. The company aims to minimize downtime for its clients and maximize the operational readiness of their aircraft.

Chicago, IllinoisHeadquarters
1989Year Founded
DEBTCompany Stage
Financial Services, AerospaceIndustries
201-500Employees

Benefits

Health coverage - We win at wellness. At JSSI, we believe that healthy and happy employees are better poised to make an impact in today’s global workforce. To that end, we provide industry-leading benefits plans that stay competitively priced for our employees and their families year after year.
Paid time off - We win at work-life balance. Our vacation benefits are highly competitive and increase based on tenure. In addition to our generous package of vacation, holidays, and sick days, JSSI also offers a Charitable Services Day in which employees are paid for a day of volunteering with a charity of their choosing.
Retirement package - We help prepare for a winning future. We all know the importance of saving for the future. In an effort to encourage our employees to plan for their retirement, JSSI provides an employer match to employee 401(K) contributions by matching 75% of employee contributions on up to 6% of eligible earnings.
Transporation - Move to win. Our commuter benefits plan gives JSSI employees the opportunity to set aside pre-tax dollars to put towards the inevitable use of parking and/or public transit to get to work each day.

Risks

Increased competition from companies advancing sustainable aviation technologies may impact JSSI's market share.
Expansion in Latin America poses risks related to economic instability and regulatory challenges.
Recapitalization may lead to increased financial scrutiny and pressure on operational decisions.

Differentiation

JSSI offers the only hourly cost maintenance program for all business aircraft types.
JSSI's global network of certified technical advisors ensures comprehensive maintenance support.
JSSI Parts Leasing provides efficient parts ordering and leasing for various aircraft models.

Upsides

JSSI's expansion in Latin America captures growing demand in the business aviation market.
The introduction of JSSI PartsHub enhances operational efficiency for clients.
Strong financial backing from Blackstone supports JSSI's growth and innovation.

Land your dream remote job 3x faster with AI