Lead Platform Engineer - Data &

Your role at Halcyon Labs The Lead Platform Engineer, Data Denver, CO; Detroit, MI will be required to work hybrid (2 days per week in office). All candidates will be required to work EST hours. What will help you succeed Minimum Requirements 6+ years of hands-on data platform experience, with direct ownership of a Snowflake environment at production scale. Preferred Requirements Deep Snowflake DBA skills: virtual warehouse sizing, auto-suspend and scaling policy configuration, multi-cluster warehouse management, and credit cost governance. Snowflake RBAC design: functional role hierarchy design, privilege grants, service account management, and systematic access provisioning - not one-off manual grants. Row-Level Security implementation using Snowflake row access policies for multi-tenant or restricted datasets. Snowflake feature ownership: Streams, Tasks, Dynamic Tables, Snowpipe, External Stages, Data Sharing, and Secure Views in production workloads. Query profiling and optimization: reading query profiles, identifying bottleneck operators, applying clustering keys, and resolving warehouse contention. Deep experience administering dbt project end-to-end - model architecture (staging / intermediate / marts), incremental and snapshot patterns, and environment separation dbt Cloud or dbt Core deployment administration: job scheduling, environment variable management, run monitoring, failure alerting, and model promotion across dev/staging/prod. Test coverage governance: enforcing schema tests, data tests, and source freshness checks as mandatory gates before production promotion. dbt observability: configuring and maintaining Elementary, or equivalent tooling - including artifact-based monitoring, model health dashboards, and freshness tracking against Snowflake account usage Experience partnering with analytics engineers to review model design, optimize underperforming models, and maintain lineage and metadata for downstream governance. Platform-level administration of Fivetran or Matillion: connector governance, sync scheduling, schema drift policy, user and environment management, and operational escalation handling. Alerting and notification automation: configuring and owning alerts for pipeline failures, data quality breaches, SLA violations, and Snowflake cost spikes - routed to Slack, PagerDuty, email, or ServiceNow with actionable diagnostic context. CI/CD for the data platform: GitHub Actions or GitLab CI pipelines for dbt, Terraform, and ETL tool configuration with environment promotion gates, automated testing, and rollback on failure. Strong Python and SQL: used for automation scripting, operational tooling, and platform health monitoring, not just pipeline development. Hands-on experience enabling Snowflake Cortex AI features, Cortex Analyst semantic model configuration, Cortex Search index setup, and production use of LLM functions Experience developing analytics agents on behalf of business stakeholders, connecting Snowflake data to Slack or other collaboration tools via bot APIs, webhooks, or slash commands so users can query data and receive insights in their workflow. Practical experience configuring or fine-tuning LLMs (Cortex, OpenAI, Anthropic Claude, or Azure OpenAI) including prompt engineering, system instruction design, and parameter tuning to improve accuracy on governed data. Ability to design and maintain a semantic data layer, verified views, curated schemas, and structured metadata that grounds LLM-generated outputs in accurate, governed Snowflake data. Snowflake SnowPro Core, SnowPro Advanced, or Cortex AI certification. Experience with multi-agent frameworks (LangChain, LangGraph, or AutoGen) applied to enterprise data workflows. Why you will love being a Halcyon Labsr A one-product software company creating real value for the largest enterprises and millions of end customers globally, striving for a world where software works perfectly. Working with the latest technologies and at the forefront of innovation in tech on scale; but also, in other areas like marketing, design, or research. A team that thinks outside the box, welcomes unconventional ideas, and pushes boundaries. An environment that fosters innovation, enables creative collaboration, and allows you to grow. A globally unique and tailor-made career development program recognizing your potential, promoting your strengths, and supporting you in achieving your career goals. A truly international mindset that is being shaped by the diverse personalities, expertise, and backgrounds of our global team. A relocation team that is eager to help you start your journey to a new country, always there to support and by your side. Attractive compensation packages and stock purchase options with numerous benefits and advantages. Compensation and Rewards DOE, salary $140K - $163K, plus Health, Dental, Life, STD, LTD, 401K, PTO. Total compensation may vary depending on candidate experience/education and location. All your information wi