Job Requirements:

• Minimum 3 years’ experience of working on end-to-end Analytics project.
• Minimum 3 years of hands-on experience with Azure ecosystem + Power BI / AWS ecosystem + Power BI.
• Experience with connecting to files, databases, and other sources to get data in Power BI.
• Modelling of tables and sound knowledge of DAX to create measures, calculated tables etc.
• Sound knowledge of Data Warehousing and modelling concepts.
• Experience in creating custom Time Intelligence measures, Dimensional Hierarchies and other measures using DAX.
• Experience in creating business friendly and visually appealing dashboards by improvising on features provided by Power BI.
• Extensive experience in using bookmarks, view selections and actions to customize look and feel/navigation of dashboards.
• Experience in using Power Query for making any changes while reading data.
• Must have – SQL query expertise.
• Candidates should be Microsoft Power BI Certified in the below:
• Microsoft Certified: Power BI Data Analyst Associate (PL-300).
• Exposure to Creating and maintaining partitions in Analysis Services based on datasets.
• Experience in building Tabular models in Azure Analysis Services/SSAS.
• Scripting for managing automated scheduled refresh for Analysis Service models.
• Preferred but not a must have - Experience in using Azure Data Factory/SSIS as ETL tool for building a data warehouse/data lake.
• Experience with other Azure components for data handling and data transformation.
• Working knowledge of Azure services like Blob Storage, Event Hub, Azure Function etc.
• Exposure to data integration tools like Azure Data Factory/SSIS/Informatica.
• Experience in design and build of various ETL routines using data integration tools.
• Exposure to data science & ML – Azure ML /AWS Sagemaker – As added advantage.
• Strong hands-on experience in following areas : MS Power BI – Primary skill.
• MS Azure Analysis Services – Primary skill.
• SQL query – Primary skill.
• MS Azure Data Factory – Added advantage.
• Additional desirable skills: Exposure to data analytics, statistical model development will be added advantage.
• Excellent written and verbal communication skills.
• Qualifications: M.Tech / B.E. / B.Tech (Computer Science, Information systems, IT) / MCA / MCS.