Sr. Data Engineer II

Job description

**About Allocate** Allocate is transforming private market investing by enabling RIAs and family offices to seamlessly discover, model, and manage their private market exposure. Our platform combines curated fund and co-investment opportunities with institutional-grade infrastructure. Through a single, data-rich digital experience, clients access top-tier opportunities across venture capital, private equity, private credit, and other private asset classes—backed by powerful tracking, analytics, and administration tools. **Job Description** Allocate is looking for a Senior Data Engineer to help build out the data infrastructure that powers our analytics, reporting, and data-driven product features. As a fintech startup on a mission to make investing in top-tier private markets more accessible, we have a wealth of financial and investment data to harness. Our data lead has established the foundational architecture and strategy, and we are now looking for a strong senior engineer to help extend, scale, and harden it. In this role you will partner closely with our data lead to model core financial entities, integrate internal and external sources, and build the pipelines and infrastructure that let our engineering and product teams make informed decisions and ship compelling features. This is a hybrid position based out of our Palo Alto, CA office, where you will work alongside our backend team (C#/.NET) and frontend team (Node/Vue.js) to integrate data pipelines into our platform. If you are a hands-on engineer who wants to do high-impact data work in a collaborative startup environment, we want to hear from you. **Responsibilities** - **Build and Extend Data Architecture:** Build on and extend Allocate's data lakehouse on AWS, combining data lake storage and warehouse technologies to store diverse financial datasets. Contribute to our knowledge graph that models key relationships (investors, funds, companies, etc.) and to the vector database integration that stores embeddings for semantic search and retrieval across our AI agents, models, and providers. - **Develop Data Pipelines:** Create robust ETL/ELT pipelines to ingest, clean, and transform data from various sources (internal application data and third-party APIs). Ensure both batch processing and real-time data streaming are handled to support up-to-date analytics and recommendations. Build pipelines with an eye on scalability (able to handle increasing data volume and complexity) and reliability (proper error handling and monitoring). - **Enable AI/ML Capabilities:** Work closely with our data science and engineering team to provision the data and infrastructure needed for machine learning models and AI features. This includes preparing training datasets, setting up feature stores, and orchestrating workflows that feed LLM-based agents with the context they need (e.g. retrieving relevant data via vector similarity search). You will also help implement systems to serve AI model outputs (such as recommendations) back into the product in real time. - **Engineering Excellence and Collaboration:** Partner with our data lead and the broader engineering team to deliver data and AI infrastructure. Raise the bar through thoughtful code review, testing, and adherence to best practices, and help engineers who consume data in their services do so effectively. Work in cross-functional squads to incorporate data-driven features into the product roadmap, and share your expertise with peers as the team grows. - **Infrastructure and DevOps:** Collaborate with our DevOps engineers to deploy and maintain data services. Containerize and orchestrate data tools (using Docker/Kubernetes on AWS EKS) for production use. Implement CI/CD pipelines for data workflows so that changes to data processing or models are tested and deployed automatically. Monitor the health and performance of our data platforms (setting up alerts, dashboards) and be ready to troubleshoot and resolve issues in production to ensure uptime of critical data and AI services. - **Continuous Improvement:** Stay up to date with the latest in data engineering and AI, from new AWS offerings to open-source ML tools. Evaluate and recommend new technologies, for example assessing whether a stream processing platform like Kafka/Kinesis or an orchestration tool like Airflow could improve pipeline reliability. Challenge conventions and innovate: we encourage rethinking how things are done as we push to build a world-class, intelligent platform. **What You'll Need to Succeed** - **Strong Data Engineering Experience:** 5+ years of hands-on experience in data engineering (or related fields), including designing and building large-scale data pipelines and storage solutions. You should have taken projects through the full lifecycle from design to production deployment. - **Cloud Proficiency (AWS):** Strong experience working with AWS cloud services for data. You should be comfortable with tools like S3, EC2, ECS, EKS, Athena, Redshift, Glue, and Step Functions. Experience setting up infrastructure-as-code (Terraform/CloudFormation) for these services is a plus. - **Database and Data Modeling Skills:** Proficiency in SQL and relational database design. Able to design efficient schemas and optimize queries/indexes for performance. Experience building or working with data warehouses or lakehouses (e.g. Snowflake, Databricks Delta Lake) is highly desired. Familiarity with graph databases (Neo4j, AWS Neptune, etc.) and knowledge graph schemas will help you hit the ground running. - **Programming Expertise:** Fluency in at least one major programming language used in data engineering. Python is commonly used for data pipelines, and pandas/PySpark experience is valuable. We also value experience with TypeScript/Node.js in data contexts, since our stack leans toward modern web technologies. The ideal candidate can work across languages, for example writing a data API in C# or Node.js to interface with our backend while also crafting Python scripts for data processing. Clean, maintainable code and adherence to best practices are a must. - **AI/ML Familiarity:** While this is not a pure ML researcher role, you should understand how machine learning models consume data. Experience preparing datasets for training, working with feature stores, or integrating ML model outputs into applications is important. Knowledge of vector embeddings and experience with vector databases (Postgres pgvector, Chroma, Pinecone, etc.) is a big plus, as our AI features rely on semantic search. Familiarity with frameworks for building AI agents or retrieval-augmented generation (e.g. LangChain, LlamaIndex) is also valuable. - **AI-Native Mindset:** treating AI as core to the workflow, fluency with agentic tools and LLM-assisted dev, pushing the frontier of AI tooling. - **DevOps and DataOps Skills:** Solid understanding of containerization and deployment. Experience using Docker to package data applications and Kubernetes (or AWS EKS) to run distributed jobs/services. You should be comfortable setting up CI/CD pipelines for automated testing and deployment of data pipelines or ML models. Experience with workflow managers (Airflow, Prefect, dbt, or similar) is beneficial. - **Strong Analytical and Problem-Solving Skills:** Ability to analyze complex data problems, debug pipeline issues, and optimize system performance. You should be detail-oriented about data correctness and have a knack for troubleshooting data discrepancies or bottlenecks in processing. - **Compliance and Security:** working in a regulated SEC environment, handling sensitive investor/financial data, building with auditability, least-privilege, and data governance in mind. - **Collaboration and Communication:** Excellent communication skills and a collaborative mindset. You will be working with a diverse fully-remote team, so you need to articulate ideas clearly and build consensus. Comfort mentoring peers and driving technical projects to completion is important, as is a positive attitude toward continuous learning and improvement. We value growth mindset and adaptability. **Education:** Bachelor’s degree in Computer Science, similar technical field of study, or equivalent practical experience **Essential Values & Culture:** - Providing our clients with a world-class experience is our number one priority. We obsessively search for ways to improve the experience for our clients and partners. This requires extraordinary response times, proactivity, and ensuring that everything we do, from product strategy to offline communications is a top-tier client experience. - **Challenge convention:** Instead of detailing all the reasons why an idea may not work, we constantly question things to determine how a viable idea may be put into motion. - **Commitment to continuous improvement:** We find ways to personally scale each day by pushing ourselves up the learning curve. - **Meritocracy, not politics:** We place the utmost value on results and rewards through merit, not reward actions driven by political agendas or behavior. - **Civil Discourse is embraced:** We believe open, intellectually curious conversations are required to consistently arrive at the best decisions. Respect is paramount in our dealings with one another, but our mission is always to get the right answer collectively, not to be right. - **Embrace technological change:** We adopt tools and techniques that make us faster, smarter, and better. We stay open to innovation, especially around AI and automation, and drop outdated methods without hesitation. Complacency kills progress, we value adaptability and curiosity. **Additional Details:** - **Location:** Palo Alto (hybrid) - **Employment:** Full-time - **Seniority:** Mid-level professional - **Salary:** Total compensation may also include a discretionary performance-based bonus. The expected base salary range for this role is $145,000 to $220,000. *Actual compensation will be determined based on the candidate's primary work location and other job-related factors including skills, experience, qualifications, interview performance, internal equity, and market data. Candidates located in higher cost-of-living markets, including the San Francisco Bay Area, may be considered within the higher end of the range.* *This range reflects base salary only and does not include bonus, equity, benefits or other forms of compensation that may be offered. Total compensation may also include a discretionary performance-based bonus.* - **Benefits:** Medical, dental, and vision. 401(k), and responsible vacation time (PTO) - Travel required for team/department offsites - An in-person interview may be required during the interview process - A Broadband internet connection required - Compliance with Allocate's Code of Ethics is a given for this role.