Senior Data Engineer

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. Client 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.

Client 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.
• Key Responsibilities:
o Performs all technical aspects of data architecture and database management for assigned applications, including developing prototypes, developing new database structures and APIs as applicable.
o Performs transformation of logical data architectures into physical data designs, according to database design best practices and standards
o Provides database administration services to projects crafting, extending or maintaining databases, data warehouses and datamarts
o Debugs database components, identifies, fixes and verifies remediation of design and/or performance defects.
o Performs ongoing refactoring of database design and continuously improves product to follow data placement procedures and re-use of existing databases as appropriate.
o Ensure optimal data replication, performance, High Availability, backup and recovery processes exists to meet requirements, reduce cost and adhere to standards.
o Leads in development of plans and strategies, best practices, and standards related to data management processes, data products, data security and programs.
o Functions as Senior member of an agile team and leads data assets as per the enterprise standards, guidelines and policies.
o Typically spends 50% of time in database development and testing and remainder of time collaborating with partners through ongoing product/platform releases.
o Communicates and works collaboratively with business and product teams to support changes and implementation.
o 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.
o Partner with delivery architects and engineers to design optional data tier solutions to meet enterprise platform objectives and goals.
o Stays abreast of new DBMS features and functions and drive adoption across Client to use product capabilities.
o Active member of the vendor product development strategy that will enable vendors to provide solutions and features to meet Client needs.
o Contributes to decisions about tools, methods and approaches.
o Finds opportunities to embrace innovative technologies.
o Works closely with product owners on blueprints and annual planning of feature sets that impact multiple platforms and products

Team Environment Tech Stack:
o Db2, Couchbase, Postgres, Oracle
o Primarily React via OneApp and Java via OneData
o Cucumber, Gatlin, Karate, Jest
o AWS, GCP
o Terraform
o GitHub Actions
o GitHub Enterprise
o Jenkins

Education & Experience Requirements:
6+ years of database development experience in a professional environment and/or comparable experience such as:
Hands on expertise with design and development across one or more database management systems (Postgres)
Experience with distributed (multi-tiered) systems, algorithms, and application development (Java)
Experience with database development and support of OLTP and/or OLAP systems.
Demonstrated experience with big data technologies (Spark) 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
3+ years Spark

Enterprise Req Skills

java,postgresql,Spark,cloud,oracle,software development,Data Engineering,scala,jenkins,ab initio,Aws

Top Skills Details

- 6+ years of experience working in Data Engineering and Software Development at the enterprise level on an external facing applications deployed on the the cloud (AWS preferred but any cloud is fine)
- Strong data engineering experience with Postgres & Spark (preferably Scala Spark but will consider PySpark)
- Strong hands of development experience with Java (and/or Scala)
- System design knowledge especially around persistence which includes scalability, resiliency, latency, performance, etc