Lead Software Engineer

At Franklin Templeton, we believe success is built through powerful partnerships. As a forward thinking asset manager, we build dynamic relationships with clients, understand their goals, and navigate complex markets together. We leverage cutting edge strategies and deep insights to unlock opportunities for long term wealth creation. Our talented, global teams bring expertise that is both broad and unique. From our welcoming, inclusive, and supportive culture to our globally diverse business, we offer opportunities not only to help you reach your potential, but also to contribute to our clients’ success. Lead Software Engineer About The Department Delivers reliable, SLA-driven data pipelines (holdings, transactions, positions)Supports downstream analytics, reporting, and consumption systems in the Investments domainAgile delivery: sprint-based planning, stand-ups, reviewsCross-functional collaboration with architects, ingestion teams (ADF/APIs), and business stakeholdersOwnership-driven with aligned data/domain responsibilitiesCulture of collaboration, continuous learning, and innovationFocus on automation, new Snowflake capabilities, and AI-assisted developmentKey impact: data accuracy, availability, performance, and cost efficiency Job Overview Lead implementation of architecture and translate platform strategy into scalable data solutionsOwn end-to-end data pipeline strategy, reliability, performance, and cost optimizationDeliver scalable, enterprise-grade data solutions enabling business and analytics use casesDrive platform roadmap / architectural direction How You Will Add Value Architect and design end-to-end data platforms: Source → Raw → Standard → ConsumptionOwn and enforce platform-level ELT frameworks and engineering standards (append-only, CDC, watermark, auditing)Lead development of pipelines using Snowflake SQL, Stored Procedures, Tasks, Dynamic TablesDesign and govern ingestion patterns (API → ADF → Blob → Snowflake) ensuring resiliency and scalabilityDrive advanced data modeling (dimensional models, SCD strategies, data marts)Establish data quality, observability, monitoring, and alerting frameworksLead performance engineering and cost optimization (query tuning, clustering, pruning, warehouse usage)Own warehouse strategy (sizing, concurrency, workload isolation)Define and implement data governance standards (RBAC, masking, compliance, lineage)Lead code reviews, engineering standards, and reusable frameworksMentor engineers and guide technical problem-solving across the teamCollaborate with architects, product owners, and business stakeholdersTranslate enterprise architecture into implementable designsDesign and implement disaster recovery (DR) strategies and validate readiness through RTO/RPO testing AI Fluency - AI-first mindset Uses AI tools (Copilot, Cortex) to accelerate development and improve solution qualityApplies AI to optimize pipeline design, transformations, and performanceValidates AI outputs for correctness, efficiency, and architectural alignmentIdentifies and implements AI-driven automation across development, testing, and operationsDrives adoption of AI-assisted development practices across the team What Will Help You Be Successful In This Role Deep hands-on experience with Snowflake, including:Strong understanding of Snowflake architecture (storage, compute, cloud services)Expertise in virtual warehouses, workload isolation, and concurrency managementAdvanced query performance tuning and cost optimizationExperience with Stored Procedures, Tasks, Dynamic Tables, and orchestration patternsStrong expertise in:ELT architecture and frameworks (incremental, CDC, auditing, error handling)Data warehousing and dimensional modeling (Facts, SCD Type 1/2, data marts)Strong SQL and performance optimization skillsPython for orchestration and integrationsProven experience designing and scaling production-grade data platformsFamiliarity with Medallion Architecture (Bronze/Silver/Gold)Strong data governance (RBAC, masking, lineage) Technical Environment Core Stack: Snowflake (SQL, Stored Procedures, Tasks, Dynamic Tables), Python, ADF, APIs, Blob StorageOperating Environment: Cloud-based (Azure + Snowflake ecosystem)Workflow: Agile delivery, CI/CD (GitLab, Jenkins, Liquibase), standardized development and release practicesQuality & Reliability: Data quality, observability, monitoring, alerting, SLA adherence and incident management Nice To Have Skills Advanced clustering strategies and workload optimizationExperience with ADF, APIs, Blob storageCI/CD frameworks and deployment automationExposure to Snowflake Cortex / AI capabilities and analytics use casesGitHub Copilot and AI-driven engineering workflows Work Schedule & Location This role will work a hybrid schedule 3 days/week in any of our Franklin Templeton locations with a preference to locations in the Eastern time zone and Canada. Franklin Templeton offers employees a competitive and valuable range of total rewards – monetary and non-monetary – designed to support their well-being and recognize their time, talents, and results. Along with base compensation, employees are eligible for an annual discretionary bonus, a 401(k) plan with a generous match, and recognition rewards. We also offer a comprehensive benefits package, which includes a range of competitive healthcare options, insurance, and disability benefits, employee stock investment program, learning resources, career development programs, reimbursement for certain education expenses, paid time off (vacation / holidays / sick / leave / parental & caregiving leave / bereavement / volunteering / floating holidays) and a motivational wellbeing program. We expect the annual salary for this position to range between $128,100 – $174,500, depending on location and level of relevant experience, plus discretionary bonus.... At Franklin Templeton, we believe your benefits should support your life, your goals, and your future. That’s why we offer a comprehensive Total Rewards package designed to help you thrive both personally and professionally. Highlights Of Our Benefits Include Paid Time Off: Three weeks of PTO in your first year Health Coverage: Competitive medical, dental, and vision insurance to support your well-being Retirement Savings: 401(k) plan with an 85% company match on pre-tax and/or Roth contributions, up to IRS limits Equity & Investing: Employee Stock Investment Plan (ESIP) with discounted share purchase opportunities Learning Education Assistance Program (LEAP): To support your ongoing growth and career advancement Employee Investment Benefits: Opportunity to purchase company funds with no sales charge 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. Artificial intelligence or automated tools may be used to assist in the screening, assessment, or selection of applicants for this position.