Data and Analytics Engineer

Overview

Data and Analytics Engineer on the DWCS Data and Analytics team, transforming complex data into actionable insights and building metrics, pipelines and dashboards that give visibility into the effectiveness of the access control environment and help identify security risks.

What you'll do

• Design, build and maintain KPIs, operational reports and dashboards to monitor the health, compliance and effectiveness of DWCS services.
• Analyze large, multi-source datasets to identify trends, patterns, anomalies and potential security risks related to user access, entitlements, client services and privileged accounts.
• Create interactive data visualizations and present analytical findings to stakeholders and leadership to support data-driven decision-making.
• Develop, validate and apply statistical models, predictive analytics and Generative/Agentic AI workflows to enhance analytical capabilities and deliver forward-looking security intelligence.
• Perform exploratory and ad-hoc data analyses across multi-source DWCS datasets to address urgent security or operational queries and deliver actionable insights for leadership.
• Build, maintain and optimize batch and real-time ETL/ELT pipelines, SQL queries and automated data refresh processes to ensure clean, reliable and timely data feeds for BI and reporting platforms.
• Partner with operations, engineering, cybersecurity and governance teams to understand their data requirements and deliver ongoing analytical support.
• Identify opportunities to automate reporting processes, establish data quality frameworks and enhance data integrity across source systems.

What you'll need

• 5–8 years of relevant experience in data analytics, business intelligence or data engineering.
• Strong proficiency with data analysis and scripting tools such as SQL, Python and Excel.
• Proven experience building and optimizing ETL/ELT data pipelines, managing batch/real-time data ingestion and writing complex SQL queries for large, multi-source datasets.
• Hands-on expertise with enterprise data visualization tools such as Tableau.
• Excellent analytical, problem-solving, and written/verbal communication skills.

Nice to have

• Familiarity with statistical/predictive modeling (forecasting, regression), Generative AI (LLMs, RAG) and Agentic AI frameworks (e.g., LangGraph, CrewAI, tool-calling) to automate data reasoning and analytics workflows.

Details

• Full-time role.
• Location: Chennai, Tamil Nadu, India.