Job Description
- 6+ years experience with T-SQL and SQL Server (SSIS and SSRS)
- Proficient with Tableau, preferably 4+ years creating dashboards
- Experience working with businesses and delivering dashboards
- Experience in Data Warehouse architecture
- Exposure to Microsoft BI
Project description
You will be working in a cutting edge, banking environment which is now ongoing thorough upgrade program. You will be responsible for translating business data and overall data into reusable and adjustable dashboards used by senior business managers.
Responsibilities
Design and develop complex T-SQL queries and stored procedures for data extraction, transformation, and reporting.
Build and manage ETL workflows using SSIS to support data integration across multiple sources.
Create interactive dashboards and reports using Tableau and SSRS for business performance monitoring.
Develop and maintain OLAP cubes using SSAS for multidimensional data analysis.
Collaborate with business and data teams to understand reporting requirements and deliver scalable BI solutions.
Apply strong data warehouse architecture and modeling concepts to build efficient data storage and retrieval systems.
Perform performance tuning and query optimization for large datasets and improve system responsiveness.
Ensure data quality, consistency, and integrity through robust validation and testing processes.
Maintain documentation for data pipelines, ETL jobs, and reporting structures.
Stay updated with emerging Microsoft BI technologies and best practices to continuously improve solutions.
Skills
Must have
At least 6 years of experience with T-SQL and SQL Server (SSIS and SSRS exposure is a must.
Proficient with Tableau, preferably with at least 4 years of experience creating dashboards.
Experience working with businesses and delivering dashboards to senior management.
Working within Data Warehouse architecture experience is a must.
Exposure to Microsoft BI.
Nice to have
N/A
Other
Languages
English: C1 Advanced
Seniority
Senior
