Havas Chicago Logo

Havas Chicago

Senior Database Engineer

Posted 9 Days Ago
Be an Early Applicant
In-Office
Chennai, Tamil Nadu, IND
Senior level
In-Office
Chennai, Tamil Nadu, IND
Senior level
Designs, builds, and optimizes Azure and Microsoft Fabric data platforms, including lakehouses, warehouses, dimensional models, ETL/ELT pipelines, semantic models, and AI-ready data products. Develops RAG and LLM solutions with embeddings, retrieval, evaluation, and responsible AI controls. Establishes governance, security, data quality, observability, CI/CD, and Infrastructure as Code practices while optimizing performance and cost. Provides technical leadership, architecture guidance, mentoring, documentation, and cross-functional collaboration.
The summary above was generated by AI

Agency :

Havas Creative

Job Description :

The Senior Database Engineer is a hands-on senior engineering role responsible for designing, building, optimizing, and evolving modern Microsoft data platforms across Azure and Microsoft Fabric. The position owns cloud data engineering, enterprise warehouse and lakehouse architecture, data integration, semantic consumption, and AI-ready data products. The successful candidate brings a minimum of seven years of data engineering, database engineering, or data warehousing experience, including practical experience enabling generative AI solutions with copilots, large language models, retrieval-augmented generation, embeddings, vector or hybrid retrieval, prompt engineering, model evaluation, and responsible AI controls.
  • Design, build, and support enterprise data solutions using Azure and Microsoft Fabric. 

  • Create scalable Fabric Lakehouse, Fabric Warehouse, and hybrid warehouse architectures with raw, standardized, curated, and consumption-ready layers. 

  • Design dimensional models, star schemas, facts, dimensions, data marts, semantic-ready datasets, and reusable data products. 

  • Build production ETL/ELT using Fabric Data Factory, Azure Data Factory, SQL, Python, PySpark, notebooks, APIs, files, and event or batch integration patterns. 

  • Engineer OneLake-aligned solutions, shortcuts, pipelines, notebooks, SQL endpoints, Power BI semantic models, and Direct Lake patterns when appropriate. 

  • Create governed data foundations for generative AI, copilots, agents, search, and analytics using Microsoft Foundry or Azure OpenAI, Azure AI Search, and enterprise data sources. 

  • Design and implement RAG workflows, including ingestion, chunking, metadata, embeddings, vector/hybrid retrieval, grounding, prompt design, citations, and evaluation. 

  • Evaluate LLM solution quality, grounding, latency, cost, content safety, data leakage risk, and business fitness before production use. 

  • Use tools such as Copilot in Microsoft Fabric, GitHub Copilot, Microsoft 365 Copilot, Copilot Studio, or approved enterprise copilots to accelerate development and build user-facing experiences. 

  • Apply responsible AI practices, human review, access controls, privacy protections, prompt and model testing, auditability, and monitoring. 

  • Implement data quality, lineage, observability, reconciliation, validation, security, and governance controls throughout the engineering lifecycle. 

  • Use Git, pull requests, automated tests, CI/CD, environment promotion, and Infrastructure as Code for data pipelines, notebooks, database objects, and platform configuration. 

  • Optimize workloads for performance, scalability, reliability, and cost across SQL, Spark, Fabric capacity, storage, pipelines, and semantic models. 

  • Partner with BI, analytics, application engineering, DBAs, security, infrastructure, and business stakeholders on end-to-end solution architecture. 

  • Provide technical leadership, code and design reviews, reusable templates, technical documentation, and mentoring. 

Required Qualification:

Minimum 7 years of professional data engineering, database engineering, data warehousing, or closely related experience, including senior-level design ownership. 

• Hands-on production experience with Azure data services and Microsoft Fabric or equivalent Microsoft cloud lakehouse/warehouse technologies. 

• Advanced SQL and strong knowledge of relational design, dimensional modeling, data warehousing, data marts, and performance engineering. 

• Experience building and operating ETL/ELT pipelines with SQL, Python or PySpark, notebooks, APIs, files, orchestration, and incremental processing patterns. 

• Practical AI/LLM experience, including at least one implemented Copilot, chatbot, agent, RAG, intelligent search, or LLM-enabled data solution. 

• Experience with prompt engineering, grounding, embeddings, vector or hybrid retrieval, model evaluation, responsible AI, security, and observability. 

• Experience with Git, pull requests, automated testing, CI/CD, environment promotion, and repeatable deployment practices. 

• Strong understanding of identity, cloud security, data governance, privacy, data quality, lineage, and operational support. 

General Competencies 

  • Hands-on ownership, sound judgment, attention to detail, and disciplined follow-through. 

  • Clear written and verbal communication with technical and non-technical stakeholders. 

  • Ability to mentor team members, lead design or incident reviews, and document repeatable standards. 

  • Commitment to security, data privacy, responsible technology use, and continuous learning. 

Contract Type :

Permanent

Here at Havas across the group we pride ourselves on being committed to offering equal opportunities to all potential employees and have zero tolerance for discrimination. We are an equal opportunity employer and welcome applicants irrespective of age, sex, race, ethnicity, disability and other factors that have no bearing on an individual’s ability to perform their job.

Similar Jobs

26 Days Ago
In-Office
Chennai, Tamil Nadu, IND
Senior level
Senior level
Agency • Information Technology
Design, develop, and maintain MSSQL and MySQL databases; write SQL/PLSQL, stored procedures, triggers, cursors, and schedulers. Troubleshoot jobs and performance, work with ETL tools (Talend/Fivetran/Pentaho) and document-oriented databases, support cloud database administration, enforce security, collaborate with developers/QA/DevOps, produce technical documentation, and potentially lead small projects.
Top Skills: Cloud DatabasesCursorsDocument-Oriented DatabasesETLFivetranMssqlMySQLPentahoPl/SqlSchedulersSQLStored ProceduresTalendTriggers
20 Days Ago
In-Office
Chennai, Tamil Nadu, IND
Senior level
Senior level
Software
Develop efficient database solutions using MS SQL Server and PostgreSQL, optimize queries, implement ETL processes, and create reports while ensuring data integrity and performance tuning.
Top Skills: AdfAsp.NetC#DynatraceGitJIRAMs Sql ServerNewrelicPostgresSQLSsisSsrsSvn
14 Minutes Ago
Hybrid
Chennai, Tamil Nadu, IND
Senior level
Senior level
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Develop data science and AI solutions using Python and Django, including data collection, labeling, curation, feature engineering, classical machine learning, and generative AI. Deploy models to production using CI/CD, Airflow, and MLflow; automate modeling pipelines and monitor model drift. Collaborate with stakeholders in Agile Scrum teams, improve testing and automation practices, and analyze business requirements.
Top Skills: AgileAirflowCi/CdDjangoHadoopMlflowPandasPythonScrumSparkSQL

What you need to know about the Chennai Tech Scene

To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account