Data Engineer

Job Description:

• Design, build, and maintain scalable and secure data architecture in Snowflake
• Develop and optimize Snowflake objects, including tables, dynamic tables, views, and warehouses
• Manage Snowflake security and access
• Partner with the Integration team on ETL pipelines in and out of the data warehouse using Snowflake-native tools, Informatica, and MuleSoft
• Build and manage deployment of Snowflake changes across environments, including production, using GitHub
• Ensure data quality, integrity, and lineage across pipelines
• Write and optimize query performance and warehouse usage
• Monitor Snowflake compute costs
• Develop scripts for moving data and ETL/ELT between AWS and Snowflake
• Work with AWS, S3, Azure, GCP, and blob storage
• Support the production Enterprise Data Warehouse environment, including ingestion and transformation issues
• Perform unit testing and clearly document builds
• Partner with data analysts, governance, and Business Intelligence teams to enable analytics
• Support the Data Architect and Business Intelligence teams with optimized data models
• Translate business requirements into scalable data solutions
• Maintain working knowledge of the organization’s mission and programs
• Perform other related duties as assigned

Requirements:

• Bachelor’s degree in Computer Science, Information Systems, or related field
• 5+ years of designing and implementing a fully operational production-grade large-scale data solution
• Hands-on experience with Snowflake Data Cloud
• Understanding of enterprise data management concepts, including governance, engineering, science, lake, warehouse, sharing, and applications
• Experience using GitHub for deployments
• Strong SQL skills
• Experience with cloud platforms such as AWS, Azure, or GCP
• Knowledge of data modeling techniques, including Kimball and Data Vault
• Excellent written and verbal presentation and communication skills
• Ability to problem solve in an environment with unclear requirements
• Weekend and evening work may be required

Benefits:

• Medical insurance
• Dental insurance
• Vision insurance
• Life insurance
• Flexible spending accounts
• 403b retirement plan
• Generous paid time off
• Federal paid holidays
• Wellness program
• Employee assistance program
• Annual incentive plan
• Competitive benefits package
• Reasonable accommodations for individuals with disabilities