Lead Analyst, Data Platform Engineering

Location:

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

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.

• 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

• 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

• 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

• 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

• 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

• Bachelor’s degree in Computer Science, Information Systems, or a related technical field
• 5+…