Software Engineer Ii (Data)

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 indigital-firstoperations, allowing our teams to collaborate effectively across most US states, 2 Canadian Provinces, and Mexico. We also have physical offices in San Francisco, CA and Austin, TX, 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 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

• 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.
• Design and implement sophisticated data models in SQL.
• Document data models, architectural decisions and data dictionaries to enable collaboration, maintainability and usability of our analytics platforms and code.
• Learn our application data schema, develop a fluency in how to transform it to enhance customer’s decision-making with data.
• Work closely with the other Software Engineers to ensure sound, scalable implementation.
• Drive instrumentation and development of foundations for product usage reporting for internal users.

Qualifications

• You must be flexible and adaptable—you will be operating in a fast-paced startup environment
• Experience developing on (or administering) BI / data visualization platforms (ex. Looker, Tableau, PowerBI, Mode, Data Studio, Domo, QlikView etc.).
• Strong command of Python and experience building production web applications using Python
• Experience with relational databases (Postgresql preferred), data modeling and database design
• Bachelor's degree in Computer Science or equivalent work experience
• Experience with cloud based services (AWS RDS preferred)
• 2+ years of experience contributing to ETL (Extraction Transform Load) or ELT (Extraction Load Transform) pipelines

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.

Benefits

Compensation for this position includes a base salary, equity, and a variety of benefits. The U.S. base salary for this role is $128,000 - $160,000. Actual base salaries will be based on candidate-specific factors, including experience, skillset, and location, and local minimum pay requirements as applicable. We are actively hiring for this role in Canada, and offer competitive local pay and benefits. Your recruiter can provide further details.

• Competitive salary and meaningful equity
• Freedom to customize your work and technology setup as you see fit
• Monthly work from home wellness stipend while we're all remote
• Professional development stipend
• Mental wellness coverage including live coaching and therapy sessions
• Health, dental, and vision care for you and your family
• Generous paid family leave, medical leave, and bereavement leave policies
• Healthcare FSA and commuter benefits programs
• Home office productivity allowance to help create an ideal work from home setup
• 401k retirement savings plan
• Unlimited vacation policy and paid holidays

#Juniper-US

#Juniper-Canada