Job description
**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 offices within First Interstate Bank's fourteen state footprint, including Arizona, Colorado, Idaho, Iowa, Kansas, 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.
- Accrue and use your paid time off (PTO) immediately – no waiting period – plus paid federal holidays in addition to PTO.
- Through our Child Care Assistance Program, First Interstate will contribute up to $1,500 per eligible dependent, with a max of $4,500 annually.
- We prioritize wellness by offering eligible employees $25 per month, or $300 per year, toward a fitness club membership or exercise-related classes.
- 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
This position requires proven database querying and analytic skills in combination with superior communication abilities to deliver relevant, timely and insightful information to the business. The successful applicant will be able to collaborate and communicate with all levels of management to provide reporting and critical information to support the strategic initiatives and daily operations of the bank’s business lines.
ESSENTIAL DUTIES & RESPONSIBILITIES include, but are not limited to, the following:
- Creating analysis and visualization tools for business data, metrics, and measures which allow staff to align and track data against overall business strategies, goals, and objectives driving innovation, insight, and decision making
- Maintaining a library portfolio of model documents, templates, or other reusable assets
- Supporting logical and physical data modeling to support business intelligence initiatives
- Assisting with the development of Extraction, Transformation and Loading (ETL) processes to acquire and load data from internal and external sources
- Collaborating with developers, stakeholders, and subject matter experts (SME) to establish the technical vision and analyze trade-offs between usability and performance needs
- Designing and maintaining CI/CD processes for Enterprise Analytics
- Deploying Reports, SQL Database Objects and Applications to On-Premise and Cloud Environments
- Consolidating issues for further review and developing clear written recommendations that require minimal editing, then presents to and resolves issues with management
- Utilizing API integrations to support Enterprise Analytics initiatives
- Maintaining and monitoring GitHub, Power BI, and other BI platforms
- Identifying and using appropriate investigative and analytical technologies to interpret and verify results
- Coordinating with the business to ensure follow-up and resolution of exceptions, including specific individual resolution as well as root-cause analysis and control gap identification
EDUCATION and/or EXPERIENCE
Possess a Bachelor's degree (BS/BA) from a four-year college or university in Computer Science or related technical fields in combination. A minimum of 7 years of experience as a Business Intelligence/Data Analyst as a primary job function, preferably in the banking industry.
OTHER SKILLS & REQUIREMENTS
- Strong background using PowerBI, Power BI API’s and Cmdlets, GitHub or other business intelligence visualization tools
- Strong background in Python and SQL syntax and familiarity with relational database structures as well as API Integrations
- Knowledge of Git or equivalent source control system
- Knowledge of implementing Trunk-Based Development, Git-Flow or other branching models.
- Intermediate knowledge of Kimball Data Warehousing and Star / Snowflake Schemas
- Experience working within agile methodologies
- Experience in Plotly Dash Enterprise preferred
- Prior experience creating Tabular SSAS Data Cubes preferred
LANGUAGE SKILLS
Ability to write and communicate reports, business correspondence, and procedure manuals. Ability to effectively present information and respond to questions from groups of managers, clients, customers, and the general public.
MATHEMATICAL SKILLS
Must be able to work with moderate mathematical concepts. Must be able to apply concepts such as fractions, percentages, ratios, and proportions to practical situations.
REASONING ABILITY
Defining problems, collecting data, establishing facts, and drawing valid conclusions. Solving practical problems and dealing with a variety of concrete variables in situations where only limited standardization exists. Interpreting a variety of instructions furnished in written, oral, diagram, or schedule form. Prioritizing and working autonomously yet collaboratively when necessary.
PHYSICAL DEMANDS
While performing the duties of this job, the employee is regularly required to talk and 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.
WORK ENVIRONMENT
The characteristics described are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
COMPENSATION & BENEFITS
We offer a competitive total compensation package including base salary and benefits. The pay range for this position is $53,954 to $89,023 per year (in CO & WA), 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 include, but are not limited to, medical, dental, vision, 401(k), and Paid Time Off, including Federal holidays. For more information regarding out 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
.
colinoncars.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, colinoncars.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, colinoncars.com is the ideal place to find your next job.