Senior Data/Reporting Analyst, Reporting Transformation

Positions: 1

Project: Reporting & Data Modernization | Enterprise Data & Analytics
Location: Onshore – Remote
Engagement: 6-month contract, extendable
Experience: 5–8 years

About the Role

The Senior Data/Reporting Analyst will work closely with the client and Data Architect to assess and modernize the existing Power BI reporting landscape. The role will focus on analyzing reports and embedded business logic, supporting report rationalization, identifying reusable data elements, and helping transition reporting toward a common semantic/data layer. The ideal candidate will be hands-on, analytical, and comfortable working directly with business and technical stakeholders to simplify reporting and improve consistency, maintainability, and scalability.

Technical Competencies

• Advanced Power BI expertise, including Power Query (M), DAX, semantic modeling, and performance optimization.
• Strong SQL skills for analyzing, transforming, reconciling, and validating data across multiple sources.
• Ability to reverse-engineer existing Power BI reports, including embedded business logic, transformations, calculations, data sources, and dependencies.
• Strong understanding of semantic/data models, dimensional modeling, and reusable data structures to reduce report-level logic.
• Working experience with Databricks, Spark SQL, or equivalent cloud data platforms and curated analytical datasets.

Behavioral Competencies

• Self-driven and hands-on, with the ability to independently own assigned reporting and analysis activities.
• Strong analytical and problem-solving mindset, particularly in complex and poorly documented reporting environments.
• Strong client-facing communication skills, with the ability to work directly with business and technical stakeholders.
• Comfortable working through ambiguity, asking the right questions, and proactively identifying dependencies and risks.
• Collaborative and pragmatic, working closely with the Data Architect and client teams while balancing immediate reporting needs with longer-term modernization objectives.

Required Qualifications

• 5–8 years of experience in BI, data analytics, analytics engineering, or senior reporting/data analyst roles.
• Strong hands-on experience with Power BI, DAX, Power Query, and SQL in enterprise reporting environments.
• Proven experience analyzing and reverse-engineering existing reports to identify embedded business/data logic and dependencies.
• Experience with report rationalization/modernization and semantic or shared data models, including retain, retire, quick-fix, and rebuild assessments.
• Experience with Databricks or equivalent cloud data platforms; Python and Azure DevOps/GitHub experience preferred.