Sr Business Intelligence Analyst
MidFirst Bank Oklahoma City, Oklahoma, United States
Financial Services · 51-200 employees
Applying here? Try the free cover letter tool — paste this posting and your résumé, no account needed.
About the role
Lead the development, validation, documentation, and ongoing support of database queries, data extracts, reporting sources, and analytical solutions for operational, strategic, and regulatory needs. Partner with business and technology stakeholders to translate requirements into reliable reporting, improve and modernize data processes, and guide consistent analytical practices.
What they look for
Requirements
Requires at least four years of progressively responsible experience in business intelligence, analytics, reporting, data warehousing, or a related field, plus a bachelor's degree in a relevant discipline or equivalent professional experience. Candidates must have at least three years of relevant U.S.-based experience, reside in Oklahoma, and demonstrate advanced SQL and Excel skills, data warehouse knowledge, stakeholder communication, and the ability to manage multiple priorities independently.
Full 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.
Additional qualifications include:
- 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
Similar roles
-
Werkstudent Data Analytics & Business Intelligence (w/m/div.)
Bosch Group Gunzenhausen, Bavaria, Germany
-
Finance Business Intelligence (Fullstack) - Hanoi, Vietnam
Flight Centre Hà Nội, Vietnam
-
ITIL - Business Intelligence Senior Specialist
NTT DATA Services Noida, Uttar Pradesh, India
-
Power BI / Fabric BI Developer
Zensar Pune, Maharashtra, India
-
Senior Developer - Power BI
Sapiens India
-
Business Intelligence Specialist
Molson Coors Belgrade, Central Serbia, Serbia