Role Overview
We are seeking a highly analytical and technically proficient Data Reporting Lead Analyst to support the Markets Technology PMO organization. The successful candidate will be responsible for extracting, transforming, and presenting Book of Work data to provide clear, actionable insights into project portfolios, status, and performance. This role requires a strong blend of data expertise, development knowledge, and an understanding of project management principles to create customized views that drive informed decision-making within the PMO.
Key Responsibilities
- Data Analysis & Interpretation: Analyze existing project data feeds, databases, and reports to understand the available Book of Work information, including project status, resource allocation, budget vs. actuals, timelines, risks, and issues.
- Stakeholder Collaboration: Work closely with PMO leadership, project managers, and other stakeholders to define reporting requirements and understand key performance indicators (KPIs) for project portfolios.
- Custom Report Development: Design, develop, and implement customized reports, dashboards, and data visualizations that provide a comprehensive and digestible view of the Book of Work data.
- Technical Implementation: Utilize development knowledge (e.g., advanced SQL, scripting languages like Python, API integrations) to extract, cleanse, transform, and aggregate data from various project management systems and data sources.
- Data Integrity & Validation: Ensure the accuracy, consistency, and reliability of all project-related data used in reports and analyses. Perform rigorous testing and validation of reports.
- Reporting Infrastructure Management: Maintain and optimize existing PMO reporting tools and solutions, ensuring efficiency and scalability.
- Process Improvement: Identify opportunities to streamline data collection, reporting processes, and enhance data quality within the PMO.
- User Support & Training: Provide guidance and training to PMO team members and project managers on how to effectively use and interpret generated reports and dashboards.
- Trend Analysis: Proactively identify trends, anomalies, and critical insights within the Book of Work data to highlight potential risks or areas for improvement.
- Documentation: Create and maintain detailed documentation for all reports, data sources, methodologies, and technical specifications.
Qualifications
- Bachelor's degree in computer science, Information Systems, Business Analytics, Project Management, or a related quantitative field.
- Proven experience (7+ years) in a reporting, data analysis, or business intelligence role, with significant exposure to or direct experience supporting a Project Management Office (PMO).
- Strong proficiency in SQL for complex data querying, manipulation, and optimization.
- Demonstrated experience with data visualization and reporting tools (e.g., Tableau, Power BI, QlikView, advanced Excel reporting).
- Solid understanding of project management concepts, lifecycles, and common PMO metrics.
- Experience with ETL processes and data warehousing principles.
- Exceptional analytical, problem-solving, and critical thinking skills with a strong attention to detail.
- Excellent communication and interpersonal skills, with the ability to translate technical data insights into business language for various audiences.
Desired Skills
- Experience with Project Portfolio Management (PPM) software (e.g., Jira, Azure DevOps, Planview, Clarity PPM).
- Experience with Citi PM applications is a plus
- Proficiency in scripting languages such as Python for data automation and custom integration.
- Familiarity with API integration for connecting different project management tools and data sources.
- Understanding of Agile, Waterfall, or other project methodologies.
- Demonstrated ability to manage and prioritize multiple urgent requests in a fast‑paced environment.
------------------------------------------------------
Job Family Group: Technology------------------------------------------------------
Job Family:Applications Development------------------------------------------------------
Time Type:Full time------------------------------------------------------
Primary Location Full Time Salary Range:$120,800.00 - $170,800.00------------------------------------------------------
Most Relevant Skills Please see the requirements listed above.------------------------------------------------------
Other Relevant Skills For complementary skills, please see above and/or contact the recruiter.------------------------------------------------------
Automated Processing and AIWe use automated processing, including artificial intelligence, for our legitimate business interests (or our reasonable and appropriate business purposes) to identify and align the candidate's skills and abilities with a specific job opening. Additionally, if you so choose, or consent, we can match your skills and abilities to other suitable roles at Citi.
Importantly, all our hiring processes and decisions, including determining your suitability for a role, are conducted, checked, and decided by individuals. Our automated processing and AI do not involve relying on automatic or autonomous decision-making. Please refer to any Jurisdictional Considerations, with specific provisions for your country (where relevant) for further details.
------------------------------------------------------
This job opening is for an existing job vacancy.
------------------------------------------------------
Citi is an equal opportunity employer, and qualified candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other characteristic protected by law.
If you are a person with a disability and need a reasonable accommodation to use our search tools and/or apply for a career opportunity review Accessibility at Citi.
View Citi’s EEO Policy Statement and the Know Your Rights poster.
Skills Required
- Bachelor's degree in computer science, Information Systems, Business Analytics, Project Management, or a related quantitative field
- Proven experience (7+ years) in a reporting, data analysis, or business intelligence role
- Strong proficiency in SQL for complex data querying and optimization
- Experience with data visualization and reporting tools (e.g., Tableau, Power BI)
- Understanding of project management concepts and PMO metrics
- Experience with ETL processes and data warehousing principles
- Exceptional analytical, problem-solving, and critical thinking skills
- Excellent communication and interpersonal skills
Citi Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Citi and has not been reviewed or approved by Citi.
-
Healthcare Strength — Benefits coverage is positioned as comprehensive, including health, dental, and vision insurance plus on-site clinics, prescription drug support, and disability coverage. Family-building support such as fertility assistance is described as a notable differentiator within the overall package.
-
Retirement Support — Retirement benefits are framed as strong, highlighted by a 401(k) with matching and additional plan options like a Roth 401(k). Financial support is reinforced through discounts and broader financial guidance resources tied to the benefits ecosystem.
-
Wellbeing & Lifestyle Benefits — Wellbeing support extends beyond insurance through programs like an Employee Assistance Program, counseling/legal resources, and gym or wellness reimbursement. These offerings increase the perceived total rewards value even when cash compensation sentiment varies by role.
Citi Insights
What We Do
Citi's mission is to serve as a trusted partner to our clients by responsibly providing financial services that enable growth and economic progress. Our core activities are safeguarding assets, lending money, making payments and accessing the capital markets on behalf of our clients. We have 200 years of experience helping our clients meet the world's toughest challenges and embrace its greatest opportunities. We are Citi, the global bank – an institution connecting millions of people across hundreds of countries and cities.
