Sr.Data engineer

Sr.Data engineer

Posted 1 day ago by 1753947338

Apply
Negotiable
Outside
Remote
USA
Apply
Airflow Apache Airflow Automation AWS Identity And Access Management (IAM) BigQuery Business Intelligence Cloud Computing Cloud Storage Cloud Technology Continuous Integration and Continuous Delivery Data Engineering Dataflow Data Infrastructure Data Integrity Data Mart Datamodel Data Modeling Data Pipeline Data Validation Data Warehousing Dimensional Modeling Extract Transform Load (ETL) File Servers Google Cloud Google Cloud Composer Google Cloud Platform (GCP) Information Systems Management Metadata Microsoft SQL Servers Platform Tools Scalability SQL (Programming Language) Tableau (Business Intelligence Software) Terraform Verification And Validation Workflows

Summary: Our client is looking for a Senior Data Engineer to modernize and scale their Business Intelligence data infrastructure by transitioning from on-prem SQL Server solutions to a cloud-native environment on Google Cloud Platform. The role involves building scalable data pipelines and data models that support Tableau dashboards. This hands-on position requires collaboration with BI developers and analysts to ensure data integrity and alignment with reporting needs. The ideal candidate will also mentor junior engineers and establish best practices in cloud data engineering.

Key Responsibilities:

  • Lead the migration of the existing SSIS-based ETL workflows to cloud-native pipelines using DBT and/or Google Cloud Platform tools such as Dataflow, Dataform, or Cloud Composer (Airflow).
  • Design and implement scalable, efficient data models in BigQuery, following best practices for dimensional modeling.
  • Optimize and maintain existing SQL transformations, ensuring correctness and performance in the cloud.
  • Collaborate with BI developers and analysts to ensure data marts align with Tableau reporting needs.
  • Ensure data integrity, security, and lineage through testing, documentation, and observability practices.
  • Work with on-prem teams to phase out legacy systems and design transitional architectures where needed.
  • Establish best practices and mentor junior engineers on cloud-first data engineering patterns.

Key Skills:

  • 5+ years of experience in data engineering with strong SQL and ETL skills.
  • Experience with SSIS and legacy SQL Server based data marts.
  • Proficiency in Google BigQuery and/or similar cloud data warehouses.
  • Hands-on experience with DBT or modern transformation frameworks.
  • Strong knowledge of dimensional modeling and data warehousing principles.
  • Experience migrating on-prem pipelines to cloud platforms.
  • Familiarity with Google Cloud Platform-native services such as Cloud Storage, Pub/Sub, Dataflow, Composer, and IAM.
  • Strong knowledge of Healthcare Information Systems.

Salary (Rate): undetermined

City: Chicago

Country: USA

Working Arrangements: remote

IR35 Status: outside IR35

Seniority Level: Senior

Industry: IT

Detailed Description From Employer:

Our client is seeking Senior Data Engineer to help modernize and scale our Business Intelligence data infrastructure. This role will be critical in transitioning our existing on-prem SQL Server based dimensional data mart and SSIS pipelines into a cloud-native solution on Google Cloud Platform (Google Cloud Platform) using tools like DBT, BigQuery, and other Google Cloud Platform-native services.

This is a hands-on engineering role focused on building robust, scalable data pipelines and enabling performant data models that power Tableau dashboards used throughout the organization.

Responsibilities:

  • Lead the migration of the existing SSIS-based ETL workflows to cloud-native pipelines using DBT and/or Google Cloud Platform tools such as Dataflow, Dataform, or Cloud Composer (Airflow).
  • Design and implement scalable, efficient data models in BigQuery, following best practices for dimensional modeling.
  • Optimize and maintain existing SQL transformations, ensuring correctness and performance in the cloud.
  • Collaborate with BI developers and analysts to ensure data marts align with Tableau reporting needs.
  • Ensure data integrity, security, and lineage through testing, documentation, and observability practices.
  • Work with on-prem teams to phase out legacy systems and design transitional architectures where needed.
  • Establish best practices and mentor junior engineers on cloud-first data engineering patterns.

Qualifications:

Required:

  • 5+ years of experience in data engineering with strong SQL and ETL skills.
  • Experience with SSIS and legacy SQL Server based data marts.
  • Proficiency in Google BigQuery and/or similar cloud data warehouses.
  • Hands-on experience with DBT or modern transformation frameworks.
  • Strong knowledge of dimensional modeling and data warehousing principles.
  • Experience migrating on-prem pipelines to cloud platforms.
  • Familiarity with Google Cloud Platform-native services such as Cloud Storage, Pub/Sub, Dataflow, Composer, and IAM.
  • Strong knowledge of Healthcare Information Systems.

Preferred:

  • Experience supporting or integrating with Tableau-based BI solutions.
  • Exposure to infrastructure-as-code tools like Terraform for Google Cloud Platform.
  • Knowledge of data observability tools and practices.
  • Comfortable with Git-based CI/CD for data pipeline deployments.

Nice to Have:

  • Familiarity with Google Cloud Platform networking and cost optimization strategies.
  • Experience with data validation or automated testing frameworks for pipelines.
  • Knowledge of metadata management or cataloging tools (e.g., Data Catalog, DataPlex).

What You'll Bring:

  • A builder's mindset with a bias for simplification and automation.
  • A collaborative approach to working with BI and application teams.
  • The ability to balance long-term platform scalability with short-term deliverables.
  • A passion for cloud innovation and data platform modernization.

Apply
Similar Jobs
Loading data...