D
Diego de Jesus Ortega Manriquez
About
Detail
Mexico City, Mexico
Contact Diego regarding:
groups
Networking
Résumé
Jobs
verified_user
0% verified
- JInvestment Analytics ManagerJellyfish,Apr 2025 - Current (1 year 7 months)• Project Leadership & Solution Design - Led complex analytics projects, translating business objectives into measurement frameworks for iterative improvements to client marketing programs. • Client Engagement & Advisor - Served as a trusted advisor, simplifying complex statistical findings for executive-level decision-making and driving project ROI. • Technical Configuration - Maintained data warehouse architecture, optimizing scripts Python/SQL for configuring and scaling analytical solutions, demonstrating a strong technical background in cloud data management.
- JAnalytics ManagerJellyfish,Feb 2021 - Apr 2025 (4 years 3 months)• Implementation Leadership - Managed the complete lifecycle of data optimization projects, ensuring data integrity and achieving a significant improvement in data accuracy (e.g., managing the viability for the MMM Meridian data).
• System Orchestration - Oversaw data pipeline management to integrate and synchronize information between cloud systems analytics platforms, CRMs, CDPs, and ad servers.
• Client Training & Workshop - Serve as a Subject Matter Expert, leading advanced technical workshops - BigQuery, Google Analytics, Firebase - to foster platform adoption and client capability. Additionally, I guided clients in optimizing their media strategies, particularly for Meta platforms, Google Ads, YouTube Ads, and LinkedI - HTechnical Account ManagerHexagon Data,Jan 2019 - Feb 2021 (2 years 2 months)• Solution Design & Configuration - Configured and optimized data integration between systems, leveraging technical expertise to orchestrate client data flow. • Client Technical Advisory - Provided technical documentation and strategic guidance to clients for solution implementation and monitoring, serving as the primary technical point of contact during onboarding. • Requirements Gathering & Problem Solving - Conducted detailed requirements analysis and diagnostics of client environments and internal platforms to identify and resolve data flow issues, ensuring successful implementation. Additionally, utilized knowledge of digital advertising and platforms such as Facebook Ads and Meta Ads Manager to enhance API-based integration of medi
Education
verified_user
0% verified
Associate Data AnalystDataCampOct 2025 - Current (1 year 1 month)- Google Cloud Certified - Professional Data EngineerGoogleJun 2025 - Current (1 year 5 months)
- MBootcamp Full-Stack Web Development in JavaScriptMUKTEKOct 2018 - Current (8 years 1 month)
- BAUniversidad de SonoraOct 2013 - Current (13 years 1 month)
Projects (professional or personal)
verified_user
0% verified
- Dynamic Data Governance & LookML SecurityJellyfishJun 2025 - Jul 2025 (2 months)• Analytical Solution Development: Designed and implemented a dynamic access control solution in Looker for a financial services client with high-volume transaction data.
• Problem Solving & Scalability: Overcame production issues by creating flexible logic to filter user data using a specific API-based ID, enabling a single dashboard to serve all institutional clients.
• Quantitative Objectives: Simplified administration and ensured long-term adoption by designing a solution that scales for new clients without requiring model updates. Additionally, I ensured the successful export of ads data and attribution information from GA4 to BigQuery, which enhanced our data governance framework and provided valuable insights for fut - Marketing Mix Model (MMM) Viability and Statistical ConsultingJellyfishApr 2025 - Current (1 year 7 months)• Statistical Analysis & Viability: Led technical assessment, providing Campaign granularity non-viable for prediction due to temporal limitations.
• Recommendation: Proposed Strategy level grouping as the pragmatic solution for model convergence and forecasting-phase predictiveness.
• Data integrity & Significance: Flagged critical data gaps and explained how this compromises model effectiveness.
• Leveraged experience in processing data for Marketing Mix Models using the Meridian framework, which involved integrating online and offline data sources. This included a focus on analyzing online spend metrics from various platforms, such as Meta, Google Ads, Pinterest, LinkedIn, and YouTube, enhancing the overall effec - Data Architecture and Optimization BigQuery-SnowflakeJellyfishNov 2024 - Dec 2024 (2 months)• Data Architecture Deep Dive: Built a business case to maintain the GA4-BQ raw data pipeline over a direct Snowflake connector, preventing dashboard fragmentation. Justified GA4-BQ by explaining its raw data schema is distinct from the GA4 API model used by Snowflake. • Marketing Program Optimization: Developed a BQ cost optimization strategy (partitioning, archiving) and proposed a Looker Dashboard to monitor consumption and align costs revenue KPIs. Additionally, ensured the successful export of ads data and attribution information from GA4 to BigQuery and subsequently to Snowflake, which enhanced the overall data integrity and reporting capabilities within the marketing programs.