Freelancer profile translated to English.

Description

Analytics Engineer | Snowflake | dbt | SQL | Data Modeling

I help companies design, develop, and optimize data solutions using Snowflake and dbt.

I have experience in data integration and modeling projects related to procurement, suppliers, invoices, and accounting, working with different ERPs and analytical platforms.

Services

- dbt model development

- Data modeling (Facts, Dimensions, and Star Schema)

- SQL query optimization

- Development and maintenance in Snowflake

- Data integration from Oracle EBS and other ERPs

- ETL/ELT process design

- Technical and functional documentation

- Support in Analytics Engineering projects

Technologies

- Snowflake

- dbt

- SQL

- Git

- Oracle EBS

- Power BI

Specialization

- Procurement

- Accounting

- Data Warehousing

- Analytics Engineering

- ERP Integration

Languages

Spanish
Native or bilingual
English
Basic

Workplace preferences

Can work on-site

Cádiz (up to 50km)

Devoteam
ANALYTICS ENGINEER / SNOWFLAKE ADMIN
March 2026 - May 2026 (2 months)
Administration and evolution of enterprise Snowflake accounts for an insurance company. Administration of multiple Snowflake accounts. Security, roles, masking policies, and AES-256 encryption management with AWS Secrets Manager. Renewal and management of SCIM tokens and integration with corporate identity systems. Anomaly analysis in roles and accesses through queries on ACCOUNT_USAGE.
• ● Work with Openflow and Snowflake connections with external tools.
Stratesys
ANALYTICS ENGINEER
March 2023 - March 2026 (3 years)
Participation in analytical projects on Snowflake and dbt for Fluidra, a multinational company in the swimming pool sector. Project for the complete migration of legacy architecture (Informatica IICS) to dbt.
• ● Complete migration of 4 regions (NAM, EMEA, APAC, and Global) from Informatica IICS to dbt.
• ● Models on entities of up to 100 million records including data from SAP, AS400, M3, Oracle, and Epicor.
• ● Design and construction of dimensional models and fact tables for the Procurement domain (supplier purchases).
• ● Integration of purchasing data from multiple ERPs: SAP (GL Account, Supplier Invoice), M3, AS400, Epicor.
• ● Development of ELT transformations with complex business logic: deduplication, reconciliation, KPI calculation.
• ● Construction of stage, intermediate, and mart layers following the medallion architecture.
• ● Analysis and cost optimization on Snowflake ACCOUNT_USAGE.
• ● Technical and functional documentation of models and data processes.
• ● Integration and synchronization of data with Salesforce using Informatica IICS. Resolution of functional incidents and validation of data quality with the business.
Bosonit
BIG DATA DEVELOPER
April 2022 - March 2023 (11 months)
Document and approve the Snowflake Snow Pro Certification and carry out a POC for the creation of sales datamarts in Snowflake.