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