194 applicants

Company

Original Job Post

American Express · 3 days ago

Senior Data Engineer

New York, NY

Full-time

Hybrid

Senior Level

$110K/yr - $190K/yr

Wonder how qualified you are to the job?

Maximize your interview chances

Debit CardsFinance

Actively Hiring

Comp. & Benefits

Insider Connection @American Express

Discover valuable connections within the company who might provide insights and potential referrals, giving your job application an inside edge.

Responsibilities

Architect and refine a robust technology infrastructure cost allocation model using ApptioOne and TBM Studio, with a focus on continuous integration and improvement

Extract, transform and load (ETL) data from diverse sources, including general ledger fields and other systems of record into a coherent, actionable format

Maintain seamless data links between internal systems and ApptioOne, ensuring high data quality and consistency

Work closely with stakeholders across Technology, Finance and business unit portfolio leaders to define data and analytics requirements and incorporate cost drivers, allocation methods, and infrastructure nuances

Regularly review and update the cost model to reflect changes in technology infrastructure, business strategy and financial policies

Develop SQL queries, scripts and routines to automate data processing and enhance the model’s accuracy and efficiency

Generate insightful data visualization and reports to aid in decision-making and demonstrate the cost model’s value to stakeholders

Lead training sessions and create comprehensive documentation to empower end users to leverage the cost model effectively

Function as an active member of an agile team through consistent development practices (tools, components, and documentation)

Find opportunities to adopt innovative technologies

Take part in reviews of individual or team contributions

Work on prioritized/assigned features for ongoing sprints

Communicate and work reciprocally with business and product teams to support changes and implementation

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

SQLETLKPI DesignData VisualizationData AnalysisPythonRScalaMS SQL Reporting ServicesTableauInformaticaCognosMicrostrategyPowerBIMatplotlibDistributed SystemsRelational Database DesignAutomated TestingFinancial Data AnalysisCost ModelingEnterprise Infrastructure TechnologiesProblem-SolvingProject ManagementCommunicationApptio OneTBM Studio

Required

Hands-on expertise with distributed (multi-tiered) systems and relational database design, development, troubleshooting and automated testing

Demonstrated experience in data visualization with a focus on financial data analysis and cost modeling

Advanced proficiency in SQL and familiarity with other relational database technologies

Proficiency with industry recognized ETL methods, processes and standards

Proficiency with KPI and metric design

Thorough understanding of enterprise infrastructure technologies such as Compute, Storage, Network, Mainframe to inform model development and adjustments

Strong analytical, problem-solving and project management skills, coupled with a continuous improvement mindset

Excellent communication skills, capable of explaining complex data issues in simple terms to a diverse audience

Strong proficiency in data manipulation and analysis using programming languages such as Python, R, or Scala

Demonstrable experience with data visualization and reporting tools (e.g.: MS SQL Reporting Services, Tableau, Informatica, Cognos, Microstrategy, PowerBI, matplotlib, etc.)