Data Engineer II - Data Analyst (SQL)

Job Overview

At Bank of America, we are guided by a common purpose to help make financial lives better through the power of every connection. This Data Engineer II - Data Analyst role is pivotal in achieving this by developing and delivering data solutions to accomplish technology and business goals. The position involves working with stakeholders and Product and Software Engineering teams to implement data requirements, analyze performance, and troubleshoot data problems within system engineering domains.

Responsibilities

• Work across development teams to refine and deliver data requirements through the delivery lifecycle.
• Leverage architecture components in solution development, coding solutions to integrate, clean, transform, and control data in operational and analytical data systems per acceptance criteria.
• Build processes supporting data transformation, data structures, metadata, data quality controls, dependency, and workload management.
• Define and build data pipelines and complex data sets to enable data-informed decision making, identifying and raising risks at all stages of the data engineering process.
• Develop and execute test plans to produce quantitative results, contribute to existing test suites including integration, regression, and performance, analyze test reports, identify test issues and errors, and triage underlying causes.
• Drive complex information technology projects to ensure on-time delivery and adhere to team delivery and release processes.
• Identify, define, and document data engineering requirements, communicating required information for deployment, maintenance, support, and business functionality.
• Work with technology partners and a diverse set of stakeholders to identify and close gaps in data management standards adherence, negotiate paths forward, and help identify and communicate solutions to complex data problems leveraging knowledge of information systems, techniques, and processes.
• Independently develop automated testing solutions using a variety of technologies (SQL, Alteryx, SAS, Python, Tableau, etc.).

Managerial Responsibilities

• Diversity & Inclusion Champion: Creates an inclusive team where members are treated fairly and respectfully.
• Manager of Process & Data: Demonstrates and expects process knowledge, data-driven decisions, simplicity, and continuous improvement.
• Enterprise Advocate & Communicator: Delivers clear and concise messages that motivate, convey the "why" and connects contributions to business results.
• Risk Manager: Leads and encourages the identification, escalation, and resolution of potential risks.
• People Manager & Coach: Knows and develops team members through coaching and feedback.
• Financial Steward: Manages expenses and demonstrates an owner’s mindset.
• Enterprise Talent Leader: Recruits, on-boards, and develops talent, and supports talent mobility for career growth.
• Driver of Business Outcomes: Delivers results through effective team management, structure, and routines.

Required Skills and Experience

• 3 years minimum experience in data extraction with ability to write SQL queries.
• 3 years of Data Analytics, Alteryx Core Certification, SQL Training, Database knowledge.
• Skilled in the use of data wrangling and visualization tools such as Alteryx and Tableau.
• Understanding of Data Integration/ETL tools.
• Familiarity with DataRobot, Instabase, and UIPath are a plus.

Desired Skills and Experience

• Advanced SQL writing abilities.
• Knowledge of how to connect to data sources and extract and analyze data.
• Experience with Python is a plus.
• AI/Data Science Experience is a plus.
• Audit experience is a plus.