Data Architect 2

Hancock Whitney Corp.; New Orleans (LA); On-site; USD 90,000 - 120,000; Full time

Job summary

Hancock Whitney Corp. is seeking a seasoned data warehouse professional to develop, support, and optimize enterprise data for reporting and analysis. You will analyze source data, design robust data models, and implement ETL processes to ensure data quality and accessibility across business units.

Responsibilities include optimizing queries, maintaining documentation, and mentoring junior team members while aligning with regulatory requirements and governance standards.

Qualifications

• Bachelor’s degree in CS, MIS or similar field.
• At least six years related experience in database administration, data architecture or data modeling.
• Advanced SQL & database development.
• ETL design patterns & best practices (MS Integration Services, Informatica, etc.).
• Knowledge of data warehousing concepts and data modeling.
• Proficiency with Office suite including Word, Excel, PowerPoint.

Responsibilities

• Develop, support, and optimize the data warehouse for reporting and analysis.
• Analyze source system data and build processes for data cleansing and categorization.
• Translate business requirements into logical and physical data models.
• Design and build data structures to support analysis and reporting.
• Troubleshoot and optimize existing queries and databases.
• Maintain data dictionary and documentation, ensuring data quality.

Skills

Advanced SQL & DB development

Data modeling

ETL design patterns

Data warehousing concepts

Database design

Education

Bachelor's degree in Computer Science / MIS

Tools

Snowflake

Databricks

Azure

AWS

Job description

Develop, support, and optimize the data warehouse to facilitate reporting and analysis of enterprise data. Responsible for analyzing source system data, building processes to provide data cleansing and proper categorization. Translates business processes into logical and physical models in support of business requirements.

ESSENTIAL DUTIES & RESPONSIBILITIES

• Experience with Cloud Data storage technologies like Snowflake, Databricks, Azure, AWS or similar is preferred Contributes to the data warehouse development lifecycle (requirements gathering, ETL, database design & development, testing & validation).
• Designs and builds data structures to support analysis and reporting.
• Designs and builds processes to ensure integrity and quality of data.
• Troubleshoots and optimizes existing queries and databases.
• Recommends and implements process improvements.
• Maintains data dictionary & documentation.
• Maintains knowledge of current BI tools, methods, and best practices.
• Acts as an internal consultant providing technical guidance on business systems projects.
• Determines and resolves problems with other systems analysts, programmers, and systems users.
• Maintains, develops, modifies, and documents processes according to general specifications and guidelines.
• Provides guidance to lower-level team members.
• Consults with managerial and systems analysis personnel to clarify intent, identify problems, suggest changes, and determine extent of programming and coding required.
• Revises or directs revision of existing programs to increase operating efficiency or adapt to new requirements.
• Analyzes, defines, and documents system requirements for data, workflow, logical processes, hardware and operating system environment, interfaces with other systems, internal and external checks, and controls and outputs.
• Researches and evaluates software and hardware to enhance and improve existing processes.
• Performs other duties and special projects as assigned by Senior Management.
• Incumbent is required to comply with all applicable federal, state, and local banking and industry related laws and regulations including but not limited to the Bank Secrecy Act.

MINIMUM REQUIRED EDUCATION, EXPERIENCE & KNOWLEDGE

• Bachelor’s degree; BS in Computer Science, Management Information Systems or similar degree preferred.
• At least six years related experience and/or training and experience with a developed expertise in database administration, data architecture or data modeling.
• Knowledge of Microsoft Office products including Microsoft Word, Excel, Power Pivot, PowerPoint, Access Outlook email program.
• General database administration practices.
• Knowledge of application of data warehousing and data modeling concepts.
• Advanced SQL & database development.
• ETL design patterns & best practices (MS Integration Services, Informatica, etc.)
• SQL optimization methods and techniques.
• Demonstrated leadership capabilities on sizable projects.

ESSENTIAL MENTAL & PHYSICAL REQUIREMENTS

• Ability to work under stress and meet deadlines.
• Ability to travel.
• Ability to lift/move/carry approximately 100 pounds if required to perform the essential job functions.

SUPERVISORY RESPONSIBILITIES

None.

Equal Opportunity/Affirmative Action Employers. All qualified applicants will receive consideration for employment without regard to race, color, religious beliefs, national origin, ancestry, citizenship, sex, gender, sexual orientation, gender identity, marital status, age, physical or mental disability or history of disability, genetic information, status as a protected veteran, disabled veteran, or other protected characteristics as required by federal, state and local laws.

When you choose a career with Hancock Whitney (Nasdaq: HWC), we pledge a heartfelt promise: You can grow. You have a voice. You are important. You also share in a rich regional heritage and embrace core values—timeless ideals vital to our culture since the 1800s that inspire how we serve clients, communities, and each other: Honor & Integrity, Strength & Stability, Commitment to Service, Teamwork, and Personal Responsibility.

A fast-growing organization consistently rated among America’s strongest, safest financial services institutions, our company is based in Gulfport, Mississippi. Our bank and subsidiaries provide contemporary, comprehensive consumer, commercial, and wealth financial products and services at regional headquarters and 200-plus financial centers across a vibrant Southeast corridor including Alabama, Florida, Louisiana, Mississippi, Tennessee, and Texas.

Each day, our nearly 4,000 associates carry on a mission to help people achieve their financial goals and dreams.

We come to work to create opportunities for the people we serve in the communities we call home.

Together, we continue building a company solidly focused on being better, going beyond, and doing more to secure success for the people and businesses depending on us.

Let our legacy lead to your future.

Learn more at hancockwhitney.com/ourstory