Engineer-SQL (Data Analysis/ Visualization)

$85,000 - $150,000/Yr

American Express - Phoenix, AZ

Full-time - Entry Level

Phoenix, AZ

Credit Intermediation and Related Activities

About the position

The Engineer - SQL (Data Analysis/Visualization) position at American Express focuses on the design, development, testing, and deployment of IT Asset Management (ITAM) solutions. The role involves collaborating with technology and business partners to ensure high-quality data integration and analysis, driving root cause identification for issues, and supporting data testing and documentation. The engineer will work in a diverse tech team, contributing to software that enhances customer experiences while also engaging in professional development opportunities.

Responsibilities

• Assist in documenting data requirements and data stories, including analyzing data requirements, data stories and corresponding data sources and data architecture.
• Liaise between ITAM product and control development, control operations, technology support and development related to IT asset data requirements and issues.
• Assist in supporting data testing.
• Conduct data mining/analysis activities to provide actionable insights to support issue identification, resolution or to support enhancements.
• Investigate and drive incident and problem resolution, collaborating with partner teams.
• Monitor and measure accuracy of inbound data feeds, data conditioning processes and work with partner teams to identify and drive resolution of quality or completeness gaps.
• Assist in investigating, documenting and monitoring all upstream and downstream systems, tools and processes which facilitate effective operation of ITAM controls.
• Provide data analysis and documentation to support process and audit activities.
• Communicate the status of issues, preventative solutions and resolution to the team and leader with an emphasis on risk awareness.

Requirements

• Up to 4 years of software development experience in a professional environment and/or comparable experience.
• Familiar with Agile or other rapid application development methods.
• Hands-on experience with SQL and relational databases, data visualization, dashboard or report design, Power BI.
• General knowledge of distributed (multi-tiered) systems, algorithms, and relational databases.
• Bachelor's degree in computer science, computer science engineering, or related field required; advanced degree preferred.
• Understands XML/JSON and schema development/reuse, database concepts, database designs.
• Conducts systematic and rational analyses to identify the root cause of problems.
• Excellent skills in organizing and managing workload to ensure demands are met and targets are achieved.
• Experience in data and information analysis, utilizing various sources to make sound conclusions and decisions.
• Is clear when explaining ideas and concepts to others, communication is structured and easy to understand.
• Demonstrates analytical thinking and adaptive communication.
• Knows when to raise decisions and when to make on-the-spot decisions.
• Able to challenge the status quo and drive creative ideas and solutions.
• Recognizes the importance of teamwork and collaboration to achieve objectives.
• Adapts to change quickly and easily.

Nice-to-haves

• Experience with IT Asset Management, multi-source CMDB and the ServiceNow platform.
• Professional certifications or 3+ in IT Asset Management (i.e., CSAM, CITAM, CHAMP, CAMSE or equivalent).

Benefits

• 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