Lead Sql Server

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 Faraaz@techstargroup.com 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:

• Monday to Friday

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