Microsoft SQL Server Engineer

Green Light Cost Management, LLC; Scottsdale (AZ); In loco; USD 90.000 - 130.000; Tempo pieno

Descrizione del lavoro

Green Light Cost Management, LLC in the United States is seeking a Microsoft SQL Server Engineer to design, build, and optimize our healthcare data infrastructure, supporting Elixir-based applications and claims processing systems.

You will implement T-SQL stored procedures, SSIS packages, SQL Server Agent jobs, and enforce security/compliance while collaborating with developers, data scientists, and analysts to scale performance and reliability in a fast-growing healthcare tech environment.

Competenze

• Bachelor's degree or equivalent work experience in a related field.
• Proficiency in T-SQL and query optimization with extensive experience writing stored procedures.
• Deep knowledge of ANSI 837 healthcare claim formats (HCFA 837P and UB 837I).
• Experience with Agile development and working in an Agile team.
• Experience using GitLab for issue tracking, CI/CD, and source control.
• Strong analytical and problem-solving skills; excellent teamwork and communication.

Mansioni

• Develop, optimize, and maintain complex T-SQL stored procedures to support Elixir-based applications.
• Ensure database security and compliance with industry standards.
• Parse and process ANSI 837 healthcare claim data (HCFA 837P, UB 837I).
• Design and maintain SQL Server Agent jobs and SSIS packages to automate data loading and transformations.
• Collaborate with software developers, data scientists, and data analysts to meet data needs.
• Perform troubleshooting and root-cause analysis; document database processes.
• Plan and implement scaling strategies for growing database systems.

Conoscenze

T-SQL

SQL optimization

Stored procedures

Agile

GitLab

Data security

ETL

SSIS

Elixir integration

Collaboration

Formazione

Bachelor's degree in Computer Science / IT / Data Science or related

Strumenti

SSIS packages

SQL Server Agent

GitLab

Descrizione del lavoro

SUMMARY:

Green Light is a healthcare technology company on a mission to help health plan dollars go as far as possible. The engineering team is at the heart of that mission.As a Microsoft SQL Server Engineer, you will play a critical role in designing, building, and optimizing our database infrastructure, which is the backbone of our operations.

Your work will yield tremendous value for American healthcare consumers and their families, as we deliver effective solutions aimed at reducing the cost of healthcare.

AS A MICROSOFT SQL SERVER ENGINEER YOU WILL:

• Stored Procedure Development: Design, write, and maintain complex T-SQL stored procedures that directly support our Elixir-based applications, serving as a critical bridge between our backend services and data layer.
• Security: Ensure that our databases meet high standards of data security and compliance.
• Claims Data Processing: Parse, validate, and process ANSI 837 healthcare claim data including both HCFA (professional) and UB (institutional) claim formats, ensuring accuracy and compliance with industry standards.
• Automated Job Development: Design and maintain SQL Server Agent jobs and SSIS packages (.dtsx) to support automated data loading, processing, and transformation workflows that feed our claims processing pipeline.
• Collaboration: Collaborate with cross-functional teams, including software developers, data scientists, and data analysts, to support their data needs and ensure seamless integration with our systems.
• Troubleshooting and Problem-Solving: Be the subject matter expert on the databases you work in and address any related issues and contribute to root-cause analysis.
• Documentation: Maintain comprehensive documentation of database processes.
• Scalability: Develop and implement strategies for scaling our database systems as our business continues to experience rapid growth.

YOU WILL THRIVE IN THIS ROLE IF YOU HAVE:

• A Bachelor's degree in Computer Science, Information Technology, Data Science, or a related field (or equivalent work experience).
• Proficiency in T-SQL and SQL query optimization, with deep day-to-day experience writing and maintaining stored procedures in support of application development teams and a hands-on approach to being embedded in the development workflow.
• Extensive knowledge of the ANSI 837 standard, including practical experience parsing and processing both HCFA (837P) and UB (837I) claim formats, understanding of loop and segment structures, and familiarity with how claim data flows through healthcare billing and adjudication pipelines.
• Familiarity with Agile development methodologies and experience working within an Agile team environment, including contributing to sprint planning, daily standups, and iterative delivery cycles.
• Experience using a project management and source control platform such as GitLab to create, manage, and work tickets through the full development lifecycle from requirements to production deployment.
• Strong analytical and problem-solving skills.
• Excellent teamwork and communication skills.
• Passion for contributing to a meaningful mission and experiencing hyper-growth in a dynamic work environment.
• Strong knowledge of data security and compliance standards.
• Familiarity with data modeling and ETL processes, including hands-on experience developing and maintaining SSIS packages (.dtsx) and SQL Server Agent jobs for automating data loads, processing workflows, and scheduled operations in a production healthcare data environment.

QUALIFICATIONS THAT ARE A BIG PLUS

• Experience supporting Elixir or other functional language backend applications through SQL data layers.
• Familiarity with EDI transaction sets beyond 837, such as 835 remittance or 834 eligibility transactions.
• Prior experience in a healthcare technology, payer, or clearinghouse environment where ANSI EDI standards are part of daily work.
• Experience designing SSIS-based ETL pipelines for high-volume healthcare claims data ingestion and processing.