Enterprise Data Lead Analyst

First Interstate Bank

Billings, MT

JOB DETAILS
SKILLS
Agile Programming Methodologies, Americans with Disabilities Act (ADA), Analysis Skills, Application Programming Interface (API), Banking Operations, Banking Services, Business Administration, Business Banking, Business Case, Business Development, Business Intelligence, Business Intelligence Software, Business Operations, Business Processes, Business Strategy, Cloud Computing, Communication Skills, Compensation and Benefits, Computer Mouse Hardware, Computer Science, Concrete, Consulting, Data Analysis, Data Collection, Data Processing, Data Warehousing, Database Analysis, Database Technology, Documentation, Documentation Plan, Editing, English Language, Environmental Issues, Establish Priorities, Git, GitHub, Homeland Security, IBM Product Family, Industry/Trade Analysis, Keyboards, Leadership, Lift/Move 50 Pounds, Mathematics, Metrics, Microsoft Excel, Microsoft Office, Microsoft PowerPoint, Microsoft SQL Server, Microsoft Visio, Microsoft Windows Operating System, Microsoft Word, Operations, Physical Demands, Power BI, Presentation/Verbal Skills, Problem Solving Skills, Python Programming/Scripting Language, Query Analysis, Regulatory Compliance, Relational Databases (RDBMS), Reporting Skills, Requirements Management, Risk, Root Cause Analysis, SQL (Structured Query Language), SQL Databases, Snowflake Schema, Social Security Administration, Source Code Control System (SCCS), Spanish Language, Star Schema, Statistics, Strategic Planning, System Operations, Time Management, Usability Engineering, User Documentation, Writing Skills
LOCATION
Billings, MT
POSTED
Today
**If you are a current FIB employee, please apply through the Career Worklet in the Employee Portal. This position can be located in Billings, MT; Bend, OR; Boise, ID; Omaha, NE; or Sioux Falls, SD. 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. Student debt employer repayment program. 401(k) retirement plan with a 6% match. 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 Enterprise Data Lead Analyst uses proven database querying and analytic skills in combination with superior communication abilities to deliver relevant, timely, and insightful information to the business. This position will 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 AND RESPONSIBILITIES Maintains knowledge of standardized department practices, documentation methodologies, and storage procedures, to ensure alignment on overall department objectives. Creates 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. Designs, validates, and schedules queries and reports in various databases and reporting environments. Works closely with end users and management to evolve, improve, and automate existing data processes. Provides data and support in projects relating to business development, operation, risk, and other functional areas. Develops specifications, documentation, and end user materials. Develops core understanding of the business to consult with decision makers and provide recommendations based on knowledge of the data and business needs. Documents and maps existing and desired business processes, using a consistent process mapping approach. Collaborates with developers, stakeholders, and subject-matter experts (SME) to establish the technical vision and analyze trade-offs between usability and performance needs. Deploys reports, SQL database objects, and applications to on-premises and cloud environments. Consolidates issues for further review and develop clear written recommendations that require minimal editing, then presents to and resolves issues with management. Identifies and executes appropriate investigative and analytical technologies to interpret and verify results. Completes 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. 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 Achieve level three 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. Advanced experience using Power BI, Power BI API’s and Cmdlets, GitHub, or other business intelligence visualization tools. Ability to lead department initiatives and team meetings without supervision. Strong documentation and planning skills are required with the expectation to be held responsible for projected project outcomes. Ability to identify and present business cases to management that benefit the department and organization. Strong communication skills while maintaining a high-level of professionalism within the organization. Expectation to collaborate directly with c-suite level employees on high-level banking initiatives. Strong background in Python and 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, and 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. Advanced knowledge of Kimball Data Warehousing and Star/Snowflake Schemas. 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. Ability to work with moderate mathematical concepts. Ability to apply concepts such as fractions, percentages, ratios, and proportions to practical situations. Define problems, collect data, establish facts, and draw valid conclusions. Solve practical problems and deal with a variety of concrete variables in situations where only limited standardization exists. Interpret a variety of instructions furnished in written, oral, diagram, or schedule form. Prioritize and work autonomously, yet collaboratively, when necessary. EDUCATION AND/OR EXPERIENCE Bachelor's Degree in a related field required 7-9 years related experience, training, and/or equivalent combination of education and experience required Experience that includes business administration, mathematics, computer science, and/or statistical analytics in the banking industry 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 **If you are a current FIB employee, please apply through the Career Worklet in the Employee Portal. First Interstate Bank is an equal opportunity employer committed to a diverse workforce and a barrier-free employment process. Employment is based solely on 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. In order to ensure reasonable accommodations for individuals protected by Section 503 of the Rehabilitation Act of 1973, the Vietnam Era Veterans' Readjustment Assistance Act of 1974, and Title I of the Americans with Disabilities Act of 1990, as amended, individuals that require accommodation in the job application process for a posted position may contact us Monday through Friday, 8 am to 5 pm MST at careers@fib.com. All applicants must pass pre-employment screenings including a background check. First Interstate BancSystem participates in E-Verify which will require new employees to verify their identity and employment eligibility through the internet-based system operated by the Social Security Administration (SSA) and the Department of Homeland Security (DHS). E-Verify Notice English or Spanish Right to Work Notice English or Spanish

About the Company

F

First Interstate Bank