Location
Pleasant Prairie, WI | United States
Job description
Full job description
We are looking for an experienced Lead SQL Server with Power BI at Pleasant Prairie, WI Onsite . Please go through the below job description and revert me back with your updated resume at [email protected] or reach me on 469-809 8178.
Lead SQL Server with Power BI
Pleasant Prairie, WI (Onsite)
Long Term Contract
Interview Mode: 1st round telephonic & 2nd round will be Face to Face (Will Reimbursement for in person interview).
Need Only: Wisconsin, Minnesota, Iowa, Illinois, Indiana, Michigan OR Who can go F2F interview in Pleasant Prairie, WI.
Job Description:
- Strong experience in architecting SSRS, SSAS and Power BI based solutions.
- Must be very strong in SQL/PLSQL. Should be Strong enough to troubleshoot complex report queries and stored procedures.
- Should be able to implement architect on data refresh, security, performance optimization of SSRS and Power BI reports.
- Should have very good experience in relational database system like SQL Server, Oracle etc.
- Perform support functions for all applications related to SSRS, SSAS and Power BI based reports by investigating on all major/minor incidents, service requests and enhancements (in Service Now).
Moreover, coordinate with business and offshore teams to convey the requirements, clarify the designs, and verify the deliverables.
- Perform support functions and work on report fixes on hard deadlines in case of HIGH PRIORITY issues.
- Should have experience in PBRS to create new schedules and support existing.
- Strong Technical skills in Power BI Desktop and Power BI service, especially expertise in DAX functions and Power BI modelling.
- Perform application, batch jobs monitoring, and ensure smooth functioning of the client business processes end to end and collaborate with other teams in case of any issues with batch run.
- Should be very strong in improving the performance or optimizing the runtime of SSRS and Power BI reports on hard deadlines.
- Strong experience in Data Modeling.
- Having good knowledge or experience in Cognos and Python is an added advantage.
- Should be ready to support over weekend as a POC.
Skills Required :
- SQL Server Reporting Services
- Power BI (On-prem and Cloud)
- PBRS
- SQL/PLSQL
- SQL Server Analysis Services
- Cognos
- Basic Python
Job Type: Contract
Salary: $60.00 - $65.00 per hour
Schedule:
Experience:
- SSRS: 10 years (Required)
- SSAS: 10 years (Required)
- Power BI: 10 years (Required)
- Power BI Reports Scheduler: 10 years (Required)
- Python: 8 years (Preferred)
- Cognos: 8 years (Preferred)
- Data modeling: 10 years (Preferred)
Ability to Commute:
- Pleasant Prairie, WI 53158 (Required)
Ability to Relocate:
- Pleasant Prairie, WI 53158: Relocate before starting work (Required)
Work Location: In person
Job tags
Salary