Lead BI 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 BI EngineerAbout the TeamEnterprise 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 RoleWe 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 valueLead the design and delivery of enterprise BI solutions, including dashboards, scorecards, semantic models, curated datasets, and self-service reporting productsPartner with business stakeholders to understand priorities, define KPIs, translate requirements, and deliver clear, actionable insightsDesign, build, and optimize Power BI semantic models, DAX measures, dataflows, and reporting layers for performance, usability, and maintainabilityDevelop analytics-ready datasets using SQL, Snowflake, and modern data modeling practices to support enterprise reporting and decision-makingEstablish and promote BI standards for metric definitions, report certification, documentation, naming conventions, data quality, and access controlsImprove BI performance and reliability through query optimization, model tuning, refresh monitoring, and capacity-aware designCollaborate with data engineering, analytics, and platform teams to strengthen upstream data pipelines, data marts, governance, and lineageSupport BI modernization efforts, including migration and rationalization of legacy reporting assets into strategic enterprise platformsLeverage AI-assisted tools and automation to improve BI development, documentation, troubleshooting, and delivery efficiencyProvide technical leadership, mentoring, design reviews, and best-practice guidance to BI developers, analysts, and cross-functional partnersModern BI & AI EnablementAI-Assisted DeliveryUse AI-enabled tools responsibly to accelerate BI development, prompt engineering/DAX/SQL authoring, testing, documentation, and modernizationApply AI-assisted techniques to analyze requirements, draft metric definitions, identify data quality gaps, and improve dashboard rationalizationUse clear prompts, validation practices, and review patterns to improve the consistency, accuracy, and maintainability of BI assetsStay current with emerging analytics capabilities, including natural language querying, semantic model assistants, automated insights, and intelligent observabilityOperational ExcellenceUse monitoring and observability practices to proactively manage usage, adoption, failures, data freshness, and performance trendsCreate and maintain documentation, lineage summaries, release notes, and support artifacts that improve transparency and operational supportContinuously improve dashboard performance, refresh reliability, query efficiency, and semantic model qualityWhat will help you be successful in this role8+ years of experience in business intelligence, analytics engineering, data engineering, or enterprise reporting, including experience leading BI solution deliveryArchitecting Visualization/Enterprise BI platform solutions, Power BI, DAX, dimensional modelling, KPI design, and data visualization best practicesAbility 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 datasetsExperience with Snowflake or modern cloud data warehouse platforms supporting scalable reporting and analytics solutionsProven ability to improve BI performance, reliability, usability, and adoption across large or complex datasetsStrong knowledge of data governance, security, access controls, data quality, lineage, documentation, and report certification practicesExperience supporting BI modernization, migration, rationalization, or standardization across enterprise reporting platformsWorking knowledge of delivery practices such as Agile, source control, deployment pipelines, testing, and release managementExcellent communication, stakeholder management, facilitation, and storytelling skillsDemonstrated ability to mentor others, lead design discussions, influence standards, and collaborate effectively across functionsBachelor’s or Master’s degree in Computer Science, Engineering, Information Systems, Data Analytics, or a related field, or equivalent practical experienceTechnical SkillsBI Platforms & Visualization: Visualization/Enterprise BI tool platforms, Agentic BI, paginated reports, dashboard design, report automationSemantic Modeling: Power BI semantic models, DAX, calculation groups, star schema design, governed metrics, reusable datasetsData Platforms: Snowflake, cloud data warehouses, data marts, data lakehouse concepts, curated analytics datasetsData Engineering & Querying: Advanced SQL, Python preferred, ETL/ELT concepts, pipeline troubleshooting, performance tuningGovernance & Quality: Data quality checks, lineage, documentation, role-based access, certified reports, metric governanceDevOps & Delivery: Git, GitLab/GitHub, deployment pipelines, release management, Agile delivery, automated testing conceptsPreferred QualificationsExperience with Visualization BI tools like Power BI, deployment pipelinesExperience with MicroStrategy, BO, or legacy BI modernization and migration to Power BIFamiliarity with AI-assisted analytics, natural language querying, automated insight generation, or BI productivity toolsPython experience for automation, data validation, metadata extraction, or reporting operationsDomain knowledge in financial services, investment data, asset management, or enterprise operations reportingWork Schedule & LocationThis 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.#LI-Hybrid ##MID_SENIOR_LEVELAt 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.Job SummaryJob number: Profession: Technology