PhoenixRecruiter Since 2001
the smart solution for Phoenix jobs

Senior Engineer - DW/ETL

Company: American Express
Location: Phoenix
Posted on: February 24, 2021

Job Description:

You Lead the Way. We've Got Your Back.

At American Express, we know that with the right backing, people and businesses have the power to progress in incredible ways. Whether we're supporting our customers' financial confidence to move ahead, taking commerce to new heights, or encouraging people to explore the world, our colleagues are constantly redefining what's possible - and we're proud to back each other every step of the way. When you join #TeamAmex, you become part of a diverse community of over 60,000 colleagues, all with a common goal to deliver an exceptional customer experience every day.

  • Serving as a core member of an Agile team that leads user story analysis and elaboration, designs and develops software applications.
  • Responsible for the Applications Architecture / Technical design & build, work/coordinate with other team's Architect, Engineers and vendors as necessary.
  • Writing code and unit tests, automation, and conducting code reviews and testing.
  • Identifying exciting Technology modernization opportunities for adopting new open source-based Technology tools & products to solve existing needs and predicting future challenges.
  • Performing ongoing refactoring of code, utilizing visualization and other techniques to fast track concepts, and delivering continuous improvement.
  • Working with Product Managers to prioritize features for ongoing sprints and managing a list of Technical requirements based on industry trends, new technologies, known defects, and issues.
  • Strong contributor in complex Data Warehousing and Business Intelligence project implementations.
  • Proven experience in working directly with business customers.
  • Data analysis skills - ability to dig in and understand complex models and Business processes.
  • Data profiling experience.
  • Defining and implementing Data Integration Architecture.
  • Proven problem-solving / problem-resolution abilities.
  • Manage your own time, and work well both independently and as part of a team.
  • Quickly generate and updating proof of concepts for testing and team feedback.
  • Embrace emerging Technology standards while promoting best practices.

    Minimum Qualifications
    • 7+ years of experience with Data Warehouse ETL design, development and maintenance with successful implementation of large Enterprise BI solutions.
    • Bachelor's Degree in Computer Science, Computer Engineering or equivalent is required.
    • Demonstrated experience in Agile Development, Application Design, Software Development, and Testing.
    • Should have good work Technical knowledge and experience in Finance domain.
    • Highly proficient in SQL and PL/SQL , PostgreSql ; Skilled at optimizing large complicated SQL statements ; Strong SQL skills including complex query building and query performance tuning.
    • Strong UNIX shell scripting skills.
    • Should have at least more than 2 + Technical implementation experience in large-scale enterprise applications. Experience in handing huge volume of Data ingestion, processing and reporting.
    • Profound knowledge of Data Warehousing design concepts/skills.
    • Working experiencing on appliance based BI / Datawarehouse platform like Netezza , Yellowbrick preferred.
    • Strong Knowledge of logical and physical Data Modeling (relational, dimensional data modeling).
    • Provide Technical recommendations to improve efficiency of Data Management /ETL process.
    • Strong dB query optimization & performance tuning skills. The ability to quickly and efficiently analyze and resolve performance issues within variety of operational environments.
    • Create proactive alerts/notifications to identify when data load anomalies occur.
    • Create/ maintain database objects such as tables, views, indexes, constraints, and SQL code, and stored procedures and shell scripts.
    • Knowledgebase with Java/J2EE, and Spring and building RESTful APIs.
    • Knowledge in Object Oriented Analysis and Design across a variety of platforms.
    • Thorough understanding of XML, JSON, Web Service technologies, and data structure fundamentals.
    • Working experience on modern relational, non-relational database like NoSql, Couchbase, PostgreSQL , MemSQL.
    • Ensure data quality and integrity within each data set and support linkage to other appropriate data sets in consistent manner. This includes testing and validating any new database design against previous data structures.
    • Demonstrated ability to analyze data concerning production volumes, batch schedules, and i/o statistics.
    • Ability to effectively communicate with internal and external business partners.


      Soft Skills

      Highly collaborative, self-starter, technical contributor, outstanding communication practices.

      Data analysis experience is a bug plus.

      Preferred Skills
      • Experience using ETL such as Talend , Informatica.
      • Experience in open source tool and design pattern.
      • Support on-loading/off-loading data to/from Hadoop environment.
      • Working experience in Big Data technologies (Hadoop, Spark, Kafka, MAPR (plus), NoSQL).
      • Knowledgeable and experienced with scripting languages such as Python, etc.
      • Knowledgeable and experienced with in-memory computation and data virtualization tools & techniques.
      • Experience with DevOps tools, automating engineering and operational tasks.
      • Expertise in troubleshooting complex OS, database, file system, network configuration, and application & web server issues.
      • Experience with a broad range of software languages and Financial business domain knowledge will be a plus.

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

        American Express is an equal opportunity employer and makes employment decisions without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability status, age, or any other status protected by law

        ReqID:
        Schedule (Full-Time/Part-Time): Full-time
        Date Posted: Feb 16, 2021, 11:36:42 AM

