15 Aug
|
Ngage Intelligence
|
Ahmedabad
15 Aug
Ngage Intelligence
Ahmedabad
Job Type : Full Time , work from office , 5 Days Working.
We are seeking a skilled and experienced Microsoft BI Engineer to join our team. The ideal candidate will have robust hands-on experience in ETL development, SSIS, SSAS, DAX, Power BI, Azure Data Factory (ADF), data warehousing, and data lakes.
The candidate should be detail-oriented, analytical, and passionate about working with data. This role requires strong problem-solving skills and the ability to collaborate effectively with development, product, and business teams in a fast-paced environment.
Key Responsibilities
- Design, develop, maintain, and optimize ETL processes using SQL Server Integration Services (SSIS).
- Develop, maintain, and troubleshoot SSIS packages and data integration workflows.
- Collaborate with the development team on SQL database updates, schema changes, stored procedures, and data-related product enhancements.
- Analyze business and product data and generate data summaries and insights to support AI prompt generation and AI-driven use cases.
- Develop, maintain,
and optimize SSAS Tabular models/cubes to support business intelligence and reporting solutions.
- Write, optimize, and troubleshoot DAX queries and measures for analytical reporting.
- Develop and maintain Power BI dashboards, reports, semantic models, and datasets that provide actionable business insights.
- Work closely with business and technical stakeholders to understand requirements and translate them into scalable BI solutions.
- Ensure data accuracy, consistency, integrity, and quality across BI solutions and data pipelines.
- Perform data analysis to identify trends, patterns, anomalies, and actionable insights.
- Troubleshoot and resolve issues related to SSIS, SSAS, Power BI, SQL, ADF, and other BI processes.
- Design and manage data integration and orchestration workflows using Azure Data Factory (ADF).
- Develop and maintain data warehouse and data lake solutions.
- Write, optimize, and troubleshoot T-SQL
📌 Microsoft BI Engineer (Ahmedabad)
🏢 Ngage Intelligence
📍 Ahmedabad