Senior Data Engineer - Postgres/Oracle

Description

You Lead the Way. We've Got Your Back.

With the right backing, people and businesses have the power to progress in incredible ways. When you join Team Amex, you become part of a global and diverse community of colleagues with an unwavering commitment to back our customers, communities and each other. Here, you'll learn and grow as we help you create a career journey that's unique and meaningful to you with benefits, programs, and flexibility that support you personally and professionally.

At American Express, you'll be recognized for your contributions, leadership, and impact-every colleague has the opportunity to share in the company's success. Together, we'll win as a team, striving to uphold our company values and powerful backing promise to provide the world's best customer experience every day. And we'll do it with the utmost integrity, and in an environment where everyone is seen, heard and feels like they belong.

Join Team Amex and let's lead the way together.

As part of our diverse tech team, you can architect, code and ship software that makes us an essential part of our customers' digital lives.??Here, you can work alongside talented engineers in an open, supportive, inclusive environment where your voice is valued, and you make your own decisions on what tech to use to solve challenging problems.??American Express offers a range of opportunities to work with the latest technologies and encourages you to back the broader engineering community through open source.??And because we understand the importance of keeping your skills fresh and relevant, we give you dedicated time to invest in your professional development.??Find your place in technology of #TeamAmex.

American Express is looking for Senior Engineers to contribute to the company's focus on building products, like @Work, to support our large and global corporate clients.

@Work helps our clients manage their Corporate Card and Corporate Purchasing Card programs more efficiently online. From performing everyday administrative tasks and account maintenance, to accessing reports and utilizing reconciliation solutions, @Work enables fast, efficient, and effective program management resulting in time and cost savings for our clients.

In this role, you will oversee all technical aspects of our databases that power our global @work application. This role requires a deep understanding of database architectures and hands-on experience with database technologies. The successful candidate will ensure optimal database performance, security, resiliency, integrity, and availability, along with implementing innovative solutions such as the Point of Arrival (POA) system for our data layer.

• Scope of Impact/Influence:

• Leads and mentors teams of engineers through ongoing development efforts.

• Ensures engineers adhere to team standards.

• Accountable for accurate completion and quality of all documentation and work produced by engineering team.

• Accountable for delivering a quality product that meets the customers' needs.

Key Responsibilities :

• Performs all technical aspects of data architecture and database management for assigned applications, including developing prototypes, developing new database structures and APIs as applicable.

• Performs transformation of logical data architectures into physical data designs, according to database design best practices and standards

• Provides database administration services to projects crafting, extending or maintaining databases, data warehouses and datamarts

• Debugs database components, identifies, fixes and verifies remediation of design and/or performance defects.

• Performs ongoing refactoring of database design and continuously improves product to follow data placement procedures and re-use of existing databases as appropriate.

• Ensure optimal data replication, performance, High Availability, backup and recovery processes exists to meet requirements, reduce cost and adhere to standards.

• Leads in development of plans and strategies, best practices, and standards related to data management processes, data products, data security and programs.

• Functions as Senior member of an agile team and leads data assets as per the enterprise standards, guidelines and policies.

• Typically spends 50% of time in database development and testing and remainder of time collaborating with partners through ongoing product/platform releases.

• Communicates and works collaboratively with business and product teams to support changes and implementation.

• Works with product team to prioritize features for ongoing sprints and leading a list of data requirements based on industry trends, new technologies, known defects, and issues.

• Partner with delivery architects and engineers to design optional data tier solutions to meet enterprise platform objectives and goals.

• Stays abreast of new DBMS features and functions and drive adoption across Amex to use product capabilities.

• Active member of the vendor product development strategy that will enable vendors to provide solutions and features to meet Amex needs.

• Contributes to decisions about tools, methods and approaches.

• Finds opportunities to embrace innovative technologies.

• Works closely with product owners on blueprints and annual planning of feature sets that impact multiple platforms and products

Knowledge/Skills

• Strong analytical skills with a proven ability to understand and document business data requirements in complete, accurate, extensible and flexible logical data models, data modeling tools.

• Able to facilitate discussions between Technology and business people, recognize issues of conflict and inconsistency between data requirements and pursue a resolution of these issues

• Evaluates and undertakes impact analysis on major design options for databases and assesses and leads associated risks

• Expert in XML and schema development/reuse, RDBMS databases, Open Source. Expertise in NoSQL will be an added advantage.

• Leads modification and maintenance of data structures and associated components according to logical and physical design structures for large or complex systems.

• Mastered Metadata Management and Database Management

• Partners with Sr. Data Engineers and Sr. Data architects to build complex company platform level data models and database designs.

• Takes technical responsibility for all stages in the database development process.

• Crafts and/or uses System-of-Records (SORs) and identify data reuse.

• Deep Technical knowledge of DBMS products and ecosystem - e.g. storage formats, access algorithms, data management processes, administration, data maintenance, replication, high availability, encryption, etc.

• Ability to monitor and tune databases and DBMSs to reach high performance - e.g. use data monitoring and analysis tools, tune configuration parameters, alter physical designs, benchmark, etc.

• Takes part in reviews of own work and leads reviews of colleagues' work.

• Has working knowledge of the range of tools used in the planning, analyzing, crafting, building, testing, configuring, and maintaining of assigned application(s)

• Able to participate in assigned team's Agile delivery methodology.

• Understands and has practical experience with infrastructure technologies and components like servers, jvms and networking concepts.

• Application of industry best practices, processes, and standards

• Identifies a number of ways to do things differently that will continuously improve the product.

• Understands the complete vertical platform environment (technical stack)

• Tech Stack

• Db2, Couchbase, Postgres, Oracle

• Primarily React via OneApp and Java via OneData

• Cucumber, Gatlin, Karate, Jest

• AWS, GCP

• Terraform

• GitHub Actions

• GitHub Enterprise

• Jenkins

• Education & Experience

• 6 years of database development experience in a professional environment and/or comparable experience such as:

• 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) as appropriate

• 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 variety of data stores (document, column family, graph, etc.)

• Bachelor's degree in computer science, computer science engineering, or related field required; advanced degree preferred.

• 3 years Java.

• 3 years Postgres/Oracle.

Qualifications

Salary Range: $110,000.00 to $190,000.00 annually bonus benefits

The above represents the expected salary range for this job requisition. Ultimately, in determining your pay, we'll consider your location, experience, and other job-related factors.

We back our colleagues and their loved ones with benefits and programs that support their holistic well-being. That means we prioritize their physical, financial, and mental health through each stage of life. Benefits include:

• 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

For a full list of Team Amex benefits, visit our Colleague Benefits Site .

American Express is an equal opportunity employer and makes employment decisions without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran status, disability status, age, or any other status protected by law.

We back our colleagues with the support they need to thrive, professionally and personally. That's why we have Amex Flex, our enterprise working model that provides greater flexibility to colleagues while ensuring we preserve the important aspects of our unique in-person culture. Depending on role and business needs, colleagues will either work onsite, in a hybrid model (combination of in-office and virtual days) or fully virtually.

US Job Seekers/Employees - Click here to view the "Know Your Rights" poster and the Pay Transparency Policy Statement.

If the links do not work, please copy and paste the following URLs in a new browser window: ~~~ to access the three posters.

Employment eligibility to work with American Express in the U.S. is required as the company will not pursue visa sponsorship for these positions.

Job: Technology

Primary Location: US-New York-New York

Schedule Full-time

Req ID: 24006477