Data Engineer II: Modernize & Model with Star Schema

BlueLabs; United States; Remote; USD 95,000 - 125,000; Full time

Benefits offered by this job

Health insurance

401K matching

Unlimited vacation

Parental leave (15 weeks)

Tuition reimbursement

Flexible working hours

Remote friendly (within the U.S.)

Job summary

BlueLabs is seeking a Data Engineer II to partner with the Director of Data in advancing our data platform. You will drive Kimball-style dimensional modeling, migrations, and data hygiene, delivering scalable pipelines in a cloud-agnostic environment.

You will mentor junior engineers, influence architectural directions, and collaborate with cross-functional teams to meet current and future reporting needs while improving data quality and governance.

Qualifications

• 5+ years of experience in data engineering with ownership of complex data platform initiatives.
• Deep expertise in dimensional modeling, Kimball and star/snowflake schema design.
• Experience leading data warehouse migrations or platform modernization.
• Proficiency in SQL and Python with production-quality code.
• Strong dbt skills including tests, macros, packages, and docs.
• Hands-on with Snowflake & Redshift and modern data stack tools.
• Systematic approach to data quality, validation pipelines, and monitoring.
• Ability to work autonomously in evolving problem spaces.
• Strong communication to explain decisions to engineers and stakeholders.
• Passion for social impact work and cross-functional teamwork.

Responsibilities

• Partner with the Director of Data to translate platform vision into engineering execution.
• Lead design and implementation of Kimball-style dimensional models and star schema architectures.
• Own and enforce data hygiene standards across the platform and remediate data quality issues.
• Design, build, and maintain production-grade data pipelines with focus on reliability and observability.
• Develop and champion best practices for data modeling, transformation, and testing.
• Drive extraction of business logic into well-documented, cloud-agnostic layers.
• Collaborate with analysts, engineers, and stakeholders to meet current and future reporting needs.
• Provide technical guidance and mentorship to Data Engineer I team members.
• Contribute to architectural decisions and participate in design reviews.
• Support documentation standards to keep codebase and platform well understood.

Skills

Kimball modeling

Star schema

SQL

Python

dbt

Snowflake

Redshift

data quality

communication

mentoring

Tools

Snowflake

Redshift

dbt

Job description

BlueLabs is seeking a Data Engineer II to partner with the Director of Data in advancing our data platform. You will drive Kimball-style dimensional modeling, migrations, and data hygiene, delivering scalable pipelines in a cloud-agnostic environment.

You will mentor junior engineers, influence architectural directions, and collaborate with cross-functional teams to meet current and future reporting needs while improving data quality and governance.