Senior Enterprise Data Analyst

Posted 25 Days Ago
Urbandale, IA, USA
In-Office
Senior level
Insurance • Professional Services • Software • Financial Services
The Role
Leads enterprise reporting, data modeling, governance, reconciliation, and dashboard development across wealth management systems. Ensures data integrity and standardized KPI reporting while analyzing financial and operational trends. Partners with business, technology, operations, finance, and senior leadership to deliver actionable insights, improve reporting processes, support system transformations, and drive adoption of consistent reporting practices.
Summary Generated by Built In

Position Overview

We are seeking a highly analytical and detail-oriented Senior Enterprise Data Analyst to lead the design, development, and governance of enterprise reporting across a complex Wealth Management ecosystem. This role is responsible for ensuring data integrity, consistency, and transparency across multiple reporting systems while enabling actionable insights for executive decision-making.

The ideal candidate will have deep expertise in data modeling, data reconciliation, and reporting architecture, along with a strong understanding of data flows across custodians, clearing firms, portfolio accounting platforms, and CRM systems. This role will partner closely with business leaders, technology teams, and data stakeholders to standardize reporting and drive data-driven decision making.


Key Responsibilities

Data Modeling & Architecture

  • Design and maintain scalable data models to support enterprise reporting across KPI, AUM/AUA, revenue, and advisor performance metrics
  • Define and standardize data structures, relationships, and hierarchies across multiple reporting systems
  • Partner with IT and data engineering teams to ensure optimal data pipelines and reporting architecture

Data Integrity & Governance

  • Establish and enforce data governance standards, including definitions, lineage, and validation processes
  • Lead reconciliation of data across multiple systems (custodians, clearing firms, CRM, portfolio accounting) to ensure accuracy and completeness
  • Identify and resolve data discrepancies, proactively improving data quality and controls
  • Document data sources, transformations, and reporting logic to ensure transparency and auditability

Reporting & Analytics

  • Develop and enhance enterprise reporting frameworks for KPIs, AUM/AUA, revenue, net flows, business performance, and data governance
  • Build dynamic dashboards and reporting solutions using tools such as Power BI, Excel data models, or similar platforms
  • Standardize KPI definitions and reporting outputs to ensure consistency across business units and leadership reporting
  • Deliver both recurring and ad hoc reporting with a focus on clarity, accuracy, and timeliness

Insights & Decision Support

  • Analyze financial and operational trends (e.g., net new assets, retention, revenue growth) to generate actionable insights
  • Partner with senior leadership to translate data into strategic recommendations and business actions
  • Identify opportunities to improve reporting efficiency, automation, and scalability

Cross-Functional Collaboration

  • Serve as a key liaison between Business, Technology, Operations, and Finance teams
  • Support enterprise initiatives (e.g., platform transitions, mergers, reporting transformations) by aligning data and reporting requirements
  • Drive adoption of standardized reporting practices across the organization

Qualifications

  • Bachelor’s degree in Finance, Business, Data Analytics, Information Systems, or related field
  • 5+ years of experience in business analytics, reporting, or data management (preferably in Wealth Management or Financial Services)
  • Advanced expertise in Microsoft Excel (data modeling, Power Query, PivotTables)
  • Experience with Power BI, Tableau, or other data visualization tools
  • Strong understanding of data modeling concepts (star schema, relational data, normalization)
  • Experience working with large, complex datasets across multiple systems
  • Familiarity with SQL or other data querying tools strongly preferred

Core Competencies

  • Strong analytical and problem-solving skills with a focus on data accuracy
  • Exceptional attention to detail and commitment to data integrity
  • Ability to synthesize complex data into clear, executive-level insights
  • Strong communication skills with experience presenting to senior leadership
  • Ability to manage multiple priorities in a fast-paced, evolving environment
  • Proactive mindset with a focus on continuous improvement and automation

Preferred Attributes

  • Experience in Wealth Management, RIAs, asset management, or broker-dealer environments
  • Knowledge of data flows across custodians, clearing firms, portfolio accounting platforms, and CRM systems
  • Experience supporting enterprise reporting transformation or system integrations
  • Exposure to data governance frameworks and controls in regulated environments

