girl looking into her desktop
Back to search results

Architect/Data Modeler, Enterprise Finance Technology

Charlotte, North Carolina;

Job Description:

Enterprise Finance Technology (FT) at Bank of America

  • Believes diversity makes us stronger so we can reflect, connect and meet the diverse needs of our clients and employees around the world

  • Is committed to building a workplace where every employee is welcomed and given the support and resources to perform their jobs successfully

  • Wants to be a great place for people to work and strives to create an environment where all employees have the opportunity to achieve their goals

  • Provides continuous training and development opportunities to help employees achieve their career goals, whatever their background or experience

  • Is committed to advancing our tools, technology, and ways of working to better serve our clients and their evolving business needs

  • Believes in responsible growth and is dedicated to supporting our communities by connecting them to the lending, investing and giving them what they need to remain vibrant and vital


Who We Look For 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.

Treasury Data Services team within Finance Technology consists of extremely talented engineers, who develop industry leading data services solutions in support of multiple Data Warehouses providing quality, controlled data consisting of end of day and intraday fixed income and derivative trading positions and other financial data for our front office, middle office, market risk and finance business partners.

We are looking for looking for a talented and highly motivated Data Architect with a strong background in dimensional data modeling and experience designing and building enterprise data warehouses. The right candidate will be instrumental in leading efforts to modernize our data architecture and help deliver functionality to the Treasury business to be more effective managing the banks funding and investment activities.

ROLE OVERVIEW:

Enterprise Finance Technology’s Data Horizontal team is looking for motivated new talent to enhance the architecture, data model and data capabilities of the Corporate Investments Data Warehouse (CIDW).

  • The incumbent will contribute to a range of initiatives by helping teams build strong technical foundations and enabling future business strategy.

  • Provide technical support and guidance for teams building high-performance, integrated and controlled data integration solutions.

  • Acts as both an individual contributor and as a seasoned technical resource able to provide technical direction to development teams.

  • This incumbent will help the team craft data solutions to meet business and enterprise requirements and lead data modeling efforts.

  • While our core stack is currently Informatica / Oracle / SQL, we are exploring new big data methods of moving data using Python, PySpark, Airflow and Rules Engines.


REQUIRED MINIMUM QUALIFICATIONS

  • Strong background in Dimensional Data Modeling (E.g. Kimball Methodology, star schema, snowflake, normalization forms)

  • Experience designing and building data warehouses and knowledge of the data flows involved

  • Solid background in Data Warehouse / Data Mart / Business Intelligence delivery

  • Experience with ETL and the patterns involved in transforming data into a form easily digestible for business users

  • Bachelor’s degree in STEM related field


PREFERRED MINIMUM QUALIFICATIONS

  • Experience with Oracle Exadata and background in solving database performance issues and the skill to design high performing data models

  • Knowledge of Capital Markets and Finance and how to represent in a data model

  • Experience using a data modeling tool (e.g. Power Designer, Erwin)

  • Programming experience in Python, PySpark (Pandas, DataFrames)

  • Previous experience using an ETL tool such as Informatica

  • Knowledge of Linux, bash, Perl

  • Previous experience with Rules Engines (e.g. Sapiens)

Job Band:

H5

Shift: 

1st shift (United States of America)

Hours Per Week:

40

Weekly Schedule:

Referral Bonus Amount:

0

Job Description:

Enterprise Finance Technology (FT) at Bank of America

  • Believes diversity makes us stronger so we can reflect, connect and meet the diverse needs of our clients and employees around the world

  • Is committed to building a workplace where every employee is welcomed and given the support and resources to perform their jobs successfully

  • Wants to be a great place for people to work and strives to create an environment where all employees have the opportunity to achieve their goals

  • Provides continuous training and development opportunities to help employees achieve their career goals, whatever their background or experience

  • Is committed to advancing our tools, technology, and ways of working to better serve our clients and their evolving business needs

  • Believes in responsible growth and is dedicated to supporting our communities by connecting them to the lending, investing and giving them what they need to remain vibrant and vital


Who We Look For 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.

Treasury Data Services team within Finance Technology consists of extremely talented engineers, who develop industry leading data services solutions in support of multiple Data Warehouses providing quality, controlled data consisting of end of day and intraday fixed income and derivative trading positions and other financial data for our front office, middle office, market risk and finance business partners.

We are looking for looking for a talented and highly motivated Data Architect with a strong background in dimensional data modeling and experience designing and building enterprise data warehouses. The right candidate will be instrumental in leading efforts to modernize our data architecture and help deliver functionality to the Treasury business to be more effective managing the banks funding and investment activities.

ROLE OVERVIEW:

Enterprise Finance Technology’s Data Horizontal team is looking for motivated new talent to enhance the architecture, data model and data capabilities of the Corporate Investments Data Warehouse (CIDW).

  • The incumbent will contribute to a range of initiatives by helping teams build strong technical foundations and enabling future business strategy.

  • Provide technical support and guidance for teams building high-performance, integrated and controlled data integration solutions.

  • Acts as both an individual contributor and as a seasoned technical resource able to provide technical direction to development teams.

  • This incumbent will help the team craft data solutions to meet business and enterprise requirements and lead data modeling efforts.

  • While our core stack is currently Informatica / Oracle / SQL, we are exploring new big data methods of moving data using Python, PySpark, Airflow and Rules Engines.


REQUIRED MINIMUM QUALIFICATIONS

  • Strong background in Dimensional Data Modeling (E.g. Kimball Methodology, star schema, snowflake, normalization forms)

  • Experience designing and building data warehouses and knowledge of the data flows involved

  • Solid background in Data Warehouse / Data Mart / Business Intelligence delivery

  • Experience with ETL and the patterns involved in transforming data into a form easily digestible for business users

  • Bachelor’s degree in STEM related field


PREFERRED MINIMUM QUALIFICATIONS

  • Experience with Oracle Exadata and background in solving database performance issues and the skill to design high performing data models

  • Knowledge of Capital Markets and Finance and how to represent in a data model

  • Experience using a data modeling tool (e.g. Power Designer, Erwin)

  • Programming experience in Python, PySpark (Pandas, DataFrames)

  • Previous experience using an ETL tool such as Informatica

  • Knowledge of Linux, bash, Perl

  • Previous experience with Rules Engines (e.g. Sapiens)

Shift:

1st shift (United States of America)

Hours Per Week: 

40

Learn more about this role

Full time

JR-21041624

Band: H5

Manages People: No

Travel: No

Manager:

Talent Acquisition Contact:

Kimberly Rohn

Referral Bonus:

0