Data Architect 2

Location: UNO Center, New Orleans, Louisiana

Company

hirify.global is a banking organization requiring compliance with applicable banking and industry regulations.

What you will do

• Develop, support, and optimize the enterprise data warehouse for reporting and analysis.
• Analyze source-system data and build cleansing, categorization, and data-quality processes.
• Gather requirements and design logical and physical data models, database structures, and ETL processes.
• Troubleshoot and optimize queries and databases while implementing process improvements.
• Maintain the data dictionary, technical documentation, and system requirements.
• Provide technical guidance on business systems projects and support other analysts, programmers, and users.

Requirements

• Bachelor’s degree in Computer Science, Management Information Systems, or a similar field.
• At least six years of related experience or training with database administration, data architecture, or data modeling.
• Advanced SQL and database development skills, including SQL optimization techniques.
• Knowledge of data warehousing, data modeling, general database administration, and ETL design patterns.
• Experience with Microsoft Office tools, including Excel, Power Pivot, Access, and Outlook.
• Demonstrated leadership capabilities on sizable projects and the ability to work under stress, meet deadlines, and travel.

Nice to have

• Experience with cloud data storage technologies such as Snowflake, Databricks, Azure, AWS, or similar platforms.
• Experience with ETL tools such as Microsoft Integration Services or Informatica.

Culture & Benefits

• Full-time employment.
• Work includes collaboration with managerial personnel, systems analysts, programmers, and business users.
• Compliance with federal, state, local, banking, and industry-related regulations is required.
• The role may require lifting or carrying approximately 100 pounds when necessary to perform essential job functions, subject to reasonable accommodation.