Lead Platform Engineer - Data & AIYour role at DynatraceThe Lead Platform Engineer, Data & AI is responsible for designing and developing solutions for the operational health, governance, and continuous improvement of the data platform, owning Snowflake administration, data pipeline/dbt administration, and the automation of the broader data technology stack from end to end. This is a hands-on operational and engineering role. The right candidate combines deep platform administration skills with a systems-thinking mindset: they identify manual processes and eliminate them through automation, maintain platform reliability at scale, and are beginning to explore how AI agent capabilities can extend the value delivered to data consumers.
Key Responsibilities:
- Snowflake Platform Administration: Own Snowflake administration end-to-end across development, staging, and production environments consolidating instances, covering warehouse sizing and cost governance, query optimization, object lifecycle management, RBAC design, Row-Level Security policy implementation, and access provisioning automation. Maintain platform health through proactive monitoring, manage Snowflake feature adoption (Streams, Tasks, Dynamic Tables, Snowpipe), and act as the primary escalation point for Snowflake performance and access issues.
- dbt Administration & Governance: Administer the dbt project and deployment infrastructure - owning project configuration, model architecture standards, environment and job management, test coverage enforcement, documentation requirements, and model promotion workflows across environments. Monitor dbt run health and lineage, configure observability tooling (Elementary or equivalent), and partner with analytics engineers to review and certify models for production use.
- Data Stack Automation & Operations: Automate the operational layer of the data technology stack - including ETL/ELT tool administration (Fivetran, etc), RBAC and access provisioning via Terraform or scripting, alerting and notification pipelines for data quality and platform health, and CI/CD release workflows for dbt and platform configuration. Reduce manual operational toil by building reusable automation frameworks that make routine platform tasks fast, auditable, and self-service where appropriate.
This is a remote eligible position. Candidates who sit within a 45 mile radius of Boston, MA; 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.
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.
