Associate Data Engineer

Execute all programming tasks, including programming, analyzing, designing, developing, implementing, modifying, and maintaining computer programs. Work on systems of small to moderate size and complexity or segments of larger systems.

• Conceptualize design, implement and develop solutions for complex system/programs independently.
• Design and develop applications that may involve sophisticated data manipulation. Implementation and maintenance of complex Data Store/ Data Lake/Lake house and Data warehousing systems and data-intensive solutions that are scalable, optimised and fault‑tolerant.
• Document system builds and application configurations; maintain and update documentation as needed.
• Provide technical analysis, design, development, conversion and implementation work.
• Work as a project leader, as needed, for projects of moderate complexity.
• Serve as a technical resource for all Data Engineering applications.
• Compare, evaluate and implement new features and technologies, and integrate them into the computing environment.
• Follow team software development methodology.
• Mentor lower‑level software developers.
• Design and implement Data Migration and Data Integration across cloud and hybrid environments.
• Mastery and hands‑on experience with Data Engineering technologies and scripting languages.
• Ability to translate complex functional and technical requirements into detailed architecture, design and high‑performing software.
• Design, build and optimise pipelines for data collection for storage, access and analytics.

Minimum Requirements:

Education and Experience:

Bachelor’s degree and five years of relevant experience, or a combination of education, training and relevant experience.

Knowledge, Skills and Expertise:

• Expertise in designing, developing, testing and deploying applications.
• Ability to define and solve logical problems for highly technical applications.
• Hands‑on experience and training in Advanced SQL, Advanced Python programming, AWS Services (such as S3, Redshift, Glue ETL, IAM, DMS, Appflow, VPC and others), Snow Flake, Five Tran, KAFKA, Airflow, Oracle Cloud and other open‑source tools.
• Experience in writing reusable complex Python/PySpark scripts for ELT, Business Logic or APIs. Other coding experience such as Scala and R programming is a plus.
• Hands‑on development work on all aspects of data analysis, data provisioning, modelling, performance tuning and optimisation.
• Experience in working on AWS cloud environment, using the marketplace for the right tool, efficient utilisation of them to meet business requirements.
• Build scalable data pipelines for both real‑time and batch using best practices in data modelling, ETL/ELT processing using various technology stack.
• Experienced in Data Modeling, Data Migration and Data Integration. Know the pain points in Data integration across SaaS applications and implement the best solution that fits the organisation.
• Strong communication skills with both technical and non‑technical clients.

• Constantly perform desk‑based computer tasks.
• Frequently sit, grasp lightly/fine manipulation.
• Occasionally stand/walk, use a telephone.
• Rarely writing by hand, lift/carry/push/pull objects that weigh up to 10 pounds.

Consistent with its obligations under the law, the University will provide reasonable accommodation to any employee with a disability who requires accommodation to perform the essential functions of the job.

• May work extended hours, evenings and weekends.

• Interpersonal skills:
  Demonstrates the ability to work well with Stanford colleagues and clients and with external organisations.
• Promote culture of safety:
  Demonstrates commitment to personal responsibility and value for safety; communicates safety concerns; uses and promotes safe behaviours based on training and lessons learned.
• Subject to and expected to comply with all applicable University policies and procedures, including but not limited to the personnel policies and other policies found in the University’s Administrative Guide, (Use the "Apply for this Job" box below)..

The expected pay range for this position is $138,402 to $163,985 per annum. Stanford…