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
Working Environment:
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 from home opportunity under the work from home guidelines upon completion of onboarding.