43803 Data Analyst | Reporting Transformation | Salesforce to ServiceNow & Snowflake
Cephas Consultancy Services Private Limited · Lower Montville, Morris County ·
- Employment
- Contract
- Category
- Data analytics
- Experience
- 5+ years
Contract role (6 months, extendable) for a Senior Data/Reporting Analyst working remotely onshore with a client's Enterprise Data & Analytics team to assess and modernize a Power BI reporting landscape: reverse-engineering reports, rationalizing them, and moving logic toward a shared semantic/data layer. Core stack: Power BI (DAX, Power Query), SQL, and Databricks/Spark SQL.
Positions:1 Contract
Experience
5 - 8 Years
Role Title : Senior Data / Reporting Analyst
Project : Reporting & Data Modernization|Enterprise Data & Analytics
Location : Onshore - Remote
Engagement : Contract – 6 months, extendable -
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.
Behavioural Competencies:
Self-driven and hands-on, capable of independently owning 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.
PI287623714