Business Intelligence Analyst

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
• 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
• Ad hoc responsibilities as assigned

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 major or GPA is required.

1-3 years of experience in business intelligence, data analytics, reporting, data warehousing or a related data role is required.

Additional qualifications include:

• Intermediate skills in Excel and SQL
• Knowledge of BI and reporting concepts and analysis techniques
• Knowledge of general principles of data warehouse environments and enterprise BI tools regardless of platform
• Demonstrated 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
• Demonstrated 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 must reside in Oklahoma

Preferred Qualifications:

• Experience working with Microsoft SQL Server, Access SQL, and Microsoft Access
• Familiarity with general principles of data warehouse environments
• Exposure to managing large amounts of data from various sources
• Exposure to project management tools including: Asana or Clarizen

#MM

#LI-DNI

#LI-Onsite

Experience

Required* 5 - 7 years: Commensurate experience in lieu of specific degree major or GPA is required

• Knowledge of BI and reporting concepts and analysis techniques; Knowledge of general principles of data warehouse environments and enterprise BI tools regardless of platform
• 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
• Demonstrated ability to turn complex concepts into understandable content for non-technical users
• Demonstrated ability to build strong cross-functional partnerships
• Intermediate skills in Excel and SQL
• 1 - 3 years: experience in business intelligence, data analytics, reporting, data warehousing or a related data role is required

Education

Required* Bachelors or better

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 (https://www.eeoc.gov/poster) notice from the Department of Labor.