BC

Data Engineer - Global People Analytics

BCG

6 months ago

3 - 5 years

Work From Office

Gurgaon, Haryana, Haryana, India

  • Develop and maintain data warehouse solutions, including data modeling, schema design, and indexing strategies
  • Identify and integrate diverse data sources, both internal and external, into a centralized data platform
  • Implement and manage data lakes, data marts, or other storage solutions as required
  • SQL

    Snowflake

    MYSQL

    PostgreSQL

    PYTHON

    Cloud Platforms

    Data Modeling

    Data Visualization (Tableau, Power BI)

    Job description & requirements

    Key Responsibilities


    1. Develop and maintain data warehouse solutions, including data modeling, schema design, and indexing strategies
    2. Optimize data processing workflows for improved performance, reliability, and scalability
    3. Identify and integrate diverse data sources, both internal and external, into a centralized data platform
    4. Implement and manage data lakes, data marts, or other storage solutions as required
    5. Ensure data privacy and compliance with relevant data protection regulations
    6. Define and implement data governance policies, standards, and best practices
    7. Transform raw data into usable formats for analytics, reporting, and machine learning purposes
    8. Perform data cleansing, normalization, aggregation, and enrichment operations to enhance data quality and usability
    9. Collaborate with data analysts and data scientists to understand data requirements and implement appropriate data transformations



    What You'll Bring


    1. Bachelor's or Master's degree in Computer Science, Data Science, Information Systems, or a related field
    2. Proficiency in SQL and experience with relational databases (e.g., Snowflake, MySQL, PostgreSQL, Oracle)
    3. 3+ years of experience in data engineering or a similar role
    4. Hands-on programming skills in languages such as Python or Java is a plus
    5. Familiarity with cloud-based data platforms (e.g., AWS, Azure, GCP) and related services (e.g., S3, Redshift, BigQuery) is good to have
    6. Knowledge of data modeling and database design principles
    7. Familiarity with data visualization tools (e.g., Tableau, Power BI) is a plus
    8. Strong problem-solving and analytical skills with attention to detail
    9. Experience with HR data analysis and HR domain knowledge is preferred


    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 :

    Gurgaon, Haryana, India, Gurgaon, Haryana, India

    Create alert for similar jobs

    Similar Jobs

    Data Engineer - Global People Analytics-BCG-Gurgaon, Haryana, India-3 - 5 years