below marketmost similar roles pay hereabove market
This role pays less than
80%
of similar roles. Most pay
$150,374–$197,500
— the blue band above.
At the midpoint, this role pays about
$139k
versus about
$174k
for comparable roles.
Based on 240 similar postings.
Employer
About Franklin Templeton
Franklin Templeton is a global investment management organization offering a wide range of mutual funds, ETFs, and alternative investment solutions to retail and institutional investors worldwide. Industry: Investment Management & Asset Management
Franklin Templeton currently has
17 open roles
on FindRole.
Listed pay typically runs
$140,000–$174,500
across 17 roles with salary data.
The Lead BI Engineer joins the Enterprise BI team to design, develop, and govern scalable business intelligence solutions that facilitate data-driven decision-making. This role involves leading the delivery of high-impact products, including Power BI dashboards, semantic models, and certified datasets. You will partner with stakeholders to translate requirements into actionable insights while optimizing performance through query tuning and capacity-aware design. Key responsibilities include establishing standards for metric definitions, data quality, and lineage while supporting BI modernization and migration from legacy assets. Technical requirements include proficiency in SQL, Snowflake, DAX, and dimensional modeling, alongside experience with Python, Git, and Agile delivery. You will also leverage AI-assisted tools for prompt engineering and automated testing to improve development efficiency across the enterprise reporting landscape.
Lead the design and delivery of enterprise BI solutions including dashboards, semantic models, and curated datasets.
Partner with business stakeholders to define KPIs and translate requirements into actionable insights.
Build and optimize Power BI semantic models, DAX measures, and dataflows for high performance.
Develop analytics-ready datasets using SQL and Snowflake to support enterprise-wide decision-making.
Establish and enforce BI standards for metric definitions, data quality, documentation, and access controls.
Improve BI reliability through query optimization, model tuning, and proactive refresh monitoring.
Support BI modernization by migrating and rationalizing legacy reporting assets into strategic platforms.
Provide technical leadership and mentoring to BI developers and cross-functional partners.
What we're looking for
8+ years of experience in business intelligence, analytics engineering, data engineering, or enterprise reporting, including leading BI solution delivery.
Bachelor’s or Master’s degree in Computer Science, Engineering, Information Systems, Data Analytics, or a related field, or equivalent practical experience.
Expert knowledge of Power BI, DAX, dimensional modeling, star schema design, and KPI design.
Advanced SQL skills and experience with Snowflake or modern cloud data warehouse platforms.
Proven ability to lead design, develop, and optimize enterprise BI solutions, including semantic models and curated datasets.
Strong knowledge of data governance, security, access controls, data quality, lineage, and report certification practices.
Experience with Agile delivery, source control (Git), deployment pipelines, and release management.
Python experience for automation, data validation, or reporting operations (preferred).
SQL
Power BI
Tableau
Python
Databricks
Microsoft Fabric
Azure Data Factory
Snowflake
ETL
ELT
Data Modeling
GenAI
LLM
Power Automate
Power Apps
Excel
S/4HANA
Agile