Data Engineer II

Job Description:

At Bank of America, we are guided by a common purpose to help make financial lives better through the power of every connection. Responsible Growth is how we run our company and how we deliver for our clients, teammates, communities and shareholders every day.

One of the keys to driving Responsible Growth is being a great place to work for our teammates around the world. We’re devoted to being a diverse and inclusive workplace for everyone. We hire individuals with a broad range of backgrounds and experiences and invest heavily in our teammates and their families by offering competitive benefits to support their physical, emotional, and financial well-being.

Bank of America believes both in the importance of working together and offering flexibility to our employees. We use a multi-faceted approach for flexibility, depending on the various roles in our organization.

Working at Bank of America will give you a great career with opportunities to learn, grow and make an impact, along with the power to make a difference. Join us!

Job Description:
This job is responsible for developing and delivering data solutions to accomplish technology and business goals and initiatives. Key responsibilities include performing code design and delivery tasks associated with the integration, cleaning, transformation, and control of data in operational and analytical data systems. Job expectations include working with stakeholders and Product and Software Engineering teams to aid with implementing data requirements, analyzing performance, and researching and troubleshooting data problems within system engineering domains.

Candidate will provide support to audit teams through a number of advanced automation tools to develop new testing methodologies that provide coverage for high-risk areas. Support may be in the form of issue validation, point-in-time audits, dashboard development, or audit planning. Candidate will be given the opportunity to learn and make use of sophisticated tools (SQL, Alteryx, Informatica, SAS, Tableau, SSRS, DataRobot etc) and technologies (Big data like Hadoop, Python/R Programming, AI/Data Science,) to provide customized automated solutions across multiple business segments. Day-to-day activities will include data extraction from multiple sources, performing advanced data analytics, and building dashboards.  Opportunity exists for candidate to expand into predictive modeling, NLP solutions, and advanced analytics to provide deeper insight into the audit objectives.

Responsibilities:

• Works across development teams to contribute to the story refinement and delivery of data requirements through the delivery life cycle

• Leverages architecture components in solution development, codes solutions to integrate, clean, transform, and control data in operational and analytical data systems per acceptance criteria

• Builds processes supporting data transformation, data structures, metadata, data quality controls, dependency, and workload management and defines and builds data pipelines and complex data sets to enable data-informed decision making, identifying and raising risks at all stages of the data engineering process

• Develops and executes test plans to produce quantitative results, contributes to existing test suites including integration, regression, and performance, analyzes test reports, identifies test issues and errors, and triages underlying causes

• Drives complex information technology projects to ensure on-time delivery and adheres to team delivery and release processes

• Identifies, defines, and documents data engineering requirements, communicating required information for deployment, maintenance, support, and business functionality

• Works with technology partners and a diverse set of stakeholders to identify and close gaps in data management standards adherence, negotiates paths forward, and helps 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.)

• Responsible for multiple projects simultaneously.

• Utilizes sound, seasoned analytical skills and possesses product, business, and technical expertise to execute assigned responsibilities.

• Coordinates, schedules, scopes, and leads data automation activities on audits (incl. large, cross-functional reviews).

• Leads data analysis of control deficiencies to drive actionable business impact, influences management on sufficiency of correctives actions, recommends audit rating.

• Implements risk-based audit strategy. Exercise judgment and critical thinking to influence business partners.

• Identifies control trends through data analysis in assigned business areas as well as assessing impact to the business and to the Bank overall by applying deep and broad business acumen.

• Coaches/trains team in execution of data automation activities to support the audit plan.

• Follows the lifecycle of our internal system for automation activities and ensure its data accuracy and completeness.

• Ensure timely delivery of automation activities as per the point-in-time audit and issue validation timelines.

REQUIRED SKILLS AND EXPERIENCE

• Bachelor’s degree OR 3 years minimum experience in data extraction with ability to write SQL queries. 

• 3+ years in Data analytics

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

• Proven experience coordinating multiple projects/assignments simultaneously under minimal supervision and completing assigned tasks accurately and on a timely basis.

• Must demonstrate strong attention to detail with excellent organization skills.

• Excellent Communication skills (verbal and written)

DESIRED SKILLS AND EXPERIENCE

• Advanced SQL writing abilities

• 3  years of Data Analytics, Alteryx Core Certification, SQL Training, Database knowledge.

• 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

Skills:

• Analytical Thinking
• Application Development
• Data Management
• DevOps Practices
• Solution Design
• Agile Practices
• Collaboration
• Decision Making
• Risk Management
• Test Engineering
• Architecture
• Business Acumen
• Data Quality Management
• Financial Management
• Solution Delivery Process

Shift:

1st shift (United States of America)

Hours Per Week: 

40

Pay Transparency details

US - CT - East Hartford - 101 E River Dr - One Riverview Square (CT2550)

Pay and benefits information

Pay range

$92,500.00 - $117,400.00 annualized salary, offers to be determined based on experience, education and skill set.

Discretionary incentive eligible

This role is eligible to participate in the annual discretionary plan. Employees are eligible for an annual discretionary award based on their overall individual performance results and behaviors, the performance and contributions of their line of business and/or group; and the overall success of the Company.

Benefits

This role is currently benefits eligible. We provide industry-leading benefits, access to paid time off, resources and support to our employees so they can make a genuine impact and contribute to the sustainable growth of our business and the communities we serve.