Power BI Lead - SQL/SSIS

Experience: 6 years Skills: Power BI, SSRS, DAX, SQL Location: Gurugram (On-site) Mandate: Must work from the client location (5 days a week) Notice Period: Only candidates serving notice period or immediate joiners will be considered. Roles and Responsibilities : - We are seeking a Power BI Developer to build and maintain BI and analytics solutions with insightful dashboards that transform data into knowledge. - Experience with data and business analysis will be considered. - It would be best if you are an analytical person and a good communicator. - A Power BI developer's primary responsibility will be to transform raw data into relevant insights via interactive and simple-to-understand dashboards and presentable reports keeping everything in mind. Roles and Responsibilities : - Recognize business requirements in the context of BI and create data models to transform raw data into relevant insights - Working closely with business team for articulating the requirements - Taking ownership of the delivery and mentoring junior resources in the team - Using Power BI to create dashboards and interactive visual reports - Define key performance indicators (KPIs) with specific objectives and track them regularly - Analyze data and display it in reports to aid decision-making - Convert business needs into technical specifications and establish a timetable for job completion - Create, test, and deploy Power BI scripts, as well as execute efficient deep analysis Use Power BI to run DAX queries and functions - Create charts and data documentation with explanations of algorithms, parameters, models, and relationships - Construct a data warehouse - Expertise into SQL queries - use of joins, sub queries - Make technological adjustments to current BI systems to improve their performance For a better understanding of the data, use filters and visualizations - Analyze current ETL procedures to define and create new system Required Skills : - 6 years of relevant experience in Power BI. - Good to have experience in Azure services. - Hands on experience on DAX functions- Date and Time, Time Intelligence, Logical, Mathematical and Trigonometric, Statistical, Text, Parent-Child Functions - Proficiency in writing SQL queries and use of Relational Keys, Select Queries, Joins, Data Modelling, - Fact and Dimension Table Types, Different Schemas, DDL, DML - Understanding of Data warehousing DWH concepts. - Capable of enabling row-level data security - Knowledge of Power BI application security layer models - Prior experience in data-related tasks - Understanding of the Microsoft BI Stack - Be familiar with MS SQL Server BI Stack tools and technologies, such as SSRS and TSQL, Power Query, - MDX, Power BI, Data Modelling - Analytical thinking for converting data into relevant reports and graphics - Ability to run DAX queries on Power BI desktop - Proficient in doing advanced-level computations on the data set - Excellent communication skills are required to communicate needs with client and internal teams successfully - Join our dynamic and innovative team, and contribute your expertise to deliver cutting-edge web applications Flexibility : - Opportunity to work on multiple technologies - Medical Coverage & Life Insurance - Company Events and Outings - Tech Thursdays and Fun Fridays - 5 days working - Work-Fun Environment (ref:hirist.tech)

Location: in, IN

Posted Date: 5/9/2025