Senior Business Intelligence Analyst at MFA Oil Company in MFA Oil Corporate Office, Columbia, 1 Ray Young Dr, Columbia, Missouri, United States of America

Job description

• Posted Tuesday, September 22, 2026 at 6:00 AM
• The Senior Business Intelligence Analyst works with all levels of the organization to turn data into clear, compelling stories that drive business decisions. This position primarily builds Power BI reports and Power Platform Power Apps using data from MFA Oil's data lakehouse, with a strong emphasis on understanding the business behind the numbers and communicating insights in a way that resonates with leadership and end users. This role also contributes to the design and building of data marts in the gold layer and partners with the business to guide the adoption of data agents and Copilot capabilities, focusing on business context and validation rather than the underlying data engineering.
• MFA Oil Company is an Equal Opportunity/Drug-Free Employer.

Responsibilities

• Design, build, and maintain Power BI reports and dashboards that translate complex data into clear, actionable stories for leaders and business users
• Design, build, and maintain Power Apps solutions on the Power Platform, using the data lakehouse as the underlying source
• Partner with business users to deeply understand their processes, priorities, and pain points, and translate that understanding into effective reporting and app solutions
• Mentor and provide guidance to less experienced analysts on report design, storytelling technique, and business context
• Contribute to the design and build of data marts in the gold layer, working closely with data engineering to ensure structures support reporting and storytelling needs
• Test and verify the accuracy of reports, apps, and underlying data independently before delivery, using SQL and Excel as needed to validate results
• Serve as a business and data domain expert in the training and implementation of data agents and Copilot capabilities, ensuring outputs are accurate and grounded in real business context
• Independently evaluate AI-assisted or AI-generated outputs for accuracy, and verify results rather than relying on them at face value
• Identify opportunities to improve or automate reporting processes and drive adoption of best practices across the BI function
• All MFA Oil employees are expected to know and adhere to company and position specific policies and procedures. While this job description contains the primary duties of the position, employees may be expected to perform other duties as assigned.

Requirements

• Bachelor's degree in business, information technology, statistics, or other related field; or an associate’s degree plus related experience
• Five or more years of experience building reports and dashboards in Power BI, with a strong track record of data storytelling for business audiences
• Demonstrated ability to develop deep business knowledge and translate it into insights that influence decisions
• Strong SQL skills for querying and validating data
• Experience using Excel to test, cross-check, and validate report and data accuracy
• Excellent written and oral communication and presentation skills, with the ability to both solicit information from and explain data clearly to non-technical audiences
• Critical thinking and problem-solving skills
• Self-motivated, with the ability to manage multiple deadlines and drive work forward with minimal oversight
• Ability to thrive in a fast paced, growing organization and rapidly changing environment.
• Detail-oriented with the ability to consistently provide accurate, high-quality work
• Ability to work both independently and in a team environment
• Ability to maintain the confidentiality of sensitive information
• Ability to speak, read, write, and understand the English language to communicate accurately and effectively with customers, coworkers, and supervisors.
• Ability to meet Company requirements, including successful pre-employment background and check and drug test.
• Legal authorization to work in the United States
• Experience with Power Platform tools, including Power Apps and Power Automate
• Experience working with data warehouses or Lakehouse environments (Microsoft Fabric preferred)
• Familiarity with Python for light data manipulation or validation
• Experience with AI tools such as Copilot or data agents, including the ability to critically evaluate and verify AI-generated output rather than relying on it to understand the business or tell the story
• Experience as a functional business analyst
• Ability to think outside the box and research solutions to difficult problems
• Ability to set priorities and goals and develop plans for achieving them

Skills

Required

• Power BI
• SQL
• Excel
• Data storytelling
• Business acumen
• Communication
• Presentation
• Critical thinking
• Problem-solving
• Self-motivation
• Time management
• Adaptability

Preferred

• Power Apps
• Power Automate
• Microsoft Fabric
• Python
• AI tools (Copilot, data agents)
• Functional business analysis

Benefits

• Our benefits are designed to invest in you! We offer a comprehensive benefits structure for regular full-time positions, including competitive wages, paid time off, paid company holidays, and the opportunity for eligible employees to share in company success through profit sharing and/or performance incentives. Health benefits include medical, dental, vision, an employee assistance program and company-paid life insurance, and short- and long-term disability. Our retirement benefits include a 401(k) plan with a company match offering pre-tax and Roth options.