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)

Basic Qualifications: 

• 5+ years of experience in a similar role with a architectural purview 
• Experience with data orchestration tools like Airflow, Dagster, Stitch or Prefect, or writing custom ETL/ELT data pipelines with Python
• Experience with cloud OLAP databases like BigQuery, Redshift or Snowflake, writing DDL/DML operations in SQL as well as performance tuning queries
• Excellent troubleshooting and problem-solving skills, able to deal with ambiguity and problem-solve independently, as well as have a strong curiosity and passion to seek opportunities for automation and improved reliability
• Knowledge of BI Tools such as Tableau

Preferred Qualifications:

• Highly motivated, self-starter, organized, independent with an ability to effectively manage through change and prioritize efforts
• Strong aptitude for technology and the interest and drive to continually expand your technical skill set
• Fundamental analytical and conceptual thinking and problem-solving skills
• Ability to manage multiple projects simultaneously transparently as well as effectively collaborate across teams and to work in a diverse, fast-paced environment
• Proven ability to work in an ever-changing environment, ability to connect the dots and make decisions on your own feet 
• Exceptional communication skills including ability to take an independent stance when interfacing with cross functional stakeholders, while maintaining their respect and confidence

Perks & Benefits:

• $175,000 - $195,000 annual salary + bonus determined by the experience, knowledge, skills, and abilities of the applicant - Please note, our salary ranges are based on current market data. Should you feel strongly that we are not in line, we highly recommend you to reach out and let us know. We are always looking to improve on building the best place for employees.
• Equity 
• Flexible PTO Policy
• All the benefits: medical, dental, and vision insurance, 401(k) with employer match, short and long term disability coverage (paid by Facet), life insurance options and paid parental leave
• Certification reimbursement program 
• Work from anywhere in the US

Equal Opportunity Employer

We’ve consciously built an equitable and inclusive culture where everyone is welcome to bring their authentic selves to work. At Facet Wealth, we specifically look for individuals of varying strengths, skills, backgrounds, and ideas. We believe this gives us a competitive advantage to better serve our clients and employees.

All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status.