Key skills
Data pipelinesFinancial data modelingSnowflakeRedshiftBigQueryPythonAirflowSparkIcebergDelta LakeSQLdbtETL/ELT pipelinesData immutabilityAuditabilitySlowly changing dimensionsSOX controlled data systemsETLELT
About this role
Instacart is transforming the grocery industry by providing essential services that customers rely on for grocery delivery. The Senior Data Engineer II, Finance will work closely with finance, accounting, billing, and revenue teams to develop scalable data solutions and own critical data integration pipelines to ensure accurate financial reporting.
Responsibilities:
- You will work closely with finance, accounting, billing, and revenue teams to understand their main pain points and translate them into self-serve, reliable, and scalable data solutions
- You are expected to mentor other team members and be a champion of engineering excellence across the organization
- You will be part of a small team with a large amount of ownership and autonomy, managing initiatives directly from design through execution
- You will have the freedom to suggest and drive organization-wide initiatives that shape the financial data vision and roadmap
- You will own critical data integration pipelines and models, ensuring uniform, reliable, timely, and accurate financial reporting
Requirements:
- 8+ years of working experience in a Data/Software Engineering role, with a focus on building data pipelines (specialized in financial data)
- Strong knowledge of cloud based warehouses like Snowflake, Redshift, BigQuery
- Strong knowledge of common data infra technologies (Python, Airflow, Spark, Iceberg, Delta Lake) in a production environment
- Expert in data modeling with experience in modeling complex financial data with scalability and usability in mind
- Expert with SQL and dbt (Data Build Tool)
- Experience building high quality and complex ETL/ELT pipelines including pipelines for accounting/billing purposes
- Experience with data immutability, auditability, slowly changing dimensions or similar concepts
- Adept at fluently communicating with many cross-functional stakeholders to drive requirements and design shared datasets
- An ability to balance a sense of urgency with shipping high quality and pragmatic solutions
- Experience working with a large codebase on a cross functional team
- Bachelor's degree in Computer Science, computer engineering, electrical engineering or equivalent work experience
- Experience with Snowflake, dbt (Data Build Tool) and Airflow
- Experience with SOX controlled data systems