Requirements
- 7+ years experience in data engineering
- Experience in development of pipelines to ingest and transform data from sources using REST APIs, AWS S3 and Airflow
- Experience in building dbt models to transform data using Medallion architecture
- Experience in designing and building dimensional data models from scratch with Type 2 SCDs and star schemas
- Experience in maintaining data warehouses on SQL Server
- Experience in designing and building at least one data warehouse on Snowflake from scratch
- Be the Snowflake and dbt expert on the team, providing guidance on best practises
- Make key design decisions for a brand new multi-dimensional data model
- Make key architectural decisions for building a brand new data warehouse on Snowflake
- Build and maintain pipelines to ingest data from Salesforce and various other data sources
- Build and maintain dbt models to transform data using Medallion architecture for use by business intelligence tools
- Work closely with our Business Intelligence team - monitoring and implementing enhancement requests for the data warehouse to meet the reporting demands of stakeholders
- Strong SQL skills (CTEs and window functions)
- Proficiency in Python for building pipelines with Snowpark
- Experience designing multi-dimensional data models with star schema and Type 2 SCDs
- Experience with dbt for building robust ELT processes
Work Arrangement
Remote (Worldwide)
Team
Structure: international data team
Additional Information
- The role involves collaboration with team members in different time zones.
- Strong interpersonal skills are important.
- Opportunity to develop mentoring skills as the team expands.
- Lyra uses artificial intelligence (AI) tools to support parts of the hiring process, including reviewing applications, analyzing resumes, summarizing interviews, or assessing responses. Final hiring decisions are made by humans.
