Key Responsibilities:
- SQL Development:
- Write and optimize complex SQL queries to extract and manipulate data from multiple databases.
- Create, modify, and maintain stored procedures, views, and functions.
- Perform database performance tuning and optimization.
- Analyse data requirements and design appropriate database structures.
- SSRS Development:
- Design, develop, and maintain reports using SQL Server Reporting Services (SSRS).
- Create and deploy interactive, drill-down, and parameterized reports.
- Collaborate with business users to gather and define reporting requirements.
- Maintain and troubleshoot existing SSRS reports for enhancements or bug fixes.
- Data Management:
- Extract, transform, and load (ETL) data from different sources to the SQL Server database.
- Ensure data integrity and accuracy by implementing data validation rules.
- Collaboration & Support:
- Work closely with business analysts and stakeholders to understand reporting needs.
- Provide technical support and troubleshoot database-related issues.
- Document all processes, queries, and reports for future reference.
Key Skills and Qualifications:
- Technical Skills:
- Proficiency in SQL Server, including T-SQL (Transact-SQL).
- Strong experience in developing reports using SQL Server Reporting Services (SSRS).
- Experience with database design and management, including normalization, indexing, and performance tuning.
- Hands-on experience with ETL processes.
- Familiarity with other BI tools (Power BI, Tableau, etc.) is a plus.
- Other Qualifications:
- Bachelor's degree in Computer Science, Information Systems, or a related field.
- 3-5 years of experience in SQL development and SSRS report writing.
- Strong problem-solving and analytical skills.
- Ability to work independently as well as collaboratively within a team environment.
- Strong verbal and written communication skills.
Preferred Qualifications:
- Knowledge of SQL Server Integration Services (SSIS) for ETL processes.
- Experience with SQL Server Analysis Services (SSAS).
- Familiarity with data warehousing concepts and architecture.
- Experience in Agile or Scrum development environments.
