Remote Capacity Engineer Jobs in Oregon (NOW HIRING)

About Us:

Our purpose is to help clients exceed their financial health goals. Across the reimbursement cycle, our scalable solutions and clinical expertise help solve programmatic needs. Enabling our teams with leading technology allows analytics to guide our solutions and keeps us accountable achieving goals.

We build long-term careers by investing in YOU. We seek to create an environment that cultivates your professional development and personal growth, as we believe your success is our success.

JOB SUMMARY:

ESSENTIAL DUTIES AND RESPONSIBILITIES:
Note: The essential duties and responsibilities below are intended to describe the general duties and responsibilities of this position and are not intended to be an exhaustive statement of duties. This position may perform all or most of the primary duties listed below. Specific tasks, responsibilities or competencies may be documented in the Team Member's performance objectives as outlined by the Team Member's immediate Leadership Team Member.

Impact:

Essential Functions:

Note: The essential duties and primary accountabilities below are intended to describe the general content of and requirements of this position and are not intended to be an exhaustive statement of duties. Incumbents may perform all or most of the primary accountabilities listed below. Specific tasks, responsibilities or competencies may be documented in the incumbent's performance objectives as outlined by the incumbent's immediate supervisor or manager.

• Design, develop, and maintain SQL Server databases hosted on AWS RDS, ensuring reliability, availability, and data integrity.
• Perform query and index performance tuning - analyze execution plans, identify bottlenecks, and implement optimizations to support production workloads.
• Conduct load testing to simulate high-traffic scenarios, interpret results, and drive schema or configuration improvements.
• Collaborate with application developers to review and improve database-facing code, stored procedures, functions, and views.
• Develop and maintain data models, schema designs, and documentation following best practices for normalization and scalability.
• Build and maintain ETL/ELT pipelines and data transformation workflows using Python or similar tooling.
• Participate in CI/CD pipelines for database change management, including scripted migrations and version-controlled deployments.
• Ensure all data practices comply with HIPAA regulations and internal data governance standards for handling PHI/PII.
• Monitor database health, capacity, and performance metrics; proactively address issues before they impact end users.
• Contribute to peer code reviews and help establish database development standards across the team

Knowledge, Skills & Abilities:

• Bachelor's degree or equivalent
• 3-5 years of hands-on experience as a SQL Server Database Developer or Database Engineer.
• Strong proficiency in T-SQL including complex queries, stored procedures, triggers, and views.
• Demonstrated experience with query performance tuning - reading execution plans, optimizing indexes, and resolving blocking/deadlock issues.
• Experience designing and managing databases on AWS RDS for SQL Server.
• Solid understanding of relational data modeling, normalization, and schema design principles.
• Experience with load testing methodologies and tools; ability to define test scenarios and interpret results.
• Working knowledge of ETL/ELT processes and experience with Python or similar scripting languages for data pipelines.
• Familiarity with CI/CD practices for database change management (e.g., Flyway, Liquibase, or equivalent).
• Understanding of HIPAA compliance requirements as they relate to data handling, access control, and audit logging.
• Strong communication skills and ability to collaborate effectively in a fully remote environment

Preferred Qualifications:

• Experience working in a healthcare or health-tech environment with exposure to clinical or claims data.
• Familiarity with AWS ecosystem services such as CloudWatch, Parameter Store, or Secrets Manager in a database context.
• Knowledge of HL7/FHIR data standards or healthcare interoperability concepts.
• Experience with reporting tools or analytics platforms (e.g., Power BI, SSRS, Tableau).
• Exposure to NoSQL databases or hybrid data architectures.

Tech Stack:

SQL-Server (AWS RDS) T-SQL Python AWS CI/CD Tooling ETL/ELT Pipelines

We Offer:

• Remote, predictable, full-time, M-F days within your timezone (EST, CT, MT, PST)

• Opportunities for career growth within the organization

• Salary commensurate to skill level

• Medical, Dental, Vision, long-term disability insurance, life insurancecoverage and more

• 401Kwith company match

• Holidays, Flexible/Uncapped paid time off,

• Allowance for certifications/continuing education

Physical Requirements and Demands:

Note: Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions as described.

Regular eye-hand coordination and manual dexterity is required to operate office equipment. The ability to perform work at a computer terminal for 6-8 hours a day and function in an environment with constant interruptions is required. At times, incumbents are subject to sitting for prolonged periods. Infrequently, incumbent must be able to lift and move material weighing up to 20 lbs. Incumbent may experience elevated levels of stress during periods of increased activity and with work entailing multiple deadlines.

A job description is only intended as a guideline and is only part of the employee's function. The company has reviewed this job description to ensure that the essential functions and basic duties have been included. It is not intended to be construed as an exhaustive list of all functions, responsibilities, skills and abilities. Additional functions and requirements may be assigned by supervisors as deemed appropriate

PHYSICAL DEMANDS:
Note: Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions as described. Regular eye-hand coordination and manual dexterity is required to operate office equipment. The ability to perform work at a computer terminal for 6-8 hours a day and function in an environment with constant interruptions is required. At times, Team Members are subject to sitting for prolonged periods. Infrequently, Team Member must be able to lift and move material weighing up to 20 lbs. Team Member may experience elevated levels of stress during periods of increased activity and with work entailing multiple deadlines.
A job description is only intended as a guideline and is only part of the Team Member's function. The company has reviewed this job description to ensure that the essential functions and basic duties have been included. It is not intended to be construed as an exhaustive list of all functions, responsibilities, skills and abilities. Additional functions and requirements may be assigned by supervisors as deemed appropriate.