Opening For Ms Bi Developer For Mumbai Location
- Locuz
- 5 - 10 years
- Mumbai
- 15 days ago
- Email to a friend
- Report this job
Job Description
MS BI Developer (Only Female Candidate)
Roles and Responsibilities
SQL Development Experience:
- Minimum 5 years of experience as BI developer with Microsoft tools and technologies (MS BI)
- Excellent Data Analysis skill.
- IT experience in working with T-SQL and Development on Microsoft SQL Server database 2016 onwards.
- Experience with T-SQL in constructing Tables, implementing stored Procedures, Functions, Views, etc.
- Expert in working with database jobs, ETL scheduling etc.
- Experience in working with Cloud platform like Azure, AWS or GCP would be added advantage.
- SSAS Development Experience
- Hands on experience on Analysis Services (SSAS), and Visual Studio.
- Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
- Deploy and processed SSAS cubes using SQL Server Agent.
- Hands on experience of developing model in SSAS Cubes.
- Experience in developing DAX in SSAS.
- Good in depth understanding of different type of relationships and data modelling.
- SSIS Development Experience
- Experienced in using ETL tools in (SSIS) 2019/2016.
- Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
- Data Loading Experience in SQL Server using SSIS ETL and Experience in developing packages in SSIS and DTS according to task.
- Data analysis and data migration by transferring them using SSIS packages.
- Additional experience of working with ADF pipelines would be plus.
- Power BI Experience:
- Developed Power BI model used for financial reporting of P & L and Headcount.
- Designed and documented the entire Architecture of Power BI.
- Expertise in writing complex DAX functions in Power BI.
- Used various sources to pull data into Power BI such as SQL Server, SQL Azure etc...
- Created content pack and allow access to the end user.
- Created Workspace and content packs for business users to view the developed reports.
- Scheduled Automatic refresh and scheduling refresh in power bi service.
- Write calculated columns, Measures queries in power bi desktop to show good data analysis techniques.
- Weekly presentation to the business users about the reports and their changes as required.
- Worked on all types of transformations that are available in Power bi query editor.
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Data Science & AnalyticsRole Category: Business Intelligence & AnalyticsRole: BI DeveloperEmployement Type: Full timeContact Details:
Company: LocuzLocation(s): Mumbai+ View Contact
Keyskills: Power Bi SSAS MSBI SQL Server SSIS Azure Data Factory Dax Queries Power Bi Reports Business Intelligence Microsoft Power Bi Dax SQL Azure
Fraud Alert to job seekers!
₹ 5-13 Lacs P.A
Similar positions
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in