Systems Analyst - Technology Business Managemen - Apptio

Role:
Systems Analyst
- Technology Business Management (TBMA)

Team: ETX Portfolio Management and Analytics

Dept: ETX Strategy and Governance

Fulltime – Springfield, MA

To continue adding insight to our IT expenses at Mass Mutual, we are seeking a Technology Business Management Analyst (TBMA) to join our Business of IT Tools Team. The candidate will be responsible for the maintenance, development and enhancement of our TBM platform (Apptio). This includes report development and maintenance of the TBM ecosystem, data management and analysis.

Be part of a growing team, focused on delivering quality data and analytics thru the TBM platform Apptio. Supporting highly mature APPTIO model and creating clear, multi-lense reports. Allowing our IT, Finance and Business partners to make data driven decisions and focus Mass Mutual on value creation.

• Design, develop, and maintain the Technology Business Management (TBM) Model R12, Architecture and Data across Cost Pools, Towers, Services through various modules in Apptio.
• Gather functional and business requirements from client and translate into a functional hosted solution design, which meets customer needs, provides maximum solution value, and is within scope of Apptio products/services. Configure, test, & document Apptio Dashboard, reports and underling data models to meet function design and specifications.
• Responsible for administering and day to day managing of system production support, reporting development cycles, including business requirements design solutioning, test management, integration strategy, deployment and training
• Own end to end the monthly calendar for the Apptio system, responsible for monthly opening and closing of the forecast, supporting the monthly close process, annual / strategic plan and associated dashboard reporting
• Conduct data quality and gap analysis, develop a maturity plan and collaborate with data source owners on data sets
• Responsible for delivering Apptio system integration, enhancements, and optimization capabilities for dashboard reporting
• Perform monthly data loads, monitoring integrity of data, analysis, and maintenance of reference data and mapping issues, solutioning of data errors.
• Ability to support data connectivity through API’s and those embedded within our tool and develop integrations and modeling across large data sets
• Monitor & control dashboards that focuses on data reconciliations and controls, quickly escalating issues, troubleshooting and solutioning
• Works with IT leaders to develop & deliver data capabilities needed for Apptio tools, streamlining overall system architecture including configuration and components and ensures usability/functionality of components
• Provides new reporting capabilities and support strategic vision around monthly reporting needs
• Import, transform and rationalize data from systems of record (SAP, PPM, Service Now, CTM, AWS, Azure) understanding system integration points and impacts on production
• Participates in collaborative efforts with finance. Allocation and Reporting
• Responsible for improving and enhancing use of the Apptio Platform through automation, data configuration, allocation changes, existing report updates and new report creation
• Is the technical contact for the company when communicating to the Apptio Operations and/or Engagement Management teams
• Support the Forecast and Annual Budget processes

• Bachelors degree in Data Analytics, Management Information Systems, Finance or related degree
• 8+ years of relevant experience in systems analytical work
• 5+ years’ experience as an Apptio System Administrator and executing custom solutions in TBM Studio
• Certified TBMA

• 4+ years of experience as Apptio Administrator
• Proficient in accounting concepts, practices, and procedures.
• Experience with Cost Transparency and IT Planning
• High degree of organization and ability to manage multiple, competing priorities simultaneously.
• Strong understanding of formulaic logic in MS Excel (if statements, VLOOKUP, pivot tables, macros, etc.)
• Experience working with large data sets in Excel
• History of analytical problem solving and…