Overview

Job Title: Sr. BI & Data Engineer

Responsibilities

• Own development and maintenance of Power BI dashboards, reports and semantic models.
• Translate business requirements into meaningful KPIs, reports and analytical solutions.
• Design reusable and scalable Power BI data models.
• Develop dashboards for management and business functions.
• Improve dashboard performance, usability and data reliability.
• Manage Power BI workspaces, datasets, refreshes and access where required.
• Establish consistent definitions for important business KPIs and metrics.
• Develop and maintain ETL/ELT pipelines from databases, applications, APIs and other data sources.
• Build and maintain data warehouses, data marts and analytical datasets.
• Perform data transformation, cleansing and validation.
• Design appropriate dimensional models for reporting and analytics.
• Automate recurring data integration and reporting processes.
• Monitor data pipelines and resolve failures or data-quality issues.
• Write advanced and optimized SQL queries for reporting and data processing.
• Work with SQL Server and other relational databases.
• Identify inefficient queries and collaborate with the DBA on performance improvements.
• Understand indexing, joins, aggregations and execution plans sufficiently to build efficient reporting solutions.
• Ensure BI workloads do not unnecessarily impact production databases.
• Implement basic data-quality checks and validation processes.
• Identify discrepancies between source systems and reports.
• Maintain documentation for data sources, transformations, KPIs and reporting logic.
• Follow appropriate security and access-control practices.
• Support the development of a reliable single source of truth for business reporting.
• Work directly with business users to understand reporting and analytics requirements.
• Challenge unclear requirements and help define the right metrics and reporting approach.
• Convert business problems into practical data solutions.
• Present dashboards and insights to business stakeholders.
• Provide ongoing support and training to Power BI users where required.
• Identify opportunities to automate manual Excel-based or operational reporting.
• Modernize legacy reports and reporting processes.

Qualifications

• Department / Function: Technology D&S
• Location: Ahmedabad
• Employment Type: Full-time
• Sahana System Limited (SSL), headquartered in Ahmedabad, is an ISO-certified IT company established in 2012. Listed on the National Stock Exchange (NSE) and holding CMMI Level 5 compliance, ISO 9001, and ISO/IEC 27001 certifications, SSL has built a strong reputation in both domestic and international markets.
• We specialize in digital product engineering, digital transformation, cloud services, blockchain, business consulting, and digital marketing, while leveraging cutting-edge technologies such as AI, ML, IoT, BI, DevOps, and Cyber Security. With a strong focus on innovation and sustainable technology, we empower enterprises, government sectors, and defence organizations worldwide.
• Our global footprint spans the North America, Middle East, South East Asia, and we are actively expanding into the European, Japanese and Russian market.
• Website: https://www.sahanasystem.com/
• LinkedIn: https://www.linkedin.com/company/sahanasystemltd/
• Position Overview
• The person will work closely with the DBA, application development and business teams to ensure that data is accurate, performant, secure and useful for decision-making.
• The candidate should be able to:
• Understand Business Requirements> Write SQL >Build ETL >Design Data Model > Build Power BI Semantic Model> Create Dashboard >Validate Data >Optimize Performance