CrawlJobs Logo

Data Reporting Lead Analyst

Canada, Mississauga 120800.00 - 170800.00 USD / Year · Job Posted May 16, 2026
Apply Position
Job Link Share

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.

Job Responsibility

  • 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

Requirements

  • 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

Nice to have

  • 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

Looking for more opportunities?

Search for other job offers that match your skills and interests.

Similar Jobs for

Data Reporting Lead Analyst

8 matching positions

Lead Data Analyst–Regulatory Reporting - Senior Vice President

We are looking for a technical problem-solver to join our Global Regulatory Repo...
Location
Location
India , Mumbai
Salary
Salary:
Not provided
https://www.citi.com/ Logo
Citi
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Advanced SQL: comfortable writing complex queries from scratch (Joins, Window Functions, Case Logic)
  • Data Analysis: ability to compare large datasets (Source vs. Target) to identify variances
  • Domain Knowledge (Banking or Trading): Familiarity with Lending products (Mortgages, Revolving Credit, Term Loans), Deposits, and General Ledger concepts OR Familiarity with Capital Markets products (Derivatives, Securities, Repos) and trade lifecycles
  • Understanding of how product data translates to financial reporting
  • Experience with JIRA for defect tracking and requirements management
  • Ability to read and interpret Data Mapping Documents (Source-to-Target mappings)
  • 8+ years experience
  • Should have team handling experience
Job Responsibility
Job Responsibility
  • Upstream Change Impact Analysis (The "Shield"): Monitor and review upcoming changes in upstream source systems
  • Analyze the "Blast Radius" of these changes using data mapping files and SQL
  • Conduct "content analysis" to verify if the nature of the data is changing
  • Incident Triage & Root Cause Analysis (The "Detective"): Investigate "perceived data issues" raised by the Regulatory Reporting team
  • Execute complex SQL queries to trace data lineage back to the source
  • Determine the verdict: Is this a true upstream Data Quality (DQ) issue, a logic gap in our transformation layer, or a valid business event?
  • Prevent false alarms from reaching the technology development team
  • Testing Strategy & Requirements Management: Translate findings into actionable JIRA tickets
  • Define test cases for User Acceptance Testing (UAT)
  • Communication & Stakeholder Management: Act as the translator between the Reporting Team and the Technology Team
Read More
Arrow Right

Data Quality and Reporting Lead Analyst - Vice President

The Data Quality Analytics & ReportingLead Analyst is responsible for delivering...
Location
Location
India , Mumbai
Salary
Salary:
Not provided
https://www.citi.com/ Logo
Citi
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 13+ years of experience, Banking or Finance industry preferred
  • Experience / Certifications in Agile Methodology preferred
  • Possesses a comprehensive understanding of how own area and others collectively integrate to contribute towards achieving business objectives
  • Effective collaborator, by being able to build relationship and partnership s with others to meet shared objectives
  • Communicates effectively and in a way that conveys a clear understanding of the unique needs of different audiences
  • Experience in managing and implementing successful projects
  • Proficient in the use of basic Microsoft applications (Word, Excel, PowerPoint)
  • Bachelor's/University degree, Master's degree preferred
Job Responsibility
Job Responsibility
  • Designs/analyzes complex reports to satisfy management requirements
  • Develops broad-based business reporting solutions to issues that have complex/multiple variables have potential to cause substantial impact if left unresolved
  • Leads reengineering efforts in business's methodology, strategy, and organizational goals
  • Manages overall projects, and contributes to identifying solutions for business reporting issues
  • Provides in-depth and sophisticated analysis with interpretive thinking to define problems and develop innovative solutions
  • Acts as advisor or coach to new or lower-level personnel in processes and procedures of the team
  • Influences strategic functional decisions through advice, counsel or provided services that have direct impact on the business
  • Completes projects to acquire data, manage it, and present it for use in reporting and statistics
  • Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firm's reputation and safeguarding Citigroup, its clients and assets, by driving compliance with applicable laws, rules and regulations, adhering to Policy, applying sound ethical judgment regarding personal behavior, conduct and business practices, and escalating, managing and reporting control issues with transparency
  • Fulltime
Read More
Arrow Right

Data Quality Analytics and Reporting Lead Analyst- Vice President

The Data Quality Analytics & Reporting Lead Analyst is responsible for deliverin...
Location
Location
India , Mumbai
Salary
Salary:
Not provided
https://www.citi.com/ Logo
Citi
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 12+ years of experience, Banking or Finance industry preferred
  • BI Tooling including but not limited to Tableau, Power BI, MSTR
  • Experience / Certifications in Agile Methodology preferred
  • Possesses a comprehensive understanding of how own area and others collectively integrate to contribute towards achieving business objectives
  • Effective collaborator, by being able to build relationship and partnerships with others to meet shared objectives
  • Communicates effectively and in a way that conveys a clear understanding of the unique needs of different audiences
  • Experience in managing and implementing successful projects
  • Proficient in the use of basic Microsoft applications (Word, Excel, PowerPoint)
  • Bachelor's/University degree, Master's degree preferred
