- 7 years of experience with Snowflake and SQL Server
- 10 years of experience with Informatica Cloud IDMC platform – Batch Integration
- 7 years of experience with Performance Tuning and Optimization methodologies
Cloud Data Engineer - Denver, United States - Heartland Financial USA, Inc.
Description
Employment at Heartland Financial USA, Inc. is employment at willHTLF 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.
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.
SummaryHTLF 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.
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.
SummaryUnder limited direction, the Cloud Data Engineer II is responsible for the design, development, testing, implementation, maintenance, performance, and up-time of the Cloud Data Warehouse at HTLF.
The main goal is to ensure the accuracy, availability and consistent performance of the data that supports corporate reporting and analytics needsPRIMARY & 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 experience developing shell scripts
Experience using source control tools such as GIT
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:
40 Time Type:
Full time
The targeted salary for this role is:
$116, $150,996.00
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.
About UsAt HTLF we seek those who are lifelong learners, creative thinkers and have an inquisitive mind.
If you thrive on challenges and look forward to new opportunities that build positive relationships while providing exceptional results, HTLF is the place for you.
We want you to discover your unique potential and limitless professional possibilities while working with us. HTLF is a diverse and inclusive workplace creating an environment where work feels like a second home. Everyone, regardless of their role, will feel accepted, supported and equally involved.What makes our team so great is the value HTLF places on individualism and appreciation for the differences each employee offers.
We're a growing team committed to creating a valued workplace for everyone.Our leaders are actively engaged and committed to providing a positive and professional work environment. They are dedicated to helping you grow and develop your career. We work closely with our employees to strategize individual professional development plans, performance goals and professional development opportunities.
Recognizing and rewarding hard work, developing talent and fostering employees for the next stages of their career is what you can expect as a member of our team.
We grow, when you grow.
Our work family is extremely important to us and at HTLF we strive to ensure our employees are happy, engaged and evolving Help us continue to build an exceptional team that lives our mission statement every day of enriching lives one customer, employee and community at a time.
Employment at Heartland Financial USA, Inc. is employment at will
#J-18808-Ljbffr