Facet Wealth Logo Facet Wealth
Facet Wealth Logo

Lead Data Engineer

💰 $1,000 - $5,000 🌍 United Kingdom 📅 07/05/2023

Apply

Job Description

##### Job Description :

**As a Lead Data Engineer at Facet, you will support data analytics,
operations and other company initiatives by ingesting data from business
systems into a cloud data warehouse, working closely with analysts to model
data for optimal accessibility and performance in reports, and move data from
the data warehouse or cloud storage to business systems. The ideal candidate
will be a natural collaborator and problem solver who possesses a high
intellectual curiosity and thrives in a dynamic, fast-paced environment.**

**Day-To-Day Responsibilities: - Creation and maintenance of enterprise cloud
data pipelines**

* **_Leveraging dbt to build and maintain data models for analysis_**
* **_Oversee administration (user provisioning and de-provisioning, monitoring budget, overseeing upgrades, etc.) of Data Engineering owned tools: Astronomer (Managed Airflow), Stitch (GUI Integration Tool), GitHub (Code versioning and CI/CD), dbt (Data Transformation Tool)_**
* **_Collaborate on administration (specifically monitoring cost and usage) of shared tools: GCP (BigQuery, Cloud Storage, Secret Manager)_**
* **_Set up batch data pipelines for new business systems (this includes writing code to ingest data, adding tests to ensure data integrity, modeling data into reporting layer for analysts)_**
* **_Monitor alerting channel and fix any issues with existing 27 data pipelines_**
* **_Serve as resource for stakeholders on query performance tuning and consulting on data results_**
* **_Build new data models as needed for business (for example: monthly subscription status, marketing attribution model, etc)_**