Data Engineer

American Express Services Europe Limited; Phoenix (AZ); Hybrid; USD 85,000 - 150,000; Full time

Benefits offered by this job

6% Company Match on retirement savings plan

Flexible working model

20+ weeks paid parental leave

Free financial coaching

Job summary

A leading global financial services firm is seeking a Data Engineer to design and manage data architectures, ensuring optimal data processing and decision making. This role requires 4 years of relevant experience, proficiency in MS SQL and an analytical language such as Python or R. In addition to a competitive salary between $85,000 and $150,000, the company offers flexible working options and a comprehensive benefits package, prioritizing personal and professional development.

Qualifications

• 4 years of data architecture and MS SQL database experience in a professional environment.
• Expertise in an analytical language (Python, R or the equivalent) preferred.
• Demonstrable business report creation experience utilizing various reporting tools.

Responsibilities

• Design and build a robust data model architecture to support optimal data processing.
• Document data requirements and maintain data models for seamless integration.
• Create and maintain detailed information about data being stored.

Skills

Data architecture

MS SQL database

Analytical language (Python, R)

Business report creation

Data model design

Distributed systems

Troubleshooting

Data management

Infrastructure technologies

Education

4 years of professional experience in data architecture

Tools

SQL Reporting Services

Tableau

PowerBI

Job description

STAGING / TEST ENVIRONMENT for AMEX Internal purposes only. If you are attempting to apply for a job at American Express, please visit our Career Portal.

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

Global Infrastructure Product Services aims to establish and reinforce a culture of effective metrics, data-driven business processes, architecture simplification, and cost transparency.

A successful Data Engineer knows that delivering on that promise takes foresight, planning and agility. Our Data Engineers know how to use the latest technology to design, evaluate, debug and manage the data that leads to better decisions, maximum value, and higher customer satisfaction.

Let’s build on what you know.

If you have proficiency and experience with crafting, developing, trouble shooting, debugging, evaluating, modifying, deploying and documenting 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, let’s find business advantages hiding in plain sight. Here’s just some of what you’ll do:

• Design and build a robust data model architecture to support optimal data processing and standardized metric definitions
• Review data requirements / data stories and corresponding data sources and data architecture
• Document data requirements / data stories and maintain data models to ensure seamless integration into existing data architectures
• Create and maintain detailed information about the data being stored
• Support management of data assets as per enterprise standards, guidelines and policies
• Review and understand processing requirements inclusive of data and transaction volumes, scalability, security and performance requirements
• Assist in building and improving the database design and infrastructure required to support the Technology Infrastructure portfolio
• Communicate and work closely with business and product teams to support changes and implementation
• Design, develop, and maintain reports, processes and KPIs to drive business decisions
• 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

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

Minimum Qualifications

• 4 years of data architecture and MS SQL database experience in a professional environment
• Expertise in an analytical language (Python, R or the equivalent) preferred; knowledge of SAS is a plus but not required.
• Demonstrable business report creation experience utilizing various reporting tools (e.g.: MS SQL Reporting Services, Tableau, Informatica, Cognos, Microstrategy, PowerBI, etc.)
• Experience with hands-on design and development across one or more database management systems
• Experience with distributed systems, algorithms and applications
• Strong understanding of infrastructure data and data management
• Experience with ServiceNow data and associated data model
• Hands-on expertise with distributed (multi-tiered) systems and relational database design, development, troubleshooting and automated testing
• Strong analytical skills with demonstrable ability to understand and document business data requirements
• Technical knowledge of DBMS products and ecosystem: storage formats, access algorithms, data management processes, administration, data maintenance, replication, high availability, encryption, etc.
• Proficiency with data structures and associated components
• Basic understanding of Metadata Management and Database Management
• Proficiency with and ability to document business data requirements in complete, accurate, extensible and flexible logical data models using data modeling tools
• Proficiency with creating basic data models using the relevant tools and frameworks
• Basic understanding of XML and schema development/reuse, database concepts, database design
• Proficiency with industry recognized methods, processes and standards
• Familiarity with enterprise infrastructure technologies and components (e.g.; compute, storage, JVMs, containers, networking fundamentals)

Minimum Qualifications

Salary Range: $85,000.00 to $150,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:

• 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

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 thePay Transparency Policy Statement.

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

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.

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.

Additional Note for US Applicants: American Express does not currently utilize the AI capabilities of its application management platform in making employment decisions.

If you have a disability and would like to request an accommodation in order to apply for a position you may contact us by emailing [e-mail] . Please indicate if you would prefer a response via email or phone. US applicants may also contact us by using the US Toll Free number 1-833-707-1981.