Zensar Technologies
DE&A - Core - Cloud Data Engineering - Azure Data Engineering
Be an Early Applicant
Seeking a seasoned Data Engineering Architect with 12-16 years of experience in building data platforms on Azure, focusing on ADF pipeline engineering and SQL optimization. Responsibilities include designing solutions, troubleshooting data issues, mentoring teams, and enforcing best practices in data governance and CI/CD.
Role Summary
We are looking for a strong Data Engineering Architect with 12–16 years of experience in building and architecting modern data platforms on Microsoft Azure. The ideal candidate will have deep hands-on expertise in Azure Data Factory (ADF) pipeline engineering, SQL performance tuning, and end-to-end data integration architecture, along with a strong analytical mindset to troubleshoot complex data issues. You will lead solution architecture, define best practices, and mentor teams to build scalable, secure, and reliable data solutions.
Key ResponsibilitiesAzure Data Engineering & Architecture- Architect and design end-to-end Azure data engineering solutions (batch + near real-time) aligned to enterprise standards.
- Define target state architecture for data ingestion, transformation, orchestration, and serving layers.
- Lead architectural decisions around scalability, resiliency, performance, security, governance, and cost optimization.
- Design, develop, test, and deploy Azure Data Factory pipelines following best practices (modular design, parameterization, reusability, CI/CD readiness).
- Build robust ingestion and orchestration workflows using:
- Linked Services, Datasets, Pipelines, Triggers
- Mapping Data Flows / Wrangling Data Flows (where applicable)
- Integration Runtime strategies (Self-hosted / Azure IR)
- Implement operational excellence: logging, alerting, retry patterns, failure handling, and idempotent design.
- Develop and optimize SQL queries and stored procedures to support ADF pipeline operations and downstream transformations.
- Conduct query plan analysis and performance tuning (indexes, partitioning strategies, statistics, query rewrites).
- Establish SQL coding standards and reusable patterns for transformation logic.
- Apply a strong analytical mindset to diagnose and resolve complex data integration issues across ingestion, transformation, orchestration, and storage layers.
- Perform root cause analysis (RCA) for pipeline failures, performance degradation, data quality issues, and environment instability.
- Design proactive monitoring dashboards and alerts for pipeline SLAs and data freshness.
- Define and enforce best practices for:
- CI/CD for ADF (Azure DevOps / Git-based workflows)
- Infrastructure-as-Code (ARM/Bicep/Terraform—preferred)
- Version control, code review, release management
- Implement data governance patterns: metadata management, lineage, auditing, encryption, RBAC, key management, PII controls.
- Collaborate with security/compliance teams to ensure enterprise adherence.
- Act as a technical leader for data engineering squads; mentor and guide engineers on design patterns and implementation.
- Translate business requirements into technical architecture and delivery plans.
- Work closely with Product Owners, Data Analysts, Data Scientists, and Platform teams to ensure alignment.
- 12–16 years of overall IT experience with significant data engineering & architecture exposure.
- Strong Azure Cloud Data Engineering and associated services architecture knowledge
- Deep hands-on experience with:
- Azure Data Factory (ADF) – pipeline design, orchestration, integration runtime strategy
- SQL – advanced querying, stored procedures, performance tuning
- Strong troubleshooting skills for complex multi-system data issues.
- Strong understanding of data architecture concepts:
- Data lakes/lakehouse/warehouse, dimensional modeling, ELT/ETL patterns
- Batch orchestration, dependency management, SCD handling, incremental loads
- Azure data services experience in one or more:
- Azure Synapse Analytics / Dedicated SQL Pools
- Azure Databricks / Spark
- ADLS Gen2, Azure SQL DB, Managed Instance
- Event Hub / Kafka, Stream Analytics (if real-time involved)
- Monitoring & observability:
- Azure Monitor, Log Analytics, Application Insights
- Security & identity:
- Azure AD, Managed Identity, Key Vault, RBAC
- CI/CD practices for data pipelines; Git branching strategies and release governance.
- Strong documentation skills: architecture diagrams, solution designs, operational runbooks.
- Excellent analytical thinking and structured problem-solving.
- Strong communication and stakeholder management skills.
- Ownership mindset, ability to drive standards and influence cross-team adoption.
- Proven mentoring/coaching ability.
- Bachelor’s/Master’s degree in Computer Science, Information Systems, or related field (or equivalent experience).
- Microsoft Certified: Azure Data Engineer Associate
- Microsoft Certified: Azure Solutions Architect Expert
- DP-203 / AZ-305 (or equivalent)
- Highly reliable ADF pipelines with strong observability, error handling, and SLA adherence.
- Measurable improvements in SQL performance and pipeline execution time.
- Standardized architecture patterns adopted across teams.
- Reduced incident rates through proactive monitoring and strong RCA discipline.
Azure Data Architect
QualificationsAzure Data Architect
About UsAt Zensar, we’re “experience-led everything”. We are committed to conceptualizing, designing, engineering, marketing, and managing digital solutions and experiences for over 130 leading enterprises. We are a company driven by a bold purpose: Together, we shape experiences for better futures. Whether for our clients, our people, or the world around us, this belief powers everything we do. At the heart of our culture is ONE with Client - a set of four core values that reflect who we are and how we work: One Zensar, Nurturing, Empowering, and Client Focus.Part of the $4.8 billion RPG Group, we’re a community of 10,000+ innovators across 30+ global locations, including Milpitas, Seattle, Princeton, Cape Town, London, Zurich, Singapore, and Mexico City. Explore Life at Zensar and join us to Grow. Own. Achieve. Learn. to be the best version of yourself.
We believe the best work happens when individuality is celebrated, growth is encouraged, and well-being is prioritized. We are an equal employment opportunity (EEO) and affirmative action employer, committed to creating an inclusive workplace. All qualified applicants will be considered without regard to race, creed, color, ancestry, religion, sex, national origin, citizenship, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veteran status.
Top Skills
Azure Data Factory
Azure
SQL
Similar Jobs
Beauty • Robotics • Design • Appliances • Manufacturing
The Product Developer role requires supporting product management activities for new launches, improvements, and optimizations while working cross-functionally to maximize product value and customer satisfaction.
Top Skills:
ExcelMicrosoft PowerpointMicrosoft WordSharepoint
Beauty • Robotics • Design • Appliances • Manufacturing
The Senior Electrical Engineer at SharkNinja will design and develop embedded electronics for cleaning products, build and test prototypes, and mentor junior engineers.
Top Skills:
Analog CircuitsAsmCDigital CircuitsEmbedded DesignI2CMicrocontrollersMicroprocessorPower SuppliesSmbusSpiStm32
Beauty • Robotics • Design • Appliances • Manufacturing
The Director of Global CX Optimization will lead order support operations, improve customer experience, and manage cross-functional teams regarding payment governance and logistics issues.
Top Skills:
Contact Centre PlatformsCRMOms
What you need to know about the London Tech Scene
London isn't just a hub for established businesses; it's also a nursery for innovation. Boasting one of the most recognized fintech ecosystems in Europe, attracting billions in investments each year, London's success has made it a go-to destination for startups looking to make their mark. Top U.K. companies like Hoptin, Moneybox and Marshmallow have already made the city their base — yet fintech is just the beginning. From healthtech to renewable energy to cybersecurity and beyond, the city's startups are breaking new ground across a range of industries.
