43803 Data Analyst | Reporting Transformation | Salesforce to ServiceNow & Snowflake

Cephas Consultancy Services Private Limited; New Jersey; Híbrido; USD 90 000 - 130 000; Tempo integral

Resumo da oferta

Cephas Consultancy Services Private Limited is seeking a Senior Data/Reporting Analyst to modernize Power BI reporting, analyze data, and transition to a unified semantic layer. You will work closely with the client and Data Architect, owning reporting activities and driving rationalization across sources.

The role emphasizes hands-on analysis, strong SQL, Power BI expertise, and collaboration with stakeholders to improve scalability and maintainability.

Qualificações

• 5–8+ years in BI, data analytics or senior reporting roles.
• Hands-on with Power BI, DAX, Power Query and SQL in enterprise environments.
• Ability to reverse-engineer reports to identify embedded logic and dependencies.
• Experience with Databricks or equivalent cloud data platforms; Python and DevOps tools preferred.

Responsabilidades

• Assess and modernize the Power BI reporting landscape in collaboration with stakeholders.
• Analyze reports, rationalize content, and transition to a common semantic/data layer.
• Identify reusable data elements and reduce report-level logic for maintainability.
• Collaborate with Data Architect and client teams to balance immediate needs with modernization.

Conhecimentos

Power BI

DAX

Power Query

SQL

Semantic modeling

Databricks

Python

Azure DevOps

GitHub

Client-facing communication

Performance optimization

Analytics

Ferramentas

Databricks/Spark SQL

Azure DevOps

GitHub

Descrição da oferta de emprego

43803 Data Analyst | Reporting Transformation | Salesforce to ServiceNow & Snowflake

43803 Data Analyst | Reporting Transformation | Salesforce to ServiceNow & Snowflake

Cephas Consultancy Services Private Limited Permanent Remote Work, New Jersey, United States

About this position

Positions:1 Contract
Experience
5 - 8 Years

Role Title : Senior Data / Reporting Analyst

Location : Onshore - Remote

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.

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.

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.