Striiver Consulting
Location
India | India
Job description
Roles & Responsibilities :- As a SQL and Power BI Analyst, you will be responsible for developing, maintaining, and optimizing SQL queries and Power BI reports to support data-driven decision-making for our client. - The ideal candidate will have strong expertise in Microsoft Excel, Power BI, and SQL, with the ability to create models from scratch and enhance existing client models.- Develop Complex SQL queries to extract, analyze, and manipulate data from multiple databases.- Develop and present reports and dashboards to clients and management using Power BI.- Optimize SQL queries and database performance for improved efficiency and scalability.- Provide technical support and troubleshooting for SQL and Power BI-related issues.- Utilize SQL for database management and data analysis.- Conduct financial analysis and modeling using Excel and Power BI, including functions such as SUM, Average, SUMIF, PMI, NPV, IRR, VLOOKUP, RUNDOWN, PV, Index Match Match, IF (MIN, MIN), IF(VLOOKUP), HLOOKUP, SUMPRODUCT, and more.Collaborate with team members and contribute to a diverse, collaborative, and driven professional environment.Requirements : - Skills, Knowledge, and Abilities : - The person should have decent knowledge VBA.- The person should have decent knowledge SqL Queries & Database.- The person should have decent knowledge Spread Sheet Server - Add on in Excel.- The person should have decent knowledge Query Design.- Strong proficiency in writing complex SQL queries and optimizing database performance.- Strong command of Excel, Power BI/Looker, SQL, Word, and PowerPoint. - Experience in managing workload, report production, and programs. - Basic Understanding of private equity, investment risk, and real estate investments.- Knowledge of data analytics, with the ability to create reporting tools and dashboards. (ref:hirist.tech)
Job tags
Salary
