Sr.Data engineer

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 (GCP)  using tools like  DBT ,  BigQuery , and other GCP-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 GCP 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 :

Preferred :

Nice to Have :

What You'll Bring :