The role involves designing and optimizing data pipelines in Snowflake, developing ETL workflows, collaborating on data integration, ensuring data security, and performance monitoring.
This is a remote position.
-
Snowflake Data Engineer & Developer
Position: Snowflake Data Engineer & Developer
Location: VA, MD, DC - Hybrid or Remote
Type: Full-time
Experience Level: Mid-Senior Level
Department: Data Engineering / Development
About the Role:
As a Snowflake Data Engineer & Developer working on the DoD’s Analytics Platform, you will design, develop, and optimize data pipelines, ensuring seamless data ingestion, transformation, and processing in Snowflake. You will collaborate with teams to integrate data from various sources, maintain data integrity, and ensure the platform supports DoD's mission-critical analytics.
Key Responsibilities:
- Data Pipeline Development: Build and manage efficient data pipelines for ingesting, transforming, and loading data into Snowflake.
- ETL/ELT Workflows: Develop and automate ETL/ELT processes using Snowflake, Snowpipe, and Streams & Tasks.
- Database Optimization: Design Snowflake database structures and optimize queries, ensuring high performance and scalability.
- Integration: Collaborate with other teams to integrate data from various sources (cloud, databases, APIs) into Snowflake.
- Data Security: Implement data encryption, role-based access controls (RBAC), and compliance with DoD IL5/IL6 standards.
- Data Transformation: Apply transformation logic and create reusable components for scalable data processing across the platform.
- Performance Monitoring: Monitor and tune performance, proactively identifying bottlenecks and optimization opportunities.
Required Qualifications:
- Experience:
- 3+ years of experience in data engineering, with at least 1 year of experience working with Snowflake.
- Proven experience in designing and implementing ETL/ELT workflows.
- Technical Skills:
- Proficient in SQL and Snowflake-specific capabilities (e.g., Time Travel, Snowpipe, Streams).
- Experience with cloud platforms (AWS, Azure), particularly data-related services.
- Knowledge of Python or Java for scripting and data automation.
- Security Clearance: Active U.S. DoD Secret Clearance (Top Secret/SCI preferred).
- Data Management: Experience in handling large-scale datasets, performing data integration, and ensuring data quality in a DoD or similar secure environment.
Preferred Qualifications:
- Certifications:
- Snowflake SnowPro Certification or equivalent.
- Cloud certifications (AWS or Azure) focusing on data.
- Data Tools: Experience with big data tools (e.g., Spark, Kafka, Hadoop).
- Automation: Familiarity with automation tools like Airflow and CI/CD pipelines for data workflows.
Why Join Us?:
- Directly support national defense and warfighter missions.
- Work on cutting-edge technology in the high-stakes environment of combat command analytics.
- Competitive compensation and benefits, along with growth opportunities in the DoD sector.
Similar Jobs
Information Technology • Insurance • Professional Services • Consulting
Design, develop, and maintain ELT/ETL Snowflake data warehouse solutions; implement data standards, CI/CD, monitoring, and production support; collaborate with product, business, and vendors; mentor junior developers and improve data engineering practices.
Top Skills:
AzureCi/CdData LakeData WarehouseEltETLGitMdmPower BISnowflakeSQLSsisSsrs
Fintech • Payments • Financial Services
Design, develop, test, maintain, and support secure, scalable data solutions using Snowflake and Databricks. Lead technical design, author specifications, review code, mentor engineers, ensure SDLC, audit/security compliance, and drive technical strategy while collaborating with architects and business partners. Participate in Agile ceremonies, be on-call as needed, and travel occasionally.
Top Skills:
AzureDatabricksEltETLPysparkPythonSnowflakeSQL
Cloud • Information Technology • Professional Services • Consulting
Design, implement, and optimize Snowflake data storage and ETL solutions. Write and tune SQL, integrate data sources and BI tools, ensure data security and compliance, and collaborate with teams to meet business objectives.
Top Skills:
ETLLookerSnowflakeSQLTableauTime TravelZero-Copy Cloning
What you need to know about the Seattle Tech Scene
Home to tech titans like Microsoft and Amazon, Seattle punches far above its weight in innovation. But its surrounding mountains, sprinkled with world-famous hiking trails and climbing routes, make the city a destination for outdoorsy types as well. Established as a logging town before shifting to shipbuilding and logistics, the Emerald City is now known for its contributions to aerospace, software, biotech and cloud computing. And its status as a thriving tech ecosystem is attracting out-of-town companies looking to establish new tech and engineering hubs.
Key Facts About Seattle Tech
- Number of Tech Workers: 287,000; 13% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Amazon, Microsoft, Meta, Google
- Key Industries: Artificial intelligence, cloud computing, software, biotechnology, game development
- Funding Landscape: $3.1 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Madrona, Fuse, Tola, Maveron
- Research Centers and Universities: University of Washington, Seattle University, Seattle Pacific University, Allen Institute for Brain Science, Bill & Melinda Gates Foundation, Seattle Children’s Research Institute
