Remote Senior Data & Reporting Analyst - BI Modernization

Cephas Consultancy Services Private Limited; New Jersey; Hybrid; USD 90,000 - 130,000; Full time

Job summary

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.

Qualifications

• 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.

Responsibilities

• 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.

Skills

Power BI

DAX

Power Query

SQL

Semantic modeling

Databricks

Python

Azure DevOps

GitHub

Client-facing communication

Performance optimization

Analytics

Tools

Databricks/Spark SQL

Azure DevOps

GitHub

Job description

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.