Dpr Construction banner

Snowflake Architect/Admin

Dpr Construction

The Role

Overview

Lead Snowflake data architecture, performance, security, and AI integration across cloud platforms

Key Responsibilities

  • data architecture
  • snowflake
  • data pipelines
  • security management
  • ai integration
  • performance tuning

Tasks

-Develop, optimize, and manage conceptual and logical data architectures and integrations across both internal and external systems. -Design, build, and own the overall data architecture across the Snowflake data platform — including the data lake, data warehouse, and data consumption layers. -Implement and manage vectorized data pipelines for semantic search and retrieval-augmented generation (RAG) within Snowflake. -Implement and manage Snowflake's security features, such as access controls, encryption, and data masking. -Support the AI team with generative AI use cases powered by Snowflake’s LLM functions, such as text summarization, classification, and Q&A on enterprise data. -Design scalable, secure, and high-performance data pipelines to support evolving business needs. -Collaborate closely with engineering, data, and analytics teams to deliver business-critical data solutions. -Participate in all phases of the project lifecycle and lead data architecture initiatives. -Leverage Snowflake Cortex to enable natural language query experiences, document understanding, and AI-driven insights directly within the Snowflake environment. -Experiment with prototype solutions using the latest Snowflake features, demonstrating practical use cases and driving early adoption across the business. -Partner with strategic customers to understand their vision and ensure future requirements are incorporated into the platform roadmap. -Stay current with evolving Snowflake AI capabilities (Cortex, Snowpark Container Services, Document AI, and Feature Store) and apply them to improve data accessibility and intelligence. -Monitor and optimize Snowflake performance, including query performance tuning, resource allocation, and cost management. -Drive high priority data initiatives using Azure/AWS as well as Snowflake & DBT. The role may also extend into some advanced Analytics and AI concepts

Requirements

  • snowflake
  • dbt
  • azure/aws
  • sql
  • python
  • devops

What You Bring

-Experience in designing data structures for data lakes and cloud data warehouses to support analytics and reporting. -Strong communicator with the ability to present ideas clearly and influence stakeholders — with a passion for enabling data-driven transformation. -Familiarity with agile methodologies, and experience working closely with cross functional teams to manage technical backlogs. -Understanding of vector embeddings, model governance, and prompt-driven analytics within Snowflake. -Strong proficiency in SQL, python, git and working with Snowpark DataFrames and UDFs for AI model integration. -Hands-on experience with secure and scalable enterprise data architectures using Microsoft Azure or AWS. -Skilled in orchestrating and automating data pipelines within a DevOps framework. -Hands-on experience with Snowflake Cortex, Snowpark ML, or Snowflake’s AI/ML features for model training, deployment, or inference. -10+ years of experience in data architecture and engineering, with at least 5+ years of experience in Snowflake designing and delivering solutions at scale in cloud environments. -Deep knowledge of Snowflake and DBT, with experience building robust data ingestion and ETL/ELT pipelines.

The Company

About Dpr Construction

-A forward-thinking construction company that has grown from a small operation to a nationwide leader in the industry. -Focuses on complex, large-scale projects and is known for its expertise in delivering innovative, high-quality construction solutions. -Successfully completed projects across a range of sectors, including commercial, healthcare, education, and data centers, standing out for its ability to manage large budgets and tight schedules. -Notably completed several landmark projects, including high-tech facilities and cutting-edge educational buildings, often involving collaboration with some of the largest tech and medical organizations in the world. -Strong track record in renewable energy, particularly in solar and energy-efficient construction, positioning them as a leader in sustainable building practices. -Approach to construction is driven by technology and innovation, consistently pushing boundaries to ensure maximum efficiency and quality in its operations. -Commitment to performance and safety has earned a reputation for delivering projects that meet and exceed client expectations. -From healthcare campuses to advanced research labs, the company’s dedication to excellence ensures each project is tailored to the unique needs of the client and the community.

Sector Specialisms

Mission Critical

Office

Healthcare

Pharmaceutical

Life Sciences

Technology

Data Centers

Education

Commercial

Industrial

Residential

Government

Renewables

Self-Perform Work

Concrete

Demolition

Mass Timber

Electrical

Specialty Finishes

Field Technology

Division 7 scopes

Division 10 scopes

Doors, frames and hardware

Framing & Drywall

Finish carpentry