Lead Data Engineer

As a Data Engineer at Tide, you will be responsible for building and running data pipelines and services to support business functions, reports, and dashboards. You will work with technologies such as BigQuery/Snowflake, Airflow, Stitch/Fivetran, dbt, Tableau/Looker to enhance our business intelligence capabilities. Your role involves developing end-to-end ETL/ELT pipelines, mentoring junior engineers, troubleshooting technical issues, and improving data pipeline delivery. - Developing end to end ETL/ELT Pipeline in collaboration with Data Analysts - Designing, developing, and implementing scalable, automated processes for data extraction and analysis - Mentoring Junior Engineers in the Team - Acting as an expert for data technologies and solutions - Providing troubleshooting and diagnosis for architecture and design challenges - Translating business requirements into technical specifications - Owning the delivery of data models and reports - Performing exploratory data analysis and implementing tests for data quality assurance - Optimizing data feeds and ensuring availability at required times - Discovering, transforming, testing, deploying, and documenting data sources - Implementing data warehouse governance practices - Building Looker Dashboard for specific use cases - 4+ years of development experience with Snowflake or similar data warehouse technology - Proficiency in dbt and other modern data stack technologies like Snowflake, Apache Airflow, Fivetran, AWS, git, Looker - Experience with agile processes such as SCRUM - Strong skills in writing advanced SQL statements and performance tuning - Knowledge of data ingestion techniques using tools like Fivetran - Expertise in data modeling and optimizing data models - Experience in data mining, data warehouse solutions, ETL processes, and using databases in a business environment - Familiarity with architecting analytical databases in Data Mesh architecture - Working in agile cross-functional delivery teams - High development standards including code quality, testing, continuous integration, and deployment - Strong technical documentation skills - Business-level English proficiency and good communication skills - Basic understanding of systems across the AWS platform,