AWS Cloud Engineering

Location: Sunnyvale, CA (100% onsite)Salary Range: $130K - $140K per yearAbout the RoleWe 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.ResponsibilitiesDesign, 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 Qualifications7+ 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 QualificationsExperience 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 InsuranceDental and Vision Insurance401k ContributionsCritical Illness InsuranceVoluntary Permanent Life InsuranceAccident InsuranceOther Employee PerksLanceSoft 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.