Data Architect

Hancock Whitney

Data Architect 2 developing and optimizing the data warehouse to facilitate enterprise reporting and analysis at Hancock Whitney. Involves database design, data cleansing, and integrity assurance.

Posted 7/29/2026full-timeNew Orleans • Louisiana, Mississippi • 🇺🇸 United StatesMid-LevelSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Expertise in data warehouse development, including ETL design, database administration, and data modeling, with a strong focus on data integrity and optimization. Proven ability to translate business requirements into technical solutions while providing guidance and leadership to team members.

Highest-signal resume keywords

Data Warehouse DevelopmentETL Design & DevelopmentAdvanced SQL & Database DevelopmentData Modeling ConceptsDatabase Administration Practices

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQL Optimization MethodsData Cleansing ProcessesLogical & Physical Data ModelsData Structures DesignTesting & ValidationProcess Improvement ImplementationData Dictionary MaintenanceSystem Requirements AnalysisTroubleshooting DatabasesDocumentation Practices

Soft Skills

Leadership CapabilitiesTechnical GuidanceProblem-SolvingCollaboration with Team MembersConsultation with Management

Tools & Technologies

Microsoft Office SuiteMS Integration ServicesInformaticaPower PivotAccess

Industry Keywords

Data WarehouseData ArchitectureData ModelingDatabase AdministrationEnterprise Data Analysis

Tech Stack

Tools & technologies

ETLInformaticaSQL

About the role

Key responsibilities & impact

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.
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.
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.

Requirements

What you’ll need

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.

Benefits

Comp & perks

Equal Opportunity/Affirmative Action Employers.
Professional development opportunities.