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 workLead 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 #J-18808-Ljbffr Stanford University