Develop a solution to integrate case management business data into Snowflake EDW on a near real-time basis
Produce and maintain dimensional data models for the data marts
Develop and maintain downstream data marts and their corresponding ETL/ELT processes
Develop and maintain comprehensive documentation including the STTMs, data models, and testing documents
Develop, deploy and maintain data presentation and data reports using presentation tools
Design and develop data ingestion, ETL/ELT pipelines, and transformation logic
Implement robust, reusable data services supporting analytics and reporting
Collaborate with architects to implement logical and physical data models in Snowflake
Develop and maintain high-quality, testable code using secure coding standards
Integrate data pipelines with cloud services, messaging, and storage components
Optimize pipeline performance and scalability
Support CI/CD-enabled deployments including automated testing
Participate in code reviews, design reviews, and sprint ceremonies
Support incident resolution and root cause analysis for data pipeline failures
Produce and maintain technical documentation and runbooks

Requirements

Bachelor's degree in Computer Science or relevant computer-based major
8 years of IT related experience with 7+ years’ experience in developing IT and cloud infrastructures
Experience in software engineering and design architectures
Experience and understanding of best practices regarding system security measures
Experience in conducting research for advanced technologies
Experience with AWS data and compute services
Experience with Airflow or equivalent orchestration tools
Proven track record in software and data engineering roles
Strong proficiency with SQL and data transformation techniques
Hands-on experience with Snowflake
Familiarity with Agile/Scrum delivery environments
Experience working in regulated or compliance-driven environments
Experience supporting federal EDW or analytics programs
Excellent presentation and communication (oral and written) skills

Benefits

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLETLELTdata modelingdata ingestiondata transformationdata servicescloud infrastructuresoftware engineeringsystem security

Soft Skills

communicationpresentationcollaborationproblem-solvingroot cause analysiscode reviewdesign reviewagile methodologyteamworkdocumentation