# Lead BI Engineer — Franklin Templeton

- Location: Baltimore, MD
- Posted pay: $128k–$151k/yr
- Posted: Oct 23, 2026
- Status: open (checked Nov 21, 2026)
- Apply (employer's site): https://careers.franklintempleton.com/us/en/job/FTGFTMUS869241EXTERNALENUS
- Employer record: https://visajobs.io/company/franklin-templeton-companies.md

## Sponsorship history
- Tier: Some history
- Occupation (SOC): Data Scientists (15-2051)
- Employer's certified LCAs for this occupation in MD, FY2024–FY2026: 0
- …in the whole US: 3
- With this exact title: 0
- Median DOL prevailing wage, level I / II: $81k / $104k

## Description
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 BI Engineer
About the Team
Enterprise BI delivers trusted, scalable, and governed business intelligence solutions that help leaders make confident, data-driven decisions. The team partners across business, technology, and data organizations to design curated datasets, semantic models, reporting standards, and executive-ready dashboards that improve transparency, consistency, and speed to insight.
About the Role
We are seeking a Lead BI Engineer to drive the design, development, optimization, and governance of enterprise business intelligence solutions. This role will lead the delivery of high-impact BI products, including Power BI dashboards, semantic models, certified datasets, and self-service reporting capabilities. The ideal candidate combines strong technical expertise with business partnership, delivery ownership, and the ability to influence standards across teams.
How you will add value
Lead the design and delivery of enterprise BI solutions, including dashboards, scorecards, semantic models, curated datasets, and self-service reporting products
Partner with business stakeholders to understand priorities, define KPIs, translate requirements, and deliver clear, actionable insights
Design, build, and optimize Power BI semantic models, DAX measures, dataflows, and reporting layers for performance, usability, and maintainability
Develop analytics-ready datasets using SQL, Snowflake, and modern data modeling practices to support enterprise reporting and decision-making
Establish and promote BI standards for metric definitions, report certification, documentation, naming conventions, data quality, and access controls
Improve BI performance and reliability through query optimization, model tuning, refresh monitoring, and capacity-aware design
Collaborate with data engineering, analytics, and platform teams to strengthen upstream data pipelines, data marts, governance, and lineage
Support BI modernization efforts, including migration and rationalization of legacy reporting assets into strategic enterprise platforms
Leverage AI-assisted tools and automation to improve BI development, documentation, troubleshooting, and delivery efficiency
Provide technical leadership, mentoring, design reviews, and best-practice guidance to BI developers, analysts, and cross-functional partners
Modern BI & AI Enablement
AI-Assisted Delivery
Use AI-enabled tools responsibly to accelerate BI development, prompt engineering/DAX/SQL authoring, testing, documentation, and modernization
Apply AI-assisted techniques to analyze requirements, draft metric definitions, identify data quality gaps, and improve dashboard rationalization
Use clear prompts, validation practices, and review patterns to improve the consistency, accuracy, and maintainability of BI assets
Stay current with emerging analytics capabilities, including natural language querying, semantic model assistants, automated insights, and intelligent observability
Operational Excellence
Use monitoring and observability practices to proactively manage usage, adoption, failures, data freshness, and performance trends
Create and maintain documentation, lineage summaries, release notes, and support artifacts that improve transparency and operational support
Continuously improve dashboard performance, refresh reliability, query efficiency, and semantic model quality
What will help you be successful in this role
8+ years of experience in business intelligence, analytics engineering, data engineering, or enterprise reporting, including experience leading BI solution delivery
Architecting Visualization/Enterprise BI platform solutions, Power BI, DAX, dimensional modelling, KPI design, and data visualization best practices
Ability to translate business needs into clear KPIs, requirements, dashboards, data products, and analytical narratives for technical and non-technical audiences and recommend the right platform for long term strategic needs.
Advanced SQL skills and strong understanding of dimensional modelling, star schema design, data marts, KPI definitions, and analytics-ready datasets
Experience with Snowflake or modern cloud data warehouse platforms supporting scalable reporting and analytics solutions
Proven ability to improve BI performance, reliability, usability, and adoption across large or complex datasets
Strong knowledge of data governance, security, access controls, data quality, lineage, documentation, and report certification practices
Experience supporting BI modernization, migration, rationalization, or standardization across enterprise reporting platforms
Working knowledge of delivery practices such as Agile, source control, deployment pipelines, testing, and release management
Excellent communication, stakeholder management, facilitation, and storytelling skills
Demonstrated ability to mentor others, lead design discussions, influence standards, and collaborate effectively across functions
Bachelor’s or Master’s degree in Computer Science, Engineering, Information Systems, Data Analytics, or a related field, or equivalent practical experience
Technical Skills
BI Platforms & Visualization: Visualization/Enterprise BI tool platforms, Agentic BI, paginated reports, dashboard design, report automation
Semantic Modeling: Power BI semantic models, DAX, calculation groups, star schema design, governed metrics, reusable datasets
Data Platforms:

> History, not a promise: past H-1B filings do not mean an employer will sponsor you or a given role. Data: U.S. DOL OFLC LCA disclosure (FY2024–FY2026 for role counts, certified LCAs) and the USCIS H-1B Employer Data Hub. Not legal advice. Methodology: https://visajobs.io/methodology
