Location
Pleasant Prairie, WI | United States
Job description
Title: Lead SQL BI Reporting
Location: Pleasant Prairie, Wisconsin / Onsite
Interview: Second round IN person only
Duration: Long Term
Job Description:
- Strong experience in architecting SSRS, SSAS and Power BI based solutions.
- Having strong hands-on experience in SSRS,SSAS and Power BI report development & Support.
- 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
Please share resumes to Abdul @ techstargroup.com
Report this job
- Dice Id: 91123676
- Position Id: 2024-8688
Job tags
Salary
