Responsibilities
- Design, build, and maintain scalable ELT/ETL pipelines (FiveTran, DBT, Python,Snowpipe) in Snowflake.
- Integrate workflows using AWS services (S3, Lambda, Glue, Athena, CloudWatch).
- Administer and optimize Snowflake (user roles, warehouse sizing, access, performance).
- Develop and maintain dimensional/normalized data models in Snowflake.
- Implement data transformation logic with DBT and SQL for accuracy and maintainability.
- Transform raw data into reliable datasets for analytics and operations.
- Collaborate with teams to understand data requirements and deliver solutions.
- Ensure high data quality, consistency, and security.
- Monitor and troubleshoot pipelines, implementing logging/alerting.
- Participate in code reviews, documentation, and promote data engineering best practices.
Requirements
- B.S./M.S. in Computer Science or related field.
- 5-7 years in software development, 5+ in data/analytics engineering.
- Expertise in Snowflake, DBT, FiveTran, and SQL in production.
- Experience designing/managing AWS data pipelines.
- Strong problem-solving, communication, and cross-functional skills.
- Knowledge of data governance, performance tuning, and security.
Nice to Have
- Exposure to Shopify, NetSuite, or Segment.
- Experience with Python and Looker or other BI Visualization tools is preferred
- Experience in e-commerce, SaaS, or financial analytics environments.
- Familiarity with orchestration tools such as Airflow, Dagster, or similar frameworks.
