Role overview

Qualifications

5 plus 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

Responsibilities

Lead the migration of existing SSIS-based ETL workflows to cloud-native pipelines using DBT and/or GCP tools
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

Key facts

Remote from: United States
Full time
Senior (5-10 years)
Data Engineer
English

Hard skills

SQL (Programming Language) BigQuery SQL Server Integration Services (SSIS) Dimensional Modeling gRPC Google Cloud Composer Health Management Information Systems Tableau (Business Intelligence Software) Terraform Observability

Other skills

Collaboration

About the company

Georgia IT, Inc.

Georgia IT, Inc. provides IT Consulting for a wide range of IT services and custom build turn-key enterprise solutions. GIT specializes in improving business scalability and efficiency through BSM and SBA Solutions. GIT transforms business with service management and service automation solutions. We are BMC & HP partners. GIT Services include custom built enterprise software and customer-centric web portals, network design and implementation, remote and site-to-site VPN, network and server security assessment and setup, server and desktop virtualization, and many others. GIT also provides IT Consulting in many areas such as Disaster Recovery Planning, Enterprise Data Backup Strategy, Long Term Strategic IT Planning and Augmentation Professional Services Solutions. Professional Services Specialties: Business Process Integration, Software Integration & Development, Web portal, Networking, Remote and site-to-site VPN, Virtualization Solutions, Product Development Please contact us Hrus@georgiait.com / uthay@georgiait.com/470-798-5000 x 1010 / (732) 890-2535 direct

Company details

Company size51 - 200

Links

Website LinkedIn See all jobs

Your match analysis

See how your profile stacks up against this role.

We compared the job requirements to your profile to show where you're strong and where you fall short.

Job description

Job: Sr. Data engineer
Location: Remote (USA)
Years of experience: 5+yrs

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-Financial 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 GCP-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 GCP.
Knowledge of data observability tools and practices.
Comfortable with Git-based CI/CD for data pipeline deployments.

Nice to Have:

Familiarity with GCP 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.