Lead Engineer – Reporting​/BI Engineering

Job Description

As a Lead Engineer in Reporting / BI Engineering, you will own the day-to-day technical leadership of a small scrum team focused on building and enhancing the reporting and business intelligence capabilities of the Certent Equity Management (CEM) platform for a large, strategic enterprise client engagement. Reporting to the Sr. Engineering Manager, you will split your time roughly equally between hands‑on technical work and leading your team, setting priorities, unblocking teammates, running scrum ceremonies, and holding the team accountable for high-quality delivery.

This is both an individual contributor role and a management role. The right candidate is a seasoned engineer with deep BI and SQL expertise who leads by doing‑ someone whose technical credibility earns the team’s respect and whose organizational discipline keeps delivery on track. You will be the daily technical authority for your squad and will also be responsible for their career development.

You will partner closely with the Sr. Engineering Manager on delivery planning and escalations and will interface directly with client stakeholders. This role carries a higher degree of client‑facing responsibility than a typical engineering lead.

You will bring an AI‑first mindset, not just complying with organizational AI adoption targets, but genuinely integrating agentic development tooling into how you and your team work every day.

• Serve as the technical authority for your scrum team, making day‑to‑day engineering decisions, setting the bar for code quality, and ensuring the team delivers high-quality reporting solutions on schedule.
• Write, review, and contribute production‑quality code across the BI and reporting stack, including SQL, Oracle, and the application tier, as an active, hands‑on member of the team.
• Lead sprint ceremonies as scrum master, including sprint planning, backlog refinement, daily standups, demos, and retrospectives.
• Set daily priorities for the team and actively unblock teammates by removing dependencies, clarifying requirements, and resolving technical ambiguity.
• Hold the team accountable to engineering standards, including query performance benchmarks, code review discipline, definition of done, and release readiness.

• Diagnose and rebuild poorly performing SQL, including real‑time data cube queries against non‑flattened hierarchical data models, into optimized, maintainable, production‑grade solutions.
• Lead Oracle query tuning and optimization initiatives, including execution plan analysis, indexing strategies, materialized views, partitioning, and read‑optimization patterns.
• Design and advocate for reporting data models and query architectures built for BI consumption, reducing real‑time computation overhead and improving report responsiveness.
• Establish SQL quality standards for the team and drive adoption of query review practices and performance benchmarks as part of definition of done.

• Champion organizational minimums of at least 50 percent AI‑authored pull requests and 95 percent AI‑assisted code review adoption.
• Model an agentic development mindset by integrating AI tooling into your own daily workflow and actively coaching teammates to do the same.
• Push the team beyond baseline AI adoption into workflows and practices that measurably improve delivery velocity and reporting quality.
• Stay current on agentic development tooling and provide forward‑looking recommendations to the Sr. Engineering Manager.

• Directly manage four to five engineers, owning one‑on‑one meetings, performance feedback, career development conversations, and day‑to‑day engagement.
• Partner with the Sr. Engineering Manager on hiring decisions, onboarding, and performance management.
• Identify and grow technical talent within your squad, coaching engineers on both BI and SQL technical skills as well as professional development.
• Foster a collaborative, high‑accountability team culture that takes quality seriously and supports shared success.

• Interface directly with client…