529 Services Data & Reporting Analyst

Union Bank & Trust Career•Lincoln, NE
•Hybrid

About The Position

The 529 Services Data & Reporting Analyst supports reporting, data analysis, operational processes, and technology initiatives within UBT 529 Services. The role develops and maintains reports and Power BI dashboards, assists with data validation and reconciliation, supports departmental projects, and identifies opportunities to improve reporting and operational efficiency. It works closely with 529 Services to help ensure accurate reporting and compliance with applicable 529 plan requirements. The analyst creates recurring and ad hoc reports for management and internal and external stakeholders, and supports reporting and operational relationships with Morgan Stanley and State Farm. Responsibilities include assisting with Morgan Stanley omnibus reconciliation and State Farm daily reports, supporting tax reporting files such as 1099-Q, semiannual EMMA/MSRB reporting, quarterly program reporting and account-related work, fee processing, and address-change processing. The position also supports audits, due diligence and state partner requests, system testing, documentation, troubleshooting, and operational process improvements. The role requires developing an understanding of 529 plan operations, state partner requirements, and applicable regulations; adhering to bank policies and controls; completing compliance training; and reporting compliance issues as required. Regular and reliable attendance is an essential function. Other job-related duties and special projects may be assigned. The work is sedentary and indoors. Hybrid work from home may be available under the applicable guidelines after onboarding is complete.

Requirements

  • Bachelor’s degree in a related field or equivalent experience.
  • Three years of experience with Microsoft Power BI, including developing reports, dashboards, and data visualizations and working with data models.
  • Three years of experience with SQL, SSRS, and database querying.
  • Ability to analyze data, identify discrepancies, troubleshoot issues, and communicate findings.
  • Expertise in Microsoft Office, including Excel and Access, and experience working with other financial software.
  • Strong attention to detail and commitment to accuracy.
  • Self-motivation, good judgment, and initiative.
  • Ability to translate business needs into useful reports, dashboards, and data visualizations.
  • Professional and effective written and oral communication skills.
  • Organization and ability to manage multiple assignments and deadlines.
  • Analytical and problem-solving ability.

Nice To Haves

  • Experience within financial services, investment products, or 529 college savings plans.
  • Curiosity and interest in using data and technology to improve processes.
  • Ability to recognize opportunities for process improvement and automation.

Responsibilities

  • Develop, maintain, and enhance Power BI dashboards and reports to monitor operational activity, trends, volumes, and key performance indicators.
  • Create and maintain operational reports and queries using Power BI, SQL, Excel, and SSRS, emphasizing data accuracy and usability.
  • Analyze data from PowerAgent, PAWorx, PA Port, and other systems supporting 529 Services.
  • Perform data validation, reconciliation, and quality-control reviews to ensure internal and external reporting is accurate and complete.
  • Create recurring and ad hoc reports for management, advisors, broker-dealers, state partners, and other internal and external stakeholders.
  • Assist with departmental projects, including requirements gathering, testing, documentation, implementation, and post-implementation review.
  • Identify opportunities to automate reporting and improve operational processes using Power BI, Power Query, SQL, Excel, and other available technology.
  • Assist with testing system enhancements, upgrades, reports, and operational changes.
  • Compile and report information for internal and external audits, due diligence requests, and state partner requests.
  • Serve as an operational liaison with Morgan Stanley home office; support the omnibus relationship through reconciliation, reporting, research, and resolution of discrepancies.
  • Serve as an operational liaison with State Farm home office; design, develop, troubleshoot, maintain, and validate daily reports and support the operational relationship.
  • Support preparation and validation of tax reporting files, including 1099-Q and other state partner reporting.
  • Assist with semiannual EMMA/MSRB reporting by gathering and validating applicable money movement, benchmark, and fee information.
  • Research and resolve reporting and operational issues supporting the State Farm relationship.
  • 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 before statement generation.
  • Work with internal team members and external vendors to research and resolve reporting, data, and system-related issues.
  • Develop knowledge 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 adhere to applicable bank policies, laws, and regulations; complete compliance training and follow internal processes and controls; report compliance issues and violations as required.
  • Maintain regular and reliable attendance and perform other job-related duties or special projects as assigned.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service