**If you are a current FIB employee, please apply through the Career Worklet in the
Employee Portal.
This position may be located at any of the First Interstate Bank offices in Colorado, Idaho, Iowa, Minnesota, Missouri, Montana, Nebraska, North Dakota, Oregon, South Dakota, Washington and Wyoming.
What’s Important to You

We know your career is just one aspect of a meaningful, complex, and demanding life. That’s why we designed our compensation and benefits package to provide employees and their families with as much choice as possible.

• Generous Paid Time Off (PTO) in addition to paid federal holidays.
• Child Care Assistance Program for eligible dependent(s).
• Exercise reimbursement program for employees.
• The health and happiness of the places we call home matter to us. Learn a little more about what we do for the

communities we serve
and why we want YOU to be a part of it.
We encourage you to apply. Reach for what you want and tell us why your work ethic and willingness to learn make you a natural fit for #TeamFirstInterstate.

SUMMARY

The Data Warehouse Engineer I is involved in the design, analysis, and development efforts for the Data Warehouse and Business Intelligence projects and resolves complex business problems. This position includes modeling, building, and populating the Data Warehouse, as well as providing reporting capabilities.

QUALIFICATIONS

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

KNOWLEDGE, SKILLS AND ABILITIES

• Ability to read, analyze, and interpret the most complex documents and to read and interpret data schemas, with emphasis on SQL Server Implementations.
• Ability to respond effectively to the most sensitive inquiries or complaints.
• Ability to prepare presentations using original or innovative styles and techniques and make persuasive speeches and presentations on controversial or complex topics to top management, public groups, and/or the board of directors.
• Ability to apply advanced mathematical and statistical concepts to tasks such as frequency distributions, analysis of variance, correlation techniques, sampling theory, and factor analysis.
• Ability to apply principles, logical, or scientific thinking to a wide range of intellectual and practical problems.
• Ability to deal with a variety of abstract and concrete variables.

EDUCATION AND/OR EXPERIENCE

• Bachelor’s Degree in Computer Science or related field required
• 1-3 years experience in data engineering or data warehousing, in a similar data developing role, and/or equivalent combination of education and experience required and
• Experience using Azure Data Factory, Microsoft SSIS, or other leading ETL tools preferred and
• Experience with Spark, Hadoop, or cloud technologies preferred

ESSENTIAL DUTIES AND RESPONSIBILITIES

• Assesses business rules, performs source-to-target data mapping, and designs, reviews, implements, and optimizes ETL processes.
• Reviews project plans, develops and tests specifications, and performs data analysis.
• Provides development support for existing systems, troubleshoots data and/or system issues, and builds and extends tool sets.
• Creates and/or maintains batch jobs.
• Creates and maintains online systems and printed documentation.
• Provides data analysis and identifies data-related issues within the Data Warehouse environment, as well as sources systems as needed.
• Provides quality service satisfaction by possessing strong customer service skills.
• Creates and maintains the logical and physical dimensional data models.
• Works within an agile development methodology.

The physical demands and work environment are representative of those that must be met or encountered to successfully perform the essential functions of the job. In compliance with the Americans with Disabilities Act, the company provides reasonable accommodation to qualified individuals with disabilities and encourages both prospective and current employees to discuss potential accommodations with the employer.

• Dexterity of hands/fingers to operate computer keyboard and mouse - Frequently
• Lifting - Occasionally (up to 50 lbs)
• Sitting - Frequently
• Standing - Occasionally
• Noise Level - Moderate
• Typical Work Hours - M-F (8-5)
• Regular and Predictable Attendance - Required
• as needed No frequent travel requirements, except for 1-2 annual trips to a First Interstate hub location for 2-3 days to work with and meet colleague