> Markdown version of [/jobs/ext/2947003-lead-bi-engineer](https://www.wearedevelopers.com/jobs/ext/2947003-lead-bi-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Lead BI Engineer

- **Company:** Franklin Templeton Investor Services, LLC
- **Location:** Baltimore, MD, United States
- **Experience:** Expert
- **Salary:** $128,100.0 - $150,800.0
- **Contract:** Permanent contract
- **Skills:** Agile Methodology, Artificial Intelligence, Business Analytics Applications, Data Analysis, Systems Engineering, Automation of Tests, Business Intelligence Development, Big Data, Cloud Database, Information Systems, Data Validation, Information Engineering, Data Governance, Extract Transform Load (ETL), Data Mart, Data Visualization, Data Warehousing, DevOps, Dimensional Modeling, Github, Python (Programming Language), Metadata, MicroStrategy, Performance Tuning, Productivity Software, Query Optimization, Release Management, Power BI, SQL Databases, Sql Optimization, Delivery Pipeline, Snowflake, Prompt Engineering, Gitlab, Git, Information Technology, Data Analytics, Star Schema, Data Management, Data Lakehouse, Software Version Control, Data Pipelines
- **Published:** September 16, 2026
- **Apply:** https://www.careerjet.com/job/us30393a0f229d7e5890850ac2a55bad43/eaa

## About the 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.

## Description

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, MANTECH is seeking a motivated, career-driven, and customer-focused Senior Systems Engineer to join our team in Laurel, MD. You will play a critical role in supporting the enterp…

 + 4 days ago


## Related Videos

- [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94)
- [WeAreDevelopers LIVE - Modern DevOps for IoT Devices and More](https://www.wearedevelopers.com/videos/1805-wearedevelopers-live-modern-devops-for-iot-devices-and-more)
- [Innovating Developer Tools with AI: Insights from GitHub Next](https://www.wearedevelopers.com/videos/1268-innovating-developer-tools-with-ai-insights-from-github-next)
- [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt)
- [Git for Code Reviews](https://www.wearedevelopers.com/videos/429-git-for-code-reviews)
- [Bringing AI Model Testing and Prompt Management to Your Codebase with GitHub Models](https://www.wearedevelopers.com/videos/1536-bringing-ai-model-testing-and-prompt-management-to-your-codebase-with-github-models)

## Related Articles

- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)
- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [Best Companies to Work For in Berlin: Top 14 Companies in 2023 ](https://www.wearedevelopers.com/magazine/188-best-companies-to-work-for-in-berlin-top-14-companies-in-2023)
- [Best Coding Boot Camps in Germany](https://www.wearedevelopers.com/magazine/237-best-coding-boot-camps-in-germany)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)