Role Description The Data Engineer position is responsible for designing, building, and maintaining robust data infrastructure and automation solutions that support our organization's data-driven initiatives. This role will work closely with cross-functional teams to develop scalable data pipelines, optimize data workflows, and ensure high-quality data delivery across the enterprise. This position requires strong technical expertise in Python and SQL programming, along with experience in modern data engineering tools and cloud platforms. What You’ll Do - Design, build, and maintain scalable data pipelines within Snowflake from multiple sources. - Build and maintain medallion architecture (bronze/silver/gold layers) for data lake solutions. - Design data models that support both business intelligence and AI requirements. - Lead cloud-native data platform evolution, integrating Snowflake with AWS. - Collaborate with business analysts, data scientists, and stakeholders to understand data requirements and translate them into technical specifications. - Implement data quality frameworks and monitoring systems to ensure accuracy, completeness, and consistency of data assets. - Develop and maintain comprehensive documentation for data pipelines, models, and processes. - Optimize query performance and resource utilization to reduce costs and improve processing times. - Participate in on-call rotation to support production data systems and resolve incidents. Qualifications - Bachelor's degree in Computer Science, Information Systems, Data Engineering, Mathematics, Statistics, or related technical field or equivalent relevant experience required. - 5+ years of hands-on data engineering experience building production-scale data systems. - Snowflake proficiency: warehouses, databases, roles, RBAC, Snowpipe, streams, tasks, and performance optimization. - Strong SQL mastery: complex queries, window functions, CTEs, query optimization, and database design. - Programming proficiency: Python for data transformation, automation, and pipeline development. - Cloud platform experience: Deep knowledge of AWS data services and architecture patterns. - Version control and CI/CD: Git, GitHub/GitLab, automated testing, and deployment pipelines. - Orchestration expertise: Apache Airflow or similar workflow management tools. - Excellent communication skills with ability to explain technical concepts to non-technical stakeholders. - Experience in financial services or highly regulated industries preferred. - Familiarity with data governance tools and frameworks preferred. - Experience with Snowflake engineering processes preferred. - Certifications: Snowflake SnowPro Core and AWS Cloud practitioner preferred. - Understanding of business intelligence, machine learning workflows, and AI practices preferred. Benefits - Medical, Dental and Vision Insurance. - Health Savings Account (HSA), Health Reimbursement Account (HRA) & Flexible Spending Accounts (FSA). - Short- and Long-Term Disability Plan. - Group Life Insurance. - 401K Salary Deferral Plan. - Wellness Program. - Education & Tuition Expense Reimbursement. - PTO and Unique Vacation Purchase Program. - Nationwide Pet Insurance Coverage.