Remote Data Engineer: Scalable Pipelines & AI-Driven Platform

Wal-Mart; San Francisco (CA); Remote; USD 62,000 - 76,000; Part time

Job summary

FocusKPI is seeking a Data Engineer to join a growing client team and help build reliable data systems that power decision-making. You will own end-to-end data pipelines, work with Snowflake, dbt, Airflow, and cloud services, and ensure data quality and governance while enabling AI-assisted development tools.

The assignment is 100% remote in the United States with a 4–6 month duration and 40 hours per week.

Qualifications

• Bachelor’s degree in CS, Engineering, Mathematics, or related field or equivalent practical experience.
• 4–5 years of industry experience in software or data engineering, including production data systems.
• Strong programming skills in Python, Java, or another general-purpose language, plus strong SQL skills.
• Experience building or maintaining ETL/ELT pipelines and working with dbt, Fivetran, or similar tools.
• Hands-on experience building production pipelines for file ingestion into a data warehouse.
• Experience with cloud data warehouses such as Snowflake, BigQuery, or Redshift and orchestration tools such as Airflow/Cloud Composer.
• Understanding of data modeling, data quality, relational data, and query and performance optimization.
• Strong software engineering fundamentals including version control, testing, code reviews, and CI/CD.
• Ability to troubleshoot production systems methodically and communicate with technical and business partners.
• Experience in Financial Services or FinTech preferred

Responsibilities

• Build, maintain, and improve reliable data pipelines that ingest, transform, and deliver data across the client’s data platform.
• Own data engineering projects and pipelines through implementation, testing, deployment, monitoring, troubleshooting, and ongoing support.
• Work with Snowflake, dbt, Airflow/Cloud Composer, APIs, files, and cloud services to support production workloads and optimize them for reliability, performance, scalability, and cost.
• Support warehouse development through thoughtful schema design, data modeling, testing, documentation, data quality practices, and query optimization.
• Improve ingestion, orchestration, validation, retries, backfills, monitoring, and alerting while reducing recurring operational work.
• Use AI-assisted engineering tools to accelerate development, debugging, documentation, and analysis with strong quality standards.
• Own end-to-end data lifecycle management—from ingestion and transformation to modeling, orchestration, and serving layers.
• Ensure data quality, governance, and reliability with testing, observability, lineage, and data validation practices.
• Drive platform optimization and cost efficiency across the data ecosystem.
• Establish engineering best practices—CI/CD, Infrastructure as Code, code reviews, documentation, and secure data handling.
• Partner with technical and business stakeholders to translate data needs into reliable, production-grade solutions

Skills

Python

SQL

ETL Pipelines

Data Engineering

Data Modeling

Airflow

CI/CD

Communication

Education

Bachelor’s degree in Computer Science, Engineering, Mathematics, or related field

Tools

Snowflake

BigQuery

Redshift

dbt

Fivetran

Cloud Composer

Git

Job description

FocusKPI is seeking a Data Engineer to join a growing client team and help build reliable data systems that power decision-making. You will own end-to-end data pipelines, work with Snowflake, dbt, Airflow, and cloud services, and ensure data quality and governance while enabling AI-assisted development tools.

The assignment is 100% remote in the United States with a 4–6 month duration and 40 hours per week.