Senior Data Engineer

Juniper Square

Juniper Square

Data Science
Posted on Thursday, August 17, 2023

About Juniper Square

Our mission is to unlock the full potential of private markets. Privately owned assets like commercial real estate, private equity, and venture capital make up half of our financial ecosystem yet remain inaccessible to most people. We are digitizing these markets, and as a result, bringing efficiency, transparency, and access to one of the most productive corners of our financial ecosystem. If you care about making the world a better place by making markets work better through technology – all while contributing as a member of a values-driven organization – we want to hear from you.

Juniper Square offers employees a variety of ways to work, ranging from a fully remote experience to working full-time in one of our physical offices. We invest heavily in digital-first operations, allowing our teams to collaborate effectively across most US states and 2 Canadian Provinces. We have a physical office in San Francisco, CA for employees who prefer to work in an office some or all of the time.

GP Experience

Juniper Square serves two sides of the private capital markets, the investment managers (GPs) and the investors (LPs). The GP eXperience team (i.e., GPX) is responsible for Juniper Square’s product offering for General Partners (GPs). This is our core product that enables all other innovation at Juniper Square as we unlock and improve the world’s private capital markets. Our platform handles billions of dollars of transactions each month and we are actively expanding into additional private asset classes such as Venture Capital & Private Equity. Come help us innovate in fundraising, reporting, asset-ownership mapping, and more.

The Team

The Data Engineering team is responsible for Data pipelines that serve multiple types of customers including internal Juniper Square users for Business Intelligence and GPs for Analytics on their data. We support the ability for these customers to create and manage their custom dashboards. We also support the ability for other Product Engineering teams to add metrics to track product usage for the features they launch into production.

About your role

Juniper Square is growing rapidly, and our data needs are growing even faster, so we’re growing our Data Engineering Team. As a Senior Data Engineer your role will be pivotal to evolving our existing data and reporting experiences. You’ll build out pipelines to gather data from multiple sources and make it available for analysis. You will shape both internal and external analytics products to help guide business-critical decisions, enhance their workflows, and improve decision-making.

What you’ll do

  • Design and implement sophisticated data models in SQL.

  • Work closely with the other Software Engineers to ensure sound, scalable implementation.

  • Act as a technical expert on our team regarding all things data, especially as the data team grows and evolves.

  • Introduce new technologies to evolve and enhance our data pipeline capabilities.

  • Document data models, architectural decisions and data dictionaries to enable collaboration, maintainability and usability of our analytics platforms and code.

  • Assist with governance, guidance, code reviews, and access controls so that we maintain consistency, quality, and business confidentiality as we scale analytics access across the company and to customers.

  • Externally: learn our application data schema, and develop a fluency in how to transform it to enhance customer’s decision-making with data.

  • Internally: guide product and development teams, advising on instrumentation and laying development foundations for product usage reporting.

  • Fulfill projects with minimal guidance but with an appropriate sense of when and how to collaborate with others.

  • Build scalable, highly performant infrastructure for delivering clear business insights from a variety of raw data sources.


  • Bachelor's degree in Computer Science, or equivalent work experience

  • 5+ years of experience building ETL (Extraction Transform Load) or ELT (Extraction Load Transform) pipelines from scratch

  • Strong command of relational databases (Postgresql preferred), data modeling and database design

  • Strong command of Python and experience using Python for Data Pipelines

  • Experience with cloud based services (AWS RDS preferred)

  • Experience developing on (or administering) BI / data visualization platforms (ex. Looker, Tableau, PowerBI, Mode, Data Studio, Domo, QlikView etc.).

  • Basic understanding of data warehouses such as Amazon Redshift, Google BigQuery, Snowflake etc.

  • Demonstrated history of translating data into clear and actionable narratives and communicating opportunities and challenges relevant to stakeholders.

  • You must be flexible and adaptable—you will be operating in a fast-paced startup environment.

At Juniper Square, we believe building a diverse workforce and an inclusive culture makes us a better company. If you think this job sounds like a fit, we encourage you to apply even if you don’t meet all the qualifications.


Compensation for this position includes a base salary, equity, and a variety of benefits. The U.S. base salary range for this role is $160,000 - $200,000 and the Canadian base salary range for this role is $200,000 - $250,000 CAD. Actual base salaries will be based on candidate-specific factors, including experience, skillset, and location, and local minimum pay requirements as applicable.

Benefits include:

  • Health, dental, and vision care for you and your family

  • Life insurance

  • Mental wellness coverage

  • Fertility and growing family support

  • Unlimited vacation in addition to company paid holidays

  • Paid family leave, medical leave, and bereavement leave policies

  • Retirement saving plans

  • Allowance to customize your work and technology setup at home

  • Annual professional development stipend

Your recruiter can provide additional details about compensation and benefits.