Job Responsibility
Job Responsibility
  • Designs/analyzes complex reports to satisfy management requirements
  • Develops broad-based business reporting solutions to issues that have complex/multiple variables have potential to cause substantial impact if left unresolved
  • Leads reengineering efforts in business's methodology, strategy, and organizational goals
  • Manages overall projects, and contributes to identifying solutions for business reporting issues
  • Provides in-depth and sophisticated analysis with interpretive thinking to define problems and develop innovative solutions
  • Acts as advisor or coach to new or lower-level personnel in processes and procedures of the team
  • Influences strategic functional decisions through advice, counsel or provided services that have direct impact on the business
  • Completes projects to acquire data, manage it, and present it for use in reporting and statistics
  • Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firm's reputation and safeguarding Citigroup, its clients and assets, by driving compliance with applicable laws, rules and regulations, adhering to Policy, applying sound ethical judgment regarding personal behavior, conduct and business practices, and escalating, managing and reporting control issues with transparency
  • Fulltime
Read More
Arrow Right

Wholesale Credit Risk Data Quality Analytics and Reporting Senior Lead Analyst- Senior Vice President

Location
Location
India , Pune
Salary
Salary:
Not provided
https://www.citi.com/ Logo
Citi
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 15+ years of experience in Banking or Finance industry preferred
  • 12+ years of experience on working with Wholesale Credit Risk dataset
  • Experience / Certifications in Agile Methodology preferred
  • Experience monitoring and managing Data Quality on an ongoing basis, including identifying and resolving issues
  • executing against Data Quality strategies and policies
  • Communicates effectively, develops and delivers multi-mode communications that convey a clear understanding of the unique needs of different audiences
  • able to drive consensus, and influence relationships at all levels
  • Collaborates effectively by building partnerships and working well with others to meet shared objectives
  • Strong negotiation, influencing and stakeholder management skills across a variety of stakeholders at different levels
  • Optimizes work processes by balancing effective / efficient processes with a focus on continuous improvement. Demonstrates ability to balance between understanding the big picture while paying close attention to detail
Job Responsibility
Job Responsibility
  • Directs key initiatives within the business through the collection, analysis, review, reporting, documentation and communication of business needs and requirements
  • Manages resource allocation of work on key projects/initiatives
  • Deals with complex and highly variable issues with substantial potential business impact
  • Applies ingenuity and creativity to problem analysis and resolution in complicated and/or novel situations
  • Acts as an advisor or coach to new or lower-level personnel in the business processes and procedures of the business
  • Provides in-depth and sophisticated analysis with interpretive thinking to define problems and develop innovative solutions
  • Influences strategic functional decisions through advice, counsel or provided services that have direct impact on the business
  • Designs/analyzes complex reports to satisfy management requirements
  • Uses broad discretion in developing solutions for broad-based business reporting issues
  • Leads reengineering efforts in business's methodology, strategy, and organizational goals
  • Fulltime
Read More
Arrow Right
New

Lead Data Analyst (OAC)

Location
Location
India , Noida
Salary
Salary:
Not provided
https://www.soprasteria.com Logo
Sopra Steria
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Proficient in Oracle Analytics Cloud (OAC) and other Data Visualization Tools like Power BI, Tableau
  • Skilled in modeling, maintaining semantic models in OAC and Optional (data model in Power BI)
  • Skilled in creating Workbooks/Data visualizations and BI Publisher reports
  • Data Warehousing Concepts: Strong understanding of data warehousing architecture, design principles, and best practices
  • Good knowledge of securing report objects and data in BI Applications
  • Proficiency in writing and debugging SQL queries
  • Total Experience Expected: 06-08 years
  • BTECH / MCA
  • Fulltime
Read More
Arrow Right

Lead Data Analyst

Location
Location
United Kingdom , London
Salary
Salary:
60000.00 - 80000.00 GBP / Year
bbcstudios.com Logo
BBC Studios
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Knowledge and experience of digital/social media (in particular YouTube, Facebook and TikTok)
  • Experience of pitching and selling
  • Experience in line management and leading a team of data analysts
  • Knowledge of the media landscape and the part data and analytics plays
  • Data driven experience using Excel and PowerPoint
  • Experience using Python, SQL, and data visualisation tools such as Tableau
  • Experience across short-term, tactical projects as well as larger more strategic pieces, which includes scoping and building roadmaps for projects
  • Experience managing suppliers and partners to deliver clear aims
