Report Writer – SQL, SSRS & PBI | Remote | Jobs In India

DigitalXNode

Chennai

A distancia

INR 900.000 - 1.300.000

Jornada completa

Hace 7 días

Sé de los primeros/as/es en solicitar esta vacante

Consigue una respuesta de este empleador

Tu currículum y tu carta de presentación, adaptados exactamente a lo que buscan contratar.

Supera los filtros ATS

Descripción de la vacante

The ideal candidate should be highly comfortable with complex T-SQL, stored procedures, views, functions, execution plans,

Formación

3–8 years of SQL development, reporting, or data reporting engineering.
Expert-level T-SQL covering complex queries and functions.
Hands-on SSRS experience and Power BI dashboard development.
Experience migrating SSRS to Power BI and Azure Fabric capacity.

Responsabilidades

Analyze and deconstruct complex SQL logic including dynamic SQL and functions.
Map data flows and dependencies across database objects for data lineage.
Identify and diagnose query and stored-procedure performance issues.
Apply query tuning to improve report execution time and reduce server load.
Refactor SQL for readability without changing output.
Document SQL logic, data dependencies, and improvements.
Migrate on-prem SSRS reports to Power BI Tabular reports using Azure Fabric.

Conocimientos

Analytical thinking

Attention to detail

English communication

Educación

Bachelor's degree in Computer Science or Engineering

Herramientas

SQL Server

T-SQL

SSRS

Power BI

Azure

SSIS

SSAS

Descripción del empleo

Company Overview

At DigitalXnode, we bring businesses and skilled professionals together to meet evolving workforce demands. We assist organizations across India with recruitment and staff augmentation, helping them find suitable candidates for a variety of technical, business, and project-based roles. Our approach emphasizes matching the right skills with the right requirements.

Company Overview

Job Summary

DigitalXnode is looking for a Data Reporting Engineer with 3-8 years of experience in SQL development, SSRS reporting, SQL performance tuning, and Power BI for an Indian Client. The role focuses on improving existing SSRS reports, simplifying complex SQL logic, identifying performance bottlenecks, and supporting migration to Azure Fabric and Power BI Tabular reporting. The ideal candidate should be highly comfortable with complex T-SQL, stored procedures, views, functions, execution plans, indexing, and data dependencies, with strong attention-to-detail and communication skills.

Key Responsibilities

Analyse and deconstruct complex SQL logic, including dynamic SQL, stored procedures, views, nested views, scalar functions, and table-valued functions.
Map data flows and dependencies across database objects to understand report data sources and data lineage.
Identify and diagnose query and stored-procedure performance issues.
Apply advanced query tuning and optimization techniques to improve report execution time and reduce server load.
Refactor complex SQL into simpler, readable, and maintainable structures without changing report output.
Prepare and maintain documentation covering SQL logic, data dependencies, analytical insights, and proposed improvements.
Apply SQL development best practices for performance, readability, and maintainability.
Migrate on-premises SSRS reports to Power BI Tabular reports using Azure Fabric capacity.
Build Power BI dashboards and interactive reports that accurately reflect required SSRS reporting formats.
Validate changes carefully to ensure report results remain accurate after optimization or refactoring.
Work with technical and business stakeholders to understand existing reporting logic and communicate changes clearly.

Required Technical Skills

3-8 years of relevant experience in SQL development, reporting, or data reporting engineering.
Expert-level T-SQL covering syntax, functions, joins, subqueries, window functions, and advanced query techniques.
Strong hands-on SSRS experience.
Advanced SQL query optimization and performance tuning skills.
Ability to read and understand SQL Server execution plans and indexing strategies.
Ability to reverse engineer complex SQL and understand data lineage and dependencies.
Experience with stored procedures, dynamic SQL, views, nested views, scalar functions, and table-valued functions.
Hands-on Power BI and Power BI dashboard experience.
Experience with SSRS-to-Power BI migration.
Knowledge of Azure and Azure Fabric reporting environments.
Strong problem-solving, analytical, attention-to-detail, and English communication skills.

Preferred Technical Skills

Power BI Tabular models and semantic reporting structures.
Azure Fabric capacity and cloud reporting.
SQL Server Analysis Services (SSAS).
SQL Server Integration Services (SSIS) and data-flow concepts.
Modernization of legacy reporting environments.
Report-output validation during migration or refactoring.

AI Experience Is Not Specifically Required.

Managerial Experience

No direct people-management responsibility is there but there would be collaboration with technical and business stakeholders.

Operational Experience

SSRS report development and maintenance.
SQL Server query analysis and performance tuning.
Execution-plan analysis and indexing review.
Complex SQL refactoring and documentation.
Data lineage and dependency analysis.
SSRS-to-Power BI migration support.
Power BI dashboard development.
Report validation and quality assurance.

Qualifications

Bachelor's degree in Computer Science, Engineering, or a related discipline.
Candidates from any graduate background may also be considered if their relevant experience and technical skills align with the project requirements.
3-8 years of relevant experience.

Certifications