Lead BI Engineer

Franklin Templeton; Baltimore (MD); Hybrid; USD 128,000 - 151,000; Full time

Benefits offered by this job

Paid Time Off

Health Coverage

401(k) match

Employee Stock Purchase Plan

LEAP education assistance

Job summary

Franklin Templeton seeks a Lead BI Engineer to drive the design, development, optimization, and governance of enterprise BI solutions. You will lead delivery of high-impact BI products including Power BI dashboards, semantic models, certified datasets, and self-service reporting capabilities.

The role combines strong technical skills with business partnership, delivery ownership, and influence across teams, with a hybrid schedule in Baltimore, MD.

Qualifications

• 8+ years of experience in business intelligence, analytics engineering, data engineering, or enterprise reporting.
• Architecting Visualization/Enterprise BI platform solutions and data visualization best practices.
• Strong SQL skills and knowledge of dimensional modelling, KPI design, and data governance.

Responsibilities

• Lead the design and delivery of enterprise BI solutions, including dashboards, semantic models, and self-service reporting products.
• Partner with business stakeholders to define KPIs, translate requirements, and deliver actionable insights.
• Establish BI standards for metric definitions, report certification, documentation, and access controls.
• Mentor BI developers and collaborate across data engineering, analytics, and platform teams.

Skills

BI experience

SQL

Data governance

Agile delivery

Stakeholder management

Mentoring

Power BI

Education

Bachelor’s or Master’s degree in CS/Engineering/IS/Data Analytics

Tools

Power BI

Snowflake

Python

Job 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: Snowflake, cloud data warehouses, data marts, data lakehouse concepts, curated analytics datasets

Data Engineering & Querying: Advanced SQL, Python preferred, ETL/ELT concepts, pipeline troubleshooting, performance tuning

Governance & Quality: Data quality checks, lineage, documentation, role-based access, certified reports, metric governance

DevOps & Delivery: Git, GitLab/GitHub, deployment pipelines, release management, Agile delivery, automated testing concepts

Preferred Qualifications

• Experience with Visualization BI tools like Power BI, deployment pipelines
• Experience with MicroStrategy, BO, or legacy BI modernization and migration to Power BI
• Familiarity with AI-assisted analytics, natural language querying, automated insight generation, or BI productivity tools
• Python experience for automation, data validation, metadata extraction, or reporting operations
• Domain knowledge in financial services, investment data, asset management, or enterprise operations reporting

Work Schedule & Location

• This role will work a hybrid schedule 3 days/week in our Baltimore, MD office.

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 – $150,800, 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.