Davide Moraschi
Senior Data Architect/Engineer
Experience
Senior Data Architect/Engineer
Straumann Group
- Data architect to design, create, and monitor pipelines for the marketing intelligence unit.
- Maintain legacy ETL and new data pipelines using AWS AppFlow, Step Functions, Athena, Snowflake.
- Deploy infrastructure as code with Terraform.
- Monitor pipeline metrics and implement DevOps practices with AWS CodeCommit.
Data Flow Architect
Sanofi
- Gathered functional requirements from different business units and designed data flows and documentation in Jira.
- Defined data flow methodologies, tools, techniques, and deliverables.
- Performed functional design with stakeholders, capturing business requirements and creating data deliverables.
- Developed logical and physical data models and implemented data governance.
- Ensured proper implementation of Data Excellence guidelines and monitoring of metadata and KPIs.
- Developed supply chain management indicators including delivery on time/in-full and shipment monitoring.
Senior Data Engineer
Pfizer - PGS Operations Insights
- Rebuilt Python pipeline introducing CI/CD tools and a DataOps mindset for supply chain insights.
- Migrated application database from on-premises Linux to Kubernetes on AWS, reducing load times by 50% and adding exception handling, monitoring, and logging.
- Migrated all SQL and job scripts from Redshift to Snowflake, reducing database size, backup times, and network costs.
- Mentored colleagues on best practices in big data and infrastructure.
Data Lead and Architect
Yara International
- Led a team of 8 to audit, review, and document existing data infrastructure.
- Proposed and bootstrapped a plan to increase efficiency and reduce costs.
- Introduced a ticketing system for request and issue accountability.
- Streamlined relationships with other departments and helped stakeholders define enterprise-wide KPIs.
- Automated and debugged AWS Glue pipelines, reducing day-to-day operations and adding monitoring and logging.
- Cleaned up redundant and obsolete pipelines.
Azure Data Engineer
Caterpillar
- Built a new version of a legacy system to store, retrieve, and update data about products, bills of materials, and services.
- Tuned database design and processes to move data from the legacy system to Azure Cloud using Azure SQL change tracking and incremental load.
- Added DevOps and DataOps as standard procedures for database deployment.
- Optimized application performance by rewriting SQL queries and proposing plans to resolve data problems and save cloud costs.
DBA, Backend Developer
MERGE (BEAM Interactive)
- Developed SQL and JSON backend for CustomEyes Configurator, a sales automation tool that won a 2020 award.
- Used T-SQL stored procedures and system-versioned tables to support disconnected and connected mode data sync.
- Designed, optimized, and monitored Azure SQL data models.
- Introduced DataOps procedures and standards.
SQL Database Expert
Equature (DSS Corporation)
- Overhauled dynamically generated database to improve speed and accessibility for ingestion and content delivery platforms.
- Streamlined solution to segregate capture data from static data.
- Optimized hardware, operating system, and database layers to achieve sub-second response.
- Performed SQL Server DBA tasks and query optimization.
Data Engineer, Data Analyst
COTY
- Migrated accounting and financial reports from SAP BW to MicroStrategy, including data modeling, semantic layer, and dashboard creation.
- Developed advanced KPIs for accounts payable, accounts receivable, and supply chain.
- Coordinated external database stakeholders and designers across different time zones.
- Translated stakeholder requirements into reliable, actionable insights.
Data Architect, Engineer, Analyst
AGQ LABS
- Gathered requirements, analyzed, and developed data analysis projects supporting logistics, production, and financial departments with data modeling, ETL, and training.
- Maintained existing BI stack on MS SQL Server.
- Performed DBA tasks and optimization.
- Worked with SSIS and MicroStrategy.
Author
PACKT Publishing
- Managed book development from concept through writing, proofreading, and release.
- Created additional materials including videos and examples.
- Coordinated with PACKT editor team in Asia to release the book ahead of schedule.
- Covered data warehouse, data modeling, SQL Server, and advanced analytics in MicroStrategy.
Database Developer, Programmer
INyDIA
- Automated integration of multiple diagnostic appliances with the Xiril Workstation (thermoshaker, barcode scanner, etc.).
- Conceived and developed a database for unified sample reporting based on MS Access and XML/XSLT.
- Developed an application in C++ for motor driver management and integrations in C#.
Database Specialist Business Intelligence Architect
Public Health Services of Andalucía
- Designed and created an MVP for a hospital data analysis application and infrastructure based on MicroStrategy and SharePoint with SSO and privacy compliance.
- Integrated departmental pipelines with the Hospital Information System using HL7.
- Implemented microservices architecture and API and streams integration.
- Automated database maintenance using T-SQL and PowerShell and managed Bitbucket source code repository.
Industries Experience
See where this freelancer has spent most of their professional time. Longer bars indicate deeper hands-on experience, while shorter ones reflect targeted or project-based work.
Experienced in Healthcare (8 years), Government and Administration (6 years), Agriculture (3 years), Information Technology (3 years), Pharmaceutical (2 years), and Manufacturing (2 years).
Business Areas Experience
The graph below provides a cumulative view of the freelancer's experience across multiple business areas, calculated from completed and active engagements. It highlights the areas where the freelancer has most frequently contributed to planning, execution, and delivery of business outcomes.
Experienced in Information Technology (16 years), Business Intelligence (15 years), Product Development (7 years), Supply Chain Management (3 years), Operations (3 years), and Finance (3 years).
Summary
Author of the book “Business Intelligence with MicroStrategy”
Worked for years in Fortune companies designing and maintaining scalable data infrastructures based on Azure and Amazon Web Services. Completed successfully on-premises cloud migrations including ETL pipelines. DataOps approach to database development. 15+ years of experience with SQL technologies. 5+ years DevOps tools and Agile projects. 5+ CI/CD tools experience (GitHub, Azure DevOps, Terraform).
Skills
- Learning Ability
- Curiosity
- Resilience
- Adaptability
Languages
Certifications & licenses
Microsoft Cert if ied Azure Data Engineer
Microsoft
Profile
Frequently asked questions
Do you have questions? Here you can find further information.
Where is Davide based?
What languages does Davide speak?
How many years of experience does Davide have?
What roles would Davide be best suited for?
What is Davide's latest experience?
What companies has Davide worked for in recent years?
Which industries is Davide most experienced in?
Which business areas is Davide most experienced in?
Which industries has Davide worked in recently?
Which business areas has Davide worked in recently?
Does Davide have any certificates?
What is the availability of Davide?
What is the rate of Davide?
How to hire Davide?
Average rates for similar positions
Rates are based on recent contracts and do not include FRATCH margin.
Similar Freelancers
Discover other experts with similar qualifications and experience
Experts recently working on similar projects
Freelancers with hands-on experience in comparable project as a Senior Data Architect/Engineer
Nearby freelancers
Professionals working in or nearby Seville, Spain