Job Details
Experience Needed:
Career Level:
Education Level:
Salary:
Job Categories:
Skills And Tools:
Job Description
Job Summary
The Analyst is responsible to lead the design, development, and administration of enterprise BI platforms and data warehouses using Informatica and Tableau.
The role also involves handling regulatory data submissions, supporting data virtualization solutions, and ensuring data quality and performance across reporting systems.
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
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
The Analyst is responsible to lead the design, development, and administration of enterprise BI platforms and data warehouses using Informatica and Tableau.
The role also involves handling regulatory data submissions, supporting data virtualization solutions, and ensuring data quality and performance across reporting systems.
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
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
Job Requirements
Collaborate with business teams to gather requirements and deliver insights
Ensure QA/UAT processes and provide end-user training
Ensure QA/UAT processes and provide end-user training