Sr Business Intelligence Analyst

MidFirst Bank; Oklahoma City (OK); On-site; USD 90,000 - 130,000; Full time

Job summary

Midland Mortgage, a division of MidFirst Bank, seeks a Senior Business Intelligence Analyst to lead the development, testing, and maintenance of SQL-based data extracts and reporting sources that support enterprise analytics. You will partner with business units, operations leadership, and Corporate Technology to ensure data accuracy and actionable insights.

4+ years in BI, data analytics, or data warehousing are required.

Qualifications

• 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.

Responsibilities

• Lead data and reporting initiatives from requirements gathering through query development, data extracts, validation, and ongoing support.
• Partner with operations leadership, Corporate Technology, and stakeholders to align BI solutions with business goals.
• Develop and maintain data sources, queries, and workflows for enterprise reporting and BI solutions.
• Perform ad hoc data analysis and reporting to support internal and regulatory needs.
• Drive process improvements to standardize, automate, and modernize legacy reporting.

Skills

SQL

Relational databases

Data modeling

Data analysis

Power Query

Education

Bachelor's degree in MIS/CS/Data Analytics

Tools

SQL Server

Microsoft Access

Power BI

Job description

This Senior Business Intelligence Analyst position is a role within Midland Mortgage, a division of MidFirst Bank, in the Strategy and Operational Support group. In this role, you will independently lead 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. You will partner directly with business unit stakeholders, operations leadership, and Corporate Technology to ensure data is accurate, available, and appropriately structured for operational and strategic reporting needs.

Key Areas of Responsibility

• Stakeholder Partnership and Business Alignment
  • Work closely with operations leadership, Corporate Technology, and internal and external stakeholders to align business intelligence and reporting solutions with company goals.
  • Partner with stakeholders to clarify requirements, challenge assumptions, translate business needs into technical solutions, and communicate recommendations.
• Project Execution and Prioritization
  • 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 independently manage workloads across multiple concurrent initiatives.
• Data Management and Technical Delivery
  • 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.
• Reporting, Analysis, and Decision Support
  • Perform ad hoc data analysis and data pulls to support internal, external, operational, and regulatory reporting needs.
  • Prepare data, analysis, and reporting inputs, performance metrics, operational reporting, and data-driven decision-making.
• Process Improvement and Modernization
  • Improve inefficient data and reporting processes through standardization, automation, and best-practice sharing.
  • Support legacy reporting modernization and transitions to enterprise business intelligence platforms.
• Documentation and Analytical Leadership
  • Produce and maintain analytical outputs, technical documentation, data definitions, database objects, and data schemas that support reporting and business analysis.
  • Serve as a senior analytical resource by learning complex business processes, guiding team members, and promoting consistent analytical practices.

Position Requirements

This position requires a Bachelor's degree in Management Information Systems, Computer Science, Mathematics, Data Analytics, or another business-related field with a minimum GPA of 3.0, or commensurate professional experience in lieu of the specified degree major or GPA.

A minimum of 4 years of progressively responsible experience in business intelligence, data analytics, reporting, data warehousing, or a related data role is required.

• 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
• Proven ability to partner with business and technical stakeholders, communicate complex concepts clearly, and translate requirements into reporting solutions
• Sound judgment, discretion, ownership, and the 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
• Position requires a minimum of 3 years of relevant US based experience.
• To be considered must reside in Oklahoma

Preferred Qualifications:

• Familiarity with Microsoft Power BI or comparable business intelligence platforms, including how database structures and data sources support downstream reporting
• Experience working with Microsoft SQL Server, enterprise data warehouse environments, Microsoft Access, and Access SQL
• Experience supporting the 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

#MM

#LI-DNI

#LI-Onsite

Qualifications

Education

Required

Bachelors or better.

Experience

Required

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

Bachelor's degree in Management Information Systems, Computer Science, Mathematics, Data Analytics, or another business-related field with a minimum GPA of 3.0, or commensurate professional experience in lieu of the specified degree major or GPA.

4 years: progressively responsible experience in business intelligence, data analytics, reporting, data warehousing, or a related data role is required.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.