Data Engineer II

LUMI is the company’s largest Big Data Platform, ideally suited for computationally and/or data‑intensive processing applications. Whether the data needs to be processed in batch, online, or streaming mode, LUMI provides robust, scalable, and cost‑efficient capabilities to handle such workloads effectively.
This role sits within a hub of highly motivated Big Data engineers working on exciting and upcoming technologies. The Cornerstone platform offers an environment where engineers are challenged every day to build high‑quality, reliable products.
As we continue our journey to the public cloud (GCP), you will be part of a fast‑paced Agile team contributing to the design, development, testing, troubleshooting, and optimization of solutions that simplify access to American Express’s Big Data Platform.
Focus
Designs, develops, debugs, tests, deploys, and documents software components and services that support customer‑facing applications, business applications, and internal platforms, under the guidance of senior engineers and architects.
Organizational Context
Member of an engineering or delivery and integration team, reporting to an Engineering Manager or Engineering Director, and working closely with senior engineers and cross‑functional partners.

Responsibilities

• • As a Big Data Engineer, you'll be responsible for designing and building high performance, and scalable data platforms

  • You will be leading team of multiple very enthusiastic and skilled engineers to drive the product development and adoption

  • You will be required to effectively collaborate with product teams from business group and understand the product roadmap and vision and translate that into engineering artefacts

  • You will work with a variety of teams and individuals, including platform engineers, usecase owners, analytical users to understand their needs and come up with innovative solutions

  • You will follow the Amex-way of building engineering products that leads to engineering excellence by adopting DevOps principals

Qualifications

• • Bachelor's degree in computer science, Engineering, or a related field. Master's degree would be a plus

  • Great to have: - GCP professional certification - Data Engineer/Cloud Architect will be preferable

  • Strong hands-on experience with GCP services (Big Query, Dataflow, Dataproc, Pub/Sub, Cloud Storage, Composer, etc.).

  • Expert in Google Big Query tool for data warehousing needs

  • 4+ years of software development experience with hands-on expertise in coding in Java/Python/Scala etc.

  • 3+ years of experience in creating low code/no code ETL tool for setting up large scale data transformation on GCP Cloud

  • Strong SQL, RDBMS skills. Expert in writing complex SQLs for different databases such as Hive, MySQL, Postgres etc.  Proficiency in working with NoSQL databases as well

  • Experience working with Spark, Big Data and Hive

  • Experience in Git Management including PR reviews, maintaining code hygiene

  • In-depth understanding of data warehousing concepts, dimensional modelling, and data integration techniques

  • Experience in optimizing high volume data processing jobs.

  • 3+ year's experience in writing APIs and spring boot services.

  • Knowledge of High availability and DR setup.

  • Hands-on experience on CICD pipelines, Automated test frameworks, DevOps and source code management will be a big plus (XLR, Jenkins, Git, Stash, Jira, Confluence, Splunk etc.)

  • Experience working in Agile/Safe framework for development

  • Understanding of Generative AI concepts, including LLMs (Large Language Models), prompt engineering, embeddings, and vector databases.

  • Experience integrating GenAI capabilities into data platforms (e.g., semantic search, AI-driven analytics, automated data insights).

  • Excellent communication and analytical skills

  • Excellent team-player with ability to work with global team