• 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 :- 26th Aug 2023

Job Description

This is a development position for a PowerBI role

This role will require an in person interview. While there is the possibility to do a webcam followed by in person, it is preferred for just an in person one.

Position Summary

This position is for a Power BI Developer with a background in SQL and data warehousing for enterprise level systems at DFD. The primary function of this position is to design, develop, test and deploy advanced Power BI solutions that leverage data warehouse and source system data across multiple subject areas. Coach and mentor other team members on Power BI concepts and technologies.

Responsibilities:

•Develop and maintain executive, enterprise level analytics solutions and reports using Power BI Desktop and hosted in Power BI Report Server.
•Define and follow Power BI development best practices
•Proficient with SQL Server including the ability to optimize queries to efficiently retrieve data.
•Create and maintain Power Pivot models, datasets and data flows using best practices
•Provide system support for the Power BI Report Server environment (application administration for both the development and production environments)
•Manage report security, folder security, database row level security, report schedules and distribution
•Works with complex queries; using specialized business technologies and applications in the Microsoft stack, such as DAX Studio, Tabula Editor, and Power BI Report Builder.
•Performs unit testing to validate the accuracy and validity of reports and data integrity.
•Provides user (business and client) training in BI reporting tools and reports as needed.
•Troubleshoots and resolves data integrity and performance issues.
•Communicate issues, risks, and concerns proactively to management.
•Works with business and technical teams to gather and define requirements, concise functional/technical documentation, and provide project status updates.
Required Skills:
•Senior level hands-on skills in building Reports, Dashboards, Scorecards and Reports using Power BI
•7+ years of experience with Microsoft BI stacks such as Power Pivot, SSIS, SSRS, and SSAS.
•5+ years hands-on experience in Power BI Desktop, Power BI Report Builder, Power BI Report Server and DAX Studio, must have deep technical knowledge and be able to implement any feature and solve any issue.
•5+ years of Business Intelligence, Data Warehouse, and data architecture experience.
•2+ years of experience and technical knowledge of Power BI Report Server Administration
•5+ years of experience with advanced MDX and DAX expressions
•5+ years of experience with data modeling with Power Query and Power Pivot
•Experience in integrating Power BI Reporting with Angular/.NET Core Applications
•Performs unit testing to validate the accuracy and validity of reports and data integrity.
•Strong PL/SQL development experience with the ability to write complex and nested SQL queries and stored procedures.
•Experience using source control software such as GitHub and Azure DevOps

Required/Desired Skills

 SkillRequired /DesiredAmountof ExperienceCandidate ResponseCreating paginated reports using Power BI Report builder.Required5Years Creating Dashboards and Scorecards using Power BI Desktop.Required5Years Power BI Service AdministrationRequired5Years  

Questions

 No.QuestionCandidate AnswerQuestion1Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirement? Question2Please list candidate's email address HERE that will be used when submitting E-RTR. Question3Is the candidate available to work onsite immediately upon start? Question4Where is the candidate geographically located? Question5All candidates must reside within commutable distance to the client site in Trenton - is that understood? Question6Is the candidate available for a round one, IN-PERSON interview?