Design, develop, and maintain Capricorns investment analytics and reporting infrastructure. Build scalable data pipelines that support both traditional financial reporting and impact analysis. Collaborate with investment and accounting teams, as well as external data vendors, to deliver analytical capabilities across a growing client base. Own the full lifecycle of financial datafrom raw extracts to client-facing analyticsensuring accuracy through validation systems and reproducibility checks. Develop tools to compute financial metrics across various data dimensions. Implement scalable solutions for collecting and analyzing impact metrics. Work closely with stakeholders to generalize analytical solutions for broader use. Maintain internal tools for portfolio monitoring and analysis. Collaborate using Jira and/or Confluence and participate in code reviews to ensure quality and maintainability.Job Requirements: Bachelors degree plus three years of experience, or Masters degree in Business Analytics, Data Science, Software Engineering or closely related field plus one year of experience. At least one year of the experience must include end-to-end design and orchestration of ETL (Extract, Transform, Load) data pipelines; programming for data analysis using Python and Excel; experience with T-SQL for querying and managing structured data; Azure cloud services; implementing data validation and reproducibility checks across analytical pipelines; experience with Jira and/or Confluence for team collaboration and project tracking; and experience with at least one data visualization or analytics platform such as Power BI, Tableau, or Databricks. Experience or college coursework/project work must also include use of a strongly typed, object-oriented language (e.g. Java, C#, C++, Rust).