MS SQL Technical Specialist

Job Summary

Contribute to the design, development, and maintenance of data integration solutions using Microsoft SSIS and SQL Server Reporting (SSRS). The Technical Specialist will be responsible for ensuring the data flow and reporting mechanisms are efficient, accurate, and meet the business requirements.

Key Responsibilities

1. Develop and implement etl processes using microsoft ssis to extract, transform, and load data from various sources into sql server databases.

2. Create and maintain reports using sql server reporting services (ssrs) to visualize data and provide meaningful insights to stakeholders.

3. Collaborate with cross functional teams to understand data requirements and translate them into technical solutions.

4. Monitor and optimize data integration jobs and reporting performance to ensure smooth operations.

5. Troubleshoot and resolve any issues related to data integration processes or reports.

6. Ensure data security and integrity throughout all data integration and reporting processes.

Skill Requirements

1. Proficient in microsoft sql server integration services (ssis) for designing and implementing etl processes.

2. Strong knowledge of sql server reporting services (ssrs) for creating and managing reports.

3. Experience with microsoft sql server and transact sql for data manipulation and querying.

4. Ability to analyze complex data sets and design efficient data flow processes.

5. Strong problem-solving skills and attention to detail.

6. Excellent communication and teamwork abilities to collaborate with various stakeholders.

Other Requirements

1.Microsoft Certified Solutions Developer (MCSD) certification is preferred but not mandatory required.