Snowflake Data Engineer & Developer

BizFirst LLC is focused on providing critical data solutions for the Department of Defense. They are seeking a Snowflake Data Engineer & Developer to design, develop, and optimize data pipelines for the DoD’s Analytics Platform, ensuring efficient data ingestion, transformation, and processing.

Responsibilities:

• Build and manage efficient data pipelines for ingesting, transforming, and loading data into Snowflake
• Develop and automate ETL/ELT processes using Snowflake, Snowpipe, and Streams & Tasks
• Design Snowflake database structures and optimize queries, ensuring high performance and scalability
• Collaborate with other teams to integrate data from various sources (cloud, databases, APIs) into Snowflake
• Implement data encryption, role-based access controls (RBAC), and compliance with DoD IL5/IL6 standards
• Apply transformation logic and create reusable components for scalable data processing across the platform
• Monitor and tune performance, proactively identifying bottlenecks and optimization opportunities

Requirements:

• 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
• 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
• Active U.S. DoD Secret Clearance (Top Secret/SCI preferred)
• Experience in handling large-scale datasets, performing data integration, and ensuring data quality in a DoD or similar secure environment
• Snowflake SnowPro Certification or equivalent
• Cloud certifications (AWS or Azure) focusing on data
• Experience with big data tools (e.g., Spark, Kafka, Hadoop)
• Familiarity with automation tools like Airflow and CI/CD pipelines for data workflows