Associate Data Engineer

Stanford University offers a collaborative, growth-oriented environment with strong career development programs, comprehensive health coverage, and on-site amenities at the Redwood City campus. This onsite role in Redwood City, CA carries a salary range of USD 138,402 to 163,985 per year and emphasizes mentoring, technical leadership, and translating complex requirements into scalable data solutions.

Benefits

• Career development programs and tuition-related support, including options to audit courses
• Retirement plans and generous time-off
• Family care resources and a childcare center for Stanford families
• Health care benefits and wellness options
• Fitness facilities and wellness classes on-site
• Discovery and fun with access to museums and trails
• Free commuter programs and ridesharing incentives
• Employee discounts and other campus perks
• On-site dining options including cafes and a dining pavilion
• High-end fitness facility with an outdoor pool
• Redwood City campus amenities such as onsite cafes, dining pavilion, fitness facility, outdoor pool, and childcare center

Responsibilities

• Independently design, implement and develop solutions for complex systems and programs
• Build applications involving sophisticated data manipulation and maintain data stores, data lakes, lake houses, and data warehousing solutions that are scalable, optimized, and fault-tolerant
• Document system builds and configurations, and keep documentation up to date
• Provide technical analysis, design, development, conversion and implementation work
• Lead projects of moderate complexity as needed
• Serve as a technical resource for all data engineering applications
• Evaluate and integrate new features and technologies into the computing environment
• Adhere to the team software development methodology
• Mentor lower-level software developers
• Design and implement data migration and data integration across cloud and hybrid environments
• Demonstrate mastery of data engineering technologies and scripting languages
• Translate complex functional and technical requirements into detailed architecture and high-performing software
• Design, build and optimize data collection pipelines for storage, access and analytics

Requirements

• Bachelor's degree and five years of relevant experience, or an equivalent combination of education, training and experience
• Expertise in designing, developing, testing and deploying applications
• Ability to define and solve logical problems for highly technical applications
• Hands-on experience with Advanced SQL, Advanced Python, AWS services (S3, Redshift, Glue ETL, IAM, DMS, Appflow, VPC and others), Snowflake, FiveTran, Kafka, Airflow, Oracle Cloud and other open source tools
• Experience writing reusable complex Python/PySpark scripts for ELT, business logic or APIs; additional experience with Scala or R is a plus
• Hands-on development across data analysis, provisioning, modeling, performance tuning and optimization
• Experience working in AWS cloud environments and selecting tools that meet business requirements
• Ability to build scalable real-time and batch data pipelines using best practices in data modeling and ETL/ELT processing
• Proven experience in data modeling, data migration and data integration, including cross-SaaS integration challenges
• Strong communication skills with both technical and non-technical stakeholders

Technologies

Technologies: SQL, Python, PySpark, AWS, S3, Redshift, Glue ETL, IAM, DMS, Appflow, VPC, Snowflake, FiveTran, Kafka, Airflow, Oracle Cloud, Scala, R

Physical Requirements

• Constantly perform desk-based computer tasks
• Frequently sit and perform fine motor tasks
• Occasionally stand or walk and use a telephone
• Rarely write by hand and occasionally lift/carry/push/pull up to 10 pounds

Working Conditions

• May work extended hours, evenings and weekends

Work Standards

• Interpersonal Skills: ability to work well with Stanford colleagues, clients and external organizations
• Promote Culture of Safety: maintain personal responsibility for safety and communicate safety concerns
• Adhere to university policies and procedures including those in the Administrative Guide

Why Stanford is for You

• Freedom to grow: career development programs, tuition reimbursement and opportunities to audit courses, plus access to talks and screenings
• Caring culture: retirement plans, generous time-off, and family care resources
• Healthier you: extensive health benefits and a range of fitness options at campus facilities
• Discovery and fun: easy access to cultural and outdoor experiences
• Enviable resources: complimentary commuter programs, ridesharing incentives and campus discounts
• Redwood City campus: modern amenities including onsite cafes, a dining pavilion, a premium fitness facility with outdoor pool, and an on-site childcare center