AWS Cloud Engineering

Location: Sunnyvale CA (100% onsite)
Salary Range: $130K - $140K per year

About the Role
We are seeking an experienced Data Engineer to design build and optimize scalable data pipelines and analytics infrastructure. The ideal candidate has hands-on expertise with Snowflake for cloud data warehousing and Apache Doris for real-time OLAP analytics and is comfortable working across the full data lifecycle from ingestion to transformation to serving high-performance queries for analytics and BI teams.

Responsibilities

- Design build and maintain robust scalable ETL/ELT pipelines to ingest structured and semi-structured data from multiple sources into Snowflake and Apache Doris.
- Architect and optimize data models schemas and partitioning strategies in Snowflake and Doris to support high-throughput low-latency analytical workloads.
- Tune query performance indexing materialized views and storage layout in Doris for real-time OLAP use cases.
- Manage Snowflake warehouse sizing cost optimization resource monitors and query performance tuning.

Required Qualifications

- 7 years of experience as a Data Engineer or in a similar role.
- Hands-on production experience with Snowflake including SQL scripting warehouse management Snowpipe Streams/Tasks and performance tuning.
- Hands-on experience with Apache Doris including cluster architecture (FE/BE nodes) table models (Aggregate Unique Duplicate) materialized views and real-time data loading (Stream Load Routine Load Broker Load).
- Strong SQL skills and experience with data modeling (star/snowflake schemas dimensional modeling).
- Proficiency in Python commonly used in data engineering.
- Experience with workflow orchestration tools (Apache Airflow dbt Dagster or similar).
- Familiarity with streaming/messaging systems (Kafka Pulsar or similar) for real-time data ingestion.
- Solid understanding of data warehousing concepts OLAP vs. OLTP design and distributed systems fundamentals.
- Experience with version control (Git) and CI/CD practices for data pipelines.

Preferred Qualifications

- Experience migrating workloads from traditional data warehouses to Snowflake and/or Doris.
- Familiarity with cloud platforms (AWS GCP or Azure) and infrastructure-as-code tools (Terraform CloudFormation).
- Experience with containerization/orchestration (Docker Kubernetes) for deploying Doris clusters.
- Knowledge of BI/visualization tools (Tableau Looker Superset Power BI).
- Background in cost optimization and capacity planning for large-scale analytical systems.
- Contributions to open-source data engineering projects (e.g. Apache Doris community).

Employee Benefits:

At LanceSoft full time regular employees who work a minimum of 30 hours a week or more are entitled to the following benefits:

Medical Insurance

Dental and Vision Insurance

401k Contributions

Critical Illness Insurance

Voluntary Permanent Life Insurance

Accident Insurance

Other Employee Perks

LanceSoft is an equal opportunity employer. We prohibit discrimination and harassment of any kind based on race color sex religion sexual orientation national origin disability genetic information pregnancy or any other protected characteristic as outlined by federal state or local laws. This policy applies to all employment practices within our organization including hiring recruiting promotion termination layoff recall leave of absence compensation benefits training and apprenticeship. LanceSoft makes hiring decisions based solely on qualifications merit and business needs at the time.