02 Nov
|
RX Global
|
Chennai
This job is with RX Global, an inclusive employer and a member of myGwork – the largest global platform for the LGBTQ+ business community. Please do not contact the recruiter directly.
Job Description
About Team:
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.
About the role:
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.
Key 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 setting.
- 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.
Required Skills & Experience
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
📌 Senior Software Engineer I (Chennai)
🏢 RX Global
📍 Chennai