Business Intelligence Analyst

MidFirst Business Credit, Inc.; Oklahoma City (OK); Híbrido; USD 65.000 - 92.000; Jornada completa

Descripción de la vacante

Midland Mortgage, a division of MidFirst Bank, is seeking a Business Intelligence Analyst to link access databases with the data warehouse and support reporting for business units. You will work with stakeholders and DBAs to ensure data accuracy and availability for dashboards and reports.

The role requires a MIS/CS/Math related degree (or 5–7 years of relevant experience), strong SQL/Access skills, and the ability to translate complex data into understandable insights. Onsite in Oklahoma City.

Formación

• Bachelor's degree in MIS/CS/Math or related field with GPA 3.0+ or 5–7 years of experience in lieu of degree.
• Experience with Microsoft SQL Server, Access SQL, and Microsoft Access.
• Knowledge of BI and reporting concepts and data warehouse environments.
• Ability to build cross-functional partnerships and communicate with non-technical users.

Responsabilidades

• Create, document, and maintain links between access databases and the data warehouse.
• Collaborate with stakeholders and technology teams to ensure accurate data for reporting.
• Design and document new data warehouse tables and data schemas per reporting needs.
• Support development and maintenance of reports and data sources using existing DW solutions.
• Perform ad hoc data pulls to meet internal and external reporting requirements.
• Drive improvements to data processes and share best practices.
• Produce clear, articulate reporting and data schemas for insights.

Conocimientos

SQL Server

Access SQL

Microsoft Access

BI concepts

Data warehousing

Stakeholder communication

Analytical thinking

Educación

Bachelor's degree in MIS/CS/Math/Business Admin

GPA 3.0+ or 5–7 years experience in lieu of degree

Preferred: Applied Mathematics

Preferred: Applied Statistics

Preferred: Computer Science

Preferred: Management Information Systems

Descripción del empleo

This 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 be responsible for creating, documenting, and maintaining links between access databases and the data warehouse. You will communicate directly with business unit stakeholders and corporate technology database administrators to make sure data is accurate and available for use in reporting.

Responsibilities of the position include:

• Working closely with the operations leadership, corporate technology, and other internal/external stakeholders to ensure that business intelligence and reporting is aligned with the overall goals and objectives of the company
• Overseeing new change requests and effectively managing workloads
• Designing and documenting new data warehouse tables and data schema based on business reporting requirements and available operational data sources
• Supporting the development and maintenance of reports and work flow by leveraging existing Data Warehouse solutions and helping to establish new data sources
• Performs ad hoc data pulls to meet internal and external reporting requirements of the business.
• Driving improvements to ineffective or inefficient data processes and sharing best practices
• Utilizing design skills to produce and maintain clear, articulate, insightful reporting, and data schema to best deliver outputs and derived insights

**This position is fully onsite, in Oklahoma City

Position Requirements:

This position requires a Bachelor's degree in Management Information Systems, Computer Science, Mathematics, or other business related field with a minimum GPA of 3.0 or 5-7 years of commensurate experience in lieu of specific degree or GPA is required.

• Experience working with Microsoft SQL Server, Access SQL, and Microsoft Access

Knowledge of BI and reporting concepts and analysis techniques

Knowledge of general principles of data warehouse environments and enterprise BI tools regardless of platform

The ability to build strong cross-functional partnerships

Strong problem-solving, analytical reasoning, and critical-thinking abilities

Exceptional attention to detail, and time management

Excellent interpersonal, verbal, and written communication skills, including strong listening skills

Ability to turn complex concepts into understandable content for non-technical users

Ability to work independently and within a team environment

A strong willingness to learn, adapt, and actively contribute to the success of the organization

Position requires a minimum of 3 years of relevant US based experience.

To be considered for this position you must reside in Oklahoma

#MM

#LI-DNI

Qualifications

Education

Required

Bachelors or better in Business Administration or related field.

Preferred

Bachelors or better in Applied Mathematics or related field.

Bachelors or better in Applied Statistics or related field.

Bachelors or better in Computer Science or related field.

Bachelors or better in Management Information Systems or related field.

Experience

Required

Knowledge of general principles of data warehouse environments and enterprise BI tools regardless of platform

Knowledge of BI and reporting concepts and analysis techniques

Knowledge of Microsoft SQL Server, Access SQL, and Microsoft Access

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.