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