Job Description

Job Description (Key Responsibilities):

• Design, build, and maintain end‑to‑end reporting solutions, including data extraction, transformation, modeling, and visualization.
• Own report/dashboard development lifecycle: requirements → build → validation → iteration → handoff/support.
• Translate loosely defined business questions into clear metrics, KPIs, and reporting logic.
• Collaborate with business stakeholders to align definitions, assumptions, and interpretations of externally sourced data.
• Clearly explain data limitations, transformations, and lineage to non‑technical stakeholders to build trust in reporting outputs.
• Act as a bridge between business and technical teams, ensuring solutions are usable, trusted, and actionable.
• Proactively challenge requirements and propose simpler or more scalable reporting approaches.
• Build high‑quality dashboards and reports using tools such as Power BI, Tableau, or similar platforms.
• Apply best practices in data modeling, dashboard design, and performance optimization.
• Enable business users to confidently self‑serve insights through well‑designed and well‑documented reports.
• Understanding source system structures, field definitions, and delivery formats.
• Perform data mapping between external data sources and internal data models, ensuring consistency and correctness of metrics.
• Define and document data lineage, including source‑to‑target mappings, transformations, and calculation logic used in reporting.
• Validate external data against business expectations and internal reference data, identifying gaps, anomalies, and quality issues.
• Partner with internal data engineering, platform, and business teams to resolve data discrepancies and clarify ownership and definitions.
• Produce clear documentation to support auditability, explainability, and ongoing maintenance of reporting solutions.
• Job Requirements:

• 3+ years of hands‑on experience with:

• SQL (complex queries, joins, window functions, performance optimization)
• Python (Pandas, NumPy) for data transformation, analysis, and reporting workflows
• PySpark or distributed data processing frameworks

• 3+ years of experience building dashboards and reports using Power BI, Tableau, or similar BI tools, including:

• Data modeling
• Calculated measures (e.g., DAX or equivalent)
• Dashboard performance optimization

• Strong experience working directly with business stakeholders to define requirements and deliver reporting solutions.

Preferred/Nice to Have

• Experience working with Databricks or similar analytics platforms.
• Experience with merchant solutions, financial services or financial institution data.
• Background in analytics engineering or reporting‑focused analytics roles.
• Undergraduate degree in a quantitative field (e.g., computer science, engineering, math, physics, finance); graduate degree is an asset but not required.