Lead Data Strategy Consultant

Benefits

Additional Information

O'Shaughnessy 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, you'll get exposed to different cultures, people, and business development happening around the world. O'Shaughnessy 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 long‐standing 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 O'Shaughnessy 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 long‐standing 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: Investigate and resolve data issues across applications and SQL workflows. Perform diagnostics to ensure data integrity and lineage. Implement short-term fixes with rollback plans for safety. Optimize stored procedures and business logic for stability. Update C# ingestion code to improve pipeline reliability. Design and maintain ETL workflows for curated data layers. Apply validation and monitoring to prevent anomalies. Document data lineage and maintain operational playbooks. Collaborate with engineers and product teams to enforce standards. Communicate incident status and improvements to leadership. What Will Help You Be Successful in This Role? Experience & Education: Bachelor's degree in Computer Science or related field. 7-10 years of programming experience. Advanced SQL skills and experience with stored procedures. Proficiency in C# and data pipeline troubleshooting. Proficiency with Git, CI/CD, and Azure DevOps. Soft Skills: Strong communication and problem-solving skills. Ability to work independently and manage priorities. Adaptability in fast-paced environments. 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 perspectives and experiences brought by talent from around the world. Regardless of your interests, lifestyle, or background, there's a place for you at Franklin Templeton. We provide employees with the tools, resources, and learning opportunities to help them excel in their career and personal life. By joining us, you will become part of a culture that focuses on employee well-being and provides multidimensional support for a positive and healthy lifestyle. We understand that benefits are at the core of employee well-being and may vary depending on individual needs. Whether you need support for maintaining your physical and mental health, saving for life's adventures, taking care of your family members, or making a positive impact in your community, we aim to have them covered. Learn more about the wide range of benefits we offer at Franklin Templeton *Most benefits vary by location. Ask your recruiter about benefits in your country. Franklin Templeton is an Equal Opportunity Employer. We are committed to providing e