Business Intelligence Analyst

Dickinson Financial Corporation; Kansas City (MO); On-site; USD 55,000 - 65,000; Full time

Benefits offered by this job

Medical

Dental

Vision

401(k) plan

Company paid life insurance

Short and Long‑term disability

Job summary

Academy Bank seeks a Business Intelligence Analyst to design, develop, and implement Power BI reports and analytics solutions. You will partner with business and technical teams to meet analytics objectives and deliver insights for bank leadership.

Responsibilities include building dashboards, collaborating with leaders, and applying DAX, M, SQL, and Snowflake knowledge to optimize reporting. This role emphasizes data quality, documentation, and cross-functional communication.

Qualifications

• Bachelor's degree required in analytics, information systems, mathematics, statistics, business, finance, accounting, or related field.
• Experience with the full analytics implementation lifecycle from data gathering to dashboards.
• Knowledge of Power BI data querying and modeling (relationships, calculated columns, measures).
• Snowflake platform experience is preferred.

Responsibilities

• Develop Power BI dashboards for business unit leaders with timely data and insights.
• Collaborate with stakeholders to gather, clean, and transform datasets for reporting objectives.
• Communicate complex data problems clearly to business and technical teams.
• Use Power BI, DAX, M, and SQL to optimize enterprise reporting capabilities.

Skills

Detail-oriented

Organization

SQL (basic)

Python/R (basic)

DAX/M

Excel & PowerPoint

Education

Bachelor's Degree in Analytics/IS/Math/Stats/Finance

Tools

Power BI

Snowflake

Power BI Paginated Reports

SQL

Job description

Summary

The Business Intelligence Analyst will leverage their business and technical knowledge to design, develop, and implement reports and analytics solutions in Power BI. Will work with business and technical teams to understand business strategy and objectives, gather information, and ensure business needs are being met throughout the analytics lifecycle. This role is a unique opportunity to deliver valuable content, insights and analysis for business unit leadership across the Bank. The Business Intelligence Analyst will develop and provide significant business insights to help business leaders make better decisions. With a good eye for business, you’ll partner with internal stakeholders and help execute our strategic objectives.

Responsibilities

• Develop Power BI dashboards for Business Unit Leaders across the organization that deliver timely and accurate data, performance indicators, and insights.
• Build relationships and collaborate with Business Unit Leaders and internal clients to understand, gather, clean, and transform relevant datasets required to meet reporting and analytical objectives.
• Effectively communicate and interact with business and technical personnel to solve complex data problems.
• Utilize Power BI, DAX, M, and SQL to expand and optimize the Bank’s portfolio of enterprise reporting and analytics. Improve the bank’s capabilities and processes by researching, presenting, and implementing new Power BI product features.
• Perform quantitative and qualitative ad‑hoc analysis to support strategic initiatives. This analysis may include analyzing trends and synthesizing multiple datasets to uncover valuable insights.
• Build and maintain clear and relevant data and reporting documentation as needed.
• Independently handle complex issues with minimal supervision, while escalating and communicating significant issues appropriately.
• Ability to serve as a Power BI application subject matter expert and provide assistance, troubleshooting and support for users across the enterprise.
• Understand, communicate, and instill the Company’s mission, vision, and values (Pillars of Success).
• Complete monthly training in a timely manner to ensure knowledge of bank regulatory requirements, policies, and procedures.
• Working at the worksite during regular business hours and/or assigned hours.
• Other specified duties as assigned

Skills

• Strong attention to detail and ability to complete work accurately.
• Ability to organize work.
• Basic skills with SQL, Python and/or R for gathering data and automating processes and analytics.
• Demonstrated skill with DAX, M to gather, transform and visualize data to uncover emerging trends and important patterns in the business.
• Strong analytical and research skills.
• Skilled in Microsoft Excel and PowerPoint.
• Able to prioritize and manage competing projects.
• Strong written and verbal communication skills, required.
• Proficient in Microsoft Office suite of products.

Education & Experience

• Bachelor's Degree in Analytics, Information Systems, Mathematics, Statistics, Business, Finance, Accounting, or related field, required.
• Working knowledge of BI/data warehouse tools and functionality.
• Experience with Power BI Paginated Reports.
• Passion for analysis and design; candidate needs to synthesize datasets to develop and deliver data visualizations that can clearly illuminate key insights for end users.
• Experience with the complete analytics implementation lifecycle. Gathering and transforming data, building reports and dashboards, troubleshooting, data validation, and ensuring solution meets business needs.
• Experience with the Snowflake platform.
• Knowledge of Power BI data querying and modeling (relationships, calculated columns, measures).
• Minimum of 2+ years developing automated reports and dashboards in Power BI.

Physical Requirements

The work environment is typical of a standard office or retail banking setting. The position is sedentary, involving sitting most of the workday; however, the position will involve moving about the workspace to reach entrances/exits, restrooms, conference rooms, or other areas within the work environment. Reaching may be required involving the ability to move arms in any direction. Office equipment, such as a computer and telephone, will be used requiring the ability to manipulate a keyboard, mouse, and/or keypad. The ability to decipher a computer screen or written documents is necessary. The ability to express or exchange ideas; impart information to clients, coworkers, or the public; or to convey detailed or important instructions; is required. The ability to receive and understand detailed information shared through oral or written communication is required. Position requires lifting and/or the exerting of up to 10 pounds of force.

Compensation & Benefits

The Business Intelligence Analyst position pay range is $55,000 - $65,000.

Full‑time associates are eligible for our benefits package:

• Medical
• Dental
• Vision
• 401(k) plan
• Company paid life insurance
• Short and Long‑term disability insurance
• Company paid vacation, paid leave and holidays

This position will remain open until a qualified applicant is hired.

Equal Opportunity Employer/Disabled/Veterans

Academy Bank and Armed Forces Bank provides equal employment opportunities to applicants and employees without regard to race, color, religion, sex, national origin, protected veteran status, disability. Academy Bank and Armed Forces Bank provides affirmative action data on protected veteran status or disability. If you need an accommodation for any part of the employment process, please email [e-mail]