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 skills fresh and relevant, we give you dedicated time to invest in your professional development. Find your place in technology on #TeamAmex.
Job Description
Engineer –Data Transformation
Minimum Qualifications
3+ years of Informatica or similar Data Transformation software development experience
Strong working knowledge of DW/ETL&BI Concepts (dimensional modeling and relational databases)
Demonstrate data warehouse project delivery experience. Experience in architecting and developing solutions for medium to large warehouses, leveraging Informatica and Microstrategy or other reporting tools.
Proficient with performance techniques and tuning in large scale Data Warehouses
Writing code, unit tests, working on specs, automation, conducting code reviews and testing.
Proficiency in SQL and familiarity with relational database technologies such as Yellowbrick, Oracle, MS SQL, SingleStore (MemSQL), and PostgreSQL.
Familiarity with environments that have multi-terabytes of data.
Interpret dimensional models as well as relationship models
Demonstrate experience in Agile development and application design.
Ability to effectively communicate with internal and external business partners and effectively convey and promote solutions.
Ability to drive results with an emphasis on reducing cycle time and increasing speed to market of new capabilities and enhancements. Able to seize opportunities to advance capabilities and use of technology tool suite.
Preferred Qualifications
Hands-on expertise with other business intelligence tools such as PowerBI, tableau, etc.,
Understanding of the cloud-based solutions (GCP, etc.,)
Experience in key technical design documentation that provides architectural / process design.
An active member of an engineering team that designs and develops software applications providing proactive thought leadership manifesting in effective capability solutions that adhere to architecture guidelines.
Experience in platform(s) support – managing the business process and technical aspects by overseeing the health and well-being of the Application.
Strong analytical and problem-solving, coupled with a continuous improvement mindset.
Excellent communication skills, capable of explaining complex issues in simple terms to a diverse audience
Assist team members in the completion of assigned tasks
Lead training sessions and create comprehensive documentation to empower end users to leverage the Business Intelligence capabilities effectively
Proficiency in simple scripting commands using programming languages such as Python
Find opportunities to adopt new innovative technologies
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:
Competitive base salaries
Bonus incentives
Support for financial-well-being and retirement
Comprehensive medical, dental, vision, life insurance, and disability benefits (depending on location)
Flexible working model with hybrid, onsite or virtual arrangements depending on role and business need
Generous paid parental leave policies (depending on your location)
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.
Offer of employment with American Express is conditioned upon the successful completion of a background verification check, subject to applicable laws and regulations.