Senior Data Engineer (Data Modernization)

TEK Systems

United States

On-site

USD 110,000 - 165,000

Full time

8 days ago

Get more replies from employers

Send a job-specific resume in minutes.

Benefits offered by this job

Medical, dental & vision

401(k) plan

Life Insurance

Paid time off

Job summary

TEKsystems Global Services seeks a Sr. Data Engineer to design and deliver modern, scalable cloud analytics solutions using Microsoft Fabric and Snowflake. You will lead data platform architectures, develop end-to-end pipelines, and partner with data scientists and stakeholders to produce impactful insights.

You will design lakehouse and warehouse models, implement secure data governance, and contribute to reusable accelerator frameworks across teams in the US.

Qualifications

Bachelor’s or Master’s degree in Computer Science, Engineering, or related field.
6+ years of hands-on Data Engineering experience delivering enterprise-scale data platforms and analytics solutions.
At least two end-to-end implementation projects on Azure Fabric involving design, development, testing, and deployment.
At least two end-to-end implementation projects on Snowflake involving data ingestion, transformation, modeling, and optimization.
Strong expertise in SQL, Python, and ETL/ELT development.
Strong hands-on expertise in Microsoft Fabric and related Azure data services, including: Azure Data Factory, Synapse Pipelines, Azure SQL/ SQL MI, ADLS Gen2, OneLake & Lakehouse architecture, Power BI reporting development.
Strong working knowledge of Snowflake architecture, including Virtual Warehouses, Snowpipe / Copy Command / Dynamic Table, Streams & Tasks, Data Sharing, Performance Tuning, Security & Access Control.
Expertise in data modeling (star/snowflake schemas, medallion architecture).
Experience building batch and near real-time data pipelines handling structured and semi-structured data (JSON, Parquet, CSV, XML).
Knowledge of CI/CD, Git, DevOps practices, and deployment automation.
Experience implementing data quality, governance, security, and access controls in cloud platforms.

Responsibilities

Actively gather requirements in workshops and translate them into technical data solutions.
Participate in architectural discussions to design scalable, secure data engineering solutions.
Design and implement modern data platform architectures using Microsoft Fabric and Snowflake.
Develop scalable data ingestion, transformation, and orchestration pipelines using Fabric-native tools and Azure services.
Design, implement, and optimize Snowflake-based data platforms including Snowpipe, Streams, Tasks, and Virtual Warehouses.
Develop ELT frameworks and data integration on Snowflake with governance and cost controls.
Build Power BI semantic models and reports.
Implement CI/CD pipelines for data workloads and ensure data governance and security.

Skills

SQL

Python

ETL/ELT development

Microsoft Fabric

Azure data services

Snowflake engineering

Power BI

Data modeling

Stakeholder management

Education

Bachelor’s or Master’s degree in Computer Science, Engineering, or related field

Tools

Azure Data Factory

Synapse Pipelines

ADLS Gen2

OneLake & Lakehouse

Power BI

Job description

Overview

Before applying for a TGS role, internal employees must discuss their interest with their current manager.

Please share this direct link with your manager so they can submit their approval. Your application cannot move forward until the form is completed.

We are seeking a highly skilled Sr. Data Engineer with strong expertise in Microsoft Fabric, Azure analytics ecosystem, and Snowflake data platform to design and deliver modern, scalable data solutions.

The ideal candidate should be a good team player with 6+ years of experience in data engineering in Microsoft technologies, deep hands-on expertise in Microsoft Azure Fabric platform (OneLake, Lakehouse, Data Factory pipelines, Synapse Data Engineering, Purview, Power BI) and preferably some experience with Azure AI/ML services. In addition, the candidate should have at least two end to end project experience developing Snowflake native data engineering solutions involving Snowpipe / Copy Command / Dynamic Table / Streams & Tasks

This role requires expertise in designing, developing, and deploying secure, scalable, and high-performance cloud-native engineering and analytics solutions, close team collaboration with team lead/ architects, AI Engineers, Data Scientists, and Business Stakeholders to deliver impactful, data-driven solutions.

Responsibilities

Essential Functions

