Senior Data Engineer-Onsite at Portland, OR

Job Title: Sr. Data Engineer

Location: Portland, OR – Onsite

Job Type: Contract

Experience: 14 Years – Mandatory

Interested candidates are required to include their LinkedIn URL, email address, and cell phone number along with their resume when submitting their profile.

Mandatory Requirements

Candidates must have strong hands-on experience in the following:

• DBT
• Snowflake
• Advanced SQL
• Python
• Data Modeling
• CI/CD
• Healthcare Domain Experience

Roles & Responsibilities

• Design and implement scalable data models and data pipelines aligned with business requirements.
• Develop complex DBT models using advanced features, including macros, packages, and custom materializations.
• Work extensively with Snowflake for query and warehouse performance optimization.
• Develop and optimize complex SQL queries using CTEs, complex joins, analytic and window functions.
• Perform data profiling, including analysis of keys, cardinality, data types, precision, scale, and data skew.
• Implement and support data quality and testing frameworks.
• Support CI/CD processes for DBT deployments.
• Develop and maintain data models supporting healthcare and payer-related data requirements.
• Collaborate with business and technical teams to translate requirements into scalable data solutions.

Key Skills & Expertise

• Advanced SQL – CTEs, complex joins, analytic & window functions
• Snowflake – query & warehouse performance optimization
• DBT – advanced models, macros, packages & custom materializations
• Python – intermediate or higher
• Data Profiling – keys, cardinality, data types, precision, scale & skew
• Data Quality & Testing Frameworks
• CI/CD for DBT deployments
• Data Modeling
• Healthcare/Payer experience