Data Engineer

FocusKPI, Inc.; San Francisco (CA); Hybrid; USD 62,000 - 76,000; Full time

Benefits offered by this job

Remote work

Job summary

FocusKPI, Inc. is seeking a Data Engineer to join our client’s growing team and help build reliable data systems that power decision-making.

You will own data pipelines, collaborate across analytics, finance, risk, marketing, product, and engineering, and advance our platform toward reliability and scalability. You’ll work in a fully remote arrangement for 4-6 months at ~40 hrs/week, with opportunities to apply AI-assisted development tools while upholding high standards for security and

Qualifications

• Bachelor's degree or equivalent practical experience in a technical field.
• 4-5 years of industry experience in software or data engineering.
• Proficiency in Python/Java and strong SQL skills.
• Experience building or maintaining ETL/ELT pipelines with dbt, Fivetran, or similar tools.
• Experience building production pipelines for data ingestion into a data warehouse.
• Experience with Snowflake, BigQuery, or Redshift and Airflow.
• Strong data modeling, data quality, and query optimization knowledge.
• Software engineering fundamentals: version control, testing, CI/CD.
• Ability to troubleshoot production systems and communicate with stakeholders.
• FinTech or Financial Services experience preferred.

Responsibilities

• Build, maintain, and improve data pipelines across the data platform.
• Own projects from implementation through production support.
• Work with Snowflake, dbt, Airflow, APIs, and cloud services to optimize workloads.
• Support data warehouse development with schema design and data quality practices.
• Improve ingestion, orchestration, monitoring, and reduce recurring operational work.
• Leverage AI-assisted tools while ensuring data accuracy and security.
• Own end-to-end data lifecycle management.
• Ensure data governance and reliability with tests and observability.
• Collaborate with cross-functional stakeholders to translate data needs into solutions.

Skills

Python

SQL

Java

ETL/ELT pipelines

Data modeling

Data quality

CI/CD basics

Troubleshooting production systems

Education

Bachelor's degree in Computer Science, Engineering, Mathematics

Tools

dbt

Fivetran

Snowflake

BigQuery

Redshift

Airflow

Cloud Composer

Job description

FocusKPI is looking for a Data Engineerto join our client's growingteam and to help build and improve the data systems that power decision-making. You'll develop reliable pipelines and platform capabilities while growing your ownership of production data systems and the business outcomes they support.

Data is central to how the client builds products, manages risk, understands our members, and makes decisions. In this role, you'll work alongside experienced Data Engineers and partners across Analytics, Data Science, Finance, Risk, Marketing, Product, and Engineering. You'll own well-defined data engineering projects from implementation through production support and help make our platform more reliable, scalable, and efficient. You'll also have opportunities to apply AI-assisted development tools and support emerging AI initiatives as they evolve how they build and use data.

Work Location:

100% remote

Duration:

4-6 months/ 40 hrs per week

Pay Range:

$45 - $55/hr

**No C2C resumes are considered**

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 helping reduce recurring operational work.
• Use AI-assisted engineering tools thoughtfully to accelerate development, debugging, documentation, and analysis while maintaining strong standards for accuracy, security, review, and engineering judgment.
• Own end-to-end data lifecycle management - From ingestion and transformation to modeling, orchestration, and serving layers.
• Ensure data quality, governance, and reliability - Implement testing frameworks, observability, monitoring, lineage, and data validation practices.
• Drive platform optimization and cost efficiency - Continuously improve performance, scalability, and cloud cost management across the data ecosystem.
• Establish engineering best practices - CI/CD, Infrastructure as Code, code reviews, documentation standards, and secure data handling.
• Partner cross-functionally with technical and business stakeholders to translate data needs into reliable, production-grade solutions

Qualifications:

• Bachelor's degree in Computer Science, Engineering, Mathematics, or a related technical field, or equivalent practical experience.
• 4-5years of industryexperience in software or data engineering, including experience building or supporting 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 technologies such as 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 or Cloud Composer/Good experience with Airflow.
• 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 effectively with technical and business partners.
• Experience in Financial Services or FinTech preferred

**No C2C resumes are considered**

Founded in 2010, FocusKPI, Inc. (FocusKPI) is a data science and technology firm specializing in predictive analytics practice and methodologies. FocusKPI is a US company headquartered in Silicon Valley, California, with an East Coast office in Boston, Massachusetts.