• Design and build data ingestion pipelines integrating with dozens of external sources (social platforms, third-party APIs, web scrapers) • Architect ETL workflows using Airflow and Kafka to process high-volume data streams (millions of records daily) • Collaborate with AI/ML engineers to ensure data quality and availability for Agentic RAG pipelines • Build and optimize multi-store data architecture: vector databases (Pinecone), relational databases (Postgres), and search engines (OpenSearch) • Develop and maintain integrations with social media platforms (Meta, LinkedIn, TikTok, X/Twitter) handling webhook ingestion and API polling • Optimize data freshness, throughput, and reliability across distributed systems • Participate in code reviews and contribute to backend services (FastAPI/Python, occasional Ruby on Rails)

• Collaborate with the Product team on our client business intelligence portal • Enhance the user experience of our state-of-the-art advertising CMS • Work with the data team to make our ad campaigns run more effectively and efficiently • Improve the user experience of our ads across our suite of web and mobile applications

• Design, develop, test, and maintain backend services and platform components. • Take ownership of services throughout their lifecycle. • Make architectural and technical decisions. • Collaborate closely with other engineering teams, product management, and QA. • Write clean, efficient, and well-documented code. • Perform code reviews and ensure code quality. • Write, maintain, and continuously improve automated tests. • Troubleshoot and debug complex production issues. • Mentor junior developers.

• Analyze, maintain, and optimize PostgreSQL and Microsoft SQL database environments to ensure high availability, performance, and data integrity. • Identify and resolve performance bottlenecks, optimize SQL queries, and improve data retrieval efficiency. • Design and maintain database architecture, including schemas, tables, indexes, stored procedures, and security permissions. • Manage and support legacy databases and Platform as a Service (PaaS) database solutions. • Monitor systems for availability and oversee database replication, mirroring, failover, and disaster recovery processes. • Implement backup, restore, and recovery strategies, including point-in-time recovery and WAL archiving. • Support advanced PostgreSQL features such as JSON, full-text search, and PostGIS for geospatial queries. • Generate queries and reports using tools such as pgAdmin, psql, and third-party database clients. • Collaborate with developers, analysts, and infrastructure teams to design, implement, and troubleshoot database solutions. • Assess future storage and performance needs and maintain accurate technical documentation. • Provide recommendations on database policies, procedures, and emerging technologies. • Communicate effectively with customers, stakeholders, and technical specialists. • Contribute to team objectives and take on additional responsibilities as needed.