Senior Data Engineer

Kodiak Solutions

. Diagnose and remediate Snowflake query, warehouse, concurrency, and workload-performance issues across products .

Posted 11/2/2026full-timeRemote • United StatesSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in Snowflake query optimization, dbt project implementation, and advanced SQL and Python engineering. Capable of establishing data quality practices and leading root-cause investigations to enhance data engineering quality and performance.

Highest-signal resume keywords

Snowflake Query OptimizationProduction dbt ExperienceAdvanced SQL SkillsPython Engineering SkillsData Quality Engineering

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Query ProfilingWarehouse OperationsPerformance TuningCost OptimizationData ModelingIncremental ProcessingAutomated TestsPipeline ReliabilityELTData Engineering

Soft Skills

CoachingProblem-SolvingCollaboration

Tools & Technologies

Microsoft AzureAzure Data FactoryAzure Data Lake StorageAzure DevOpsDatadogInfrastructure as Code

Industry Keywords

Sensitive-Data ControlsRole-Based AccessData GovernanceHealthcareFinancial ProcessingSaaS Products

Tech Stack

Tools & technologies

AzureCloudPythonSnowflakeSQL

About the role

Key responsibilities & impact

Diagnose and remediate Snowflake query, warehouse, concurrency, and workload-performance issues across products
Establish approaches to workload isolation, warehouse sizing, query optimization, performance benchmarking, and capacity planning
Build cost-visibility and optimization practices using measurable workload and consumption data
Partner with product teams to address performance risks before production incidents
Define and implement reusable dbt project conventions, materialization patterns, macros, packages, and documentation
Standardize model testing, incremental transformations, version control, pull-request checks, and CI/CD quality gates
Promote maintainable transformation design, clear ownership, lineage, and appropriately scoped data contracts
Create reference implementations and templates for delivery teams
Establish approaches to data quality, reconciliation, observability, incident triage, and pipeline recovery
Improve monitoring and actionable alerting across Snowflake, dbt, Azure services, and Datadog with SRE and application teams
Lead root-cause investigations for recurring data-processing incidents and prioritize durable engineering fixes
Introduce automated performance, correctness, and production-readiness checks for critical workloads
Improve data engineering quality, scalability, and consistency across Kodiak Solutions' product portfolio
Coach engineers through challenging production problems

Requirements

What you’ll need

6+ years of software or data engineering experience
Mid-level, hands-on Snowflake experience with query profiling, warehouse operations, performance tuning, and cost optimization
Extensive production dbt experience with model design, incremental processing, macros, automated tests, and CI/CD
Advanced SQL and strong Python engineering skills, including building reusable tools and production data workflows
Experience operating large-scale cloud data platforms and debugging high-volume or concurrent workloads
Strong grounding in ELT, data modeling, testing, pipeline reliability, and data quality engineering
Demonstrated success establishing shared engineering practices without becoming a delivery bottleneck
Preferred: Experience with Microsoft Azure, Azure Data Factory, Azure Data Lake Storage, and Azure DevOps
Preferred: Experience migrating legacy SQL Server or stored-procedure-heavy environments
Preferred: Experience with Datadog, observability tooling, infrastructure as code, and developer-enablement automation
Preferred: Knowledge of sensitive-data controls, role-based access, lineage, and governance in regulated environments
Preferred: Background in healthcare, complex financial processing, or other data-intensive SaaS products