US Citizen
Green Card
EAD (OPT/CPT/GC/H4)
H1B Work Permit
Corp-Corp
W2-Permanent
W2-Contract
Contract to Hire
Consulting/Contract
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 8th Mar 2024
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.