Experience: Over all 8+Yrs exp 

Location: Anywhere from India (Remote)

Job Description:

Power BI Reporting Analyst with hands on SSIS, DWH,SQL experience. 

Roles & Responsibilities:

1. Collect and understand the report requirements by working with different SMEs
2. Create custom tables/views using ETL tools like SSIS to support report/dashboard development
3. Create datasets using T-SQL queries and stored procedures using SSMS with best performance.
4. Develop reports/dashboards using Power BI.
5. Deploy the reports/DB/ETL objects to production environment
6. Monitor the deployed reports/DB/ETL objects and make changes to the objects in lieu of source application changes
7. Communicate the overall report design with both technical and business stakeholders
8. Establish quality processes to deliver a stable and reliable reporting solutions to the client
9. Production monitoring and support

Eligibility:

1. Excellent SQL skills - Write SQL queries, create stored procedures, fix performance issues
2. Excellent Reporting skills – Hands on experience in Power BI reporting tool.
3. Good ETL knowledge – Hands on experience in SSIS ETL tool, ADF.
4. Understanding on Data warehouse, fact and dimensional tables, star and snow flake schema
5. Banking knowledge (Preferred – Deposits and Loans understanding)