Skip to content
×

Services Data & Reporting Analyst

Remote / Online - Candidates ideally in
Lincoln, Lancaster County, Nebraska, 68511, USA
Listing for: Union Bank & Trust Co.
Remote/Work from Home position Listed on 2026-11-22
Job specializations:
Salary/Wage Range or Industry Benchmark: 75000 - 105000 USD Yearly USD 75000.00 105000.00 YEAR

Job Description & How to Apply Below

Position: 529 Services Data & Reporting Analyst
Position Summary

The 529 Services Data & Reporting Analyst supports reporting, data analysis, operational processes, and technology initiatives within UBT 529 Services. This position develops and maintains reports and Power BI dashboards, assists with data validation and reconciliation, supports department projects, and identifies opportunities to improve reporting and operational efficiency. The position works closely with 529 Services to ensure accurate reporting and compliance with applicable 529 plan requirements.

Essential

Functions
  • Develop, maintain, and enhance Power BI dashboards and reports used to monitor operational activity, trends, volumes, and key performance indicators.
  • Create and maintain operational reports and queries using Power BI, SQL, Excel, and SSRS, with an emphasis on data accuracy and usability.
  • Assist with analyzing data from Power Agent, PAWorx, PA Port, and other systems supporting 529 Services.
  • Perform data validation, reconciliation, and quality-control reviews to ensure the accuracy and completeness of internal and external reporting. Ensuring 100% accuracy.
  • Create recurring and ad hoc reports for management, advisors, broker-dealers, state partners, and other internal and external stakeholders.
  • Assist with department projects, including requirements gathering, testing, documentation, implementation, and post-implementation review.
  • Identify opportunities to automate reporting and improve operational processes through Power BI, Power Query, SQL, Excel, and other available technology.
  • Assist with testing system enhancements, upgrades, reports, and operational changes.
  • Assist with data compilation and reporting for internal audits, external audits, due diligence requests, and state partner requests.
  • Operational liaison with Morgan Stanley home office. Responsible for high level Omnibus reconciliation process with $1 Billion Morgan Stanley key relationship with limited oversight.
  • Operational liaison with State Farm home office. Design, develop, trouble shoot State Farm daily reports and operational relationship management. $750 Million relationship with high level of attention required with high visibility client.
  • Support the preparation and validation of tax reporting files, including 1099-Q and other state partner reporting.
  • Assist with semiannual EMMA/MSRB reporting, including gathering and validating applicable money movement, benchmark, and fee information.
  • Support the State Farm operational relationship, including the development, maintenance, validation, and troubleshooting of daily reports. Assist with researching and resolving reporting and operational issues to support this high-visibility relationship.
  • Support the Morgan Stanley omnibus relationship by assisting with reconciliation, reporting, research, and resolution of discrepancies. Work with senior 529 Services staff to ensure accurate and timely processing and reporting.
  • Develop documentation for reports, dashboards, procedures, queries, and operational processes.
  • Support quarterly account mapping and reporting for the Nebraska Meadowlark program.
  • Assist with quarterly analysis and account creation related to the Illinois First Steps program.
  • Support 529 account fee processing and related reconciliation.
  • Assist with quarterly National Change of Address processing prior to statement generation.
  • Work with internal team members and external vendors to research and resolve reporting, data, and system-related issues.
  • Develop an understanding of 529 plan operations, state partner requirements, and applicable regulatory requirements.
  • Crosstrain on key 529 Services operational functions and provide backup support as needed.
  • Ensure compliance with 529 Laws and contracts with UBT 529 Services State Partners
  • Understand and…
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
View / Apply for Jobs
Matching My Jurisdiction

Search for further Jobs Here:

SEARCH JOBS: 10+ Million Listings
(Try combinations for better Results! Or enter less keywords for broader Results)
Job language:
Education Level
Experience Level (years)
Posted in last:
Salary