Principal Data Strategy Consultant

OShaughnessy Asset Management (OSAM) is owned by Franklin Templeton, a dynamic firm that spans asset management, wealth management, and fintech, giving us many ways to help investors make progress toward their goals. With clients in over 150 countries and offices on six continents, youll get exposed to different cultures, people, and business development happening around the world. OShaughnessy Asset Management (OSAM) operates independently as a Specialist Investment Manager and is a research and money management firm based in Stamford. Our approach to managing money is transparent, logical, and completely disciplined, leading to longstanding relationships with our clients. We are a leading provider of Custom Indexing services via CANVAS. CANVAS is a platform offering financial advisors an unprecedented level of control and ease in creating and managing client portfolios in separately managed accounts (SMAs). Advisors can set up custom investment templates, access factor investing strategies, utilize passive strategies, actively manage taxes, and apply ESG investing and SRI screens according to the specific needs, preferences, and objectives of individual clients. For more firm information, please visit www.osam.com OShaughnessy Asset Management (OSAM) is a research and money management firm based in Stamford, CT. On December 31, 2021, OSAM was acquired by Franklin Templeton. The firm manages over $20 billion in assets for institutions and financial advisors. Our approach to managing money is transparent, logical, and completely disciplined, leading to longstanding relationships with our clients. We are a leading provider of Custom Indexing services via CANVAS. CANVAS is a platform offering financial advisors an unprecedented level of control and ease in creating and managing client portfolios in separately managed accounts (SMAs). Advisors can set up custom investment templates, access factor investing strategies, utilize passive strategies, actively manage taxes, and apply ESG investing and SRI screens according to the specific needs, preferences, and objectives of individual clients. For more information on our firm, visit our website, www.osam.com About the Department: The OSAM technology team values transparency, discipline, and collaboration. Joining us means working with innovative professionals in a dynamic environment where you can grow your technical and financial expertise. You will be working with experts in technology and finance, gaining exposure to advanced portfolio solutions, and contributing to a culture of continuous improvement. How You Will Add Value You will: Troubleshoot user-reported issues across applications and SQL data sources. Diagnose and resolve data integrity and ingestion problems. Implement short-term fixes with rollback plans for safety. Optimize stored procedures for stable data transformations. Update C# ingestion code to improve pipeline reliability. Design and maintain ETL workflows for curated data layers. Enforce data validation and monitoring standards. Document data lineage and operational playbooks. Collaborate with engineers and product teams to resolve issues quickly. Communicate incident status and improvements to leadership. What Will Help You Be Successful in This Role Experience & Education: Bachelors degree in Computer Science or related field. 912 years of programming experience with strong CS fundamentals. Technical Skills: Expert SQL and performance tuning. Proficiency in stored procedures and safe operational updates. Hands-on C# experience for ingestion pipelines. Proficiency with Git, CI/CD, and Azure DevOps. Soft Skills: Strong problem-solving and attention to detail. Excellent communication across technical and non-technical teams. Ability to work independently and manage priorities. Job Level - Individual Contributor Work Shift Timings - 2:00 PM - 11:00 PM IST Experience our welcoming culture and reach your professional and personal potential! Our culture is shaped by the variety of perspec .