Sr Software Engineer I

Elsevier; Chennai District; Presencial; INR 1.200.000 - 2.400.000; Jornada completa

Descripción de la vacante

RX Global seeks a Power BI specialist in Chennai to design, develop, and maintain interactive BI reports and dashboards across multiple data sources. You will collaborate with business stakeholders to translate requirements into scalable solutions and optimise data models and DAX measures.

You will work with data engineers, implement Row-Level Security, manage publishing and scheduled refreshes in Power BI Service, and contribute to best-practice governance and documentation.

Formación

• 3-5 years of commercial experience developing Power BI solutions.
• Strong experience with Microsoft Power BI suite (Desktop, Service, Query, DAX).
• Experience with data modelling and star schema concepts.
• Experience connecting Power BI to SQL Server, Oracle and other sources.
• Experience publishing reports, managing scheduled refreshes, and implementing RLS.
• Excellent communication and ability to work with technical and non-technical stakeholders.

Responsabilidades

• Design, develop, and maintain Power BI reports and dashboards.
• Translate business requirements into effective BI solutions.
• Develop and optimise DAX measures and data models.
• Ensure data quality and implement security and governance (RLS).
• Collaborate with Data Engineers and analysts to ensure data availability.
• Publish and maintain reports in Power BI Service and manage deployments.

Conocimientos

Analytical thinking

Communication skills

Stakeholder collaboration

Problem solving

Educación

Bachelor's degree in Computer Science / IT or equivalent

Herramientas

Power BI Desktop

Power BI Service

Power Query

DAX

SQL Server

Oracle

GitHub / version control

Descripción del empleo

Job Summary

RX Global aims to create unforgettable experiences for attendees and exhibitors through organizing events. Innovation, creativity, and collaboration drive the company to offer exceptional services to clients.

This position performs software design - typically across multiple components; is developing the skills of mentoring more junior members of the team and works with others to talk to users/customers and translates their requests into solutions.

Responsibilities

• Design, develop, and maintain Power BI reports and interactive dashboards.
• Work with business stakeholders to understand reporting and analytical requirements and translate them into effective Power BI solutions.
• Develop and maintain data models within Power BI using appropriate modelling techniques.
• Develop and optimise DAX measures, calculated columns, and calculated tables.
• Develop and optimise Power Query transformations using M.
• Connect Power BI to a range of data sources, including SQL Server, Oracle, APIs, and other business systems.
• Work closely with Data Engineers to ensure appropriate data structures and datasets are available for reporting requirements, including demonstrating advanced-level SQL troubleshooting capabilities.
• Develop and maintain reusable datasets, semantic models, and reporting solutions.
• Implement appropriate data validation and quality checks to ensure accuracy and consistency of reporting.
• Apply Row-Level Security (RLS) and other Power BI security features where required.
• Publish, manage, and maintain reports and datasets within Power BI Service.
• Support Power BI workspaces, apps, scheduled refreshes, and deployment processes.
• Troubleshoot report, data refresh, performance, and connectivity issues.
• Optimise Power BI reports and data models to improve performance and usability.
• Use Performance Analyzer, DAX Studio, and Tabular Editor to troubleshoot and optimise Power BI solutions.
• Utilise the Power BI Capacity Metrics App to monitor and optimise capacity usage across multiple semantic models.
• Implement and manage incremental refresh across multiple semantic models.
• Implement and manage Power BI gateways, including associated configurations and data sources within Power BI Service.
• Work closely with the support team to quickly troubleshoot and resolve reporting issues raised in the Production environment.
• Apply Microsoft Fabric capabilities to support effective capacity management and configuration management.
• Contribute to solution design using Microsoft Fabric features and capabilities.
• Ensure dashboards and reports follow consistent visualisation and design standards.
• Maintain source code and Power BI development assets using GitHub and follow version control best practices.
• Produce technical and user documentation for developed Power BI solutions.
• Support users with Power BI reporting and provide guidance on best practices.
• Contribute to the continuous improvement of Business Intelligence and reporting standards and practices.

Requirements

Essential

• 3-5 years of commercial experience developing Power BI solutions.
• Strong experience with Microsoft Power BI, including:
• Power BI Desktop
• Power BI Service
• Power Query
• Advanced DAX
• Data modelling
• Dashboards and interactive reports
• Microsoft Fabric features and capabilities
• Reporting best practices
• Strong knowledge of DAX, including creating and optimising measures using a broad range of functions and calculated expressions.
• Strong experience working with databases, particularly Microsoft SQL Server and Oracle using SQL Developer.
• Strong SQL knowledge, including:
• Views
• Common Table Expressions (CTEs)
• RANK and other window functions
• Execution plans
• Indexing and keys
• Stored Procedures
• Query optimization and troubleshooting
• Experience developing data models using star schema and dimensional modelling principles, including large and complex models containing 30+ tables.
• Experience connecting Power BI to Oracle, SQL Server, and other data sources.
• Good understanding of Power Query and M for data transformation and preparation.
• Experience managing and publishing reports through Power BI Service.
• Experience configuring and troubleshooting scheduled data refreshes.
• Understanding of Power BI security, including Row-Level Security (RLS).
• Experience troubleshooting and optimising Power BI report and semantic model performance.
• Experience using GitHub or another source control system for version management.
• Strong analytical and problem-solving skills.
• Excellent communication skills, with the ability to work effectively with both technical and non-technical stakeholders.

Desirable

• Experience integrating Power BI with Salesforce.
• Experience working with REST APIs and API-based data sources.
• Experience working alongside Data Engineering teams and ETL processes.
• Knowledge of SSIS and/or Talend.
• Experience of working with web analytical platforms.
• Experience with Power BI deployment pipelines and application lifecycle management.
• Knowledge of AWS and/or Azure data services.
• Experience with Power BI gateway configuration and administration.
• Familiarity with Agile development methodologies.
• Experience supporting enterprise-level Business Intelligence environments.

Qualifications

• Degree in Computer Science, Information Technology, Data Analytics, Business Intelligence, or a related discipline, or equivalent commercial experience.

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.