Senior Data Engineer

Description

Think of TEKsystems Global Services (TGS) as the growth solution for enterprises today. We unleash growth through technology, strategy, design, execution and operations with a customer-first mindset for bold business leaders. We deliver cloud, data and customer experience solutions. Our partnerships with leading cloud, design and business intelligence platforms fuel our expertise. We value deep relationships, dedication to serving others and inclusion.

We drive positive outcomes for our people and our business, and we stay true to our commitments and act in harmony with our words. We exist to create significant opportunity for people to achieve fulfillment through career success.

Ready to join us?

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 (One Lake, 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.

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:

o One Lake-based data Lakehouse architectures

o Data Factory pipelines within Fabric

o Synapse Data Engineering and Data Warehousing experiences

o 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 Dev Ops/Git Hub) 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:

o Azure Data Factory (ADF) / Synapse Pipelines

o Azure SQL/ SQL MI

o ADLS Gen2

o One Lake & Lakehouse architecture

o Power BI reporting development

- Strong working knowledge of Snowflake architecture, including

o Virtual Warehouses

o Snowpipe / Copy Command / Dynamic Table

o Streams & Tasks

o Data Sharing

o Performance Tuning

o Security & Access Control

- Expertise in data modeling (star/snowflake schemas, medallion architecture)

- Experience building batch and near real-time data pipelines handling structured and…