Lead Analyst, Data Platform Engineering

Burtch Works; Scottsdale (AZ); Remote; USD 140,000 - 190,000; Full time

Job summary

Burtch Works is seeking a Lead Analyst, Data Platform Engineering for a client in the US. You will own Snowflake administration, data pipelines, and agent-enabled AI initiatives across multi-account environments.

You will design and maintain curated data layers powering dashboards and AI copilots, while collaborating with data architecture and BI teams. The role emphasizes security, reliability, and continuous platform innovation, including testing Private Preview features and enabling

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, or a related technical field.
• 5+ years of experience in data engineering, database/platform administration, or business intelligence.
• 1+ year of hands-on experience administering Snowflake or a similar cloud data platform in production.
• Hands-on experience with a multi-account Snowflake architecture.
• Strong SQL programming skills.
• Experience with data ingestion and ETL/ELT tools (e.g., Fivetran/HVR, Matillion, dbt, Coalesce, Postman).
• Familiarity with AI/LLM enablement and tools such as Claude, ChatGPT, Microsoft Copilot, GitHub Copilot, and Snowflake Cortex Code.
• Familiarity with agile development practices.
• Strong analytical and critical thinking skills with a focus on practical problem-solving within constraints.
• Strong technical documentation skills.
• Excellent oral and written communication skills, with the ability to work cross-functionally with IT and business leads daily.

Responsibilities

• Snowflake Platform Administration: manage users, roles, warehouses, RBAC/RLS/CLS, security policies, and configurations; monitor health, performance, and cost; audit security issues; manage inter-account availability; evaluate Private Preview features.
• Data Pipeline & Ingestion Engineering: design, build, and maintain ingestion pipelines; transform workflows across Foundation, Processed, and Curated layers; monitor and troubleshoot pipelines; onboard new data sources.
• AI & Agent Enablement: enable, test, and roll out AI applications and copilots; configure agents and integratons; collaborate on context-layer efforts for queries.
• Curated Data & Semantic Views: build curated datasets and models; design Semantic Views; work with BI tools to meet reporting needs; ensure data production-readiness.
• Organizational Support & Enablement: serve as go-to Snowflake expert; document architecture and runbooks; train team members and business users.

Skills

SQL programming

Data engineering

Analytics & problem solving

Documentation

Cross-functional collaboration

Communication

Agile development

Education

Bachelor’s degree in Computer Science, Information Systems, or related field

Master’s degree (preferred)

Tools

Snowflake

Fivetran/HVR

Matillion

dbt

Coalesce

Postman

Tableau

Sigma

Job description

Location: Remote - Scottsdale, AZ; La Porte, TX; or Boise, ID preferred (candidates willing to work PT hours strongly preferred)

About The Role

Our client, a large national industrial services organization, is seeking a Lead Analyst, Data Platform Engineering to serve as the team’s primary Snowflake administrator and data pipeline engineer. This person will own the day-to-day security, performance, and reliability of a multi-account Snowflake platform, build pipelines that ingest data from a wide range of sources, and develop the curated, agent-ready data layers that power the enterprise BI and AI ecosystem. The role plays a lead part in enabling AI applications such as Claude and ChatGPT across the organization, including configuring and monitoring AI agents, building semantic views, and managing data shares between Snowflake accounts. The Lead Analyst will also activate and test Snowflake Private Preview capabilities, helping the team stay ahead of platform innovation and bring new features into production.

Key Responsibilities

Snowflake Platform Administration

• Serve as primary Snowflake administrator for the organization’s Discovery accounts, managing users, roles, warehouses, RBAC/RLS/CLS, security policies, and account-level configurations
• Monitor platform health, performance, and cost, tuning workloads to meet business SLAs
• Audit and remediate security issues
• Manage availability between Snowflake accounts and partner platforms, both cloud and on-prem
• Activate, test, and evaluate Snowflake Private Preview capabilities (e.g., Agent, CoWork, and Semantic enhancements, new ingestion or compute features) ahead of general availability, documenting findings and recommending adoption strategies

Data Pipeline & Ingestion Engineering

• Design, build, and maintain pipelines ingesting data from internal and external sources via CDC/mirror replication, API-based ingestion, custom scripts, and batch and file-based loads
• Build and maintain transformation workflows across the Foundation, Processed, and Curated layers of the enterprise data warehouse
• Monitor pipeline and job performance, troubleshoot failures, and resolve data quality or timeliness issues
• Partner with source system owners and corporate teams to onboard new data sources and define ingestion standards
• Document pipeline design, dependencies, and data lineage to support governance and troubleshooting

AI & Agent Enablement

• Support enablement, testing, and rollout of AI applications and copilots (e.g., Claude, ChatGPT/Copilot, Snowflake Cortex Agents) across the analytics organization
• Set up, configure, and monitor agents (e.g., Executive Agent, BI Agent, Ontology Agent), including MCP server-based agent-to-agent integrations
• Partner with the data architecture team on context-layer efforts (ontology, knowledge graph) so agents can reliably query curated business data

Curated Data & Semantic Views

• Build and maintain curated data sets and business data models that feed dashboards, semantic views, and downstream agents
• Design and maintain Semantic Views supporting Cortex Analyst and other AI/BI consumption layers
• Partner with BI and analytics teams (Sigma, Tableau) to ensure the curated layer meets reporting and self-service needs
• Review data for accuracy and production-readiness before release to business users and agents

Organizational Support & Enablement

• Act as a go-to resource across the Data & Analytics team for Snowflake capabilities, new feature adoption, and platform best practices
• Document platform architecture, runbooks, and how-to guides for the team and business users
• Train team members and business users on new tools, features, and capabilities

Required Qualifications

• Bachelor’s degree in Computer Science, Information Systems, or a related technical field
• 5+ years of experience in data engineering, database/platform administration, or business intelligence
• 1+ year of hands‑on experience administering Snowflake or a similar cloud data platform in production
• Hands‑on experience with a multi-account Snowflake architecture
• Strong SQL programming skills
• Experience with data ingestion and ETL/ELT tools (e.g., Fivetran/HVR, Matillion, dbt, Coalesce, Postman)
• Familiarity with AI/LLM enablement and tools such as Claude, ChatGPT, Microsoft Copilot, GitHub Copilot, and Snowflake Cortex Code
• Familiarity with agile development practices
• Strong analytical and critical thinking skills with a focus on practical problem‑solving within constraints
• Strong technical documentation skills
• Excellent oral and written communication skills, with the ability to work cross‑functionally with IT and business leads daily

Preferred Qualifications

• Master’s degree
• Snowflake certification (SnowPro Core or Advanced)
• Experience with BI and visualization tools such as Tableau or Sigma
• Understanding of agentic architectures, including MCP servers and agent‑to‑agent communication