DEandA - Core - Data Engineering - Microsoft SQL Server

Zensar Technologies; Pune District; On-site; INR 3,500,000 - 6,500,000; Full time

Job summary

Zensar Technologies in Pune is seeking a Senior Data & Analytics Leader to architect and deliver enterprise data, analytics, and GenAI solutions for high-tech manufacturing. You will guide data engineering, AI/ML, and governance initiatives, and provide hands-on leadership in SSIS and Snowflake-based ecosystems.

You will engage with senior stakeholders, translate business requirements into scalable technical roadmaps, and drive performance, security, and data quality across large-scale

Qualifications

• 10+ years of overall IT experience.
• 5+ years of technical leadership experience.
• Minimum 5+ years of experience in SSIS, Snowflake and enterprise analytics platforms.
• Demonstrated success delivering large-scale data and AI transformation programs.
• Strong domain expertise in Sales Operations and Sales Analytics.
• Experience in High-Tech Manufacturing industry.

Responsibilities

• Lead architecture, design, and implementation of enterprise data, analytics, and AI solutions.
• Drive best practices for data engineering, analytics, AI/ML, and GenAI platforms.
• Provide hands-on technical guidance in SSIS and Snowflake-based data ecosystems.
• Oversee development of scalable, secure, and high-performance data platforms.
• Review solution designs, code quality, data models, and AI implementations.
• Identify opportunities to leverage AI and GenAI to improve business outcomes.
• Act as the primary technical interface for client stakeholders and senior executives.
• Translate business requirements into scalable technical solutions.
• Present architecture recommendations, project updates, and roadmaps to leadership teams.
• Collaborate with cross-functional teams including Sales, Marketing, Finance, IT, and Data Governance.

Skills

SQL

Python

Dimensional modeling

Data warehousing

ELT/ETL design

Data architecture

Performance optimization

AI basics

GenAI concepts

Education

Bachelor's/Master's in CS/Engineering/Data Science

Tools

SSIS

Snowflake Data Cloud

Tableau

SAP HANA

REST APIs

Job description

Job Description:

Required Technical Skills

Data & Analytics

• Expert-level experience with SSIS and Snowflake Data Cloud.
• Strong expertise in dimensional modeling, data warehousing, ELT/ETL design, and data architecture.
• Experience with large-scale cloud data platforms and modern data ecosystems.
• Strong SQL, python and performance optimization skills.

BI & Visualization

• Advanced experience with Tableau.
• Expertise in executive dashboards, KPI reporting, and analytical storytelling.
• Experience building enterprise semantic models and self-service analytics capabilities.

AI / Machine Learning / GenAI

Hands-on experience in one or more of the following:

• Generative AI applications
• Large Language Models (LLMs)
• Retrieval-Augmented Generation (RAG)
• Prompt Engineering
• AI Agents and Agentic Workflows
• Machine Learning model development and deployment
• Predictive Analytics and Forecasting
• MLOps practices and AI governance

Additional Technologies (Preferred)

• SAP HANA
• REST APIs
• Data Governance & Security Frameworks

Responsibilities

Technical Leadership

• Lead architecture, design, and implementation of enterprise data, analytics, and AI solutions.
• Drive best practices for data engineering, analytics, AI/ML, and GenAI platforms.
• Provide hands-on technical guidance in SSIS and Snowflake-based data ecosystems.
• Oversee development of scalable, secure, and high-performance data platforms.
• Review solution designs, code quality, data models, and AI implementations.
• Identify opportunities to leverage AI and GenAI to improve business outcomes.

Stakeholder Management

• Act as the primary technical interface for client stakeholders and senior executives.
• Translate business requirements into scalable technical solutions.
• Present architecture recommendations, project updates, business value realization, and technology roadmaps to leadership teams.
• Collaborate with cross-functional teams including Sales, Marketing, Finance, IT, and Data Governance.

Business & Domain Leadership

Must Have

• Strong domain expertise in Sales Operations and Sales Analytics.
• Experience supporting commercial organizations in the High-Tech Manufacturing industry.
• Understanding of:
  • Revenue management
  • Sales planning
  • Forecasting
  • Deal management
  • Customer lifecycle analytics
  • Pipeline management

Preferred

• Experience working with Cisco.
• Experience supporting global sales or marketing organizations within large technology enterprises.
• Familiarity with Cisco sales processes, operational data models, and commercial reporting ecosystems.

Qualifications

• Bachelors or Masters degree in Computer Science, Engineering, Information Systems, Data Science, or related field.
• 10+ years of overall IT experience.
• Minimum 5+ years of technical leadership experience.
• Minimum 5+ years of experience in SSIS, Snowflake and enterprise analytics platforms.
• Demonstrated success delivering large-scale data and AI transformation programs.

At 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.

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.