Senior Data & Automation Engineer, Enterprise Analytics

Planet Pharma

Redwood City (CA)

On-site

USD 140,000 - 180,000

Full time

9 days ago

Get a reply from this recruiter

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Revolution Medicines is seeking a Senior Data and Automation Engineer for Enterprise Applications in a 6-month temporary role with potential to convert. You will design curated datasets, build reliable pipelines, and deliver dashboards across Finance, HR, Procurement, Legal, Compliance, and Commercial Operations.

The role focuses on data quality, governance, and scalable automation using Databricks, Snowflake, and iPaaS tools.

Qualifications

Bachelor’s degree in data engineering, computer science, information systems, business analytics, or related discipline, or equivalent practical experience.
Minimum of 5 years of relevant experience in data engineering, analytics engineering, enterprise analytics, business systems, integration, automation, or data product delivery.
Hands-on experience with Databricks, Snowflake, SQL, Python or PySpark, Delta Lake, Fivetran or similar data ingestion tools, and modern data lakehouse or warehouse patterns.
Experience designing curated datasets, semantic models, data quality rules, and documentation that make enterprise data usable for business teams.
Experience integrating data across enterprise systems using APIs, flat files, middleware or integration platform as a service (iPaaS) tools, and reporting platforms, including reverse extract, transform, load (reverse ETL) or data activation patterns that move curated data and insights back into business systems.
Familiarity with G&A processes and systems, including NetSuite, Coupa, Concur, Workday Adaptive, Ironclad, Emtrain, Compliance Wire or similar Finance, Procurement, Human Resources, Legal ,learning, compliance, and planning platforms.
Experience using automation or integration platforms such as Workato, Moveworks, middleware, iPaaS, or similar tools to streamline business processes.
Ability to translate ambiguous business needs into clear technical requirements, delivery plans, and measurable outcomes.
Ability to operate independently in a fast-paced environment while collaborating effectively with business, technology, compliance, and security partners.

Responsibilities

Lead design and delivery of curated data products across Databricks, Snowflake, and related platforms, including ingestion, transformation, quality checks, and reusable data models.
Partner with G&A business owners to define analytics requirements, key performance indicators, data definitions, and priority use cases across Finance, Human Resources, Procurement, Legal, Compliance, and Commercial Operations.
Develop reliable pipelines and integrations from enterprise applications, data files, APIs, Fivetran or similar ingestion tools, middleware, and third-party sources into governed datasets.
Create dashboards, metrics layers, and insight products for broad G&A analytics, including examples such as expense management, learning analytics, gross to net reporting, budgeting and operational reporting.
Establish data curation standards for naming, lineage, documentation, access controls, data quality, and handoff to long-term support teams.
Identify and deliver automation and integration opportunities using Workato, Moveworks, middleware or similar tools to reduce manual data preparation, reconciliation, reporting, and workflow handoffs.
Evaluate and apply artificial intelligence tools responsibly to simplify work processes, improve data stewardship, and accelerate analytics delivery.
Work with Information Security, Compliance, Legal, and data owners to protect sensitive information and align with applicable privacy, governance, and access requirements.