Data Warehouse Developer (8777)

Job Description Morton is seeking an experienced Data Warehouse Developer to support the Data Strategy initiative and help build a modern, enterprise grade data platform for our client. This role focuses on designing, developing, and optimizing data pipelines and warehouse structures using AWS Glue, Snowflake, and Snowpipe. You will be responsible for transforming raw, disparate data into reliable, scalable, and well governed datasets that power analytics, reporting, and operational decision making across the agency. This role is FULLY ONSITE in North Chesterfield, VA. Responsibilities • Design, build, and maintain ETL/ELT pipelines using AWS Glue, including Glue Jobs, Workflows, Crawlers, and Catalog integration. • Develop and optimize Snowflake data models, schemas, and warehouse structures to support enterprise reporting and analytics. • Implement and manage Snowpipe for continuous data ingestion from structured and semi structured sources. • Collaborate with internal and external teams to understand data requirements, source system structures, and integration needs. • Build scalable, secure, and high performance data ingestion and transformation processes aligned with best practices. • Perform data profiling, data quality assessments, and root cause analysis for data issues across complex datasets. • Support data migration activities, including mapping, cleansing, validation, and reconciliation. • Develop and maintain documentation for data pipelines, data models, and operational processes. • Work closely with business stakeholders, SMEs, and technical teams to translate requirements into robust data engineering solutions. • Ensure compliance with data governance, security, and privacy standards across all data assets. • Optimize Snowflake performance through clustering, partitioning, caching, and query tuning. • Support ad hoc data engineering requests related to new integrations, data transformations, or enhancements. Qualifications • Proven experience as a Data Warehouse Developer, Data Engineer, or similar role. • Hands on expertise with AWS Glue, including Glue Studio, Glue Jobs (PySpark/Python), Glue Catalog, and Glue Workflows. • Strong experience with Snowflake, including schema design, Snowflake SQL, performance tuning, and data sharing. • Practical experience implementing Snowpipe for automated ingestion from cloud storage. • Strong SQL skills and experience working with large scale relational and cloud based databases. • Proficiency in Python for ETL/ELT development and automation. • Solid understanding of data modeling, data warehousing concepts, and ETL best practices. • Experience with data quality, data validation, and data reconciliation processes. • Ability to analyze complex data structures and troubleshoot data pipeline issues with precision. • Strong communication skills and ability to collaborate with cross functional teams. • Proficiency with Microsoft Office tools, especially Excel, for data validation and documentation. Education & Experience • Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or a related field. • Relevant certifications (AWS, Snowflake) are a plus.