16 Nov
|
Annalect, Omnicom Media Group India Private
|
Hyderabad
16 Nov
Annalect, Omnicom Media Group India Private
Hyderabad
Overview
Omnicom Global Solutions (OGS) is an integral part of Omnicom Group, a leading global marketing and corporate communications company. Omnicom’s branded networks and specialty firms deliver advertising, strategic media planning and buying, digital and interactive marketing, direct and promotional marketing, public relations, and other specialized communication solutions to over 5,000 clients across more than 70 countries. OGS India serves as a key global capability center for Omnicom, enabling its agencies and group companies with scaled delivery, specialized expertise, and integrated solutions. Our capabilities span Media, Data & Analytics, Technology, MarTech, Commerce, Business Support Solutions, Creative Production, Healthcare, and Strategy & Insights.
With a workforce of over 7,000 professionals in India, OGS continues to expand its capabilities and global impact, supporting the evolving needs of clients and agencies. We are committed to building future-ready talent and delivering high-quality, outcome-driven solutions.
Responsibilities
Data Engineering & Development
- Design, build, and maintain scalable data pipelines using Python and SQL.
- Develop ETL/ELT processes to extract, transform, validate, and load data from multiple sources.
- Design and maintain relational databases, schemas, and data models.
- Integrate data from APIs, databases, flat files, and enterprise applications.
- Automate ingestion, transformation, scheduling, and data processing.
- Optimize SQL queries and pipeline performance; implement validation, logging, monitoring, and error handling.
- Troubleshoot data quality, integration, and performance issues.
Data Architecture & Integration
- Build integrations between internal platforms, cloud services, and enterprise systems.
- Work with SQL tables, JSON, CSV, API responses, and other structured or semi-structured data.
- Support migrations, database enhancements, and consistent data definitions across systems.
AI & Automation Support
- Prepare and structure enterprise data for AI-powered applications and automated workflows.
- Support database and API integrations with LLM-based applications, including basic OpenAI or Azure OpenAI API usage.
- Collaborate with AI Engineers on data retrieval and access for chatbots, agents, and analytics.
- Use AI-assisted development tools productively while independently validating code and results.
Collaboration & Delivery
- Translate business requirements into technical data solutions.
- Document data models, pipelines, and integrations.
- Participate in technical reviews, testing, deployment, and production support.
- Independently debug issues and deliver maintainable solutions.
Qualifications
- 5+ years of hands-on data engineering, software development, or database engineering experience.
- Solid Python programming for data processing, scripting, automation, and API integration.
- Advanced SQL, including complex joins, query optimization, and database troubleshooting.
- Experience with relational database design, schemas, data structures, and data modeling.
- Experience building and maintaining ETL/ELT pipelines.
- Comfort with REST APIs, JSON, CSV, data transformation, and data quality controls.
- Familiarity with Git and source control.
- Ability to write, test, and debug production-ready code independently.
Preferred Technical Tools & Platforms Programming & Data Processing: Python, SQL, Pandas, NumPy; PySpark (nice to have).
Databases: PostgreSQL, Microsoft SQL Server, MySQL, Azure SQL Database.
ETL & Automation: Alteryx, Python-based ETL, Azure Data Factory; Apache Airflow (nice to have).
Cloud & Development: Microsoft Azure, Azure App Service / Azure Functions, GitHub / GitHub Actions, Replit; Google Cloud Platform (nice to have).
AI Exposure: OpenAI API / Azure OpenAI, AI-assisted coding tools; familiarity with RAG concepts (nice to have).
Reporting & Enterprise Data: Power BI, data warehouse integrations, enterprise financial and operational data systems.
📌 Senior Developer - Data Engineering (Hyderabad)
🏢 Annalect, Omnicom Media Group India Private
📍 Hyderabad