Required Skills

Power BI

Work Authorization

  • US Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

  • H1B Work Permit

Preferred Employment

  • Corp-Corp

  • W2-Permanent

  • W2-Contract

  • Contract to Hire

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 8th Mar 2024

JOB DETAIL

Key Responsibilities:
•            Design, develop, and implement Power BI dashboards and reports to meet business requirements.
•            Work closely with stakeholders to gather and understand reporting requirements.
•            Utilize DAX (Data Analysis Expressions) to create complex calculations and measures.
•            Develop and maintain Power Automate flows to automate data workflows and processes.
•            Integrate Power BI with Power Automate and SharePoint for seamless data updates and synchronization.
•            Leverage knowledge of ServiceNow to extract, transform, and load data into Power BI.
•            Create reports and dashboards that provide insights into ServiceNow metrics and KPIs.
•            Apply basic knowledge of IT service desk operations and Asset Management Database (AMDB) concepts.
•            Collaborate with IT teams to understand data sources related to service desk and AMDB.
•            Utilize Rest API for data extraction and integration into Power BI.
•            Write and optimize SQL queries to retrieve and manipulate data from various databases.
•            Implement and maintain data security measures within Power BI, ensuring compliance with organizational policies.
•            Develop role-based access control and manage user access to reports and dashboards.
Qualifications
•            5+ Years in Data analysis, business intelligence or related field.
•            Power BI Experience required:
o            Data Modeling and Transformation:
o            Apply advanced data visualization techniques
o            Power BI Administration Experience
o            Data integration with External sources
o            Identify and resolve performance bottlenecks in Power BI reports and dashboards.
o            Implement version control for Power BI artifacts to track changes and facilitate collaboration
o            Advanced understanding of data warehousing concepts, including star and snowflake schemas.
o            Proficiency in optimizing data models for large datasets and complex relationships.
o            Ability to troubleshoot and resolve issues related to data refresh, connectivity, and performance.
o            Conduct training sessions for end-users on Power BI functionality and best practices.
o            In-depth knowledge of Power BI features such as row-level security, custom connectors, and Power Query M language.
o            Experience with Power BI Premium and Power BI Service administration.
o            Capability to design and implement complex data transformations using Power Query Editor.
•            Strong proficiency in SQL queries, SQL Agent, and Store procedures.
•            Experience with Power Automate, SharePoint, ServiceNow reporting, and AMDB concepts.
•            Knowledge of Rest API, and authentication methods.
•            Understanding of data security principles and best practices.
•            Excellent communication and collaboration skills.
Preferred Skills:
•            Certification in Power BI, Azure data, or related data technologies.
•            Familiarity with data warehousing concepts.
•            Experience with cloud-based BI solutions.
•            Knowledge of business analysis and requirements gathering.

Company Information