Episode Summary I’m incredibly excited to have Ilya back for the Season 1 finale. He was my very first guest in the pilot episode, and honestly, he helped me figure out this format - what works, what doesn’t, how to make the collaborative problem-solving feel authentic. So it felt only right to close this season by bringing him back full circle. In this finale, we tackle a frustratingly common scenario: a marketing stakeholder needs data from a new platform for critical quarterly forecasting, but the data team estimates four months to build the connector. Meanwhile, two hours disappear every morning into manual CSV downloads, cleanups, and copy-paste operations, a process that’s already caused a 50% error in pipeline analysis. What seems like a technical integration problem quickly reveals itself as something much deeper: an organizational breakdown in ownership, communication, and mutual understanding between business stakeholders and data teams. And true to form, Ilya immediately zeroes in on the people side of things. Problem Category: Data Integration & ETLRuntime: 40 minutes The Problem Submitted by: Anonymous Marketing ProfessionalIndustry Context: Company with established data infrastructure and quarterly business planning cycles Problem Framework Issue: Need data from the new marketing automation platform for quarterly forecasting, but building a connector will take four months, according to the data team. Currently manually downloading CSV files daily. Trigger: Quarterly planning cycle starts in 8 weeks. Currently spending 120 minutes every morning downloading, cleaning, and manually importing marketing data files. Last week, a copy-paste error threw off pipeline analysis by 50% - only caught because the numbers seemed unrealistic. Tension: The data team focuses on building robust, enterprise-grade connectors that take months to develop properly. While understanding their approach, there’s an immediate business need that can’t wait for the perfect solution. The manual process is unsustainable and risky, but the data is critical for business planning. Boundaries: * Cannot change the quarterly planning timeline (set by business cycle) * The marketing platform was selected by leadership and cannot be changed * The data team has limited capacity and other priorities * A budget exists for reasonable interim solutions * Must maintain data quality standards for forecasting accuracy Tech Stack: New marketing automation platform with CSV export capability, central data warehouse for forecasting (specific tools not disclosed) Clarity Statement: Need an interim solution to get marketing platform data into the data warehouse reliably within the next 8 weeks, without waiting for the full enterprise connector that will take 4 months. Our Guest IlyaFractional Head of Data & Data Leadership Consultant Ilya brings over 15 years of data experience, having led data functions at companies like Ada Health (symptom checker app), and various startups and scale-ups across Berlin and Munich. Originally from Moscow with a background in computational mathematics, he moved to Germany in 2002 and transitioned from database research to hands-on data engineering and leadership roles. After the biotech winter impacted Ada Health, Ilya pivoted to fractional and interim data leadership, helping companies build data platforms and teams across different domains and stages. Special Note: Ilya was our very first guest in the pilot episode and returns to close out Season 1, bringing his people-first philosophy full circle. Connect with Ilya: * LinkedIn: https://www.linkedin.com/in/bkmy43/ * YouTube: https://www.youtube.com/@lab4.berlin (Data leadership discussions while smoking pipes - yes, really, and it’s worth checking out) * Website: https://www.lab4.berlin/ The Breakthrough Discussion Initial Reactions Ilya and I immediately recognized this as a people problem disguised as a technical problem. As Ilya put it: “From most failing projects and situations like this, I rarely saw the root cause was technology or tools.” The four-month estimate raised red flags for both of us. As Ilya observed, connecting to an API of an existing marketing tool shouldn’t take four months - what’s likely happening is that “building a connector” actually means the entire pipeline: getting the data, integrating it into the company data model, and delivering it through BI tools with proper business logic. The Real Problem Through the reflection break and collaborative discussion, we identified the core issues: * Communication Breakdown: The data team likely down-prioritized this request because other initiatives have a higher business impact, but they haven’t articulated this clearly. The stakeholder hears “four months” without understanding what’s blocking it. * Ownership Confusion: It’s unclear who owns the decision about prioritization and tradeoffs. Without clear ownership, every request becomes a negotiation rather than a strategic decision. * Missing Context: The data team probably doesn’t understand the business impact of the delay (corrupted forecasts, wasted ad spend, strategic planning delays). The stakeholder doesn’t understand what the data team is actually building and why it takes time. * Us vs Them Dynamic: The situation has devolved into adversarial positioning - “the data team won’t help me” versus “stakeholders want everything immediately” - rather than collaborative problem-solving. The Solution Approach Rather than a single technical fix, our discussion produced a multi-layered solution: Immediate Relief (Week 1-2): Ask one of the engineers to build a simple Python script or similar automation. This doesn’t need to be production-grade infrastructure - just something that reliably pulls the CSV, does basic transformation, and loads it into the warehouse. This can be a 2-3 day task rather than a 4-month project. Transparency & Context (Week 2-3): Create a visible initiative backlog overview showing everything the data team is working on. When someone says “it will take four months,” they should be able to show exactly what’s blocking it and why those other priorities matter more. This isn’t about justifying delays - it’s about enabling informed decisions. Rational Decision Framework (Week 3-4): Develop a structured way to articulate both the cost of building solutions and the business impact of delays. Put numbers on the table: What does two hours of manual work daily cost? What’s the risk value of potential forecast errors? What’s the opportunity cost of the data team working on this versus their current priorities? Strategic Alignment (Ongoing): Establish clear ownership and a prioritization process that considers both technical complexity and business impact. This isn’t about the data team gatekeeping or stakeholders demanding - it’s about having a framework where tradeoffs are visible and decisions are rational. Key Takeaways 3 Critical Insights * This is an Organizational Problem, Not a Technical One: The four-month timeline isn’t about technical complexity - it’s about priorities, communication, and organizational dynamics. The actual technical work of connecting to an API could be done much faster if approached as a quick automation rather than an enterprise-grade infrastructure. * The “Us vs Them” Dynamic Is Killing Efficiency: When stakeholders and data teams position themselves as adversaries rather than collaborators, every interaction becomes a negotiation. The marketing person sees the data team as obstructionist; the data team sees stakeholders as demanding and unrealistic. Neither side wins in this dynamic, and the business suffers. * Ownership Clarity Is Essential: Without clear ownership of prioritization decisions, every data request becomes contested territory. Someone needs to own the decision about whether a four-month wait is acceptable given the business impact, and that person needs visibility into both the technical constraints and business consequences. 4 Action Items For the Problem Submitter (and anyone in similar situations): * Request a Quick Automation Script (This Week) - Ask a data engineer to build a simple Python script or similar automation that pulls the CSV, does basic transformation, and loads it into your warehouse. Make it clear this doesn’t need to be production-grade infrastructure - just something reliable enough to bridge the gap. Timeline: 2-3 days of engineering time. * Create Initiative Backlog Visibility (Week 2) - Work with the data team to create a visible overview of all current initiatives. When told something will take four months, you should understand what’s blocking it and why those priorities were chosen. This isn’t about challenging their decisions - it’s about having context for informed discussion. * Articulate Cost and Impact With Numbers (Week 3) - Document the actual business impact: two hours daily of manual work (cost it out by salary), risk of forecast errors (quantify the potential impact), strategic planning delays (what decisions are being made without this data?). Similarly, ask the data team to articulate what they’d need to deprioritize to tackle this sooner. * Establish Ongoing Prioritization Framework (Week 4+) - Work with leadership to create a clear process for prioritizing data work that considers both technical complexity and business impact. Identify who owns these decisions and ensure they have visibility into both technical constraints and business consequences. This prevents future “four months” surprises. Episode Highlights * 02:00 - Problem reveal: Four months for a marketing platform connector * 06:30 - Ilya’s immediate diagnosis: “This is a people problem, not a technical one” * 14:45 - Post-reflection discussion: Unpacking the communication breakdown * 24:30 - The ownership question: Who actually decides priorities? * 31:00 - Quick wins vs long-term solutions
