Design, develop, and maintain scalable data pipelines and ETL/ELT processes using Snowflake and AWS services
Build and optimize data models, schemas, and warehouse architecture in Snowflake
Develop data integration solutions to consolidate data from multiple sources into our data lake and warehouse
Write efficient, maintainable Python scripts for data processing, transformation, and automation
Create complex SQL queries for data extraction, analysis, and reporting
Design and maintain data sources for Power BI and Tableau dashboards and reports
Collaborate with data analysts, business stakeholders, and BI teams to understand data requirements and optimize data delivery
Monitor and optimize data pipeline performance, troubleshoot issues, and ensure data quality.
Implement data governance and security best practices
Document data processes, workflows, and technical specifications

3+ years of experience as a Data Engineer or similar role
Strong hands-on experience with Snowflake (data warehousing, SQL optimization, stored procedures)
Proficiency in AWS services (S3, Lambda, Glue, Redshift, EMR, or similar)
Advanced SQL skills with experience in query optimization and performance tuning
Strong Python programming skills for data engineering tasks (pandas, PySpark, or similar libraries)
Experience building and maintaining ETL/ELT pipelines
Familiarity with Power BI and Tableau, including creating data connections and optimizing data models for BI tools
Understanding of data modeling concepts (star schema, snowflake schema, dimensional modeling)
Knowledge of version control systems (Git)
Strong problem-solving abilities and attention to detail

Data Engineer

Key skills