Job Responsibility
Job Responsibility
  • Leveraging insights from digital data analysis and consumer & audience research, contribute to the development of the BBC Studios social media strategy
  • Support development of our digital advertising business through analysis and interpretation of current performance – identifying key levers to commercial performance and advising on content analysis to aid performance and commissioning
  • Work with the global advertising and content sales team to develop a demand led sales and commissioning strategy
  • Support the global advertising and content sales teams during pitches and negotiations to service and win new clients, bringing together online/social media data insights with offline audience/consumer insights
  • Digital encompasses a wide range of businesses including social AVOD and E-Commerce
  • In this role, you will have the opportunity to help inform the strategy of BBC Studios’ social media brands, including: BBC Earth, Top Gear, Doctor Who, and Bluey
  • Working with data across multiple social media platforms including YouTube, Facebook, Instagram, X, TikTok, and Snapchat, you will turn data into actionable information for the business
  • Lead and manage a team of 4-5 data analysts, providing direction, support, and guidance to ensure high-quality, impactful work
  • Develop and maintain internal reporting frameworks to track KPIs, monitor business performance, and identify areas for improvement
  • Champion effective and focused digital metrics throughout the business
What we offer
What we offer
  • 26 days annual leave (plus bank holidays) and the option to buy an extra five days
  • Defined pension (up to 10% employer contributions)
  • Caring and parenting support
  • 24/7 remote GP access
  • Life assurance and accident benefit
  • Career development in a values-led purpose-driven culture
  • Flexible working
  • London Weighting Allowance of £5,441
  • 15% bonus OTE
  • Fulltime
Read More
Arrow Right

Lead Data Analyst

Location: Canberra, Melbourne, Brisbane, Adelaide, Sydney 12 months contract wit...
Location
Location
Australia , Canberra, Melbourne, Brisbane, Adelaide, Sydney
Salary
Salary:
Not provided
finxl.com.au Logo
FinXL
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Business Intelligence: Sourcing data and creating standard reports for stakeholders
  • Data Management: Implementing master data management processes and ensuring data integrity
  • Data Modelling & Design: Investigating complex enterprise data requirements and selecting appropriate modelling techniques
  • Data Visualisation: Designing and automating high-quality data visuals
  • Database Design: Developing physical database or data warehouse components
  • Programming/Software Development: Designing, coding, and testing moderately complex programs or scripts
Job Responsibility
Job Responsibility
  • Lead and manage a team, including monitoring performance, workflow, and professional development
  • Analyse complex datasets to solve organisational issues and identify trends
  • Collaborate with internal and external stakeholders to achieve project outcomes
  • Develop data policies, standards, and standard methodologies for ICT and business projects
  • Advise on application design reviews and performance testing
  • Prepare technical and corporate documentation
Read More
Arrow Right

Lead Data Analyst

We are seeking a Lead Data Analyst for a short‑term support engagement to provid...
Location
Location
Milwaukee
Salary
Salary:
Not provided
tier4group.com Logo
Tier4 Group
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor’s degree in Computer Science, MIS, Mathematics, Statistics, Business, or a related field
  • 4–5+ years of professional experience in analytics or data‑related roles
  • 3+ years of hands‑on analytics experience supporting business decision‑making
  • 5+ years of progressively responsible experience in research, data analysis, reporting, or application development
  • Strong expertise with analytical tools such as SQL, SAS, Excel, SPSS, R, or similar platforms
  • Experience with data visualization tools such as Tableau or Power BI
  • Proven ability to analyze data from multiple internal and external sources
  • Ability to communicate insights clearly and effectively to both technical and non‑technical stakeholders
  • Experience providing department‑level expertise and contributing analysis at an enterprise level
Job Responsibility
Job Responsibility
  • Provide timely support for ad hoc Tableau reporting requests submitted via Slack
  • Analyze quantitative and qualitative data to identify patterns, insights, and trends that inform business decisions
  • Develop, update, and maintain dashboards, reports, and forecasts that clearly tell a story through data
  • Partner with business stakeholders to deliver actionable insights, recommendations, and analysis (written, verbal, and presentation‑based)
  • Produce high‑quality, value‑driven analytics that support operational improvements, KPI tracking, and root cause analysis
  • Apply data visualization and design best practices while incorporating provided design direction
  • Support and enhance existing analytics products and reporting environments, including governance, documentation, and access controls
  • Collaborate with cross‑functional partners and serve as a trusted, consultative advisor to business clients, including senior leaders
  • Capture business requirements and contribute to KPI frameworks and analytical standards
  • Leverage metrics and analytics to inform forecasts related to cost, risk, and performance
What we offer
What we offer
  • Competitive Rates
  • Parttime
Read More
Arrow Right