Sr Business Intelligence Analyst

Summary

Senior Business Intelligence AnalystThis 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 ResponsibilityStakeholder 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 RequirementsThis 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 validationAdvanced Microsoft Excel skills, including analytical functions, pivot tables, data modeling, and Power QueryExperience developing and maintaining reliable data sources, queries, extracts, or semantic inputs for enterprise reporting and business intelligence solutionsWorking knowledge of enterprise data warehouses, including source-to-target mapping, ETL processes, data lineage, and data governanceAbility to manage and analyze large data sets from multiple source systems, identify trends or issues, and draw supportable conclusionsProven ability to partner with business and technical stakeholders, communicate complex concepts clearly, and translate requirements into reporting solutionsSound judgment, discretion, ownership, and the ability to work independently with minimal supervisionAbility to manage multiple projects and priorities in a deadline-driven environment while collaborating effectively with a teamDemonstrated ability to identify inefficiencies and implement sustainable data, database, process, or automation improvementsCreativity, self-motivation, organization, attention to detail, intellectual curiosity, adaptability, and commitment to high-quality resultsPosition requires a minimum of 3 years of relevant US based experience.To be considered must reside in OklahomaPreferred Qualifications:Familiarity with Microsoft Power BI or comparable business intelligence platforms, including how database structures and data sources support downstream reportingExperience working with Microsoft SQL Server, enterprise data warehouse environments, Microsoft Access, and Access SQLExperience supporting the data and database work associated with converting or modernizing legacy reporting solutionsExperience supporting financial services, mortgage servicing, banking, or similarly regulated operational environmentsExperience with data quality, data governance, data lineage, and reporting control practicesExperience with project and work management tools such as Asana or Clarizen

Job Description

Senior Business Intelligence AnalystThis 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 ResponsibilityStakeholder 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 RequirementsThis 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 validationAdvanced Microsoft Excel skills, including analytical functions, pivot tables, data modeling, and Power QueryExperience developing and maintaining reliable data sources, queries, extracts, or semantic inputs for enterprise reporting and business intelligence solutionsWorking knowledge of enterprise data warehouses, including source-to-target mapping, ETL processes, data lineage, and data governanceAbility to manage and analyze large data sets from multiple source systems, identify trends or issues, and draw supportable conclusionsProven ability to partner with business and technical stakeholders, communicate complex concepts clearly, and translate requirements into reporting solutionsSound judgment, discretion, ownership, and the ability to work independently with minimal supervisionAbility to manage multiple projects and priorities in a deadline-driven environment while collaborating effectively with a teamDemonstrated ability to identify inefficiencies and implement sustainable data, database, process, or automation improvementsCreativity, self-motivation, organization, attention to detail, intellectual curiosity, adaptability, and commitment to high-quality resultsPosition requires a minimum of 3 years of relevant US based experience.To be considered must reside in OklahomaPreferred Qualifications:Familiarity with Microsoft Power BI or comparable business intelligence platforms, including how database structures and data sources support downstream reportingExperience working with Microsoft SQL Server, enterprise data warehouse environments, Microsoft Access, and Access SQLExperience supporting the data and database work associated with converting or modernizing legacy reporting solutionsExperience supporting financial services, mortgage servicing, banking, or similarly regulated operational environmentsExperience with data quality, data governance, data lineage, and reporting control practicesExperience with project and work management tools such as Asana or Clarizen