Enterprise Data Analyst Ii

**If you are a current FIB employee, please apply through the Career Worklet in the Employee Portal
This position is located at our Billings, MT Downtown branch.
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.
• Child Care Assistance Program for eligible dependent(s).
• We prioritize wellness by offering eligible employees a monthly stipend, 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:

• Maintain knowledge of standardized department practices, documentation methodologies, and storage procedures, to ensure alignment on overall department objectives.
• Create analysis and visualization materials for business data, metrics, and measures which allows staff to align and track data against overall business strategies, goals, and objectives driving innovation, insight, and decision making.
• Design, validate, and schedule queries and reports in various database and reporting environments.
• Work closely with end users and management to evolve, improve and automate existing data processes.
• Provide data and support in projects relating to business development, operation, risk and other functional areas.
• Develop specifications, documentation, and end user materials.
• Develop core understanding of the business to consult with decision makers and provide recommendations based on knowledge of the data and business needs.
• Document and map existing and desired business processes, using a consistent process mapping approach.
• Collaborate with developers, stakeholders, and subject matter experts (SME) to establish the technical vision and analyze trade-offs between usability and performance needs.
• Deploying Reports, SQL Database Objects and Applications to On-Premises and Cloud Environments.
• Consolidate issues for further review and develop clear written recommendations that require minimal editing, then presents to and resolves issues with management.
• Identify and execute appropriate investigative and analytical technologies to interpret and verify results.
• Complete validation practices with the business end-user to ensure follow-up and resolution of exceptions, including specific individual resolution, root-cause analysis, and control gap identification.

EDUCATION and/or EXPERIENCE
Bachelor's degree (B.A.) from a four-year college or university and (4) years related experience/training; or equivalent combination of education and experience that includes Business Administration, Mathematics, CS, or Statistical Analytics. Banking Industry experience is preferred.
OTHER SKILLS & REQUIREMENTS

• Achieve level one certifications within BI environments as defined by the Analytics Center of Excellence (ACE).
• Ability to meet deadlines set-forth by management including, but not limited to; PMO initiatives, Compliance, Regulatory and Executive Mandates.
• Intermediate experience using Power BI, Power BI API's and Cmdlets, GitHub, or other business intelligence visualization tools.
• Strong communication skills while maintaining a high-level of professionalism within the organization.
• Strong background in Python, SQL syntax, and familiarity with relational database structures as well as API Integrations
• Knowledge and experience using Git or equivalent source control systems.
• Highly proficient in Windows operating systems, Microsoft Office (Word, Excel, PowerPoint, Visio), and one or more of the following database products: MS SQL Server, IBM Netezza, IBM Sailfish, or related products.
• Must have a good understanding of relational database concepts and strong querying skills.
• Experience working within Agile methodologies.
• Intermediate knowledge of Kimball Data Warehousing and Star / Snowflake Schemas

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.
**If you are a current FIB employee, please apply through the Career Worklet in the Employee Portal