The Role
Develop and maintain Power BI dashboards, reports, cubes, data models, and database queries. Translate business needs into BI specifications, analyze complex datasets, identify trends, and deliver actionable insights. Ensure report quality, performance, auditability, and data lineage. Collaborate with technical and business teams on BI projects, standardized reporting, and issue resolution. Requires strong expertise in SQL Server, SSAS, SSRS, DAX, dimensional modeling, data warehousing, and Microsoft Azure services.
Summary Generated by Built In
Develop and maintain analytical solutions, dashboards and reports to support informed business decisions.
Translate stakeholder business needs into technical specifications and BI standards.
Develop, deploy and maintain Power BI cubes, data models and database queries, and optimise them for performance.
Perform advanced data modelling, data collection and analysis from primary and secondary sources.
Identify, analyse and interpret trends and patterns in complex datasets, and turn data into business insight.
Ensure reports are tested; track and resolve defects and issues to closure.
Collaborate with the Digital Core Team and business units on BI project goals, timelines and standardised reporting requirements.
Requirements
- 4 to 6 Years of overall work experience primarily working on Analytics and BI domain preferably in Microsoft stack (MSBI, PowerBI & Excel). Experience in creating business critical Dashboards and Reports in Power BI using SQL Server, Lakehouse as sources.
- In depth knowledge of data lake, data warehouse/BI development with a focus on auditability, end-to-end lineage.
- Experience of Dynamics 365 or ERP in comparable role within IT, Finance or Business.
- Technical expertise regarding data models, database design development, data mining and segmentation techniques.
- Must have hands-on experience in Power BI report design, with mandatory expertise in the on-premise Power-BI Report Server with proficiency in DAX and TSQL queries, along with their integration with cloud services.
- Experienced in Data warehousing and Dimensional modelling (Star schema and Snowflake schema).
- Experienced in maintaining and customizing Cubes using SQL Server Analysis Services (SSAS) and experienced in Data visualization/reporting tools like SSRS and Power BI.
- Experience in creating Power BI Reports using various sources like Excel, CSV, SQL Server, Oracle, SQL Server Analysis service (SSAS), Azure SQL, Azure Data Warehouse, etc.,
- Experience in creating complex calculations and measures for Visuals and KPI’s using DAX.
- Experience in Azure Cloud Services, Azure Databricks, Azure DevOps, Azure Storage, Azure Data Lake added value
Education:
- Bachelor Degree or Masters in Computer Science/Engineering/Applications or related field.
- Certification in Business Analysis is an advantage.
- Microsoft Azure-related training/certifications are an advantage: Data Scientist Associate (DP-100), Power BI Data Analyst Associate (PL-300) or equivalent of other major cloud platforms
Knowledge of
- In-depth knowledge in SQL Server, SSAS, SSIS and SSRS; SQL database administration experience is added advantage.
- Knowledge in Microsoft Dynamics 365 architecture.
- Knowledge in PowerBI report/dashboard designing and publishing.
- Expertise in writing complex SQL queries and optimizing the Performance of Power BI Reports. Designed and created databases, tables, views, stored procedures, and functions using SQL server
Skills required:
- Proven analytical background
- Proficiency in scripting / programming languages SQL. Python/R scripting
- is preferred
- RPA and predictive analytics capabilities is an added advantage
Skills Required
- 4 to 6 years of overall work experience primarily in analytics and business intelligence
- Experience with Microsoft BI technologies, Power BI, and Excel
- Experience creating business-critical Power BI dashboards and reports using SQL Server and Lakehouse sources
- In-depth knowledge of data lakes, data warehouses, BI development, auditability, and end-to-end data lineage
- Experience with Dynamics 365 or ERP in an IT, finance, or business role
- Technical expertise in data modeling, database design, development, data mining, and segmentation
- Hands-on experience with Power BI report design and Power BI Report Server
- Proficiency in DAX and T-SQL queries, including integration with cloud services
- Experience with data warehousing and dimensional modeling, including star and snowflake schemas
- Experience maintaining and customizing cubes using SQL Server Analysis Services
- Experience with SSRS and Power BI data visualization and reporting tools
- Experience creating Power BI reports using Excel, CSV, SQL Server, Oracle, SSAS, Azure SQL, and Azure Data Warehouse sources
- Experience creating complex DAX calculations and measures for visuals and KPIs
- Experience with Azure Cloud Services, Azure Databricks, Azure DevOps, Azure Storage, and Azure Data Lake
- Bachelor's or master's degree in computer science, engineering, computer applications, or a related field
- Business analysis certification
- Microsoft Azure training or certifications, such as DP-100 or PL-300
- In-depth knowledge of SQL Server, SSAS, SSIS, and SSRS
- SQL database administration experience
- Knowledge of Microsoft Dynamics 365 architecture
- Expertise writing complex SQL queries and optimizing Power BI report performance
- Experience designing and creating SQL Server databases, tables, views, stored procedures, and functions
- Proficiency in SQL and analytical scripting or programming
- Python or R scripting experience
- RPA and predictive analytics capabilities
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
TechCarrot is a global IT services provider and digital-transformation partner, delivering cost-effective, customer-centric digital solutions to clients worldwide. Its 200-plus technology specialists provide services across multiple industries, aiming to create seamless customer experiences and support client growth. Founded in 2016 and headquartered in Dubai, the company serves the Middle East and Africa through UAE operations, APAC through India, and has also expanded into the United States and the Netherlands.
