Reporting Systems Administrator

Our client, a boutique wealth management firm in downtown Chicago, IL is looking for a Reporting Systems Administrator. The Reporting Systems Administrator is responsible for the day-to-day administration of the firm’s investment data and reporting environment, helping ensure the integrity, accuracy, and timely delivery of information used in client and performance reporting and across the digital client experience.

This individual will serve as the primary administrator of the firm’s investment reporting platform and manage the daily flow of data from custodians, portfolio accounting systems, alternative investment platforms, and other third-party sources.

The Reporting Systems Administrator will monitor and reconcile data feeds, investigate and resolve exceptions, and work closely with internal stakeholders and external vendors to ensure clients receive complete and accurate reporting. The role will also support approved initiatives involving client portal enhancements, data visualization, automation, and the thoughtful integration of artificial intelligence into our reporting and client experience platforms.

Day-to-day, this position entails:

Investment Reporting & Data Management

• Serve as the primary administrator of the firm’s client investment reporting platform.
• Manage and monitor daily data feeds from custodians, portfolio accounting systems, and alternative investment platforms.
• Validate the completeness, accuracy, and timeliness of incoming data.
• Reconcile positions, transactions, valuations, performance data, and account information across multiple systems.
• Maintain data governance standards to support consistent and reliable reporting.
• Partner with custodians and technology vendors to resolve data delivery issues and discrepancies.
• Assist with periodic audits and quality assurance reviews of reporting data.
• Monitor alternative investment data and statement connections, investigate disruptions, and promptly escalate lost connections to the appropriate manager and technology provider.

Exception Management & Issue Resolution

• Independently own data quality within third-party aggregation and reporting platforms.
• Identify errors, investigate root causes, coordinate corrections directly with vendors and data providers, and validate.
• Escalate unresolved issues to vendors, custodians, managers, and the advisory team, as appropriate.
• Track and document exceptions, root causes, resolutions, and recurring trends.
• Develop practical procedures and controls to reduce reporting errors and improve operational efficiency.
• Establish proactive monitoring tools to identify data quality issues early.

Client Reporting & Quality Control

• Support the timely and accurate production of client reports.
• Validate performance calculations and reporting outputs.
• Partner with internal stakeholders to create custom client reporting exhibits, dashboards, and analytical tools.

Technology Administration, Automation & Process Support

• Administer approved configurations and content updates within the client portal and reporting environment.
• Coordinate with internal stakeholders and technology partners to maintain data connections, reporting configurations, and system functionality.
• Implement approved automation improvements for reconciliation, exception management, and reporting workflows.
• Test approved artificial intelligence and automation tools, following established requirements, controls, and implementation priorities.
• Maintain data models, datasets, field mappings, and documentation used by reporting and approved client-facing applications.

We are seeking a highly analytical, detail-oriented professional who values data accuracy, enjoys administering systems and improving day-to-day processes, and uses technology to create greater efficiency and better client experience.

To be successful in this position, you should demonstrate:

• Exceptional attention to detail and a strong commitment to data accuracy
• Strong analytical and problem-solving skills
• Ability to identify root causes and recommend thoughtful, practical solutions
• Excellent organizational and project management skills
• Strong written and verbal communication skills
• Ability to manage multiple priorities in a deadline-driven environment
• A collaborative approach to working with internal teams and external partners
• A continuous improvement mindset, with a focus on innovation and operational excellence
• Advanced proficiency in Microsoft Excel
• Experience working with large datasets and data reconciliation processes
• Experience with investment reporting platforms, data visualization tools, or similar business intelligence solutions is required
• Familiarity with data integration, APIs, and data governance concepts is preferred
• Curiosity about artificial intelligence, automation, and emerging wealth management technologies
• A bachelor’s degree in a related field, such as, data analytics, finance, information systems, computer science, accounting, economics, or mathematics
• Minimum three years’ related experience
• Experience with investment reporting platforms, portfolio accounting systems, or wealth management technology solutions is required.
• Experience working with custodial data and alternative investment reporting is preferred.

Compensation: $70-90K plus discretionary bonus