Business Analyst Oracle SQL, ETL, BPM

Toronto - Canada

Monthly Salary: Not Disclosed

Experience Required: 5years

Posted on: 30+ days ago

Vacancies: 1 Vacancy

Job Summary

Exp Required: 8
Business Analyst

Skills Required: ORACLE SQL Business Process Management (BPM)

Job Description:

Expertly navigate the data landscape modeling robust solutions for seamless data integration management and security throughout the lifecycle while adeptly managing data systems with precision and expertise.
Develop multiple dashboards to precisely illustrate data movement in different pipelines highlighting synchronization discrepancies. Conduct thorough data analysis Root Cause Analysis (RCA) for data inconsistencies and demonstrate expertise in various ETL concepts including all types of Slowly Changing Dimensions (SCD) Facts and Dimension tables Change Data Capture (CDC) structured and unstructured data Partitions as well as proficient on Star and Snow-flake Schemas. Proficient in crafting intricate SQL queries and developing multiple automation scripts to streamline and minimize testing efforts significantly.
Quick learner with strong problem-solving and analytical abilities.
Work on data migration and conversion projects fostering collaboration with di-verse stakeholders and coordinating seamlessly between business and technical teams to ensure the smooth migration of customer data.
Devise immediate and practical remedies to unforeseen chal-lenges on data integrity allowing smooth functioning of the Data system.
Creatively bridge func-tionaldata gaps by comprehending the intricacies of the current data flow and strategically leveraging it to ensure data completeness.
Supervise and guide Data Analysts and Quality Assurance profession-als conducted thorough analysis of user needs project estimation and delivered comprehensive framework training.
Produce detailed reports utilizing SSRS reporting tool Tableau and MS-Excel in-strumental in informing crucial business decisions. Collaborate with Business stakeholders and Sub-ject Matter Experts (SMEs) to establish comprehensive Data Governance procedures.
Create artifacts such as Requirement Document Data Model Mapping Document SES and Dashboards for Data Quality.
Collaborate with multiple teams to perform end to end SDLC from Requirement gathering Designing Development Testing and maintenance.
ETL concepts SSRS reporting tool Tableau and MS-Excel Requirement Document Data Model Mapping Document SES and Dashboards for Data Quality