Sr Business Intelligence Analyst

MidFirst Bank • Oklahoma City, OK

2h • Onsite

About The Position

The Senior Business Intelligence Analyst is part of Midland Mortgage, a division of MidFirst Bank, in the Strategy and Operational Support group. The role independently leads the development, documentation, and maintenance of database queries, data extracts, reporting data sources, and related analytical solutions that connect business processes with enterprise data warehouse resources. The analyst partners with business unit stakeholders, operations leadership, and Corporate Technology to ensure data is accurate, available, and structured for operational and strategic reporting.

The position leads data and reporting initiatives from requirements gathering through development, validation, documentation, and ongoing support; manages change requests and priorities across concurrent projects; and performs analysis and data pulls for internal, external, operational, and regulatory reporting. It also improves data and reporting processes through standardization and automation, supports modernization of legacy reporting, maintains technical and analytical documentation, and serves as a senior analytical resource who guides team members and promotes consistent practices.

Requirements

• Bachelor's degree in Management Information Systems, Computer Science, Mathematics, Data Analytics, or another business-related field, with a minimum GPA of 3.0; commensurate professional experience may substitute for the specified degree major or GPA.
• At least 4 years of progressively responsible experience in business intelligence, data analytics, reporting, data warehousing, or a related data role.
• At least 3 years of relevant U.S.-based experience.
• Must reside in Oklahoma.
• Advanced proficiency with SQL, relational databases, and complex query development, including troubleshooting and data validation.
• Advanced Microsoft Excel skills, including analytical functions, pivot tables, data modeling, and Power Query.
• Experience developing and maintaining reliable data sources, queries, extracts, or semantic inputs for enterprise reporting and business intelligence solutions.
• Working knowledge of enterprise data warehouses, including source-to-target mapping, ETL processes, data lineage, and data governance.
• Ability to manage and analyze large data sets from multiple source systems, identify trends or issues, and draw supportable conclusions.
• Ability to partner with business and technical stakeholders, communicate complex concepts clearly, and translate requirements into reporting solutions.
• Sound judgment, discretion, ownership, and ability to work independently with minimal supervision.
• Ability to manage multiple projects and priorities in a deadline-driven environment while collaborating effectively with a team.
• Demonstrated ability to identify inefficiencies and implement sustainable data, database, process, or automation improvements.
• Creativity, self-motivation, organization, attention to detail, intellectual curiosity, adaptability, and commitment to high-quality results.

Nice To Haves

• Familiarity with Microsoft Power BI or comparable business intelligence platforms, including how database structures and data sources support downstream reporting.
• Experience with Microsoft SQL Server, enterprise data warehouse environments, Microsoft Access, and Access SQL.
• Experience supporting data and database work associated with converting or modernizing legacy reporting solutions.
• Experience supporting financial services, mortgage servicing, banking, or similarly regulated operational environments.
• Experience with data quality, data governance, data lineage, and reporting control practices.
• Experience with project and work management tools such as Asana or Clarizen.

Responsibilities

• Partner with operations leadership, Corporate Technology, and internal and external stakeholders to align business intelligence and reporting solutions with company goals.
• Clarify stakeholder requirements, challenge assumptions, translate business needs into technical solutions, and communicate recommendations.
• Lead data and reporting-support initiatives from requirements gathering through query development, data extracts, validation, documentation, and ongoing support.
• Oversee change requests, establish priorities, and manage workloads across multiple concurrent initiatives.
• Develop and maintain database queries, data extracts, reporting data sources, and supporting workflows using existing data warehouse resources and new data sources.
• Write and troubleshoot complex SQL queries, validate data integrity, and resolve data quality issues across multiple source systems.
• Perform ad hoc data analysis and data pulls for internal, external, operational, and regulatory reporting needs.
• Prepare data, analysis, reporting inputs, performance metrics, and operational reporting to support data-driven decisions.
• Improve inefficient data and reporting processes through standardization, automation, and sharing best practices.
• Support legacy reporting modernization and transitions to enterprise business intelligence platforms.
• Produce and maintain analytical outputs, technical documentation, data definitions, database objects, and data schemas for reporting and business analysis.
• Learn complex business processes, guide team members, and promote consistent analytical practices.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior