girl looking into her desktop
Back to search results

Cloud Data Warehousing Engineer - Core Technology Infrastructure

Pennington, New Jersey;

Job Description:

Bank of America looking for a Senior Cloud Data Warehousing Engineer with more than 5 years Microsoft Azure cloud Data engineering experience.

We are looking for Senior Engineers with experience on Azure Synapse / CosmosDB / Azure SQL Database and/or prior experience on supporting very large database migration to Azure cloud is highly preferred. This candidate will be responsible for support of multiple instances of Azure cloud databases including Synapse Analytics, CosmosDB, Azure SQL database, development/uat databases, Storage management, Archive, Restore, disaster recovery, security and the enterprise warehouse systems and business applications. Will be responsible for building and installing new cloud database solution including setting access control security layer, DR setup, Manage/Monitor cloud database system performance, including workload management, query performance and tuning. Ability to provide consulting on physical database implementations, Partitioning, Indexing, join methods, and data access paths. This individual will work closely with Microsoft vendor support, Engineering, Operation, Production support to design and implement secure, available and performant data services on Azure cloud platform supporting a variety of applications on Data Warehouse platform. Will also implement and administer access policies in conjunction with corporate standards as well as manage, design, develop, support and consult cloud shell/power shell process/scripts/tools/ARM templates for system management.

Required Skills:

  • Advanced working knowledge of MPP Database Architecture and Azure cloud architecture.
  • Database physical implementation expertise. 
  • Advanced experience on Azure security/RBAC/Database Roles.
  • Experience on Azure ADF/Synapse/CosmosDB/Storage accounts PaaS services.
  • Experience on creating resources on Azure using Power Shell / Cloud Shell with proper security and access control attributes.
  • Advanced working knowledge of database administration on any RDBMS (SQL Server / Teradata preferred) including Security administration, High Availability, DR, Performance tuning and Workload management.
  • Expert in advanced SQL (preferably T-SQL).
  • Advanced design and development of Stored procedures (T-SQL preferred).
  • Advanced knowledge of Data Warehouse design including 3NF/ Star Schema / Snow Flake design etc.
  • Database performance tuning using Indexing, Partitioning etc.
  • Experience on Agile development, SDM tools including JIRA, Bitbucket Repository, CI/CD Pipelines, Ansible, Change Management process using tools like Remedy etc.
  • Strong Python / Scala scripting experience with working knowledge on Notebooks.

Desired Skills:

  • Familiar with Cloud Storage like Native Object Storage, Machine Learning etc.
  • Familiar on Teradata database / Hadoop platform.
  • Familiar with Cloud/Blob/object storage and file formats including Parquet.
  • SSO onboarding using AD integration for authentication and authorization.
  • Familiar with Apache Spark.
  • Experience in implementing data solutions in Azure including Azure SQL, Synapse Analytics, CosmosDB, Apache Spark etc.
  • Familiar on Data Lake Architecture
  • Familiar on Azure RBAC roles.
  • Familiar on Elastic computing especially on cloud platform

Enterprise Role Overview:

Responsible for leading complex efforts to develop and deliver complex data solutions to accomplish technology and business goals. Codes design and delivery tasks associated with the integration, cleaning, transformation and control of data in operational and analytics data systems. Guides stakeholders, Product Owners, and Software Engineers through the design and execution processes. Provides technical thought leadership through implementing multiple complex data solutions, and knowledge of the interaction across multiple data flows and systems . Ensures that the design and engineering approach for complex data solutions, requiring consistency across multiple flows and systems. Conducts research, designs prototyping and other exploration activities such as evaluating new toolsets. Utilizes multiple architectural components in design and development of client requirements. Maintains, improves, cleans and manipulates data for the operational and/or analytics data systems. Constantly seeks better ways of solving technical problems and designing the solution and challenges the status quo. Collaborates with development teams to understand data requirements, ensuring the data architecture is feasible to implement and subsequently implemented accurately. Assembles large, complex data sets that meet functional / non-functional requirements. Builds processes supporting data transformation, data structures, metadata, data quality controls, dependency and workload management. Defines and builds data pipelines that enable faster, better, data-informed decision-making within the business. Contributes to existing test suites (integration, regression, performance), analyzes test reports, identifies any test issues/errors, and triages the underlying cause. Documents and communicates required information for deployment, maintenance, support, and business functionality. Adheres to team delivery/release process and cadence pertaining to code deployment and release. Identifies gaps in data management standards adherence and works with appropriate partners to develop plans to close gaps. Leads concept and experimentation testing and synthesizes the results to validate and improve analytical solution. Defines key performance indicators and internal controls. Mentors more junior Data Engineers and can coach team members in the delivery/release (CI-CD) events - e.g. branching timelines, pull requests, issue triage, merge/conflict resolution, release notes. Individual contributor.

Job Band:

H4

Shift: 

1st shift (United States of America)

Hours Per Week:

40

Weekly Schedule:

Referral Bonus Amount:

0

