Design the cloud data warehouse behind our government analytics work, from the Snowflake account structure down to the models that people actually query.
What you'll do
Design the warehouse architecture in Snowflake: databases, schemas, roles, warehouses, ingestion and how data moves from raw to curated to reporting Build and review dimensional, data vault and lakehouse models that hold up as sources change and new questions come in Write and tune Snowflake SQL, stored procedures, tasks and streams, and manage storage, compute and cost Work inside Agile Scrum sprints with our engineers and analysts, and turn requirements into stories the team can deliver Tell us plainly where a design will break on real data volumes, real query patterns or real security rules Required: At least 5 years designing data warehouses on cloud and enterprise analytics platforms At least 3 years of hands-on Snowflake programming and database management At least 3 years working on Agile Scrum teams U.S. citizen or lawful permanent resident (U.S. person) Willing to be named on a federal proposal with a one-page resume, and to sign a short letter of commitment Preferred: 12 or more years of data modeling, including leading modeling work across dimensional, data vault and lakehouse designs SnowPro Core or SnowPro Advanced Architect certification dbt, Airflow, Fivetran, Matillion or comparable ingestion and transformation tools Experience with government data, including role-based access, data sharing an