Data Architect 2

Hancock Whitney; Gulfport (MS); On-site; USD 85,000 - 112,000; Full time

Job summary

Hancock Whitney in Gulfport is seeking a Data Warehouse Developer to enhance reporting and analysis across the enterprise. This role involves developing, supporting, and optimizing data structures, ensuring data integrity, and providing technical guidance on projects.

The ideal candidate should have a Bachelor's degree in Computer Science and over six years of relevant experience, focusing on database administration and data modeling. A collaborative mindset and strong problem-solving abilities are essential for success in this position.

Qualifications

• 6+ years of experience in database administration, data architecture, or data modeling.
• Expertise in SQL optimization methods and techniques.
• Knowledge of data warehousing and data modeling concepts.

Responsibilities

• Develop and optimize data warehouse for reporting and analysis.
• Support data cleansing and proper categorization.
• Maintain knowledge of current BI tools and best practices.

Skills

Data warehouse development

Database administration

SQL optimization

Leadership capabilities

Data modeling

Education

Bachelor's degree in Computer Science or related field

Tools

Microsoft Office Suite (Word, Excel, PowerPoint, Access)

Job description

JOB FUNCTION / SUMMARY:

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:

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

SUPERVISORY RESPONSIBILITIES:

None.

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.
• Knowledge of application of data warehousing and data modeling concepts.
• 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. If the employee is unable to lift/move/carry this weight and can be accommodated without causing the department/division an "undue hardship," then the employee must be accommodated; hence omitting lifting/moving/carrying as a physical requirement.

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.