Senior Data Engineer: Snowflake Data Lakehouse Architect

Cortrol Process Systems, Inc.; Chino (CA); On-site; USD 140,000 - 190,000; Full time

Job summary

Harrington Process Solutions is seeking a Senior Data Engineer to help shape our data architecture and hands-on pipelines. You will build and optimize a Snowflake data warehouse, design Bronze-Silver-Gold layers, and integrate with Profisee within our MDM environment.

You’ll develop complex SQL, mentor other engineers, and contribute to governance, lineage, and security across our enterprise data platform.

Qualifications

• 7+ years of data engineering experience with exposure to data architecture.
• Bachelor’s degree in CS/IS/DS or equivalent experience.
• Strong hands-on Snowflake, including performance tuning, Snowpipe, Streams, Tasks, and cost optimization.
• Experience designing data warehouses/lakehouses and medallion architecture.
• Strong experience with Azure Data Factory, Azure Data Lake, and/or Azure Functions.
• Advanced SQL skills and experience building production data pipelines.
• Strong understanding of data modeling and schema design.
• Ability to communicate technical decisions to both technical and non-technical audiences.
• Experience mentoring or guiding other engineers.

Responsibilities

• Help design Harrington’s long-term data lakehouse/data warehouse architecture.
• Design, build, and optimize the Snowflake data warehouse including schemas, security, performance, and cost management.
• Develop Bronze, Silver, and Gold data layers using medallion architecture principles.
• Build and maintain data pipelines using Azure Data Factory, Snowflake, and other modern data tools.
• Partner with our MDM team to support Profisee integrations, data quality, and golden-record pipelines.
• Develop complex SQL, views, stored procedures, validation logic, and KPI queries.
• Help migrate downstream applications from direct SQL feeds to a trusted Snowflake data path.
• Provide technical guidance and mentorship to other engineers and developers.
• Establish engineering standards and support data governance, lineage, access controls, and documentation.
• Partner with external vendors and ensure solutions align with Harrington’s long-term architecture.

Skills

Snowflake

Azure Data Factory

SQL

Data modeling

Medallion architecture

Data lakehouse

Data architecture

Mentoring

Communication

Education

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

Tools

Profisee

Apache Iceberg

Delta Lake

Fivetran

dbt

Python

Power BI

Job description

Harrington Process Solutions is seeking a Senior Data Engineer to help shape our data architecture and hands-on pipelines. You will build and optimize a Snowflake data warehouse, design Bronze-Silver-Gold layers, and integrate with Profisee within our MDM environment.

You’ll develop complex SQL, mentor other engineers, and contribute to governance, lineage, and security across our enterprise data platform.