Lead Engineer – Reporting / BI Engineering

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.

Responsibilities
Technical Leadership and Delivery
• 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.

SQL and Reporting Performance
• 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.

AI-First Engineering
• 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.

Team Leadership and People Management
• 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.

Client Engagement and Requirements
• Interface directly with client stakeholders on reporting requirements, asking the right questions, digging into root business problems, and challenging requests that represent one-off solutions rather than platform-generic capabilities.
• Advocate for reporting solutions that solve client use cases while working generically across the broader CEM platform and client base.
• Partner with the Sr. Engineering Manager and Product Management to ensure reporting requirements are well-defined, properly scoped, and sequenced for delivery.
• Build credibility with client stakeholders through delivery consistency, clear communication, and a track record of solving the right problems.

Cross-Functional Collaboration
• Coordinate with matrixed QA engineers to ensure test coverage, quality gates, and release readiness are met.
• Collaborate with Principal Engineers, the Solution Architect, and peer Lead Engineers on cross-team technical decisions and data architecture standards.
• Surface delivery risks, technical blockers, and scope concerns to the Sr. Engineering Manager early and clearly.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com.To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.

• 8–10+ years of hands-on software engineering experience with strong specialization in BI, reporting, and SQL development in enterprise SaaS environments.
• Deep Oracle SQL and PL/SQL expertise, including query tuning, execution plan optimization, indexing strategies, materialized views, and large dataset performance optimization.
• Demonstrated experience diagnosing and rebuilding poorly performing SQL against complex, non-flattened relational data models, including real-time reporting query optimization.
• Hands-on experience with enterprise BI tooling such as Power BI, Tableau, Cognos, or similar, with the ability to design effective reporting solutions against complex data models.
• Demonstrated experience in a technical lead or lead engineer capacity, including setting priorities, running ceremonies, and holding teammates accountable.
• Demonstrated AI-first engineering mindset with hands-on experience using agentic development tooling such as GitHub Copilot, Devin.AI, or similar, and a track record of driving AI adoption within an engineering team.
• Experience with direct people management responsibilities, including performance feedback, career development, and team engagement.
• Familiarity with the Microsoft technology stack, including C#, .NET, and Azure cloud services, sufficient to engage in full-stack technical discussions.
• Strong code review discipline and engineering quality standards, including SQL review, query performance benchmarking, and definition-of-done rigor.
• Fluent communicator able to engage credibly and directly with client stakeholders on complex reporting requirements and clearly translate technical realities.
• Experience working with global, distributed teams across multiple time zones.
• Bachelor’s degree in Computer Science, Engineering, or equivalent work experience.

• Direct hands-on experience with Logi Analytics (Logi Symphony).
• Experience designing data cube architectures and pre-aggregation strategies to reduce real-time query load on non-flattened hierarchical data models.
• Experience with Oracle read-optimization patterns, including materialized views, query rewrite, result cache, and analytical functions.
• Familiarity with Azure cloud data services and cloud-native reporting patterns.
• Background in financial services, equity compensation, or other regulated domains where reporting accuracy and auditability are critical.
• Certified Scrum Master or equivalent Agile certification.
Experience mentoring mid-level engineers into senior or lead roles.

Benefit packages for this role will start on the 1st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.