> Markdown version of [/jobs/ext/1298834-manager-data-reporting](https://www.wearedevelopers.com/jobs/ext/1298834-manager-data-reporting). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Manager, Data Reporting - **Company:** SS&C Technologies, Inc. - **Location:** Kansas City, MO, United States - **Experience:** Expert - **Salary:** $70,000.0 - $130,000.0 - **Contract:** Permanent contract - **Skills:** Microsoft Excel, Application Programming Interfaces (APIs), Data Analysis, Big Data, Spreadsheets, Information Systems, Databases, Data Transformation, Data Mining, Data Warehousing, Relational Databases, Excel Formulas, Microsoft Office, Powerpivot, Query Optimization, Power BI, Macros, Powerquery, Vba Programming Language, Data Management - **Published:** July 16, 2026 - **Apply:** https://diversityjobs.com/main/sendform/8/8/28176/1/17599556?backUrl=%2Fcareer%2F17599556%2FManager-Data-Reporting-Missouri-Kansas-City ## About the Role * Bachelor's degree in Finance, Business, Information Systems, related field, or equivalent experience * 5+ years of experience of advanced Excel Data Reporting and Data Modeling * Expert-level proficiency in Microsoft Excel, including advanced Power Pivot, Power Query, and data modeling. * Experience developing DAX formulas, measures, calculated columns, and optimized Excel models. * Strong Power Query skills, including data transformation, combining multiple data sources, and automated refresh processes. * Advanced knowledge of Excel functions, including XLOOKUP, INDEX/MATCH, SUMIFS/COUNTIFS, dynamic arrays, and complex formulas. * Experience building complex financial or operational models with linked datasets, dashboards, and reporting outputs. What Sets You Apart (Preferred Qualifications) * Working knowledge of SQL, including joins, aggregations, and query optimization. * Experience with VBA/macros or Office Scripts for automation. * Experience using Power BI and understanding how Power Pivot translates to enterprise BI solutions. * Experience working with large datasets (100,000+ records to multi-million-row environments). * Familiarity with data warehousing concepts and relational database structures. * Experience supporting finance, fund accounting, banking operations, or investment management environments. * Understanding of data quality management, reconciliation processes, and audit controls. ## Description We are seeking a highly motivated and experienced Manager, Data Reporting, to lead a team within the Transfer Agency. This role is responsible for ensuring accurate, timely, and efficient delivery of data reporting to both internal stakeholders and external clients. The ideal candidate combines strong technical expertise, leadership capability, and a solid background in financial services and investor servicing operations. Why Join SS&C SS&C combines proprietary technology with deep industry expertise to support complex financial and health care operations. Our teams design, implement, and operate solutions that help clients manage data, automate processes, and scale their businesses with confidence. You will work with industry experts, modern platforms, and evolving technologies, gaining exposure to real-world operational challenges and large-scale enterprise environments. How You Will Make an Impact Advanced Excel & Data Modeling * Build and maintain advanced Excel data models using Power Pivot and the Excel Data Model. * Create DAX measures, calculated columns, and KPIs for business reporting. * Use Power Query to automate data extraction, transformation, and consolidation from multiple sources. * Develop interactive dashboards and executive reports in Excel. * Improve existing spreadsheets by increasing automation, accuracy, and efficiency. * Ensure data quality through validation and governance controls. * Troubleshoot and optimize complex Excel workbooks. * Integrate data from databases, flat files, APIs, and other systems. Process Improvement & Automation * Identify opportunities to automate manual reporting and business processes. * Develop Excel-based tools that improve efficiency and reduce risk. * Partner with stakeholders to understand reporting needs and deliver scalable solutions. * Recommend improvements to reporting processes and data management. * Create standardized templates and reporting frameworks for consistent use. Analytics & Business Intelligence * Perform trend, variance, and ad hoc analyses to support business decisions. * Develop and monitor key performance metrics (KPIs). * Turn data into actionable business insights, not just reports. * Serve as the team's Excel and reporting subject matter expert. ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Replacing Excel with SAP APIs & Python validation](https://www.wearedevelopers.com/videos/1944-replacing-excel-with-sap-apis-python-validation) - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) - [Crafting Custom Frameworks with Rust: A Deep Dive into Procedural Macros](https://www.wearedevelopers.com/videos/849-crafting-custom-frameworks-with-rust-a-deep-dive-into-procedural-macros) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)