Isabel Mateus
Business Intelligence Consultant @Scalefree
Signup · Get unlimited contacts
WORK HISTORY
Business Intelligence Consultant @Scalefree
Current Project: Regulatory Reporting Logic migration from SQL Server Management Studio to Snowflake (banking sector)- Implementation of Information Marts in dbt, materialized in Snowflake database, resulting in power bi dashboards or excel exports- Replication in SQL language of business logic in the form of stored procedures, dynamic SQL and views to dbt models- Creation of dimensional models using both Flat wide tables and data vault entities as sources.Tool stack: Dbt, Snowflake, SQL Server Management StudioPrevious Project: MDH migration from IBM Db2 to Snowflake (insurance sector)- Implementation of a new MDH (Master Data Hub) in Data Vault architecture composed of three layers: data quality, master data hub and golden record. To not only ensure data quality but also enable the determination of a Golden Record for customers coming from several source systemsReplication of Data Quality operations and business rules in Informatica to SQL logic applied to business vault entities- Rewiring of dashboards to the new MDH-DV solution, validations and analysis of differences by source system between the old and new MDH solution- Integration, Standardization and deduplication of records through the Golden Record led to the single version of truthTool stack: Snowflake, Informatica Developer, Wherescape, IBM DB2
EDUCATION
NOVA IMS Information Management School
Master's degree, Information Management with Specialization in Knowledge Management and Business Intelligence
Escola Superior Náutica Infante D. Henrique
Bachelor's degree, Port Management
ABOUT ISABEL MATEUS
A data-driven individual always keen for a new challenge. I love stepping outside of my comfort zone and learning something new. Passionate about data quality. Dbt and snowflake are my sweet spot.Currently, I am working as a Business Intelligence Consultant in Scalefree.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.