Key Responsibilities:
Write and optimize complex SQL queries for data extraction, transformation, and reporting.
Develop, maintain, and enhance SSRS reports based on business requirements.
Develop, maintain, and enhance BI reports based on business requirements.
Collaborate with business users to understand reporting needs and translate them into technical solutions.
Ensure data accuracy, consistency, and performance across reports and queries.
Troubleshoot and resolve issues related to SQL queries and SSRS reports.
Perform data validation and quality checks to ensure reliable reporting outputs.
Support ad hoc reporting requests and provide insights through data analysis.
Co-ordinating with Oracle team to move financials from ticketing systems to oracle.
Required Skills and Qualifications:
Proficiency in writing complex SQL queries for data analysis and reporting.
Hands-on experience in developing and managing reports using SSRS and Power BI.
Strong understanding of relational databases (e.g., SQL Server, Oracle).
Ability to translate business requirements into technical report designs.
Excellent problem-solving skills and attention to detail.
Good communication and collaboration abilities.
Knowledge of PowerBI
Qualifications:
Experience with ETL processes and data warehousing concepts.
Familiarity with Agile project methodologies.