Data Engineer

Firm Overview

Casdin Capital, LLC (“Casdin”) is a New York-based fundamental research investment firm focused on the life sciences and healthcare industry. The firm manages a long-short equity fund and makes investments in early-stage to late-stage private investments. Casdin was launched in 2012 by founder and CIO Eli Casdin and manages a multi-billion dollar fund.

At Casdin we start from a position of curiosity, honesty, and passion to gain a deep and thoughtful understanding of opportunities in the life science ecosystem. We commit to finding the highest quality management teams doing the work to create high-growth companies. We use data to continually advance our knowledge and we are long-term investors. We believe in collaboration and transparency and operate at the forefront of innovation.

Position Overview

As the data team’s second hire, the data engineer will be a key part of the future development of the data strategy at Casdin Capital. The data team is highly integrated within the organization and the deliverables have high visibility and engagement with all senior leaders within the organization.

On the research side, our goal is to build a world-class data engine that advances the investment platform, by continuing to build a data-informed industry-leading portfolio construction program. This data engine will be utilized by our investment team to drive the success of the investment decision-making process and we are passionate about delivering best-in-class technology with a scalable and resilient approach. We utilize data to drive idea generation, decision making, and risk mitigation. The data engineer will be instrumental in developing the data flows that are the foundations of these processes.

On the reporting side, the data team drives analysis and data visualization to support key business initiatives and the key drivers of the business. We leverage technology for report automation, ETL, and web-based dashboards. The data engineer will continue the core development of the code repositories, working on automation, data flows, data quality, and data manipulation to both support and advance these efforts.

The data engineer will combine technical proficiency with an understanding or keen interest in markets to take ownership of existing data programs and look to further enhance and evolve our approach. Casdin is in a growth phase and there will be a significant opportunity for the role to grow through the build-out of additional internal products and programs. We are looking for someone with a high degree of intellectual curiosity who enjoys thinking about and discussing architectural and design approaches, engineering best practices, and risk analysis.

Responsibilities

• Build automatable processes in SQL & Python related to data flows into and out of the SQL server data warehouse (data sources include third-party vendors, APIs, admins, etc).
• Manage the internal mapping tables for underlier roll-ups, custom tagging, ticker mapping across vendors, etc.
• Ensure data quality by continuing datacheck development and correcting errors highlighted in daily datacheck reports.
• Continue core development of the reporting Git repositories as it relates to reporting process automation, reporting requirements across the organization, and ETL.
• Maintain and expand the ETL and data management repo.
• Handle ad-hoc data requests across the firm to support internal needs, taking vague requests and intuitively understanding the request to generate excel files, PDFs, Powerpoints, and emails.
• Handle month and quarter-end reporting for marketing, finance, and the data scientist.
• Maintain and enhance web-based dashboards that service the organization.
• Experience with developing and maintaining internal web-based dashboards.

Requirements/Qualifications

• 4+ years of SQL experience, with the ability to code stored procedures and views.4+ years of Python experience with the ability to build data flow processes and interact with a SQL server database.
• Development in a Git environment adhering to best practices around code quality.
• Experience working with market data or exposure to investing and portfolio management.
• Ability to work in an agile type development environment, with strong communication skills for cross-functional requirements gathering and stakeholder management. This individual will need to work across multiple teams simultaneously.
• Proactive with a mind toward efficiency in the process and systems that we build and a keen interest in the effectiveness of the solutions we create.
• Exceptional attention to detail with the ability to produce error-free work and quickly find issues within a dataset.
• Passion for and understanding of equity capital markets.

The minimum and maximum base annual salary for this role is $150,000 to $200,000. Actual base salaries may vary based on factors including but not limited to experience, past performance, education, and other job-related factors. In addition to base salary compensation, we offer a comprehensive benefits package, and successful candidates are eligible to receive an annual discretionary bonus.