Staff Data Engineer (Fully Remote)

Kodiak Solutions; United States; Remote; USD 120,000 - 180,000; Full time

Job summary

Kodiak Solutions is seeking a technical leader to diagnose and resolve query, warehouse, concurrency, and workload-performance issues across products. You will establish workload isolation, sizing, query optimization, benchmarking, and capacity planning, building cost visibility with measurable workload data.

You will define dbt conventions, standardize model testing, and mentor engineers while translating enterprise architecture into practical design patterns.

Qualifications

• Strong leadership and mentoring experience in data engineering.
• Ability to guide cross-team improvements and reviews.
• Experience transforming legacy SQL into maintainable data architectures.

Responsibilities

• Diagnose and resolve data pipeline issues across products.
• Establish workload isolation, sizing, and capacity planning practices.
• Improve monitoring and alerting across Snowflake, dbt, Azure, and Datadog.
• Lead modernization of SQL and stored procedures into scalable data architectures.

Skills

Leadership

Mentoring

Cross-team collaboration

Data engineering

Tools

dbt

Snowflake

Azure

Datadog

Job description

• Diagnose and resolve query, warehouse, concurrency, and workload-performance issues across products.
• Establish workload isolation, sizing, query optimization, benchmarking, and capacity planning practices.
• Build cost-visibility and optimization using measurable workload data.

dbt Standards:

• Define reusable dbt conventions, materialization patterns, macros, packages, and documentation.
• Standardize model testing, incremental transformations, version control, PR checks, and CI/CD quality gates.
• Create reference implementations and templates for teams to adopt independently.

Operational Excellence:

• Establish repeatable data quality, reconciliation, observability, and incident triage processes.
• Improve monitoring and alerting across Snowflake, dbt, Azure, and Datadog with SRE teams.
• Lead root-cause investigations and prioritize durable engineering fixes.

Technical Leadership:

• Guide modernization of legacy SQL and stored procedures into maintainable data architectures.
• Translate enterprise architecture into implementable design patterns and coding practices.
• Mentor engineers and lead cross-team improvements through hands-on delivery and design reviews.

Kodiak Solutions

Kodiak Solutions provides technology-driven solutions for healthcare finance, unclaimed property, risk management, and revenue cycle management. They aim to streamline complex financial operations so healthcare providers can focus on patient care.