Data Architect 2-R017281

Hancock Bank • Gulfport, MS • 20h ago

Thank you for your interest in our company! To apply, click on the button above. You will be required to create an account (or sign in with an existing account). Your account will provide you access to your application information. The email address used in establishing your account will be used to correspond with you throughout the application process. Please be sure and check the spam folder. You may review, modify, or update your information by visiting and logging into your account.

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

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

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

Similar Jobs

Principal Engineer R017294

Hancock Bank • Gulfport, MS • 1d ago

IT & Engineering

1d ago

Go to Apply

Fire Alarm Technician Apprentice

Insight Global • Ocean Springs, MS • 3d ago

IT & Engineering

Job Description One of our clients is currently looking for an entry-level Fire Alarm Technician Apprentice to support the ADS team in Ocean Springs. This is a great opportunity for someone looking to break into the trad...

3d ago

Go to Apply

Fire Alarm Lead Technician

Impact Fire • Ocean Springs, MS • 4d ago

IT & Engineering

Established in 2009, Impact Fire Services was the vision of a group of experienced industry professionals that wanted to build a best-in-class fire protection and life safety company. Through superior customer service an...

4d ago

Go to Apply

Specialist, Manufacturing Engineer

L3Harris • Kiln, MS • 1w ago

IT & Engineering

L3Harris is dedicated to recruiting and developing high-performing talent who are passionate about what they do. Our employees are unified in a shared dedication to our customers' mission and quest for professional growt...

1w ago

Go to Apply

Supervisory Supply Technician

Veterans Affairs, Veterans Health Administration • Biloxi, MS • 1w ago

IT & Engineering

Summary This position serves as the Supervisory Supply Technician (Medical) for the Medical Supply Distribution (MSD) areas of Logistics Service within the VA Health Care System. As a Supervisory Supply Technician, you w...

1w ago

Go to Apply

Supply Technician

Veterans Affairs, Veterans Health Administration • Biloxi, MS • 1w ago

IT & Engineering

Summary This position serves as Supply Technician (Medical) for the Medical Supply Distribution (MSD) areas of Logistics Service within the VA Health Care System. As a Supply Technician, you will provide wards, clinics,...

1w ago

Go to Apply

Fire Alarm Technician Apprentice (Entry Level)

Insight Global • Ocean Springs, MS • 1w ago

IT & Engineering

1w ago

Go to Apply

Mechanical Engineer - Boston, MA

Serco • Gulfport, MS • 2w ago

IT & Engineering

Position Description & Qualifications If you love important, meaningful, and challenging projects and supporting the US Navy then Serco has a great opportunity for you! As the Mechanical Engineer for our LCU 1700 pro...

2w ago

Go to Apply

Engineering Technologist

Leidos • Long Beach, MS • 2w ago

IT & Engineering

Description Looking for an opportunity to make an impact? At Leidos, we deliver innovative solutions through the efforts of our diverse and talented people who are dedicated to our customers' success. We empower our team...

2w ago

Go to Apply

Blind Rehabilitation Specialist-Orientation and Mobility Department

Veterans Affairs, Veterans Health Administration • Biloxi, MS • 2w ago

IT & Engineering

Summary The Blind Rehabilitation Specialist-Orientation and Mobility Department position is located at the Gulf Coast Blind Rehabilitation Center (GCBRC) in Biloxi, Mississippi. The GCBRC training and instruction in blin...

2w ago

Go to Apply

Subscribe to get new jobs sent directly to you
(no charge, cancel anytime)