Design and maintain dimensional models (fact tables, SCD Type 1/2)
Implement data quality, monitoring, logging, and alerting mechanisms
Drive query performance tuning (Query Profile, clustering, pruning)
Optimize warehouse usage, concurrency, and cost efficiency
Implement RBAC, masking, and governance standards
Lead code reviews, best practices, and reusable frameworks
Collaborate with architects, analysts, and business stakeholders to translate requirements into solutions
Ensure SLA adherence for production pipelines
AI Fluency - AI-first mindset
Uses AI tools (Copilot, Cortex) to accelerate development, troubleshoot pipelines, and improve code quality
Uses AI to assist in designing pipelines, transformations, and improving existing solutions
Reviews and refines AI-generated outputs to ensure accuracy, efficiency, and alignment with data models and standards
Identifies where AI can help reduce manual effort (testing, documentation, repetitive tasks)
Uses AI to learn new Snowflake features and improve development practices
Uses AI to improve personal development productivity and solution quality
Technical Environment
Core Stack: Snowflake (SQL, Stored Procedures, Tasks), Python, Azure Data Factory (ADF), APIs, Blob Storage
Operating Environment: Cloud-based (Azure + Snowflake ecosystem)
Workflow: Agile delivery, CI/CD (GitLab, Jenkins, Liquibase), ticketing via standard tools (e.g., Jira)
Quality & Reliability: Data quality, monitoring, observability, alerting, incident handling
What will help you be successful in this role
Strong hands-on experience with Snowflake, including
Solid understanding of Snowflake architecture (storage, compute, cloud services)
Virtual warehouses, workload isolation, and concurrency handling
Strong query performance tuning and cost optimization
Stored Procedures, Tasks, and orchestration patterns
Exposure to or experience with Dynamic Tables
Strong expertise in
ELT frameworks (incremental processing, CDC, auditing, error handling)
Data warehousing and dimensional modeling (Facts, SCD Type 1/2)
Strong SQL and query optimization skills
Python for orchestration and integrations
Experience building and operating production-grade data pipelines
Familiarity with Medallion Architecture (Bronze/Silver/Gold)
Nice to have skills
Advanced clustering and performance optimization
Data governance (RBAC, masking)
Experience with ADF, APIs, Blob storage
CI/CD tools (GitLab, Jenkins, Liquibase)
Exposure to Snowflake Cortex / AI capabilities
GitHub Copilot and AI-assisted development tools
Work Schedule & Location
This role will work a hybrid schedule 3 days per 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 $122,000 – $158,300, 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.