MS SQL Server Developer

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!

Position Summary

Bank of America's associates are innovators and problem-solvers. We look for creative collaborators who evolve, adapt to change and thrive in a fast-paced global environment. The Global WindDown (GWD) Technology team within Finance Technology consists of extremely talented engineers, working with the Global Liquidity Management group to improve forecasting processes through technology, delivering a set of capabilities that will drive greater consistency, automation, transparency, efficiency and control.

We are looking for a talented and highly motivated software engineer with technology experience and knowledge in database technologies, to help further develop our forecasting & analytics platform.

Enterprise Finance Technology's GWD Technology team is working on and implementing innovative solutions to improve forecasting processes and support operational excellence. This role will be responsible for working closely with the technical leads and Product Owners to deliver & support data, analytics and reporting functionalities in the GWD platform. This right candidate will be responsible for hands-on application development to support the current and target process across the SDLC - design, build, test, deploy & support.

Job Description:

This job is responsible for developing and delivering complex requirements to accomplish business goals. Key responsibilities of the job include ensuring that software is developed to meet functional, non-functional and compliance requirements, and solutions are well designed with maintainability/ease of integration and testing built-in from the outset. Job expectations include a strong knowledge of development and testing practices common to the industry and design and architectural patterns.

Responsibilities:

• Codes solutions and unit test to deliver a requirement/story per the defined acceptance criteria and compliance requirements

• Designs, develops, and modifies architecture components, application interfaces, and solution enablers while ensuring principal architecture integrity is maintained

• Mentors other software engineers and coach team on Continuous Integration and Continuous Development (CI-CD) practices and automating tool stack

• Executes story refinement, definition of requirements, and estimating work necessary to realize a story through the delivery lifecycle

• Performs spike/proof of concept as necessary to mitigate risk or implement new ideas

• Automates manual release activities

• Designs, develops, and maintains automated test suites (integration, regression, performance)

Required Qualifications:

• Significant experience in Microsoft SQL programming and development is a must including SSMS, SSRS, SSIS, SSAS, Oracle, CUBE (Star Schema).

• Must have hands-on experiences in migrating from standard relational database to non-relational databases leveraging Big Data stack and alternate mechanisms like HDFS, Spark, Neo4j, Snowflake, Airflow, MongDB, etc.

• Assess and analyze existing database architecture to identify opportunities for modernization.

• Proficiency in database design, optimization, and performance tuning.

• Significant experience in data normalization, denormalization, compression techniques to optimize data-size and performance.

• Collaborate with cross-functional teams to understand business requirements and align database solutions accordingly.

• Ensure data integrity, security, and performance in the modernized database environment.

• Provide technical guidance and support to development teams during the implementation of database changes.

• Stay current with industry trends and emerging technologies in both traditional databases and big data.

• Experience in Financial data such Trade data, Reference data , etc. to build functional calculation modules, reports and dashboards

• Experience in functional knowledge of GRRP (Global Recovery and Resolution Planning) regulatory needs in terms of data, calculations& Reporting

Skills:

• Application Development

• Automation

• Influence

• Solution Design

• Technical Strategy Development

• Architecture

• Business Acumen

• DevOps Practices

• Result Orientation

• Solution Delivery Process

• Analytical Thinking

• Collaboration

• Data Management

• Risk Management

• Test Engineering

Shift:

1st shift (United States of America)

Hours Per Week:

40