Technical Engineer (Starburst)

Company :

enGen

Job Description : 

JOB SUMMARY

***CANDIDATE MUST BE US Citizen (due to contractual/access requirements)***

Candidates within a 50-mile radius of a Highmark office (Pittsburgh or Mechanicsburg) are required to work on-site Tuesdays, Wednesdays, and Thursdays, from 8:00 AM to 5:00 PM EST. Those residing outside this 50-mile radius will be required to travel to Pittsburgh for an annual meeting.

This job is an integral member of one of our teams responsible for supporting the design, development, and maintenance of our technical solutions, ensuring their efficient and reliable operation. This position will be responsible for the system administration of the Starburst Enterprise Platform (SEP) within the organization.  Eligible candidates must have a strong knowledge and proven work experience with the infrastructure components of SEP and its supporting technologies.  They will work closely with other technical professionals, analysts, and engineers to build and optimize solutions, ensuring quality, integrity, and performance. The ideal candidate is adaptable, solution-oriented, and capable of collaborating across multiple teams to support a broad range of technical initiatives. The incumbent, and team, may be involved in every aspect as a part of the technical process from idea generation, analysis, design, build, and support using various technologies and design patterns.

ESSENTIAL RESPONSIBILITIES

• Responsible for one or many of the following tasks: analyzing, designing, coding, testing and  implementing  technical solutions, as well as providing general production monitoring and support, meeting defined scope, target dates and budgets with minimal or no defects.
• Collaborate with stakeholders across IT, product, analytics, and business teams to gather requirements and provide technical solutions that meet organizational needs
• Monitor work against production schedule and  provide progress updates and report any issues or technical difficulties to leadership on a regular basis.
• Document technical processes and procedures, and participate in technical reviews and knowledge sharing sessions
• Collaborate on the design and implementation of with architecture to ensure solution alignment to enterprise goals and standards
• Perform technical analysis and provide insights to support decision-making across various departments
• Stay up-to-date with the latest relevant technologies and industry best practices
• Other duties as assigned or requested.

EXPERIENCE

Required

• 3 years of experience in one or many of the following tasks: analyzing, designing, coding, testing and implementing technical solutions, as well as providing general production support, meeting defined scope, target dates and budgets with minimal or no defects
• 3 years of technical problem solving, solution implementation, team/project collaboration experience
• 3 years of basic computer science concepts and principles, common operating systems, development languages/scripting 

Preferred

• 3 years experience installing, configuring, deploying, upgrading and managing Starburst Enterprise Platform (SEP) with a thorough knowledge of Starburst / Trino's distributed architecture, including coordinators, workers, and connectors.
• 5 years experience in managing software applications using Infrastructure-as-Code (IaC) techniques and tools including Gitlab, Terraform, Ansible, Helm Charts, .yaml code, config properties, etc
• 5 years experience with SEP security features, including authentication using LDAP, Kerberos, or OAuth and Role-Based Access Control
• 5 years experience with various SEP data source connectors (e.g., Oracle, DB2, Teradata, S3, PostgreSQL, MySQL, etc) and their configuration within Starburst.
• 5 years experience with monitoring, scaling, and troubleshooting SEP clusters.
• 5 years experience identifying key metrics for Starburst platform health and performance, set up alerts, and analyze logs for root cause analysis.
• Strong SQL skills, particularly with Trino's dialect and optimization techniques with the ability to analyze query plans, identify bottlenecks, and apply optimizations (e.g., query tuning, resource allocation, caching strategies).
• Experience with the Google Cloud Platform and it associated services a plus.

SKILLS

• Demonstrated ability to achieve stretch goals in a highly innovative and fast-paced environment
• Adaptability: Ability to take on diverse tasks and projects, adapting to the evolving needs of the or