First Interstate BancSystem Data Warehouse Engineer I in Billings, Montana
\*\*If you are a current FIB employee, please apply through the Career Worklet in the Employee Portal.
The role of Data Warehouse Engineer is to be involved in the design, analysis, and development efforts for the Data Warehouse and Business Intelligence projects, and to resolve complex business problems. This includes modeling, building, and populating the Data Warehouse, as well as providing reporting capabilities.
ESSENTIAL DUTIES & RESPONSIBILITIES include the following; other duties may be assigned.
Assess business rules; perform source to target data mapping; design, review, implement and optimize ETL processes.
Review project plans; develop and test specifications; perform data analysis.
Provide development support for existing systems; troubleshoot data and/or system issues, build and extend toolsets.
Create and/or maintain batch jobs.
Create and maintain online systems and printed documentation.
Provide data analysis and identify data-related issues within the Data Warehouse environment, as well as source systems as needed.
Provide quality service satisfaction by possessing strong customer service skills.
Create and maintain the logical and physical dimensional data models.
Work within an agile development methodology.
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
EDUCATION and EXPERIENCE
A Bachelor's degree (BS/BA) from a four-year college or university in Computer Science or related technical field and three or more (3+) years' experience; or equivalent combination of education and experience. Experience using Informatica, Microsoft SSIS, or other leading ETL tools preferred. Experience with Spark, Hadoop, or cloud technologies a plus.
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 style, techniques and make persuasive speeches and presentations on controversial or complex topics to top management, public groups and/or 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.
While performing the duties of this job, the employee is regularly required to talk or hear. The employee frequently is required to stand, walk, and sit. The employee is occasionally required to use hands to finger, handle, or feel; reach with hands and arms; and stoop, kneel, crouch, or crawl. The employee must occasionally lift and/or move up to 25 pounds. Specific vision abilities required by this job include close vision and ability to adjust focus.
The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of the job.
The noise level in the workplace is usually moderate.\*\*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.