Role: SQL/SSRS
Location: Bangalore / Mumbai
Department: Technology
Vacancy Type: Permanent
Job Shift: 12PM IST – 9PM IST
Mode: Hybrid
Experience Range: 6 years
Role Responsibilities:
The candidate will be responsible for designing, developing & maintaining interactive dashboards / reports using SQL & SSRS. Create, develop, and test reports and dashboards, utilizing functional knowledge and SQL Query transformations, as well as complex reports using advanced SQL queries and SSRS expressions. Use Power BI Service to publish reports, manage workspaces, and set up sharing permissions, and use SSRS server to deploy reports, manage subscriptions, and monitor report performance. Role will also cover aspects of data integration, performance optimization, and required security measures to ensure efficient and secure access to reports.
Some of the things you will be doing:
• SSRS Report Development:
Design, develop, and deploy SSRS reports to meet business needs.
Maintain and enhance existing SSRS reports, ensuring data accuracy and relevance.
Work with stakeholders to gather requirements and translate them into technical specifications.
• SQL Database Management:
Write, optimize, and troubleshoot complex SQL queries and stored procedures.
Perform data extraction, transformation, and loading (ETL) processes.
Ensure data integrity and security within the database environment.
Assist with database design, normalization, and optimization.
• Collaboration and Communication:
Work closely with MFs and other team members to understand business requirements and deliver high-quality solutions.
Provide training and support to the team members along with MF POCs on Power BI and SSRS report
What technical skills, experience, and qualifications do you need?
- Minimum 6 years of experience in fields of data analysis and reporting.
- Bachelor's degree in computer science and/or demonstrable experience in a similar role for a global organization.
- Proven experience in developing SSRS/PowerBI reports and handling various data integration scenarios.
- Previous work in business intelligence, data analysis, or IT support is desirable.
- Ability to diagnose complex data issues and implement effective solutions to optimize report performance.
- Excellent verbal and written communication skills to interact with clients, explain technical concepts clearly, and provide training and support.
- Commitment to ethical practices and maintaining the confidentiality of sensitive data.
- Capacity to handle various data sources and adapt to new reporting techniques as technology evolves.
- Capable of prioritizing tasks and meeting deadlines in a fast-paced environment.
- Expert knowledge of Power BI and SSRS technologies and their application to a global organization such as Deloitte.
- Proven ability to develop strategy and work across stakeholders to gain consensus.
Preferred:
- Prior experiences in same-level companies or expertise in specific industry.
- Knowledge of SSRS integration with SharePoint and other enterprise platforms.
- Experience in developing custom visuals for Power BI and custom extensions for SSRS.
