Snowflake Data Engineer

Job Description

DPR is looking for an experienced Snowflake Data Engineer to join our Data and AI team and work closely with the Data Platform, BI, and Enterprise architecture teams to influence the technical direction of DPR’s data engineering and analytics initiatives.

You will work closely with cross-functional teams, including business stakeholders, data engineers, and technical leads, to ensure alignment between business needs and data architecture and define data models for specific focus areas.

• Design, build, and own the overall data architecture across the data platform — including the data lake, data warehouse, and data consumption layers.
• Develop, optimize, and manage conceptual and logical data architectures and integrations across both internal and external systems.
• Collaborate closely with engineering, data, and analytics teams to deliver business-critical data solutions.
• 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.
• Architect scalable, secure, and high-performance data platforms to support evolving business needs.
• Partner with strategic customers to understand their vision and ensure future requirements are incorporated into the platform roadmap.
• Design, build and own data models, data flows, and integration patterns for the data lake, data warehouse, and consumption data layers.
• Support data engineers in developing and managing conceptual, logical, and physical data models.
• Rapidly prototype high-priority solutions in cloud platforms, demonstrating their feasibility and business value.
• Participate in all phases of the project lifecycle and lead data architecture initiatives.

• Proven expertise in data analysis, data modeling, and data engineering with a focus on cloud- native data platforms.
• 5+ years of experience in data architecture leadership role, designing and delivering solutions at scale in cloud environments.
• Hands-on experience with secure and scalable enterprise data architectures using Microsoft Azure or AWS.
• Deep knowledge of Snowflake and DBT, with experience building robust data ingestion and ETL/ELT pipelines.
• Experience in designing data structures for data lakes and cloud data warehouses to support analytics and reporting.
• Strong proficiency in SQL, Python, and PySpark.
• Familiarity with agile methodologies, and experience working closely with cross functional teams to manage technical backlogs.
• Skilled in orchestrating and automating data pipelines within a DevOps framework.
• Strong communicator with the ability to present ideas clearly and influence stakeholders — with a passion for enabling data-driven transformation.

• Prolonged periods of sitting and/or standing at a computer screen.
• Must be able to sit or stand for long periods of time.
• Must be able to lift 15 pounds at times.
• Occasional domestic travel, via airplane, will be required for meetings.

This is a hybrid role with most time being spent working from home. Attendance at important meetings and events at the local DPR office is required.

DPR Construction is a forward-thinking, self-performing general contractor specializing in technically complex and sustainable projects for the advanced technology, life sciences, healthcare, higher education and commercial markets. Founded in 1990, DPR is a great story of entrepreneurial success as a private, employee-owned company that has grown into a multi-billion-dollar family of companies with offices around the world.

Working at DPR, you'll have the chance to try new things, explore unique paths and shape your future. Here, we build opportunity together—by harnessing our talents, enabling curiosity and pursuing our collective ambition to make the best ideas happen. We are proud to be recognized as a great place to work by our talented teammates and leading news organizations like U.S. News and World Report, Forbes, Fast Company and Newsweek.

Explore our open opportunities at www.dpr.com/careers.