Lead Data Engineer

Responsible for performing difficult or complex analysis, design and programming involving multi-project leadership and broad responsibility in support of new and existing Data Engineering Projects and production support activities.

Minimum Requirement 

Education and Experience:

• Bachelor’s degree and eight years relevant experience or a combination of education and relevant experience.

Knowledge, Skills and Expertise:

• Thorough understanding and experience in Data Lake, Lake House and Data Warehousing Architecture.  Should be able to suggest, architect and implement  Data Lake/Lake house/ DataWarehouse solution with a set of available cloud tools and programming.

• Experience with DataOps and related set of practices, processes and technologies.

• Experienced in Data Migration and Data Integration.  Know the pain points in Data integration across SaaS applications and implement the best solution that fits the organization.

• Hands-on experience and expertise in Advanced SQL, Advanced Python programming, AWS and Other Data Engineering tools, SnowFlake, Informatica, SnapLogic, KAFKA, Airflow, Oracle Cloud data lake and other open source tools.  Experience in Data Migration/Integration tools such as AWS Data migration services,AppFlow, MuleSoft, RJ, open source and any other market available tools

• Experience in writing reusable complex Python 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, modeling, performance tuning and optimization.

• Experience in working on AWS cloud environment, using the marketplace for the right tool, efficient utilization of them to meet business requirements.

• Mastery of relational, NoSQL or NewSQL database systems. Expertise in working with unstructured, structured and semi-structured data.  

• Build scalable data pipelines for both real time and batch using best practices in data modeling, ETL/ELT processing using various technology stack

• Experience in designing and implementing tight data security at various levels.

• Experience in streaming data from SaaS/PaaS applications –  SalesForce, ServiceNow, Workday, Oracle Cloud, Marketo and others. 

• Experience in data migration and integration across cloud and on-premises systems

• Constantly monitor operations, tune for better performance and utilization.

PHYSICAL REQUIREMENTS*:

• 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.

WORKING CONDITIONS:

• May work extended hours, evenings and weekends.

WORK STANDARDS:

• Interpersonal Skills: Demonstrates the ability to work well with Stanford colleagues and clients and with external organizations.
• Promote Culture of Safety: Demonstrates commitment to personal responsibility and value for safety; communicates safety concerns; uses and promotes safe behaviors 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, http://adminguide.stanford.edu.

Why Stanford is for You:
Stanford University has revolutionized the way we live and enrich the world.  Supporting this mission is our diverse and dedicated 17,000 staff.  We seek talent driven to impact the future of our legacy.  Our culture and unique perks empower you with:

• Freedom to grow.  We offer career development programs, tuition reimbursement, or audit a course.  Join a TedTalk, film screening, or listen to a renowned author or global leader speak.
• A caring culture.  We provide superb retirement plans, generous time-off, and family care resources.
• A healthier you.  Climb our rock wall or choose from hundreds of health or fitness classes at our work-class exercise facilities.  We also provide excellent health care benefits.
• Discovery and fun.  Stroll through historic sculptures, trails, and museums.
• Enviable resources.  Enjoy free commuter programs, ridesharing incentives, discounts and more!
• Redwood City.  Our new Stanford Redwood City campus, opened in 2019, will be the workplace for approximately 2,700 staff, including University IT, whose jobs are important to supporting the University’s mission.  The campus will offer amenities such as onsite cafes and a dining pavilion, a high-end fitness facility with an outdoor pool, and a childcare center for Stanford families.

Stanford is an equal employment opportunity and affirmative action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law.

The job duties listed are typical examples of work performed by positions in this job classification and are not designed to contain or be interpreted as a comprehensive inventory for all duties, tasks, and responsibilities.  Specific duties and responsibilities may vary depending on department or program needs without changing the general nature and scope of the job or level of responsibility.  Employees may also perform other duties as assigned.