W Role Lead Data Engineer Hybrid

Position Responsibilities:

As a Lead Data Engineer, you will play a key role in designing, building, and maintaining robust data pipelines and the Snowflake data platform on AWS. You will collaborate with cross-functional teams-including data analysts, BI developers, application engineers, and business stakeholders-to ensure the delivery of well-modeled, trustworthy data that serves analytics, reporting, and business intelligence needs. Your combined hands-on technical expertise and leadership will ensure that data assets are reliable, performant, and secure.

Key responsibilities include:

• Designing and building batch and near-real-time data pipelines on AWS using services such as S3, Glue, Lambda, and Step Functions.
• Developing and maintaining Snowflake data models-across raw, staging, and reporting layers-to support analytics and reporting.
• Loading and transforming data in Snowflake, utilizing Snowpipe, Streams and Tasks, and external stages for automation and efficiency.
• Integrating data from internal applications, SaaS platforms, and third-party sources through APIs and file-based feeds.
• Performing Snowflake performance tuning/cost optimization by managing warehouse sizing, query optimization, and usage monitoring.
• Building data quality checks, monitoring systems, and alerting mechanisms to proactively identify and resolve data pipeline failures and issues.
• Applying data security and governance best practices, including role-based access controls and data masking for compliance and confidentiality.
• Collaborating with application teams working on .NET-based systems to source data, implement integrations, and ensure data reliability.
• Documenting data flows, data models, and pipeline processes, and participating in code reviews for continuous improvement.

Essential Skills, Experience

To excel in this role, you will need the following expertise and qualities:

• 8+ years of hands-on data engineering experience, with a minimum of 2 years in a technical lead or supervisory capacity.
• Extensive experience with Snowflake, including end-to-end data modeling, SQL development, and performance optimization/tuning.
• Demonstrated experience with AWS data services, specifically S3, Glue, Lambda, and Step Functions, in a production environment.
• Advanced SQL expertise and a strong understanding of data warehousing fundamentals, such as dimensional modeling and ELT best practices.
• Working proficiency with C#/.NET, including reading, supporting, or building data integrations with .NET-based applications.
• Familiarity with Git for version control and best practices in continuous integration/continuous deployment (CI/CD).
• Excellent communication skills and an ability to work collaboratively across diverse technology and business teams.
• Bachelor's degree in Computer Science, Engineering, or a related technology field-or equivalent professional experience.

Qualifications:

• Experience with dbt, Python, or Airflow preferred.
• Familiarity with infrastructure-as-code practices using Terraform or CloudFormation is a plus.
• Exposure to reporting and BI tools such as Power BI, Tableau, or others that integrate with Snowflake.
• Background in events, hospitality, or customer engagement data is an advantage.
• Relevant technical certifications-such as SnowPro Core or AWS Data Engineer (Associate)-are desirable.