Technical Lead L2

Technical Lead L2

Role

Summary:

This role focused on delivering end-to-end reporting and analytics solutions. The successful candidate will be highly hands-on, with strong coding and visualization skills, and will work closely with business stakeholders to translate business questions into clear metrics, dashboards, and reporting solutions. The role combines technical execution with business analysis responsibilities, owning the full lifecycle from requirements gathering through build, validation, iteration, and handoff.

This is a delivery-oriented role with defined timelines and clear outcomes.

Technical

Skills:

Power BI, Tableau, Python, SQL, co-pilot (nice to have)

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, Num Py) 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.