Ferruccio Guicciardi
@ferruccioguicciardi
Enterprise data engineer at Lisimad Consulting building contract-first ingestion workflows with Kafka, n8n, and FastAPI.
IrelandWhat I'm looking for
At Lisimad Consulting Ltd., I develop independent AI and data engineering projects that apply enterprise data practices to workflow orchestration, data contracts, validation, and AI-assisted operations. I built SIGMA-AETL, a documented reference implementation for contract-first data ingestion.
SIGMA-AETL uses Kafka for transport, n8n for orchestration, and FastAPI/Pydantic for deterministic validation. It stores valid and failed records separately in MongoDB, with idempotency controls and isolated failure handling to support replay and auditability.
I also developed Prompt Extractor for OCR, structured text processing, and MongoDB persistence, along with an OpenClaw-based multi-agent Forex research workflow. In SIGMA-AETL, optional local Ollama/Qwen diagnostics can explain validation failures, while AI remains advisory rather than determining correctness or routing.
Across roles in banking, investment banking, asset servicing, and insurance, I’ve worked on data integration, warehousing, modeling, reporting, and production operations. I bring a Specification-Driven Development practice to that work, translating requirements into explicit specifications, data contracts, and acceptance criteria.
Experience
Work history, roles, and key accomplishments
Independent AI and Data Engineering Projects
Lisimad Consulting Ltd.
Apr 2024 - Present (2 years 6 months)
Developing self-directed AI and data engineering portfolio projects, applying enterprise data practices to workflow orchestration, data contracts, validation, and AI-assisted operations. Built SIGMA-AETL as a documented reference implementation and developed an OpenClaw-based multi-agent Forex research workflow.
Worked on production financial systems using Python 3.12, MongoDB 5.0/MQL, Pydantic ODM, SQLAlchemy, GraphQL, and API-driven application workflows. Used SQL Server/T-SQL for queries, stored procedures, functions, and metadata analysis; supported validation, unit/mock testing, build manifests, and controlled deployment artifacts.
Senior Data Warehouse Engineer
KBC Bank Ireland
Apr 2022 - Sep 2023 (1 year 5 months)
Supported enterprise liquidity data models and ETL/pipeline operations using IBM InfoSphere DataStage, Stonebranch, Oracle PL/SQL, and SQL Server/T-SQL. Worked with Azure DevOps repositories, builds, pipelines, and releases; supported monitoring, alerts, ServiceNow/Jira, operational runbooks, and controlled banking releases.
Delivered Snowflake ingestion and transformation workflows for daily CSV/TXT feeds from AWS S3 and SFTP, using stages, streams, tasks, external tables, and SQL transformations. Worked across SQL Server, SSIS/SSAS/SSRS, dimensional modeling, Kimball-style reporting repositories, Tableau, and enterprise analytics access controls.
Built SQL Server/T-SQL and SSRS reporting repositories using Kimball methods for investment banking and asset-servicing data. Modeled complex data relationships and delivered compliance, asset-information, over-collateralization, interest-coverage, and hypothetical-trade reporting.
SQL Developer
Spencer Stuart
Jun 2019 - Feb 2020 (8 months)
Developed SQL Server/T-SQL and SSRS solutions, stored procedures, scripts, and data models; validated result sets, performed unit testing, and supported production data fixes.
Modeled Azure data warehouses using Kimball star schemas and built Azure Data Factory pipelines from Data Lake into Azure Analysis Services and the data warehouse; delivered Power BI dashboards and DAX measures.
Education
Degrees, certifications, and relevant coursework
Università Cattolica del Sacro Cuore
Postgraduate Studies, Logistics and Communications / Applications Development
2005 - 2005
Postgraduate studies in Logistics and Communications / Applications Development.
Universidad Interamericana de Costa Rica
Bachelor of Business Administration, Marketing and Finance
1989 - 1994
Bachelor of Business Administration with focus on Marketing and Finance.
Microsoft
Microsoft Certified Systems Engineer (MCSE), Systems Engineering
Microsoft Certified Systems Engineer (MCSE) certification.
n8n
n8n Basic Training - Certificate of Completion, Workflow Automation
Completed n8n Basic Training with Certificate of Completion on 11 September 2025.
Snowflake
Snowflake A-Z Zero to Hero Masterclass, Data Engineering
Completed Snowflake A-Z Zero to Hero Masterclass.
Availability
Location
IrelandAuthorized to work in
Salary expectations
Job categories
Interested in hiring Ferruccio?
You can contact Ferruccio and 90k+ other talented remote workers on Himalayas.
Message FerruccioGet matched with your dream remote job
Sign up now and join over 250,000+ remote workers who receive personalized job alerts, curated job matches, and more for free!
