Senior Data Engineer in Analytics

Full-time - Senior

South San Francisco, CA

Administrative and Support Services

About the position

The Senior Data Engineer in Analytics will own the design, implementation, and scaling of our analytics infrastructure to form the foundation of a cohesive analytics ecosystem. This role also empowers data analysts and data scientists to follow DataOps best practices to independently create metrics. Additionally, the Data Engineer will interface with the application database team to synergistically improve the overall cloud ecosystem. The ideal candidate will have demonstrable experience implementing data warehouses, a strong foundation in SQL and Python, and a mindset for cloud systems design.

Responsibilities

• Ingest data from Postgres, Google Cloud Storage, Salesforce, Jira, web analytics platforms, and other sources into BigQuery.
• Use Data Build Tool (dbt) to transform raw data into user friendly 'data-marts' for use in BI tools.
• Implement reverse-etl to make aggregate data available in the application database for web application and mobile application use.
• Use dbt to establish a robust data testing framework that ensures data remains accurate and trustworthy.
• Produce a comprehensive suite of metric definitions and documentation accessible to anyone in the organization.
• Champion DataOps best practices across teams to cultivate a consistent, high-quality approach to data management and analytics.
• Help evaluate and choose the best cloud tools to meet ever-evolving business needs.
• Monitor and implement controls to ensure data warehousing costs are predictable and within reasonable levels.
• Unlock synergies between the application database and data warehouse to reduce overall cloud costs.
• Help ensure account permissions remain appropriate and enforced across the data consumption layer.
• Implement controls to ensure the data warehouse maintains compliance with GDPR, PII laws, SOC 2, and other regulations.

Requirements

• A bachelor's or master's degree in Computer Science (or a related field) is highly recommended but not required.
• At least three years of experience with SQL, BigQuery, and GCP.
• Hands-on expertise with dbt is highly preferred.
• Experience interfacing with Postgres.
• Familiarity with ingesting data via APIs from external software platforms and transforming non-tabular data using Python is a plus.
• Experience with data streaming is also nice to have.
• Experience implementing and taking full ownership for data warehouses is essential.
• A proven track record of data modeling for analytical use cases.
• A strong emphasis on data security and governance.
• A deep understanding of the strengths and weaknesses of both transactional and analytical databases.

Nice-to-haves

• Experience with data streaming.

Benefits

• Equity compensation
• Full range of medical benefits
• Financial benefits