Apprentice Architectural Visualization Jobs in California

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.
Meet Your Recruiter
Abhishek Tiwari