Keywords: American Express, Phoenix , Senior Engineer - DW/ETL, Engineering , Phoenix, Arizona

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Other Engineering Jobs


Automotive Technician - Mobile
Description: Description: br WHO WE AREWrench, Inc. is the fastest growing mobile mechanic service around and has an immediate opening for a Mobile Auto Mechanic. Join a dynamic, groundbreaking team who is changing (more...)
Company: Wrench Inc
Location: Phoenix
Posted on: 03/8/2021

Engineer - Fullstack
Description: You Lead the Way. We've Got Your Back. br br At American Express, we know that with the right backing, people and businesses have the power to progress in incredible ways. Whether we're supporting (more...)
Company: American Express
Location: Phoenix
Posted on: 03/8/2021

Senior Salesforce Engineer - AZ
Description: No Third Party Candidates. Need ONLY W2.- br Candidate who are willing to relocate-to-Phoenix , AZ-after Pandemic. br 50 hands on coding, 50 leading a team br br Qualifications br br ul (more...)
Company: Yoh, A Day & Zimmermann Company
Location: Laveen
Posted on: 03/8/2021


DevOps Engineer
Description: You Lead the Way. We've Got Your Back.At American Express, we know that with the right backing, people and businesses have the power to progress in incredible ways. Whether we're supporting our customers' (more...)
Company: American Express
Location: Phoenix
Posted on: 03/8/2021

Quality Engineer
Description: Our client, an enterprise level credit company, is looking for a Quality Engineer to join their team in Phoenix, AZ br This is a 1 year long contract with the opportunity for extension or conversion (more...)
Company: Motion Recruitment
Location: Phoenix
Posted on: 03/8/2021

Front End Engineer - 100% Remote
Description: If you are a Front End Engineer with experience, please read on br br Location: Remote USA We're in Mesa, AZ br Full time - Direct hire br br What You Will Be Doing br ul li Collaborate (more...)
Company: Optello
Location: Phoenix
Posted on: 03/8/2021

Development Engineer CAD Tech
Description: Principal Duties Responsibilities: Work with the lead development engineer and company leadership to develop solutions for our client's development projects Support designers and engineers in the (more...)
Company: FastGrid
Location: Phoenix
Posted on: 03/8/2021

quality Engineer
Description: Projects The Candidate Will Be Working On The candidate will work on the Claims related projectsTeam And Team Size Team has 1 Scrum Master, 1 Product Owner, 3-5 Software Engineers, and 1-2 Quality Engineers. (more...)
Company: Horizontal Talent
Location: Phoenix
Posted on: 03/8/2021

Front End Engineer - 100% Remote
Description: If you are a Front End Engineer with experience, please read on Location: Remote USA We're in Mesa, AZ Full time - Direct hireWhat You Will Be Doing Collaborate with development team s and Product (more...)
Company: Optello
Location: Phoenix
Posted on: 03/8/2021

Automotive Mechanics / Technicians - All Skill Levels
Description: 4010 E. Broadway Rd., Phoenix, AZ 85040Automotive Service Technicians/ MechanicsHIRING ALL SKILL LEVELSGenerous Pay Plan Excellent Benefits Walk-in Applicants are Welcome 1-10 Premier Auto Sales is (more...)
Company: I-10 PREMIER AUTO SALES
Location: Phoenix
Posted on: 03/8/2021

Log In or Create An Account

Get the latest Arizona jobs by following @recnetAZ on Twitter!

Phoenix RSS job feeds