Job Description :
Greetings from IPS Technology Services! We are currently hiring for Power BI Developer in Southfields, MI for a long term project with one of our direct clients. I would appreciate it if you could take a minute to review this and let us know if you are open to exploring this opportunity or if you know anyone who would be a great fit for this role.

Position:- Power BI Developer
Location:- Southfields, MI
Contract :- Contract to hire

Interview Question will be related to following topics :
Power Bi
SSRS
SSIS
SQL complex
Practical coding test in Power BI - existing report


Job Details :

Power BI developer with Solid SQL Server development experience. He must have developed code and complex queries in SQL server with multiple joins to interact with very large SQL server database (500 GB+) to fetch data from the database and then write code to present data (what he has found) to using Power BI.


Skill required:-

4-3 years hands-on work experience with Microsoft Power BI experience in optimizing Microsoft Power BI dashboards with a focus on usability and performance bility and performance .

2-3 year experience in MSBI [SSIS/SSRS/SSAS] Skills.

Experience on - DAX Data Analysis expressions and functions, PowerPivot, Enhancing Power BI visuals. Data extraction and Power query for data transformation.

Creating Row level security with Power BI and integration with Power BI Service Portal. Exposure to Gateway services and handling user and app security.

Understand the underlying data and able to map the same with dashboard. Creation of Power BI dashboard and transforming the manual reports, support Power BI dashboard deployment.

Based on understanding of system upstream & downstream, provide feedback and inputs on gaps in requirements and technical feasibility of requirements.

Share best practice to ensure we leverage the best design available.


This are main responsibility for this Power BI role .

Involved with the business in gathering requirements to develop unique solutions that meets their custom needs.
Created and consulted on report user interface. Introduced new features of reporting that would be useful to the business users.
Created reports based on data from Quality Management Information Systems.
The data source for the reports were Oracle views.
Created five separate views to report on different aspects of quality management- Delivery, Quality, Production Part Approval Process (PPAP), Location and Target.
These views were created by joining numerous facts and dimension tables in Oracle database.
Created reports to determine complaints per million, Quality of non-confirming parts per million, quality of service index, major incidents that hamper quality of products.
Created drill though reports to get further insights into the data for each of the parameters on which quality was measured.
Created many calculated columns and measures in Power BI using DAX to better evaluate quality.
Created executive dashboards to visually display the data to the business users.
Created group workspace on Power BI service to enable business users to create their own reports using existing reports.
Tested and validated report accuracy with the business users to make sure that warehouse and report data is consistent.
Regularly monitored reports refresh schedule and fixed any issues that hindered the performance of the reports.
Installed and monitored Power BI gateway on the data server to enable data refresh of the reports on Power BI Service.