Data Engineer II: Kimball DW & Modern Pipelines

BlueLabs, Inc.; Oregon; Hybrid; USD 95,000 - 125,000; Full time

Benefits offered by this job

Health insurance

401K matching

Unlimited vacation leave

Paid sick, personal, and volunteer/hol

Job summary

BlueLabs is seeking a Data Engineer II in the United States to advance the data platform’s maturity by elevating data quality, leading platform modernization, and migrating legacy systems to Kimball/star schema architecture.

You will own complex engineering work, drive data modeling standards, and mentor Data Engineer I teammates while collaborating with analysts and stakeholders to meet current and future reporting needs.

Qualifications

• 5+ years in data engineering with ownership of complex data platform initiatives.
• Dimensional modeling expertise (Kimball) and star/snowflake schemas.
• Experience migrating data warehouses or modernizing platforms.
• Advanced SQL and Python producing production-grade, tested code.
• dbt proficiency: tests, macros, packages, and documentation generation.
• Hands-on with Snowflake and Redshift and modern data stack tooling.
• Data quality frameworks, validation pipelines, and monitoring.
• Autonomous with ability to progress work in evolving problem spaces.
• Strong communication to engineers and non-engineering stakeholders.
• Passion for social impact and cross-functional teams.

Responsibilities

• Partner directly with the Director of Data to translate platform vision into engineering execution.
• Lead the design and implementation of Kimball-style dimensional models and star schema architectures, migrating legacy data systems to a modern, scalable foundation.
• Own and enforce data hygiene standards across the platform — identifying, documenting, and remediating data quality issues proactively.
• Design, build, and maintain production-grade data pipelines with a focus on reliability, observability, and maintainability.
• Develop and champion best practices for data modeling, transformation, and testing across the engineering team.
• Drive the extraction and codification of business logic from existing systems into well-documented, portable, cloud-agnostic layers.
• Collaborate with analysts, engineers, and stakeholders to ensure data models meet both current reporting needs and future platform requirements.
• Provide technical guidance and mentorship to Data Engineer I team members.
• Contribute to architectural decisions and participate in design reviews, bringing a principled, opinionated perspective on platform direction.
• Support and improve documentation standards to ensure the codebase and data platform remain well-understood across the team.

Skills

SQL

Python

dbt

Dimensional modeling

Data pipelines

Tools

Snowflake

Redshift

Job description

BlueLabs is seeking a Data Engineer II in the United States to advance the data platform’s maturity by elevating data quality, leading platform modernization, and migrating legacy systems to Kimball/star schema architecture.

You will own complex engineering work, drive data modeling standards, and mentor Data Engineer I teammates while collaborating with analysts and stakeholders to meet current and future reporting needs.