Citigroup, Inc

Data Reporting Lead Analyst - VP

Citigroup, Inc • $120K — $170K *
Mississauga, ON L4T 0A1In-Person
Information Technology
5 - 7 years of experience
2 months ago
Job Overview by Ladders

Qualifications

  • Bachelor's degree in a quantitative field such as Computer Science or Business Analytics.
  • 7+ years of experience in reporting, data analysis, or business intelligence roles, particularly within PMOs.
  • Strong SQL proficiency for complex data manipulation and querying.
  • Experience with visualization tools like Tableau or Power BI.
  • Understanding of project management concepts and PMO metrics.
  • Familiarity with ETL processes and data warehousing principles.
  • Excellent analytical and communication skills to convey insights effectively.

Responsibilities

  • Analyze project data to understand Book of Work information including status and risks.
  • Collaborate with PMO leadership and project managers to define reporting needs.
  • Develop and implement custom reports and dashboards based on data analyses.
  • Implement development techniques to extract and cleanse data from various systems.
  • Ensure accuracy and reliability of project data in analyses and reports.
  • Manage and optimize PMO reporting tools for scalability.
  • Identify and propose process improvements for data collection and reporting.

Benefits

  • Opportunity to work within a highly analytical and technically-focused PMO.
  • Exposure to a wide range of data management and reporting technologies.
  • Possibility for professional development and training opportunities in data analytics and project management.
  • Collaboration with senior leadership and various stakeholders across the organization.
  • Emphasis on delivering impactful insights that drive decision-making and project success.
Full Job Description
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 AI

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

About Citigroup, Inc

Citigroup is a financial services holding company that provides financial products and services. The company operates through two segments, Global Consumer Banking (GCB) and Institutional Clients Group (ICG). The GCB segment offers traditional banking services to retail customers through retail banking, commercial banking, Citi-branded cards, and Citi retail services. The ICG segment offers various banking, and financial products and services to corporate, institutional, public sector, and high-net-worth clients. This segment provides wholesale banking products and services, including fixed-income and equity sales and trading, foreign exchange, prime brokerage, derivative services, equity and fixed-income research, corporate lending, investment banking, and advisory services, private banking, cash management, trade finance, and securities services. Citi is committed to sustainability and social responsibility, and the company invests in initiatives that promote economic progress.

Citigroup, Inc Careers

Join the vibrant team at Citigroup, Inc, a leading global bank, and propel your career into the future. Citigroup offers a plethora of job opportunities that span across various fields and expertise, making it an ideal place for ambitious professionals to thrive.

Work You’ll Do

At Citigroup, Inc, you will engage in exciting work that matters. Join our team to help innovate and drive transformation in the banking industry. With Citigroup, you can lead initiatives that redefine how banking works and how financial services can empower people globally.

Innovate and Lead

Citigroup, Inc is at the forefront of financial innovation and leadership. By joining our team, you will work alongside top professionals to develop solutions that enhance customer experiences and operational efficiency. Our commitment to innovation is fundamental, and we encourage our team to push boundaries and think outside the box.

Grow Your Career

Citigroup, Inc is not just a company; it's a place where you can grow both professionally and personally. We offer robust career paths and professional development opportunities that help you reach your potential. With diverse career tracks and the support of leadership, your growth at Citigroup is limitless.

Diversity and Inclusion

We believe our strength comes from the diversity of our team. Citigroup, Inc is dedicated to fostering an inclusive workplace where everyone can contribute their best work. Through diversity training and a culture that embraces differences, we create a welcoming environment for all employees.

Benefits and Culture

Citigroup, Inc values the well-being of its employees. We offer competitive benefits packages that support the health, finance, and lifestyle of our team members. Our culture is built on collaboration, respect, and a commitment to excellence. We ensure that every team member feels valued and part of our global family.

Internship and Employment Opportunities

Start your professional journey with Citigroup through our internship programs or full-time job opportunities. We are constantly hiring fresh talent and seasoned experts who bring creativity and innovation to our team. Whether you're refining your skills or ready to lead, there's a position waiting for you at Citigroup.

Networking and Professional Development

At Citigroup, Inc, networking and continuous learning are part of our DNA. We provide platforms for employees to connect with industry leaders and peers, enhancing their skills and opening up new career opportunities. Our leadership programs and professional development initiatives ensure that you are always ahead of the curve.

Join Our Team

Explore the numerous positions available at Citigroup, Inc that match your skills and interests. We are looking for passionate, curious, and solution-driven team players who are ready to make an impact.

Stay Connected

Keep up to date with the latest in career opportunities and industry insights at Citigroup, Inc. Subscribe to our job alert emails and read our careers blog to stay ahead in your professional journey.

Explore Citigroup, Inc Jobs

Discover the exciting and rewarding opportunities that await at Citigroup, Inc. Tailor your resume, prepare for your interview, and take the next step in your career with us.

SEARCH CITIGROUP JOBS

READ CAREERS BLOG

Citigroup, Inc is where your ambition meets opportunity. Join us and transform your career while making a global impact.
Learn more about Citigroup, Inc
Market Cap
$1.3 billion
Industry
Finance & Insurance
Net Income
$89.6 million
Founded
1812
5 Year Trend
+4.6%
NASDAQ
C
* Ladders Estimates

Similar Jobs

Ad banner background

Get Ready For Your
Next Interview

More Jobs at Citigroup, Inc

More Information Technology Jobs

Find similar Data Reporting Lead Analyst - VP jobs:

NationwideMississauga, ON