HTLF is an equal opportunity employer committed to creating a diverse workforce. We consider all qualified applicants without regard to race, religion, color, sex, national origin, age, sexual orientation, gender identity, disability or veteran status, among other factors.

HTLF is a diversified financial services company headquartered in Denver, Colorado. We deliver community banking at scale by powering our geographically diverse group of banks with technology, efficiency and strength - giving local decision-making the opportunity and insights to focus on customers and growth. Relationships have been the core of our company since its founding in 1981. We're deeply invested in the communities we serve, and that's why our clients choose us as their banking partners.

What's different about a career at HTLF? We believe our employees and their diverse backgrounds, perspectives and skills are our greatest assets. We wouldn't be HTLF without the people with whom we surround ourselves and empower to enrich the lives of our customers, employees and communities. We're dedicated to making HTLF the best place to work - where your opinions are valued, your feedback and ideas are heard, and your opportunities for personal growth and professional development are endless.

PRIMARY & ESSENTIAL RESPONSIBILITIES:

• Design, develop, and maintain Cloud Data Warehouse and analytics architecture to meet the enterprise's business analysis, data and reporting needs
• Gather and document business requirements
• Create and document technical needs and designs for databases and ETL processes that ensure optimal technical infrastructure is utilized
• Design, develop, and support new and current database structures employing industry standards and best practices that support loading and storage of data for analytics and reporting
• Design, develop, and support new and current ETL processes employing industry standards and best practices to enhance loading of data from and into different source/ target systems
• Design and implement ETL procedures for intake of data from both internal and external sources
• Ensure that all design and code is compliant with data governance rules and standards by performing data validation and quality checks
• Collaborate with business and technology stakeholders in ensuring data warehouse architecture development and utilization
• Carry out monitoring, tuning, and database performance analysis
• Perform the design and extension of data marts, meta data, and data models
• Ensure all data warehouse architecture code is maintained in a version control system
• Manage aspects of the warehouse such as data sourcing migration, quality, design and implementation
• Identify, research, and resolve technical problems as well as answer user questions
• Serve as a point of escalation and resolution for data integrity or performance issues and outages
• Evaluate current system capabilities to identify changes that need to be made and determine the impact to the business while ensuring that programming and software requirements fulfill business objectives
• Assist in establishing and maintaining Service Level Agreements
• Provide on-call support based on the database recovery timeframe
• Remain up-to-date on the latest industry trends; articulate trends and potential clearly and confidently
• Work with project and business leaders to identify analytical requirements
• Follow established methodologies during system development and ensure systems adhere to the standards and procedures established by the IT department
• Develop and maintains all system related documentation
• Perform other duties as assigned
• Complete annual E-Learning Plan and Bank Secrecy Act (BSA) training as assigned and keeps up-to-date knowledge of BSA as it relates to the job function

REQUIRED SKILLS & EXPERIENCE:

• Bachelor's Degree in an analytical related field, including information technology, science, and engineering or equivalent years of experience
• 5 - 7 years of experience with Snowflake and SQL Server
• 7 - 10 years of experience with Informatica Cloud IDMC platform - Batch Integration
• 7 - 10 years experience in advanced SQL development
• 5 - 7 years experience developing shell scripts
• Experience using source control tools such as GIT
• 5 - 7 years of experience with Performance Tuning and Optimization methodologies
• Demonstrated experience with Data Warehouse/Data Lakehouse design, development and testing
• Experience with Kimball & Inmon Data Warehouse methodologies
• Experience working with dimensional models
• Experience understanding change data capture concepts and related implementation options
• Ability to evaluate data flows to provide suggestions to optimize delivery output, adhere to security protocols, and/or remain compliant with quality control standards
• Banking - Financial Planning and Analysis experience preferred
• Experience with gathering requirements and preparing specifications
• Ability to work in an agile matrix managed environment required
• Ability to multitask, prioritize, and manage time efficiently
• Accurate and precise attention to detail
• Excellent analytical, quantitative, and organizational skills
• Ability to document procedures and build work instructions
• Knowledge of Microsoft Office and Office 365

OCCUPATIONAL CERTIFICATION:

• Snowflake SnowPro Certification preferred
• Informatica Certified Professional (ICP) preferred

Scheduled Weekly Hours:

Time Type:

The targeted salary for this role is:

You may also be offered incentive compensation, and benefits. Benefits may include Medical, Dental, Vision, 401(k), Health Savings Account, Paid Time Off. Actual compensation may vary based on geographic location of the specific role as well as work experience, education, and skills of the selected candidate.