Data Engineer - Contract ($65 - $95)

Data Engineer - Contract ($65 - $95) - Develops dimensional models following medallion architecture patterns, ensures data quality, and guarantees reliable data delivery for analytics on a Snowflake platform.

Requirements

• Design and develop dbt models following the medallion architecture (bronze > silver > gold layers).
• Build dimensional models, including fact and dimension tables, for analytics consumption.
• Implement and maintain data quality tests using dbt’s testing framework.
• Optimize SQL transformations within dbt for performance in Snowflake.
• Write and maintain schema documentation with model and column descriptions, and apply dbt best practices (refs, sources, macros, tags).
• Configure and maintain Dagster assets to orchestrate dbt model execution, including implementing schedules and sensors.
• Monitor pipeline health through the Dagster UI and resolve execution failures.
• Build and maintain bespoke Python-based ingestion pipelines for source systems without native connector support.
• Participate in code reviews for dbt models and Dagster configurations, and use tools like sqlfluff for code quality.
• Collaborate with analysts and data consumers, and document data models, transformation logic, and operational procedures.

Benefits

• Paid time off
• 401(k) matching
• Health benefits