Data Engineer

Fiduciary Trust International is a premier investment and wealth management firm with a commitment to growing and protecting wealth across generations. We offer a dynamic and collaborative approach to managing wealth for high-net-worth and ultra high-net-worth individuals and families, family offices, endowments, foundations, and institutions. Our investment managers, tax and estate planning professionals work together to develop holistic strategies to optimize clients' portfolios while mitigating the impact of taxes on their wealth. As a fiduciary, the guidance we provide is in the best interests of our clients, without conflict or competing benefits. We offer boutique customization and deep expertise in specialized investment, tax and planning strategies alongside sophisticated technology and custody platforms. Fiduciary Trust International 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. About the Department: Fiduciary Trust International (FTI), a Franklin Templeton company, is a leading provider of comprehensive wealth management solutions for high-net-worth individuals, families, foundations, and endowments. With a strong fiduciary heritage, FTI offers personalized trust and estate services, investment management, and administrative solutions designed to preserve and grow client wealth across generations. Known for its client-first culture, rigorous risk management, and collaborative approach, Fiduciary Trust International combines deep expertise with the global resources of Franklin Templeton to deliver tailored, long-term financial outcomes. The AI, Data, and Process Optimization team builds trusted, high-quality data products that power analytics and AI across Fiduciary Trust International. We work closely with business and technology teams to deliver governed, reliable datasets that enable smarter decisions and advanced workflows. Joining this team offers hands-on experience with modern data engineering practices, semantic modeling, and AI-driven solutions in a collaborative, growth-focused environment. How You Will Add Value? You will translate conceptual and logical models into physical warehouse objects and curated schemas. You will implement SQL and ELT transformations optimized for accuracy and performance. You will build BI-ready schemas aligned to reporting needs and semantic standards. You will create relationship-focused datasets supporting graph and AI retrieval patterns. You will apply data-quality rules and contribute to automated testing and monitoring. You will support entity identifier workflows and basic matching rules under senior guidance. You will monitor and troubleshoot warehouse jobs powering BI datasets. You will write clear documentation for tables, columns, and usage guidance. You will improve dataset reliability through tests, alerts, and automation. What Will Help You Be Successful? Experience, Education & Certifications: Bachelor's degree in Computer Science, Information Systems, Engineering, or related field. 2–4 years in data engineering, analytics engineering, or BI data development. Technical Skills: Strong SQL skills and experience building dimensional models and BI-ready datasets. Hands-on experience with Snowflake or modern cloud data warehouses; familiarity with ELT patterns. Basic understanding of graph concepts and relationship-centric datasets. Knowledge of data quality practices and governance fundamentals. Soft Skills: Strong collaboration, attention to detail, and ownership mindset. Ability to document and communicate technical concepts clearly. Preferred: Experience with Python and transformation frameworks (e.g., dbt). Familiarity with semantic modelling concepts and BI tools like Power BI. 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 equal employment opportunities to all applicants and employees, and we evaluate qualified applicants without regard to ancestry, age, color, disability, genetic information, gender, gender identity, or gender expression, marital status, medical condition, military or veteran status, national origin, race, religion, sex, sexual orientation, and any other basis protected by federal, state, or local law, ordinance, or regulation. If you believe that you need an accommodation or adjustment, due to a medical condition or disability, to search for or apply for one of our positions, please send an email to accommodations@franklintempleton.com. In your email, please include the accommodation or adjustment you are requesting, the job title, and the job number of the position you are applying for. It may take up to three business days to receive a response to your request. Please note that only accommodation requests will receive a response. When you become part of Franklin Templeton, you'll join a company dedicated to progress. A company that doesn't settle. One where we pursue our ambitions with energy and persistence. That's why it's so important that we empower and encourage the progress of our employees. From our welcoming, inclusive, and flexible culture – to our global and diverse business, we provide opportunities to help you reach your potential while contributing to ours. At Franklin Templeton, we embrace individual differences and value experience and perspectives brought by talent from around the world. And, although we are all different, we all have one thing in common – we are dedicated to what we do. So whether you're just starting your career journey, are well on your way, or are seeking a new direction, you''ll find the support you need to grow your career with us. Come, join us, and help us shape the future of the global asset management industry!