EnerBank Data Warehouse Architect

Location
Salt Lake City, Utah
Salary
Open
Posted
Sep 18, 2023
Closes
Oct 19, 2023

Thank you for your interest in a career at Regions. At Regions, we believe associates deserve more than just a job. We believe in offering performance-driven individuals a place where they can build a career --- a place to expect more opportunities. If you are focused on results, dedicated to quality, strength and integrity, and possess the drive to succeed, then we are your employer of choice.

Regions is dedicated to taking appropriate steps to safeguard and protect private and personally identifiable information you submit. The information that you submit will be collected and reviewed by associates, consultants, and vendors of Regions in order to evaluate your qualifications and experience for job opportunities and will not be used for marketing purposes, sold, or shared outside of Regions unless required by law. Such information will be stored in accordance with regulatory requirements and in conjunction with Regions' Retention Schedule for a minimum of three years. You may review, modify, or update your information by visiting and logging into the careers section of the system.

Job Description:

At EnerBank, the Data Warehouse Architect assists the Manager of BI & Data Services in the deployment, support, and maintenance of EnerBank's data services solutions. This includes database design, delivery, operations, and cloud ETL solutions that would help the organization to get to modern and more robust platforms.


EnerBank USA, a division of Regions Bank, engages in strategic partnerships with home-improvement manufacturers, distributors, franchisors, trade groups, and other organizations (with networks of home improvement contractors) to develop customized white-label loan programs to help them increase their sales as well as attract and retain top dealers.

Primary Responsibilities

  • Evaluates Cloud solutions or similar that could help the organization transition to a better and robust ETL platform
  • Develops and maintains ETL scripts.
  • Defines, maintains, and supports enhancements to database physical structure, functional capabilities, security, data retention, and recovery specifications.
  • Works closely with business units to ensure performant database implementations.
  • Works closely with Business Intelligence to meet the data needs of the organization
  • Supports and leads the enhancements to the Master Data Warehouse
  • Leads the efforts around transitioning the existing Master Data Warehouse setup to a cloud-based solution as well as integrating additional data sources
  • Maintains database performance by calculating optimum values for database parameters, implementing new releases, completing maintenance requirements, and evaluating computer operating systems and hardware products
  • Researches, evaluates and recommends database enhancements
  • Gathers and documents database requirements working directly with developers, administrators, stakeholders and users
  • Maintains N+1 status of the production database
  • Manages the database information lifecycle.
  • Mentors and trains junior staff members in database technology and solutions
  • Supports end-users by conducting training, providing information, and resolving problems

This position is exempt from timekeeping requirements under the Fair Labor Standards Act and is not eligible for overtime pay.

Requirements

  • Bachelor's degree in IT related field
  • Eight (8) years of database design and development experience (OLTP, OLAP)
  • Five (5) years of SQL Server administration experience

Preferences

  • Master's degree in IT related field

Skills and Competencies

  • Ability to provide after hour support for data systems' needs
  • Ability to quickly learn and adapt to new products and processes
  • Ability to work well independently and as part of a team
  • Demonstrated high level of team collaboration skills via verbal and written communication
  • Excellent analysis and logical problem-solving skills
  • Expert knowledge of OLTP and OLAP data architecture and practices
  • Expertise around Cloud ETL solutions like SAP HANA, Azure, Snowflake or similar
  • Strong knowledge of SAP BODS ETL or similar ERP platforms

Position Type

Full time

Benefits Information

Regions offers a benefits package that is flexible, comprehensive and recognizes that "one size does not fit all" for associates. Listed below is a synopsis of the benefits offered by Regions for informational purposes, which is not intended to be a complete summary of plan terms and conditions.

  • Paid Vacation/Sick Time
  • 401K with Company Match
  • Medical, Dental and Vision Benefits
  • Disability Benefits
  • Health Savings Account
  • Flexible Spending Account
  • Life Insurance
  • Parental Leave
  • Employee Assistance Program
  • Associate Volunteer Program

Please note, benefits and plans may be changed, amended, or terminated with respect to all or any class of associate at any time. To learn more about Regions' benefits, please click or copy the link below to your browser.


https://www.regions.com/welcometour/benefits.rf

Location Details

Enerbank Salt Lake City

Location:

Salt Lake City, Utah

Bring Your Whole Self to Work  

   

We have a passion for creating an inclusive environment that promotes and values diversity of race, color, national origin, religion, age, sexual orientation, gender identity, disability, veteran status, genetic information, sex, pregnancy, and many other primary and secondary dimensions that make each of us unique as individuals and provide valuable perspective that makes us a better company and employer. More importantly, we recognize that creating a workplace where everyone, regardless of background, can do their best work is the right thing to do.

   

OFCCP Disclosure: Equal Opportunity Employer/Disabled/Veterans  



Similar jobs

Similar jobs