Senior Data Analyst

Job Summary: 

We are seeking a Senior Data Analyst to support the Technology Obsolescence Task Force by providing actionable insights into technology lifecycle management across the enterprise. The role focuses on collecting, integrating, analyzing, and visualizing data from multiple IT sources to identify End-of-Life (EOL), End-of-Support (EOS), and obsolete technologies. The successful candidate will leverage Power BI, Tableau, SQL, CMDB, and IT Asset Management (ITAM) data to support modernization initiatives, risk mitigation, governance, and strategic decision-making. 

Key Responsibilities: 

• Collect, consolidate, and validate data from CMDB platforms (e.g., Remedy), IT Asset Management (ITAM) systems, vendor lifecycle repositories, and security, vulnerability, and patch management sources. 

• Ensure data consistency, accuracy, completeness, and alignment across asset, configuration, and lifecycle repositories. 

• Identify End-of-Life (EOL), End-of-Support (EOS), and obsolete technologies across hardware, software, operating systems, databases, middleware, and cloud platforms. 

• Perform lifecycle risk analysis based on technology type, vendor support status, business criticality, and operational impact. 

• Support remediation prioritization by assessing business risk, exposure, and technology criticality. 

• Design, develop, and maintain interactive dashboards and reports using Power BI and Tableau. 

• Create dashboards covering obsolescence risk heatmaps, lifecycle timelines, remediation progress, trend analysis, and compliance metrics. 

• Enable self-service analytics capabilities for business and technical stakeholders. 

• Support CMDB and ITAM data quality initiatives by identifying data gaps, inconsistencies, duplicate records, and ownership issues. 

• Collaborate with ITSM, ITAM, infrastructure, and platform teams to improve asset governance and lifecycle management. 

• Provide analytical insights to domain leads, project managers, delivery teams, security, risk, and audit stakeholders. 

• Translate complex technical data into clear, meaningful business insights and executive-level reporting. 

• Define reporting standards, data definitions, and governance metrics. 

• Automate reporting processes and data refresh pipelines where feasible. 

• Identify opportunities to enhance lifecycle visibility through predictive analytics and continuous process improvements. 

Required Skills: 

• 6–9 years of experience as a Data Analyst, Reporting Analyst, or similar role within enterprise IT environments. 

• Strong experience in data analysis, reporting, and business intelligence. 

• Hands-on expertise in: 

• Power BI (DAX, data modeling, dashboard development, performance optimization) 

• Tableau (dashboard development, calculated fields, storytelling) 

• Strong SQL skills for querying, transforming, and analyzing large datasets. 

• Experience working with structured and semi-structured data. 

• Practical experience with CMDB concepts, configuration item (CI) relationships, and data models. 

• Experience with IT Asset Management (ITAM) for hardware and software assets. 

• Strong understanding of technology lifecycle stages, including In Use, Nearing EOL, End-of-Life (EOL), End-of-Support (EOS), and Decommissioned. 

• Good understanding of enterprise IT environments, including infrastructure, applications, databases, middleware, cloud platforms, and vendor lifecycle management. 

• Knowledge of technology risk, operational resilience, security, compliance, and governance. 

• Excellent analytical, problem-solving, and critical-thinking skills. 

• Strong communication and stakeholder management skills with the ability to present insights to both technical and non-technical audiences. 

• High attention to detail and commitment to data quality. 

• Bachelor's degree in Information Systems, Computer Science, Data Analytics, or a related discipline. 

Nice-to-Have Skills: 

• Experience supporting technology modernization, infrastructure transformation, or lifecycle management initiatives. 

• Knowledge of vendor lifecycle management and support policies. 

• Experience automating reporting pipelines and data integration processes. 

• Familiarity with predictive analytics and lifecycle risk forecasting. 

• Power BI or Tableau Certification. 

• ITIL Foundation Certification. 

• IT Asset Management (ITAM) Certification. 

• Experience working in large enterprise or financial services environments. 

• Exposure to governance, risk, compliance (GRC), cybersecurity, or audit reporting initiatives.