Reporting Automation Specialist

We are seeking a highly skilled Reporting Automation Specialist to join our client's dynamic team. The ideal candidate will play a pivotal role in designing, developing, and maintaining automated reporting pipelines that consolidate data from diverse sources (e.g., Jira, databases, APIs) into actionable, executive-level dashboards and reports using Tableau, ensuring accuracy, scalability, and timeliness.

This is a 12-mon contract opportunity, in hybrid work model - 4 days in downtown client's office location.

Toronto, ON

Core Responsibilities

The following balances technical execution with strategic alignment, ensuring the role drives efficiency and informed decision-making:

• Partner with executives, data teams, and IT to define reporting requirements.
• Identify opportunities to streamline reporting workflows and reduce manual effort.
• Create interactive, visually compelling dashboards tailored for executive audiences.
• Collaborate with agile teams to align portfolio reporting with business KPIs.
• Translate complex data into actionable insights for non-technical stakeholders.
• Extract, transform, and load (ETL) data from Jira (agile/project metrics), databases, APIs, and other systems.
• Build and maintain automated workflows (e.g., Python, SQL, or tools like Alteryx) to refresh data pipelines.
• Optimize queries and calculations for performance and clarity.
• Leverage Jira’s API/REST endpoints to extract project metrics (e.g., sprint velocity, backlog status, issue trends).
• Implement data governance best practices (e.g., row-level security, data validation).
• Document processes and provide training for end-users.

Required Skill

Technical:

• Proficiency in Tableau (calculations, parameters, dashboards).
• Experience with Jira (API, JQL, agile metrics).
• ETL tools (e.g., Python, SQL, Alteryx) and data warehousing concepts.
• Basic scripting/automation (Python, Power Shell).

Soft Skills:

• Strong communication to bridge technical and executive teams.
• Analytical problem-solving and attention to detail.