Systems Analyst - Technology Business Managemen - Apptio

MassMutual•Springfield, MA

30d

About The Position

To continue adding insight to our IT expenses at MassMutual, 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 eco system, data management and analysis. The Team 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 MassMutual on value creation. The Impact: 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, ServiceNow, 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

Requirements

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

Nice To Haves

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 quickly resolving data-related issues
Knowledge of financial management processes (Budgeting, Forecasting, Cost Allocations, etc.)
Proficient in Apptio
Able to thrive in a collaborative and cross-functional environment
Strong written and verbal communication skills
Experience with AWS and/or Azure cloud billing.
Deep knowledge of the Apptio solution and the TBM Taxonomy
Experience working with at least one object-oriented language (Java, C#, Python, etc...)
Analytical and detail-oriented individual that enjoys working with data solutions.
Strong to expert skills in data manipulation with tools like MS Excel, BI tools, etc.
Ability to quickly comprehend complex spreadsheets/data
Knowledge of company IT services and financial management processes and practices such as budgeting, cost allocations, capital & operating expense handling, program portfolio management, and application / infrastructure support.
Knowledge and application of relational database concepts.
Skilled at working with large data sets in Excel, quickly resolving data-related issues.
Skilled at communicating and managing issues with technical teams in a production environment
Skilled at report creation
Experience translating executive vision into technical requirements
Experience with Cloud-ability is highly desired.

Responsibilities

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, ServiceNow, 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

Benefits

Regular collaboration with the ETX Portfolio Management and Analytics
Focused one-on-one time with your manager
Access to mentorship opportunities
Networking opportunities including access to Asian, Hispanic/Latinx, African American, women, LGBTQ, veteran and disability-focused Business Resource Groups
Access to learning content on Degreed and other informational platforms
Your ethics and integrity will be valued by a company with a strong and stable ethical business with industry leading pay and benefits

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume