MC

Data Engineer I

McKinsey&Company

6 months ago

3 - 5 years

Work From Office

Chennai, Tamil Nadu, India

  • Creating and optimizing data models and data warehouses to support reporting, analytics, and application integration
  • Working with cloud-based data platforms (AWS, Azure, or GCP) to build modern, efficient, and secure data solutions
  • Contributing to infrastructure automation and deployment pipelines using containerization and CI/CD tools
  • PYTHON

    ETL/ELT pipeline

    Azure Data Factory

    AWS Airflow

    Sql

    Cloud Platforms

    Containerization

    GEN AI

    Job description & requirements

    Your core responsibilities will include:


    1. Developing robust, scalable data pipelines for ingesting, transforming, and storing data from multiple structured and unstructured sources using Python/SQL
    2. Creating and optimizing data models and data warehouses to support reporting, analytics, and application integration
    3. Working with cloud-based data platforms (AWS, Azure, or GCP) to build modern, efficient, and secure data solutions
    4. Contributing to R&D projects and internal asset development
    5. Contributing to infrastructure automation and deployment pipelines using containerization and CI/CD tools
    6. Collaborating across disciplines to integrate data engineering best practices into broader analytical and generative AI (gen AI) workflows
    7. Supporting and maintaining data assets deployed in client environments with a focus on reliability, scalability, and performance
    8. Furthermore, you will have the opportunity to explore and contribute to solutions involving generative AI, such as vector embeddings, retrieval-augmented generation (RAG), semantic search, and LLM-based prompting, especially as we integrate gen AI capabilities into our broader data ecosystem


    Your qualifications and skills

    1. Bachelor’s degree in computer science, engineering, mathematics, or a related technical field (or equivalent practical experience).
    2. 3+ years of experience in data engineering, analytics engineering, or a related technical role.
    3. Strong Python programming skills with demonstrated experience building scalable data workflows and ETL/ELT pipelines.
    4. Proficient in SQL with experience designing normalized and denormalized data models.
    5. Hands-on experience with orchestration tools such as Airflow, Kedro, or Azure Data Factory (ADF).
    6. Familiarity with cloud platforms (AWS, Azure, or GCP) for building and managing data infrastructure.
    7. Discernable communication skills, especially around breaking down complex structures into digestible and relevant points for a diverse set of clients and colleagues, at all levels.
    8. High-value personal qualities including critical thinking and creative problem-solving skills; an ability to influence and work in teams.
    9. Entrepreneurial mindset and ownership mentality are must; desire to learn and develop, within a dynamic, self-led organization.
    10. Hands-on experience with containerization technologies (Docker, Docker-compose).
    11. Hands on experience with automation frameworks (Github Actions, CircleCI, Jenkins, etc.).
    12. Exposure to generative AI tools or concepts (e.g., OpenAI, Cohere, embeddings, vector databases).


    Experience :

    3 - 5 years

    Job Domain/Function :

    Data Engineering

    Job Type :

    Work From Office

    Employment Type :

    Full Time

    Number Of Position(s) :

    1

    Educational Qualifications :

    Bachelor's Degree

    Location :

    Chennai, Tamil Nadu, India, Chennai, Tamil Nadu, India

    Create alert for similar jobs

    MC

    McKinsey&Company

    Similar Jobs

    Data Engineer I-McKinsey&Company-Chennai, India-3 - 5 years