About Integrity

Integrity is one of the nation’s leading independent distributors of life, health and wealth insurance products. With a strong insurtech focus, we embrace a broad and innovative approach to serving agents and clients alike. Integrity is driven by a singular purpose: to help people protect their life, health and wealth so they can prepare for the good days ahead.

Integrity offers you the opportunity to start a career in a family-like environment that is rewarding and cutting edge. Why? Because we put our people first! At Integrity, you can start a new career path at company you’ll love, and we’ll love you back. We’re proud of the work we do and the culture we’ve built, where we celebrate your hard work and support you daily. Joining us means being part of a hyper-growth company with tons of professional opportunities for you to accelerate your career. Integrity offers our people a competitive compensation package, including benefits that make work more fun and give you and your family peace of mind. 

Headquartered in Dallas, Texas, Integrity is committed to meeting Americans wherever they are — in person, over the phone or online. Integrity’s employees support hundreds of thousands of independent agents who serve the needs of millions of clients nationwide. For more information, visit Integrity.com.

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.

Skills Required

  • Bachelor’s degree in Finance, Business, Data Analytics, Information Systems, or a related field
  • 5+ years of experience in business analytics, reporting, or data management
  • Advanced Microsoft Excel expertise, including data modeling, Power Query, and PivotTables
  • Experience with Power BI, Tableau, or other data visualization tools
  • Strong understanding of data modeling concepts, including star schema, relational data, and normalization
  • Experience working with large, complex datasets across multiple systems
  • Familiarity with SQL or other data querying tools
  • Experience in wealth management, RIAs, asset management, or broker-dealer environments
  • Knowledge of data flows across custodians, clearing firms, portfolio accounting platforms, and CRM systems
  • Experience supporting enterprise reporting transformation or system integrations
  • Exposure to data governance frameworks and controls in regulated environments

Integrity Marketing Group, LLC Compensation & Benefits Highlights

The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Integrity Marketing Group, LLC and has not been reviewed or approved by Integrity Marketing Group, LLC.

  • Equity Value & Accessibility — Employee ownership and stock purchase opportunities are highlighted as notable parts of the package, with ownership beginning on the first day for eligible employees. Feedback suggests these equity elements help differentiate total rewards for corporate staff.
  • Healthcare Strength — Comprehensive medical, dental, and vision coverage is commonly available to full-time corporate employees, alongside FSAs/HSAs and mental health resources. Some accounts also point to supportive additions like an EAP.
  • Retirement Support — A 401(k) plan with employer match and immediate vesting is repeatedly referenced for eligible employees. Feedback suggests these programs provide a solid financial benefits foundation.

Integrity Marketing Group, LLC Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Dallas, TX
29,757 Employees
Year Founded: 2006

What We Do

Integrity Marketing Group is a leading omnichannel insurtech platform and one of the nation's largest independent distributors of life and health insurance products. The company leverages data and proprietary technology to provide holistic health, life, and wealth solutions, primarily focusing on the senior market. It offers a broad platform of resources and tools to support its network of independent agents.

Similar Jobs

In-Office
Urbandale, IA, USA
170 Employees
In-Office
Creston, IA, USA
89016 Employees
18-20 Hourly
In-Office
Ottumwa, IA, USA
89016 Employees
18-20 Hourly

SailPoint Logo SailPoint

Technical Program Manager

Artificial Intelligence • Cloud • Sales • Security • Software • Cybersecurity • Data Privacy
Remote or Hybrid
United States
2461 Employees
98K-165K Annually

Similar Companies Hiring

Blee Thumbnail
Artificial Intelligence • Marketing Tech • Software
New York, New York
33 Employees
Vega Thumbnail
Artificial Intelligence • Automotive • Insurance • Transportation
US
65 Employees
VCA Animal Hospitals Thumbnail
Pet • Professional Services
Los Angeles, CA
35000 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account