Senior Data Engineer - Postgres/Oracle

$110,000 - $190,000/Yr

American Express - New York, NY

Full-time - Senior

New York, NY

Credit Intermediation and Related Activities

About the position

As a Senior Data Engineer at American Express, you will play a pivotal role in overseeing the technical aspects of our databases that power the global @Work application. This application is designed to help our large corporate clients manage their Corporate Card and Corporate Purchasing Card programs more efficiently online. Your responsibilities will include ensuring optimal database performance, security, resiliency, integrity, and availability, while implementing innovative solutions such as the Point of Arrival (POA) system for our data layer. You will be part of a diverse tech team where you can architect, code, and ship software that enhances our customers' digital experiences. In this role, you will lead and mentor teams of engineers, ensuring adherence to team standards and accountability for the quality of documentation and work produced. You will be responsible for performing all technical aspects of data architecture and database management, including developing prototypes, new database structures, and APIs. Your expertise will be crucial in transforming logical data architectures into physical designs, providing database administration services, debugging components, and continuously improving product designs. You will also collaborate with business and product teams to support changes and implementation, prioritizing features for ongoing sprints based on industry trends and known issues. Your role will require strong analytical skills to understand and document business data requirements, facilitate discussions between technology and business stakeholders, and evaluate major design options for databases. You will be expected to stay abreast of new DBMS features and drive their adoption across the organization, contributing to decisions about tools and methods while finding opportunities to embrace innovative technologies. This position offers a unique opportunity to work with the latest technologies in a supportive and inclusive environment, where your contributions will be recognized and valued.

Responsibilities

• Oversee all technical aspects of databases powering the global @Work application.
• Ensure optimal database performance, security, resiliency, integrity, and availability.
• Implement innovative solutions such as the Point of Arrival (POA) system for the data layer.
• Lead and mentor teams of engineers through ongoing development efforts.
• Ensure adherence to team standards and accountability for documentation and work quality.
• Perform all technical aspects of data architecture and database management for assigned applications.
• Develop prototypes, new database structures, and APIs as applicable.
• Transform logical data architectures into physical data designs according to best practices.
• Provide database administration services to projects crafting, extending, or maintaining databases.
• Debug database components, identify, fix, and verify remediation of defects.
• Perform ongoing refactoring of database design and continuously improve products.
• Ensure optimal data replication, performance, high availability, backup, and recovery processes.
• Lead development of plans and strategies related to data management processes and security.
• Function as a senior member of an agile team and lead data assets according to enterprise standards.
• Communicate and collaborate with business and product teams to support changes and implementation.
• Work with product teams to prioritize features for ongoing sprints based on industry trends and known issues.
• Partner with delivery architects and engineers to design optimal data tier solutions.
• Stay abreast of new DBMS features and drive adoption across the organization.
• Contribute to decisions about tools, methods, and approaches.

Requirements

• 6+ years of database development experience in a professional environment.
• Demonstrated experience leading teams of Data Engineers and Data Architects.
• Hands-on expertise with design and development across one or more database management systems (e.g., DB2, Couchbase, Oracle, Postgres).
• Experience with distributed (multi-tiered) systems, algorithms, and application development.
• Experience with database development and support of OLTP and/or OLAP systems.
• Demonstrated experience with big data technologies and NoSQL design and coding with various data stores.
• Bachelor's degree in computer science, computer science engineering, or related field required; advanced degree preferred.
• 3+ years of Java experience.
• 3+ years of Postgres/Oracle experience.

Nice-to-haves

• Expertise in NoSQL databases will be an added advantage.
• Strong analytical skills with a proven ability to understand and document business data requirements.
• Ability to facilitate discussions between technology and business stakeholders.

Benefits

• Competitive base salaries
• Bonus incentives
• 6% Company Match on retirement savings plan
• Free financial coaching and financial well-being support
• Comprehensive medical, dental, vision, life insurance, and disability benefits
• Flexible working model with hybrid, onsite or virtual arrangements depending on role and business need
• 20+ weeks paid parental leave for all parents, regardless of gender, offered for pregnancy, adoption or surrogacy
• Free access to global on-site wellness centers staffed with nurses and doctors (depending on location)
• Free and confidential counseling support through our Healthy Minds program
• Career development and training opportunities