Data Engineer - TechCare Operations: Blueprint team

American Express•Phoenix, AZ

2d•Hybrid

About The Position

At American Express, our culture is built on a 175-year history of innovation, shared values and Leadership Behaviors, and an unwavering commitment to back our customers, communities, and colleagues. From delivering differentiated products to providing world-class customer service, we operate with a strong risk mindset, ensuring we continue to uphold our brand promise of trust, security, and service. As part of Team Amex, you'll experience this powerful backing with comprehensive support for your holistic well-being and many opportunities to learn new skills, develop as a leader, and grow your career. Here, your voice and ideas matter, your work makes an impact, and together, you will help us define the future of American Express. How will you make an impact in this role? Here, your voice and ideas matter, your work makes an impact, and together, you will help us define the future of American Express. Digital Workplace (DW) is the convergence of digital, cultural, and physical elements that enable all American Express colleagues to do phenomenal work in a complex, dynamic, and often unstructured working environment. You will work within our TechCare Operations: Blueprint team, in partnership with our database, analytics and reporting leads to ensure maximum value as we execute on our TechCare Blueprint. You will work to develop solutions to meet the needs of our product and servicing operation leaders. Critical focus areas include: Designs, develops, solves problems, evaluates, modifies, deploys and documents all data components (data architecture, logical and physical data models, database objects and database administration) that meet the needs of customer-facing applications, business applications, and/or internal end user applications. Partner with stakeholders to understand needs, analyze data, and present solutions and insights back.

Requirements

Up to 6 years of data architecture and database development experience in a professional environment and/or comparable experience such as:
Familiar with Agile or other rapid application development methods
Experience with design and development across one or more database management systems (e.g. IMS, DB2 zOS, Oracle, MS SQL Server, PostgreSQL, Netezza (PDA/DB2AA) as appropriate
Hands-on expertise with database design and development and automated testing
Experience with distributed (multi-tiered) systems, algorithms, and application development
Proven experience in understanding of Big data technology 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
Experience with Big Data & Analytics solutions using Hadoop, MapReduce, Pig, Hive, Spark, Storm, etc.
Experience with Machine Learning
Experience with Data Modelling
Experience with web development frameworks, including Spring and Struts
Experience with Web Services design and implementation using REST APIs
Strong analytical skills with a validated ability to understand and document business data requirements in complete, accurate, extensible and flexible logical data models using data modeling tools – ErStudio, ErWin
Able to facilitate discussions between small groups of Technology and business people, recognize issues of conflict and inconsistency between data requirements and pursue a resolution of these issues
Understands XML/JSON and schema development/reuse, Open Source and NoSQL will be an added advantage
Able to establish, modify or maintain data structures and associated components according to design
Understands Metadata Management and Database Management concepts
Creates data models using the relevant tools and frameworks
Partners with Sr. Data Engineers and Sr. Data architects to create platform level data models and database designs
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 DBMS’s to reach high performance – e.g. use data monitoring and analysis tools, tune configuration parameters, alter physical designs, benchmark, etc.
Has working knowledge of the range of tools used in the planning, analyzing, designing, building, testing, configuring and maintaining of assigned application(s)
Able to participate in assigned team’s software delivery methodology (Agile, Scrum, Agile XP, Test-Driven Development, Waterfall, etc.)
Understands and has practical experience with infrastructure technologies and components like servers, jvms and networking concepts
Application of industry recognized methods, processes and standards
Identifies a number of ways to do things differently that will continuously improve the product
SDLC Methodologies and Practices
Metadata Management and Database Management
System/Platform Domain Knowledge
Understands machine learning techniques
Ability to design and implement REST APIs
Has working knowledge of Big Data & Analytics solutions using Hadoop, MapReduce, Pig, Hive, Spark, Storm, etc.
Has working knowledge of web development frameworks, including Spring and Struts
Adaptive Communication
Agile Practices
Industry and Company Knowledge
Organizational Change Management
Technical Acumen
Technology Industry Trends

Responsibilities

Partner with the product teams to understand business data requirements, identify data needs and data sources to create data architecture
Documents data requirements / data stories and maintains data models to ensure flawless integration into existing data architectures
Leads data assets as per the enterprise standards, guidelines and policies
Documents processing requirements inclusive of data and transaction volumes, scalability, security and performance requirements
Creates and maintains detailed information about the data being stored in the database
Understands the database requirements and translate into physical database design.
Follows data placement procedures and re-use of existing databases when possible
Performs database design review and supports database testing
Provides production environment support for database systems and processes
Communicates and works reciprocally with business and product teams to support changes and implementation
Write instructions to guide database operators during production runs
Work on assigned database features for ongoing sprints and lead database 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 platform objectives and goals
Function as an active member if an agile team through consistent development practices (tools, components, and documentation)
Find opportunities to adopt innovative technologies
Work with product owners to prioritize features for ongoing sprints and managing a list of technical requirements based on industry trends, new technologies, known defects, and issues.
Builds, tests, and enhances database design and infrastructure required to support the Business portfolio

Benefits

Competitive base salaries
Bonus incentives
6%25 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