Data Engineer II

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

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. Amex 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 skill fresh and relevant, we give you dedicated time to invest in your professional development. Find your place in technology on #TeamAmex.  

Let’s share success.

The Global Infrastructure Cost Transparency team, a part of Infrastructure Data & Analytics (ID&A), aims to establish and reinforce a culture of effective metrics, data-driven business processes, architecture simplification, and cost transparency.

We are seeking a Data Engineer who knows that delivering on that promise takes foresight, planning and agility. Metric-driven cost optimization, workload-specific forecasting and robust cost modeling are among the tools and practices required to drive accountability for delivering business solutions that derive maximum value. The result will provide a solid foundation for decision-making around cost, quality and speed. If you have proficiency and experience with designing and building these tools, join our team and build a career with us. 

Let’s build on what you know.

If you have deep experience with cost transparency, allocation, and optimization, you'll find a fit within our enterprise-wide Cost Transparency team responsible for establishing consistent workload attribution, unit economics and business value metrics.

Here’s just some of what you’ll do:

• Build well-architected pipelines to extract, transform and load data from various sources, including general ledger fields and other systems of record into a coherent, actionable format
• Design, develop, and maintain reports, processes and KPIs that provide detailed usage statistics, cost correlations and actionable insights across the multi-product infrastructure environment
• Build data models for comparisons of deployments on various platforms, cause and effect scenarios, and consumption pattern analysis to underpin business value measurements and cost stewardship for enterprise deployments, platform growth, and product lifecycle strategies
• Function as member of an agile team by contributing to software builds through consistent development practices (tools, common components, and documentation)
• Debug basic software components and identify code defects for remediation
• Enable the deployment, support, and monitoring of software across test, integration, and production environments
• Influence team members with creative changes and continuous improvements

Qualifications:

Are you up for the challenge? Here’s what you should have:

• Hands-on experience with IBM’s ApptioOne and TBM Studio
• Hands-on experience designing pipelines to orchestra data ingestion and integration from external systems of record (SORs) into IBM ApptioOne
• A deep understanding of ApptioOne modules, namely Cost Transparency, Total Cost of Ownership and Bill of IT
• Expert-level knowledge and experience in RDBMS (SQL Server or Oracle or PostGres), NOSQL, Json, Node Js, Python Programming, Astronomer Airflow, HTML and XML
• Acumen towards building reporting dashboards and collections for varying audience personas such as executives, finance managers, product leaders, portfolio managers and application owners/managers
• Keen ability and interest to build financial strategies, frameworks and tools from the ground up
• Ability to demonstrate increased self-reliance to achieve team goals
• Demonstrable software development experience in a professional environment and/or comparable experience such as:
  • Familiarity with Agile or DevOps
  • Experience with API design, either as a provider or consumer
  • Experience with object-oriented design and coding with variety of languages
• Experience with Power BI or Tableau is a plus, but not required
• Hands-on expertise with distributed (multi-tiered) systems and relational database design, development, troubleshooting and automated testing
• Excellent communication skills
• Bachelor’s degree in computer science, Information Technology, Data Science or related experience 

Salary Range: $89,250.00 to $150,250.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 you with benefits that support your holistic well-being so you can be and deliver your best. This means caring for you and your loved ones' physical, financial, and mental health, as well as providing the flexibility you need to thrive personally and professionally:

• 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