Key Skills: SSIS SSRS, Data Analyst, Data Analysis, Data Analytics
Roles and Responsibilities:
- Design, develop, and maintain ETL processes using SSIS and SSAS.
- Create and manage reports and dashboards using BI reporting tools such as SSRS, Tableau, and Power BI.
- Perform database performance tuning and optimization using TSQL and stored procedures.
- Collaborate with stakeholders to understand business requirements and translate them into technical specifications.
- Develop and maintain data models and dimensional models to support analytical needs.
- Ensure data quality and integrity throughout the data lifecycle.
- Provide insights and recommendations based on data analysis to drive business performance.
Skills Required:
- Strong hands-on experience with SSIS and SSRS
- Working knowledge of data modeling, ETL, and OLAP concepts
- Familiarity with reporting tools such as Tableau and Power BI
- Proficiency in TSQL, stored procedures, and performance tuning
- Good understanding of data analytics and ability to derive actionable insights
Education: Bachelor's degree in Computer Science or equivalent