Data Architect(Investments)

Lead Data Engineer / Data Architect New York City, NY; (Onsite – 5 days/week) Tech skill set: Data Architecture, Data Modelling, Expert level SQL, Python, AWS Technologies (Glue), Snowflake and data engineering design patterns Domain: Asset management, Alternatives Investments, Financial Services. About the Role: We are seeking an experienced Lead Data Engineer / Data Architect to spearhead the design, development, and implementation of our enterprise data platform. This role will be instrumental in shaping and driving our data engineering roadmap, ensuring scalability, performance, and innovation. The ideal candidate combines deep technical expertise with strong leadership skills and a solid understanding of financial services data domains. Required Qualifications: • Bachelor’s degree in Computer Science, Information Technology, or a related field. • 8+ years of experience in data engineering with a strong focus on Data Architecture, Data Modelling (Conceptual, Logical, Physical), ELT processes and data pipeline development. • Hands-on experience with Snowflake cloud data platform, including data sharing, secure views, and performance optimization. • Proficiency in SQL and familiarity with data integration and ETL/ELT tools. • AWS Technologies (Glue, EMR) • Python for data engineering workflows • Strong understanding of data engineering design patterns • Strong problem-solving skills and the ability to work independently to meet deadlines. • Excellent communication skills for effectively interacting with technical and non-technical stakeholders. Preferred Qualifications: • Certifications in Snowflake or relevant data technologies. • Experience in the financial services sector, especially asset management / alternative investments, with an understanding of data security and compliance requirements. • Familiarity with cloud platforms (e.g., AWS, Azure) and data orchestration tools (e.g., Apache Airflow). • Knowledge of data visualization tools (e.g., Tableau, Power BI). FYI: Asset Management Experience: Refers to roles and systems involved in managing investments, portfolios, and client assets — typically for institutional investors, private equity, hedge funds, or wealth management clients. Key Functions & Systems: • Portfolio management and rebalancing • Fund accounting / NAV calculation • Investor reporting and performance analytics • Trade capture and reconciliation • Risk analytics (VaR, exposure, correlation, stress testing) • Alternative investments (private equity, hedge funds, real estate funds) • Investment data management (security master, pricing, positions) • Client reporting / investor portal development • Platforms: Investran, eFront, Aladdin, SimCorp, Geneva, Charles River, Advent, Eagle PACE, Bloomberg AIM