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. 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. 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 PHYSICAL DEMANDS AND WORKING ENVIRONMENT 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 colleagues COMPENSATION & BENEFITS We offer a competitive total compensation package including base salary and benefits. The anticipated pay range for this position is $58,630 to $90,970 per year (in CO & WA), $53,300 to $82,700 per year in MN, and depends on a variety of non-discriminatory factors including, but not limited to, job-related knowledge, skills and experience, education, and geographic location. Benefits available for this position include, but are not limited to, medical, dental, vision, short-term and long-term disability benefits and life insurance, flexible spending accounts, health savings account, employee assistance program, 401(k), Paid Time Off (new hires accrue at .069 per hours worked which equates to approximately 18 days per year inclusive of paid sick time) and up to 11 paid Federal holidays. Please note this information is provided for those hired in Minnesota, Colorado and Washington only, and this role is open to candidates outside of Minnesota, Colorado and Washington with compensation that aligns with your location. For more information regarding our benefits, please visit https://www.firstinterstatebank.com/company/about/employee-benefits.php If you are a current FIB employee, please apply through the Career Worklet in the Employee Portal. Our company is an equal opportunity employer. Employment here is based solely upon an individual's merit and qualifications directly related to the position. We do not discriminate on the basis of race, color, religion, national origin, ancestry, pregnancy status, sex, age, marital status, disability, medical condition, or any other characteristics protected by law. We make all reasonable accommodations to meet the obligations set forth under the Americans with Disabilities Act (ADA) and state disability laws.
