Apply on Employer Site

KPI Partners · 5 hours ago

Senior DataOps Engineer

United States

Contract

Remote

Senior Level

KPI Partners is a recognized data, analytics, and AI consulting company seeking a highly technical and hands-on Senior DataOps Engineer. This role is responsible for ensuring the reliability, performance, security, and cost-efficiency of their modern data ecosystem, particularly focusing on Snowflake and BigQuery platforms.

ConsultingInformation TechnologyLegalSoftware

H1B Sponsor Likely

Hiring Manager

Jayesh Raneja

Responsibilities

Snowflake & BigQuery Administration

Performance Optimization: Proactively monitor and tune query performance by identifying bottlenecks and optimizing clustering strategies, search optimization, materialized views, and warehouse configurations

Security & Governance: Design, implement, and maintain complex Role-Based Access Control (RBAC) models to enforce data security, governance, and least-privilege access

Cost Management: Implement resource monitors, warehouse auto-scaling policies, and consumption tracking to optimize cloud spend and maximize ROI

Data Integration & Pipeline Operations

Data Ingestion: Provision, manage, and monitor high-volume data ingestion pipelines using Fivetran, Informatica, and Rite Sync, ensuring reliability and data freshness

Orchestration: Maintain, monitor, and troubleshoot complex workflows and DAGs in Apache Airflow to ensure timely and dependable data delivery

Transformations: Support and optimize DBT models, ensuring efficient transformations, data quality checks, testing, and documentation

Operational Excellence & Reliability

Monitoring & Alerting: Implement advanced monitoring and alerting for pipeline failures, data latency, SLA breaches, and platform health

Continuous Improvement: Regularly assess and fine-tune ingestion, orchestration, and transformation layers to improve reliability, reduce latency, and enhance performance

Technical Collaboration: Act as a senior technical peer, contributing to architecture reviews, design discussions, and deep technical problem-solving with cross-functional teams

Qualification

SnowflakeBigQueryApache AirflowDBTFivetranData SecurityData GovernanceSQLCollaboration

Required

Strong hands-on experience administering Snowflake and/or BigQuery in production environments

Deep understanding of query optimization, warehouse sizing, and cost controls

Proven experience with Apache Airflow, DBT, and modern ELT/ETL tools

Experience operating and monitoring data ingestion platforms such as Fivetran and Informatica

Strong knowledge of data security, RBAC, and governance models

Ability to troubleshoot complex data pipeline and platform issues end-to-end

Preferred

Experience supporting large-scale, high-volume analytical workloads

Familiarity with cloud cost optimization strategies in AWS, GCP, or Azure

Strong SQL expertise and understanding of distributed data architectures

Experience working in highly collaborative, fast-paced data engineering teams

Company

KPI Partners

KPI Partners provides strategic guidance and technology systems for clients wishing.

Founded in 2006

Newark, California, USA

501-1000 employees

http://www.kpipartners.com/

H1B Sponsorship

KPI Partners has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2025 (8)

2024 (6)

2023 (8)

2022 (9)

2021 (3)

2020 (11)