27 oct
|
Lever
|
Juan José Castelli
27 oct
Lever
Juan José Castelli
BigQueryData Engineer (Marketing-oriented) | Remote for Marketing Agency for EducationOur client is a fast-growing performance marketing agency specializing in mission-driven organizations across higher education and nonprofit sectors.
Since launching in ****, the agency has built a strong reputation for combining strategic thinking, creative execution, and data-driven marketing to help universities and organizations achieve measurable growth.Company Overview:Our client is a fast-growing performance marketing agency specializing in mission-driven organizations across higher education and nonprofit sectors.
Since launching in ****, the agency has built a strong reputation for combining strategic thinking, creative execution, and data-driven marketing to help universities and organizations achieve measurable growth.Your Role:The Senior Data Engineer sits at the center of the agency's Data and Analytics function, connecting every paid media platform and CRM the agency touches into a single, reliable source of truth.
You'll own the full path data takes: from a client's ad accounts and CRM, through Adverity, into a BigQuery warehouse, through modular dbt/Dataform transformations, and out to the Looker Studio dashboards and automated Google Sheets reports the team and its partners rely on daily.
Reporting to the Data and Analytics Manager, you're joining at a pivotal moment — the agency is scaling its roster of education and nonprofit partners, and this role is instrumental in evolving the automated reporting suite that makes that growth possible without sacrificing data quality or client trust.You'll:Own data ingestion & pipeline architecture — connect and maintain API pipelines from paid media platforms (Meta, Google Ads, LinkedIn, TikTok, programmatic) into Adverity, build custom Python connectors for anything not natively supported, and architect scalable pipelines from source system through to dashboardOwn CRM integration — build and maintain reliable CRM data connections (Slate, Salesforce, HubSpot) so lead and enrollment data flows cleanly into the warehouseOwn the data warehouse — route, optimize, and store raw and processed data in Google BigQuery; design efficient schemas for complex, multi-source marketing data (granularity, normalization, slowly changing dimensions); manage partitioning, clustering, and storage strategy to control query cost and performanceOwn transformation & mapping — build SQL schemas that map, blend, and organize multi-channel data accurately for each client, in modular, version-controlled, documented dbt or Dataform pipelines, with standardized naming conventions and metric definitions across platforms and clientsOwn CI/CD & data segregation — maintain CI/CD pipelines (GitHub Actions, automated testing) for robust, version-controlled releases, and enforce strict data segregation across multi-client environmentsEnable the reporting layer — create clean, performant data views built specifically for fast Looker Studio dashboards and automated Google Sheets reports, and partner with the Data and Analytics Manager and client teams to translate reporting requirements into warehouse modelsDrive data quality — monitor pipeline health, resolve API breaks, minimize latency, implement validation frameworks and automated testing, troubleshoot discrepancies to root cause across source/warehouse/BI layers, and proactively flag data quality risks to leadershipYou Bring:5+ years of hands‐on data engineering experience, ideally in a marketing or agency environmentStrong experience configuring datastreams, transformations, and destinations in Adverity or a comparable ETL platform (Fivetran, Supermetrics, Funnel)Intermediate to advanced SQL, with proven BigQuery experience in transformation, partitioning, and modelingExpertise in dbt or Dataform, managing modular, version‐controlled, documented SQL transformation pipelinesPython proficiency for custom API connections and pipeline automationExperience with CRM data flows and integrations (Slate, Salesforce, and/or HubSpot)A deep understanding of marketing metrics (ROAS, CPA, CAC) and paid platform schemas, with a proven track record of structuring data to optimize Looker Studio performanceProficiency with Git and collaborative development workflows, and proven ability to manage multi‐client data environments with strict data segregationAn analytical, solution‐driven mindset with a growth orientation, and strong communication skills that turn complex data workflows into clear narratives for non‐technical audiences — education marketing experience (traditional or online) is especially valuedBonus Points:Experience integrating AI‐driven insights or machine learning models into marketing data pipelines to sharpen predictive analytics and data utilityFamiliarity using AI or LLM tools to optimize performance forecasting, automated audience segmentation, or marketing workflowsExperience connecting, managing, and maintaining APIs for generative AI platforms within a marketing data architectureExperience using AI/ML‐driven anomaly detection to monitor pipelines and proactively flag data quality issuesWhat's Offered:Remote role with the flexibility that comes with a distributed, async‐friendly teamCompetitive compensation based on experience and locationA pivotal, high‐visibility seat on a scaling Data & Analytics team, with real ownership over the agency's reporting infrastructureThe chance to build the data backbone for an agency whose partners are education and nonprofit organizations working to build a better worldA culture built around finding a better way, playing as a team of A‐players, and treating results as the engine rather than the goalDirect impact: the pipelines and models you build directly shape how partners see (and trust) their own performance dataInterview Process:Application Review (resume + a few questions)Screening Call with Atomic HRHiring Team Interview (walkthrough of a pipeline or data model you've built)Technical Assessment (a real‐world data engineering case study)Final Interview with company leadershipvidIQ builds software to help YouTube creators achieve their goals.
Our mission is to advance the creator's journey with actionable data‐driven insights and AI‐powered tools.
We are dedicated to our values of being creator‐obsessed, lean and fast, and scientific.
Having already supported millions of creators, we invite stunning new co‐workers to join us in reaching millions more.Imagine a product that reached over a million users without a traditional sales team.
This product stands at the forefront of career evolution, where everyone can be their own brand with unlimited growth potential.
That's the opportunity at vidIQ—an infinite market, a large and highly engaged customer base, and the chance to help scale the platform that delivers insights to millions of creators.Discover more about vidIQ firsthand atAbout the TeamOur vision is to build a personal copilot for every YouTube creator.
We work in small, focused teams where people are expected to understand the problem, make decisions,
and take ownership of the outcome.We value people who are strong in their craft, communicate clearly, challenge ideas with respect, and follow through from problem to production.We're also an AI‐native team.
We build AI into our product and use it every day in how we work—from writing and reviewing code to debugging, testing, prototyping, and exploring new ideas.About the roleThis is a frontend‐leaning role, but you won't stop at the frontend.
You'll own entire product surfaces from end to end: the UI, the APIs behind it, the data it depends on, and how it performs in production.
We expect you to understand the problem, decide what to build, and ship it.You'll shape how millions of creators experience vidIQ, and you'll help define how our engineering team builds software now that AI is a real collaborator.This is a remote position open to candidates worldwide.
Employment classification and engagement structure will be determined based on location, legal requirements, and mutual fit.What you will do:Own product surfaces end to end.
You'll be the go‐to owner for key parts of vidIQ, we serve over 1M daily active creators.
You'll set their direction, track how they perform, and decide what to improve next.Work across the stack.
You'll build and change backend APIs, services, and data flows when a feature needs it, instead of waiting on another team.Drive your own roadmap.
You'll spot opportunities in user feedback, data, and the codebase, turn them into proposals, align with product and design, and deliver without needing to be managed closely.Build AI‐powered product experiences.
You'll ship LLM‐driven features across the stack, from model integration and prompts on the backend to streaming responses, error handling, and clear UX when model output is unpredictable.Fix architecture and performance problems.
You'll find bottlenecks and weaknesses anywhere in the request path, frontend or backend, and leave the system better than you found it.Make AI part of how the team works.
You'll use tools like Claude Code, Cursor, and GitHub Copilot every day, share what works, and help set team practices for using AI responsibly.Improve durability.
You'll test important workflows, add useful monitoring and error reporting, and own what you ship after it's live, whether you wrote every line or reviewed and refined AI‐generated code.Raise the bar through review and mentorship.
You'll review code from other engineers, AI‐assisted or not, and give feedback that helps others grow.About YouYou have at least 5 years of professional software development experience.You're strongest on the frontend, but you're comfortable on the backend.
You can design an API, write server‐side code, work with databases, and debug problems that cross the client‐server boundary.You're self‐driven.
You don't need a detailed spec to get started, and you're happy making decisions, asking the right questions, and moving work forward on your own.You act like an owner.
When something you're responsible for breaks, underperforms, or confuses users, you notice and fix it before anyone asks.You've led projects from concept to completion, including documenting the work and teaching others about it.You care about product quality and leave codebases in better shape than you found them.You write and speak clearly, and you can explain technical concepts to non‐technical people.You're confident with TypeScript, React, Next.js, Vite, and Tailwind.You're a heavy, thoughtful user of AI tools.
AI coding assistants and agents are part of how you plan, build, debug, test, and review every day.
You know where they save you hours and where they fail, and you check AI output as carefully as you'd check a teammate's pull request.You keep up with the fast‐moving AI landscape and like trying new models, tools, and workflows.Nice to haveBackend experience with Node.js, Scala, and/or Python, plus relational databases, caching, and queuesExperience with Redux, Redux Saga, and/or ZustandExperience building LLM‐powered features, such as streaming UIs, model APIs, prompt design, or evalsExperience with agentic coding workflows, such as running AI agents on multi‐step tasks, writing custom rules or context files, or using MCP serversPerks and BenefitsWork Remotely: Embrace the freedom to choose your ideal workspace anywhere in the world.Versátil Time Off: We support a flexible vacation policy allowing you to take time off when you need to recharge.Communication Stipend: Enjoy a monthly stipend to cover your phone and internet expenses, helping you stay connected effortlessly.Global Impact: Join our diverse team that's shaping the future of the creator economy across the globe.Competitive Compensation: vidIQ believes in offering competitive compensation that reflects your skills, experience, and contributions.
We ensure fairness through internal equity and geo‐location based pay, with the upper range reserved for individuals demonstrating exceptional job knowledge and skills.Our CommitmentAt vidIQ, we dedicate ourselves to enabling creators of all kinds to succeed.
We prioritize attracting diverse talent and fostering an environment that encourages collaboration, creativity, and personal growth.
We are committed to building a company and a community where individuals thrive by being true to themselves and are inspired to do their best work every day.What's in it for You100% remote work with flexibility to work from LATAM.Join an early‐stage cybersecurity startup where your work will directly impact the product and company growth.Be part of an engineering culture that embraces modern AI‐assisted development workflows.Company‐provided laptop and equipment.Generous PTO and regional holidays.High ownership, autonomy, and direct influence on technical decisions.Location: LATAMWork Model: 100% RemoteProject: Identity Security / Cybersecurity PlatformSeniority: SeniorEngagement: Full‐time143L - Senior Data Engineer (Python/Go/Data Ingestion/Cloud) · Remote · LATAMLocation: LATAMWork Model: 100% RemoteProject: Identity Security / Cybersecurity PlatformSeniority: SeniorEnglish Level: B2 / C1Engagement: Full‐timeGet to Know DarwoftAt Darwoft, we build custom software solutions and partner with international companies to create high‐impact digital products.We are a Latin American technology company with a people‐first culture, strong professional standards, and a long‐term partnership mindset.
We work with distributed teams, complex technical challenges, and clients whose technology has a direct impact on their businesses and users.About the ProjectWe are partnering with an innovative cybersecurity company building a next‐generation Identity Security and Identity Observability platform.The product helps enterprise security teams understand how human users,
service accounts, workloads, applications, and AI‐driven identities access systems across cloud, SaaS, network, endpoint, and on‐premise environments.At the core of the platform is a highly data‐intensive architecture that collects and analyzes large volumes of events, logs, network telemetry, identity activity, and security signals.
This information is processed to identify unusual access patterns, security risks, identity blind spots, infrastructure misconfigurations, and potential threats.The platform integrates with complex enterprise ecosystems including identity providers, cloud platforms, SASE solutions, SIEMs, endpoint security tools, network infrastructure, and security services.About the RoleWe're looking for a Senior Data Engineer focused on Data Ingestion, Integrations, and Collectors to become a key technical bridge between enterprise customers and the engineering organization.This is not a traditional backend or internal data engineering position.You'll work directly with customers to understand their infrastructure, data sources, security architecture, network topology, APIs, and workflows, then design and implement scalable mechanisms to ingest that information into the platform.You'll combine data engineering, software engineering, solution architecture, cloud infrastructure, and technical consulting.A major part of your mission will be building and evolving connectors and ingestion pipelines capable of integrating data from complex enterprise environments while maintaining reliability, scalability, security, and fast time‐to‐production.What You'll Be DoingDesign, develop, and maintain production‐grade data collectors, connectors, and ingestion services.Integrate enterprise data sources including identity providers, cloud platforms, SASE solutions, network infrastructure, endpoints, applications, security platforms, and SIEM systems.Work directly with enterprise customers to understand their environments, data flows, APIs, security requirements, and integration constraints.Participate in technical onboarding processes, from initial discovery and architecture design through production deployment.Design scalable ingestion architectures for processing security events, logs, identity activity, network telemetry, and other high‐volume data sources.Build integrations using REST APIs, cloud‐native services, event‐driven architectures, and modern software engineering practices.Develop backend services primarily using Python and/or Go.Work with SQL and NoSQL databases to store, transform, query, and analyze high‐volume data.Build and operate containerized services using Docker and Kubernetes.Deploy and integrate solutions across AWS, Azure, and GCP environments.Troubleshoot complex customer deployment and integration issues across application, infrastructure, networking, API, and data layers.Optimize ingestion performance, reliability, scalability, and operational efficiency.Collaborate with Solution Architects, Sales Engineering, Customer Success, Product, and Engineering teams.Act as a trusted technical advisor around customer data architecture, collection strategies, security integrations, and implementation best practices.Identify recurring customer requirements and transform them into reusable connectors, platform capabilities, or improvements to the core product.Contribute technical insights from real‐world implementations to the product roadmap.Support production adoption and continuously improve time‐to‐value for enterprise customers.Participate in occasional customer‐facing technical sessions and, when necessary, onsite engagements.What You Bring10+ years of professional Software Engineering, Data Engineering, Platform Engineering, or related experience.Strong software development experience with:PythonGoStrong experience designing and consuming REST APIs.Hands‐on experience building data ingestion pipelines, connector frameworks, integration platforms, or similar systems.Experience integrating complex enterprise systems and third‐party platforms.Solid understanding of both SQL and NoSQL databases.Production experience with at least one major cloud platform:AWSAzureGCPExperience working with Docker and Kubernetes.Strong experience with Git‐based development workflows and CI/CD practices.Experience designing reliable, scalable, and production‐ready distributed systems.Strong debugging skills across APIs, infrastructure, networking, application services, and data pipelines.Experience working directly with customers, stakeholders, or technical partners.Ability to translate complex customer requirements into pragmatic technical solutions.Strong communication skills and the ability to operate effectively in customer‐facing technical conversations.High degree of autonomy, ownership, and analytical problem‐solving ability.Bachelor's degree in Computer Science, Software Engineering, Systems Engineering, or a related technical discipline, or equivalent professional experience.Highly Relevant ExperienceExperience with any of the following will be especially valuable:Identity and Access Management (IAM)Identity Providers (IdPs)Identity SecurityCybersecurity platformsSIEM systemsSecurity telemetryNetwork securityEndpoint securitySASE / Zero Trust environmentsCloud securityLarge‐scale event processingStreaming architecturesIntegration ExperiencePrevious experience integrating APIs or data from platforms such as the following is highly valuable:AWSMicrosoft AzureGoogle CloudMicrosoft Entra ID / Active DirectoryOktaGoogle WorkspaceDuOCrowdStrikeZscalerPalo AltoMicrosoft DefenderSIEM and security analytics platformsDirect experience with every platform is not required.
What matters is a strong track record of learning complex APIs and transforming heterogeneous enterprise data sources into reliable integrations.Nice to HaveExperience with large‐scale data processing or streaming platforms.Experience designing reusable connector SDKs or integration frameworks.Understanding of identity‐related security concepts such as authentication, authorization, credentials, service accounts, privileged access, and non‐human identities.Experience with security events, audit logs, network telemetry, or cloud activity data.Familiarity with event‐driven and distributed system architectures.Experience deploying AI/ML‐enabled applications.Exposure to LLMs, AI agents, or AI‐powered security applications.Solution Architecture or Forward Deployed Engineering experience.Previous experience in cybersecurity startups or high‐growth SaaS environments.What Success Looks LikeSuccess in this role will be measured by your ability to:Deliver successful enterprise integrations and deployments.Reduce customer time‐to‐production.Build reliable and scalable ingestion solutions.Improve customer adoption and technical satisfaction.Resolve complex integration challenges efficiently.Turn customer‐specific requirements into reusable platform capabilities.Contribute improvements that strengthen the scalability and flexibility of the core product.What Darwoft OffersContractor agreement with payment in USD100% remote workArgentina's public holidaysEnglish classesReferral programAccess to learning platforms
#J-*****-Ljbffr
📌 Senior Data Engineer — Remote Bigquery & Etl (Juan José Castelli)
🏢 Lever
📍 Juan José Castelli