Business Analyst - Reporting & Analytics

Integrity; Urbandale (IA); On-site; USD 70,000 - 90,000; Full time

Benefits offered by this job

Competitive compensation package and benefits

Job summary

Integrity is seeking a detail-oriented and analytically driven Business Analyst to support reporting and data analytics needs. This role focuses on developing and enhancing reporting frameworks related to key performance indicators (KPIs) and business trends, requiring strong analytical skills and understanding of data flows.

The ideal candidate will have 3-6+ years of experience in business analysis, proficiency in Excel, and experience with data visualization tools. A competitive compensation package is offered.

Qualifications

• 3-6+ years of experience in business analysis, reporting, or data analytics.
• Strong proficiency in Microsoft Excel, including advanced functions and data modeling.
• Solid understanding of financial metrics and KPI frameworks.

Responsibilities

• Develop, maintain, and enhance recurring and ad-hoc reports related to KPIs and AUM.
• Analyze and interpret trends in financial and operational data.
• Ensure data integrity and governance standards are upheld across reports.

Skills

Data analysis

Data visualization

Microsoft Excel

KPI development

Collaboration

Education

Bachelor’s degree in Finance, Business, Economics, Data Analytics, or related field

Tools

Power BI

Tableau

SQL

Job description

We are seeking a detail‑oriented and analytically driven Business Analyst to support the organization’s reporting and data analytics needs. This role will focus on developing, maintaining, and enhancing reporting frameworks related to key performance indicators (KPIs), assets under management (AUM), and business trends. The ideal candidate will possess a strong understanding of data flows (custodians, clearing firms, portfolio accounting systems, CRM platforms), data aggregation techniques, and reporting methodologies, and will be comfortable engaging with senior leadership.

Key Responsibilities

• Develop, maintain, and enhance recurring and ad‑hoc reports related to KPIs, AUM, AUA, and organizational performance by business unit, product line, advisor, channel, etc.
• Standardize KPI definitions and reporting structures across business units to enable consistent enterprise‑level insights.
• Support the design and implementation of KPI frameworks, dashboards, and performance metrics.
• Analyze and interpret trends in financial and operational data such as net new assets, revenue and retention metrics to support strategic decision‑making.
• Aggregate and reconcile data from multiple internal systems and external data sources (custodians, carriers, clearing firms) to ensure accuracy and consistency.
• Identify opportunities to improve reporting efficiency, automation, and data quality.
• Provide insights and recommendations based on data analysis to senior leadership.
• Ensure data integrity and governance standards are upheld across reporting outputs.
• Document data sources, definitions, and reporting processes.

Qualifications

• Bachelor’s degree in Finance, Business, Economics, Data Analytics, or a related field.
• 3–6+ years of experience in business analysis, reporting, or data analytics.
• Strong proficiency in Microsoft Excel (advanced functions, pivot tables, data modeling).
• Experience with data visualization and reporting tools (e.g., Power BI, Tableau, or similar) preferred.
• Solid understanding of financial metrics and KPI frameworks.
• Ability to work with large, complex datasets and synthesize insights clearly.
• Strong analytical, problem‑solving, and critical thinking skills.

Core Competencies

• Excellent communication skills with the ability to present insights to senior leadership.
• Strong collaboration skills across multiple business units and functions.
• High attention to detail and commitment to data accuracy.
• Ability to manage multiple priorities and meet deadlines in a fast‑paced environment.
• Intellectual curiosity and a proactive approach to identifying trends and opportunities.

Preferred Attributes

• Experience working in financial services, asset management, or a data‑intensive environment.
• Familiarity with SQL or other data querying tools is a plus.
• Experience in KPI development and performance measurement frameworks.

Competitive compensation package and benefits.

Integrity, LLC is an Equal Opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, gender identity, national origin, disability, veteran status, or any other characteristic protected by federal, state, or local law. In addition, Integrity, LLC will provide reasonable accommodations for qualified individuals with disabilities.