Lead Engineer

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 27 U.S. states, 2 Canadian Provinces, India, Luxembourg, and England. We also have a physical offices in San Francisco, New York City, Mumbai and Bangalore for employees who prefer to work in an office some or all of the time.

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.

Qualifications

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

• 8+ 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 building production web applications using Python

• 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