529 Services Data & Reporting Analyst

Union Bank & Trust Co.

Lincoln (NE)

Hybrid

USD 75,000 - 105,000

Full time

46 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Union Bank & Trust is seeking a 529 Services Data & Reporting Analyst to develop and maintain Power BI dashboards and reports, validate data, and support audits and regulatory reporting. The role collaborates with major partners and internal teams to ensure accurate reporting and process efficiency.

The ideal candidate will have 3+ years in Power BI, SQL/SSRS, and a background in financial services or 529 plans.

Qualifications

  • Bachelor’s degree in a related field or equivalent experience required.
  • Three years’ experience with Microsoft Power BI, including developing reports, dashboards, data visualizations, and working with data models.
  • Three years of experience with SQL, SSRS, and database querying.
  • Experience in financial services, investment products, or 529 college savings plans preferred.
  • Expert in Microsoft Office (Excel and Access) and other financial software.

Responsibilities

  • Develop, maintain, and enhance Power BI dashboards and reports.
  • Create operational reports and queries using Power BI, SQL, Excel, and SSRS.
  • Analyze data from multiple systems and ensure data accuracy.
  • Perform data validation, reconciliation, and quality-control reviews.
  • Prepare and validate tax reporting files and audits.
  • Collaborate with Morgan Stanley and State Farm relationships and support reporting needs.
  • Document reports, dashboards, procedures, queries, and processes.

Skills

Data analysis

Education

Bachelor’s degree or equivalent experience

Tools

Power BI
SQL
SSRS
Excel
Access

Job description

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 PowerAgent, 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 adhere to all bank policies, laws, and regulations applicable to their role. Complete compliance training: follow internal processes and controls as required.
  • Report all compliance issues, violations of law or regulations in accordance with the steps defined in bank policies.
  • Regular and reliable attendance is an essential function of this position.
  • Performs other job-related duties or special projects as assigned.
Qualifications
  • Bachelor’s degree in a related field or equivalent experience required.
  • Three years’ experience with Microsoft Power BI, including developing reports, dashboards, data visualizations, and working with data models required.
  • Three years of experience with SQL, SSRS, and database querying required.
  • Ability to analyze data, identify discrepancies, troubleshoot issues, and communicate findings.
  • Experience within financial services, investment products, or 529 college savings plans preferred.
  • Expert in Microsoft Office (Excel and Access) and in working with other financial software.
Preferred Talents
  • Strong attention to detail and commitment to accuracy.
  • Self-motivated with good judgement and takes initiative.
  • Ability to translate business needs into useful reports, dashboards, and data visualizations.
  • Curious and interested in using data and technology to improve processes.
  • Ability to communicate and interact professionally and effectively through written and oral communication
  • Organized and able to manage multiple assignments and deadlines.
  • Ability to recognize opportunities for process improvement and automation.
  • Analytical and problem solver

Sedentary work, occasional lifting and/or carrying up to 20 pounds.

Indoor work not exposed to outdoor elements or hazards.

This role is eligible for hybrid work arrangement under the guidelines upon completion of onboarding.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Associate Product Manager / Assistant Vice President — 529 Plans
Associate Product Manager / Assistant Vice President — 529 Plans

Morgan Stanley • Town/Village of Harrison (NY)

On-site
USD 85,000 - 140,000
Associate Product Manager/AVP - 529 Plans
Associate Product Manager/AVP - 529 Plans

Morgan Stanley • Purchase (NY)

On-site
USD 100,000 - 140,000
Registered Client Relationship Analyst
Registered Client Relationship Analyst

Morgan Stanley • Lisle (IL)

On-site
USD 35,000 - 90,000
Medical benefits
Dental benefits
Vision benefits
+2
Registered Client Service Associate
Registered Client Service Associate

Morgan Stanley • Lafayette (LA)

On-site
USD 40,000 - 55,000
Client Reporting Senior Analyst
Client Reporting Senior Analyst

Bank of America Corporation • Pennington (AL)

On-site
USD 110,000 - 157,000
Annual discretionary plan
Benefits eligible
Registered Client Service Associate
Registered Client Service Associate

Morgan Stanley • Paramus (NJ)

On-site
USD 33,000 - 90,000
Medical benefits
Prescription Drug coverage
Dental insurance
+3
Service Delivery Specialist
Service Delivery Specialist

National Advisors Trust Company • Leawood (KS)

On-site
USD 42,000 - 58,000
Registered Client Service Associate
Registered Client Service Associate

Morgan Stanley • Lawrenceville (NJ)

On-site
USD 33,000 - 90,000
Medical insurance
Dental insurance
Vision insurance
+2
Client Relationship Analyst
Client Relationship Analyst

Morgan Stanley • Rochester (MI)

On-site
USD 35,000 - 90,000
Registered Client Service Associate
Registered Client Service Associate

Morgan Stanley • Morristown (NJ)

On-site
USD 32,000 - 90,000
Medical
Dental
Vision
+3