Senior Business Intelligence Analyst

MFA Oil Company•Columbia, MO

About The Position

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.

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

Nice To Haves

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

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.