Senior Data Architect - Cloud Data Warehouse & ETL

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

Job summary

Hancock Whitney in New Orleans is seeking a Data Warehouse Engineer to develop, support, and optimize the data warehouse to enable enterprise reporting and analytics. You will analyze source system data, build cleansing and categorization processes, and translate business needs into robust data models for analysis.

The role requires six years in data warehousing-related roles, strong SQL, ETL design experience, and leadership capabilities to guide teammates on key projects.

Qualifications

• Bachelor’s degree in Computer Science, MIS, or a related field.
• At least six years of experience in database administration, data architecture or data modeling.
• Strong SQL development and optimization skills.
• Experience with ETL design patterns (SSIS, Informatica) and data warehousing concepts.
• Familiarity with data cleansing and data categorization.
• Ability to lead projects and mentor teammates.

Responsibilities

• Develop, support, and optimize the data warehouse for reporting and enterprise analytics.
• Analyze source data and build data cleansing and categorization processes.
• Translate business processes into logical and physical data models.
• Design data structures to support analysis and reporting.
• Troubleshoot and optimize queries and databases.
• Provide guidance to lower-level team members and collaborate with stakeholders.

Skills

SQL

Leadership

Data modeling

Data architecture

ETL design

Query optimization

Data cleansing

Education

Bachelor’s degree in Computer Science or MIS

Tools

Microsoft Office

Job description

Hancock Whitney in New Orleans is seeking a Data Warehouse Engineer to develop, support, and optimize the data warehouse to enable enterprise reporting and analytics. You will analyze source system data, build cleansing and categorization processes, and translate business needs into robust data models for analysis.

The role requires six years in data warehousing-related roles, strong SQL, ETL design experience, and leadership capabilities to guide teammates on key projects.