Job Description:

Bank of America looking for a Senior Cloud Data Warehousing Engineer with more than 5 years Microsoft Azure cloud Data engineering experience.

We are looking for Senior Engineers with experience on Azure Synapse / CosmosDB / Azure SQL Database and/or prior experience on supporting very large database migration to Azure cloud is highly preferred. This candidate will be responsible for support of multiple instances of Azure cloud databases including Synapse Analytics, CosmosDB, Azure SQL database, development/uat databases, Storage management, Archive, Restore, disaster recovery, security and the enterprise warehouse systems and business applications. Will be responsible for building and installing new cloud database solution including setting access control security layer, DR setup, Manage/Monitor cloud database system performance, including workload management, query performance and tuning. Ability to provide consulting on physical database implementations, Partitioning, Indexing, join methods, and data access paths. This individual will work closely with Microsoft vendor support, Engineering, Operation, Production support to design and implement secure, available and performant data services on Azure cloud platform supporting a variety of applications on Data Warehouse platform. Will also implement and administer access policies in conjunction with corporate standards as well as manage, design, develop, support and consult cloud shell/power shell process/scripts/tools/ARM templates for system management.

Required Skills:

  • Advanced working knowledge of MPP Database Architecture and Azure cloud architecture.
  • Database physical implementation expertise. 
  • Advanced experience on Azure security/RBAC/Database Roles.
  • Experience on Azure ADF/Synapse/CosmosDB/Storage accounts PaaS services.
  • Experience on creating resources on Azure using Power Shell / Cloud Shell with proper security and access control attributes.
  • Advanced working knowledge of database administration on any RDBMS (SQL Server / Teradata preferred) including Security administration, High Availability, DR, Performance tuning and Workload management.
  • Expert in advanced SQL (preferably T-SQL).
  • Advanced design and development of Stored procedures (T-SQL preferred).
  • Advanced knowledge of Data Warehouse design including 3NF/ Star Schema / Snow Flake design etc.
  • Database performance tuning using Indexing, Partitioning etc.
  • Experience on Agile development, SDM tools including JIRA, Bitbucket Repository, CI/CD Pipelines, Ansible, Change Management process using tools like Remedy etc.
  • Strong Python / Scala scripting experience with working knowledge on Notebooks.

Desired Skills:

  • Familiar with Cloud Storage like Native Object Storage, Machine Learning etc.
  • Familiar on Teradata database / Hadoop platform.
  • Familiar with Cloud/Blob/object storage and file formats including Parquet.
  • SSO onboarding using AD integration for authentication and authorization.
  • Familiar with Apache Spark.
  • Experience in implementing data solutions in Azure including Azure SQL, Synapse Analytics, CosmosDB, Apache Spark etc.
  • Familiar on Data Lake Architecture
  • Familiar on Azure RBAC roles.
  • Familiar on Elastic computing especially on cloud platform

Enterprise Role Overview:

Responsible for leading complex efforts to develop and deliver complex data solutions to accomplish technology and business goals. Codes design and delivery tasks associated with the integration, cleaning, transformation and control of data in operational and analytics data systems. Guides stakeholders, Product Owners, and Software Engineers through the design and execution processes. Provides technical thought leadership through implementing multiple complex data solutions, and knowledge of the interaction across multiple data flows and systems . Ensures that the design and engineering approach for complex data solutions, requiring consistency across multiple flows and systems. Conducts research, designs prototyping and other exploration activities such as evaluating new toolsets. Utilizes multiple architectural components in design and development of client requirements. Maintains, improves, cleans and manipulates data for the operational and/or analytics data systems. Constantly seeks better ways of solving technical problems and designing the solution and challenges the status quo. Collaborates with development teams to understand data requirements, ensuring the data architecture is feasible to implement and subsequently implemented accurately. Assembles large, complex data sets that meet functional / non-functional requirements. Builds processes supporting data transformation, data structures, metadata, data quality controls, dependency and workload management. Defines and builds data pipelines that enable faster, better, data-informed decision-making within the business. Contributes to existing test suites (integration, regression, performance), analyzes test reports, identifies any test issues/errors, and triages the underlying cause. Documents and communicates required information for deployment, maintenance, support, and business functionality. Adheres to team delivery/release process and cadence pertaining to code deployment and release. Identifies gaps in data management standards adherence and works with appropriate partners to develop plans to close gaps. Leads concept and experimentation testing and synthesizes the results to validate and improve analytical solution. Defines key performance indicators and internal controls. Mentors more junior Data Engineers and can coach team members in the delivery/release (CI-CD) events - e.g. branching timelines, pull requests, issue triage, merge/conflict resolution, release notes. Individual contributor.

Shift:

1st shift (United States of America)

Hours Per Week: 

40

Learn more about this role

Full time

JR-21049166

Band: H4

Manages People: No

Travel: Yes, 5% of the time

Manager:

Talent Acquisition Contact:

Kathleen Jones-Griffith

Referral Bonus:

0