Systems Analyst - Technology Business Management - Apptio

Job Description

Role: Systems Analyst- Technology Business Management (TBMA)

Team: ETX Portfolio Management and Analytics

Dept: ETX Strategy and Governance

Fulltime - Springfield, MA

The Opportunity

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

The Minimum Qualifications

• 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

The Ideal Qualifications

• 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.

What to Expect as Part of MassMutual and the Team

• 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

#LI-RK1
MassMutual is an equal employment opportunity employer. We welcome all persons to apply.

If you need an accommodation to complete the application process, please contact us and share the specifics of the assistance you need.

California residents: For detailed information about your rights under the California Consumer Privacy Act (CCPA), please visit our California Consumer Privacy Act Disclosures page.