Senior Business Intelligence Analyst

Industry: Banking / Financial Services

Experience: 8+ years

We are seeking an experienced Senior Business Intelligence Analyst to join our team and lead the design, development, and administration of enterprise BI platforms and data warehouses. The ideal candidate will have strong expertise in Informatica PowerCenter and Tableau, along with solid knowledge of data warehousing, data modelling, and SQL.

Key Responsibilities

• Designing and developing Informatica workflows for enterprise system(s), deployment of Informatica to production environment, and writing scripts to manage/move/schedule files in accordance to Informatica integration
• Create and maintain Tableau dashboards and reports based on business requirements.
• Support and troubleshoot existing Tableau reports and BI solutions.
• Handle data extraction and submission for regulatory bodies (CB, AECB).
• SQL experience, ability to develop, modify, troubleshoot and optimize complex queries and stored procedures.
•  Deep understanding of relational/dimensional data modelling and data mapping design, integration, migration and warehousing.
• Lead BI solution design and dashboard development (Tableau)
• Manage and maintain BI servers and enterprise data warehouses
• Perform data exploration and ad-hoc SQL reporting
• Collaborate with business teams to gather requirements and deliver insights
• Ensure QA/UAT processes and provide end-user training
• Troubleshoot BI issues and implement fixes

Required Skills

• Expertise in Tableau for BI reporting and dashboard creation and Tableau server administration.
• Strong proficiency in ETL development using Informatica PowerCenter.
• Solid understanding of data warehousing, data modeling, and SQL.
• Experience with data virtualization tools.
• Familiarity with regulatory reporting processes and data submission protocols.
• Strong analytical and troubleshooting skills.
• Excellent communication and documentation abilities.

Preferred Experience

• Bachelor’s or Master’s degree in IT, Computer Engineering, or a related field.
• 8+ years of hands-on experience in data warehousing, and BI reporting.
• Strong SQL development and data modeling experience

 Nice-to-Have:

• Python scripting
• Customer profiling & MDM experience