Actively involves in requirement gathering workshops from customers, translating the functional requirements into technical solutions, and translating complex technical concepts into actionable insights for stakeholders under the guidance from an Architect or Lead Engineer
Actively participates in architectural discussions under guidance / supervision from Practice Architect / Team Lead to design and develop effective, efficient, reliable, secure, scalable, and cost-optimized data engineering solutions as per the overall data management strategy
Design and implement modern data platform architectures using Microsoft Fabric and/or Snowflake, including:
- OneLake-based data Lakehouse architectures
- Data Factory pipelines within Fabric
- Synapse Data Engineering and Data Warehousing experiences
- Snowflake Data Ingestion (different data formats)
Develop scalable data ingestion, transformation, and orchestration pipelines using Fabric-native tools, and Azure services
Design high-performance Lakehouse and Warehouse models following best practices (medallion architecture, dimensional modeling)
Integrate Azure services such as Azure Data Factory, ADLS Gen2, Azure SQL, Databricks (optional)
Design, implement, and optimize Snowflake-based cloud data platforms leveraging features such as Snowpipe, Streams, Tasks, Dynamic Tables, and Virtual Warehouses to deliver scalable, secure, and high-performance analytical solutions.
Develop enterprise-grade ELT frameworks and data integration solutions on Snowflake, ensuring adherence to data governance, performance optimization, cost management, and operational best practices
Build interactive and scalable Power BI semantic models and reports
Implement CI/CD pipelines (Azure DevOps/GitHub) for data and analytics workloads
Ensure adherence to data governance, security, and compliance standards
Occasionally mentor or oversee junior engineers and drive best practices
Contribute to developing accelerator solutions or reusable frameworks

Mandatory Skills/Competencies:

Bachelor’s or Master’s degree in Computer Science, Engineering, or related field.
6+ years of hands-on Data Engineering experience delivering enterprise-scale data platforms and analytics solutions.
At least two end-to-end implementation projects on Azure Fabric involving design, development, testing, and deployment, (preferably with production support but not mandatory).
At least two end-to-end implementation projects on Snowflake involving data ingestion, transformation, modeling, and optimization
Strong expertise in SQL, Python, and ETL/ELT development
Strong hands-on expertise in Microsoft Fabric and related Azure data services, including:
- Azure Data Factory (ADF) / Synapse Pipelines
- Azure SQL/ SQL MI
- ADLS Gen2
- OneLake & Lakehouse architecture
- Power BI reporting development
Strong working knowledge of Snowflake architecture, including
- Virtual Warehouses
- Snowpipe / Copy Command / Dynamic Table
- Streams & Tasks
- Data Sharing
- Performance Tuning
- Security & Access Control
Expertise in data modeling (star/snowflake schemas, medallion architecture)
Experience building batch and near real-time data pipelines handling structured and semi-structured data (JSON, Parquet, CSV, XML)
Knowledge of CI/CD, Git, DevOps practices, and deployment automation
Experience implementing data quality, governance, security, and access controls in cloud platforms.
Strong problem-solving, communication, and stakeholder management skills
Excellent verbal and written communication skills.
Ability to participate in agile ceremonies (planning, retrospectives, backlog grooming)
Ability to work cross-functionally with product managers, business stakeholders, and engineering teams.
Passion for staying updated with the latest cloud and AI/ML technologies and ability to evaluate and adopt emerging tools and methodologies.

Qualifications

Preferred Qualifications:

Microsoft certifications such as:
- Fabric Data Engineer Associate
- Azure AI Engineer Associate
Snowflake Certification such as:
- SnowPro® Advanced: Data Engineer
- SnowPro® Core Certification
Experience with Databricks or Synapse Spark pools
Familiarity with Streaming technologies (in Azure and/or Snowflake)
Exposure to data governance tools (Purview or equivalent)
Familiarity with Snowflake Cortex AI.

***Posting Close Date: 8/26/2026 ***

This includes receiving your manager approval form.

We reserve the right to pay above or below the posted wage based on factors unrelated to sex, race, or any other protected classification.

US Salary range:$109,700- $164,500 Potential bonus up to: $15,000

Compensation will be determined based on a variety of factors which may include, but are not limited to, education, experience, skills, and geographic location. As an internal Allegis Employee exploring roles within TEKsystems Global Services, hiring eligibility and maintaining existing ancillary benefits are subject to change with transfer from one role to another. Please reach out to Talent Mobility for specific questions: TGS_Talent_Ops@teksystems.com.

Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following: