Data Engineer/Analyst - Python/SQL

<p><p>Weve assembled a world-class team and are building a firm grounded in intellectual rigor, commitment to excellence, and a culture of ownership.

Were energized by the scale of the opportunities ahead and are looking for teammates who want to help build something fast-moving, high-impact, and built to win.<br/><br/><b>KEY RESPONSIBILITIES : </b><br/><br/>- Construct analytical dashboards from alternative data use cases, such as sector or thematic and financial KPI dashboards<br/><br/>- Load and import data into internal warehouses through Azure Blob Storage and/or S3 deliveries, SFTP, and other ingestion mechanisms<br/><br/>- Design and implement ETL workflows for preprocessing of transactional and aggregated datasets including : complex joins, window functions, aggregations, bins and partitions<br/><br/>- Manipulate and enhance time series datasets into relational data stores<br/><br/>- Implement and refine panels in transactional datasets and relevant panel normalization<br/><br/>- Conduct webscraping, extraction and post-processing of numerical data from web-based datasets<br/><br/><b>QUALIFICATIONS : </b><br/><br/>- Bachelors or Masters in Engineering, Finance, Accounting, Economics or related field<br/><br/>- Previous experience working within fundamental equity investment workflows, such as exposure to financial modeling<br/><br/>- High proficiency in SQL and the Python data stack (pandas, numpy, sklearn)<br/><br/>- Experience working with scheduling and execution platforms, such as Airflow, Prefect, or similar scheduled DAG frameworks<br/><br/>- Understanding of efficient query management in Snowflake, DataBricks, or equivalent platforms<br/><br/>- Optional familiarity with automation of workflows that produce Excel outputs, such as through openpyxl<br/><br/>- Optional familiarity with integrations and import/exports to REST/gRPC/GraphQL APIs<br/><br/><b>ADDITIONAL DETAILS : </b><br/><br/>- Work Location : In-office, 5 days per week in Mumbai, India<br/><br/>- Hours : India hours, with an overlap with the US hours (noon to late evening IST)<br/><br/>- Security : This role is performed in a dedicated, secure workspace<br/><br/>- Travel : Annual travel to the U.S. for onsite collaboration is expected<br/></p><br/></p> (ref:hirist.tech)