Lead Engineer — Reporting/BI Engineering

insightsoftware, LLC; North Carolina; Hybrid; USD 124,000 - 156,000; Full time

Job summary

insightsoftware, LLC in North Carolina is seeking a Lead Engineer for Reporting/BI Engineering. In this role, you'll lead a scrum team focusing on enhancing the Certent Equity Management platform's reporting capabilities. Responsibilities include both hands-on technical work and team leadership, ensuring high-quality delivery and client engagement.

The ideal candidate will have 8-10+ years of software engineering experience, deep SQL expertise, and familiarity with BI tools. The position offers a competitive salary and a commitment to equal employment opportunity.

Qualifications

• 8-10+ years of hands-on software engineering, specializing in BI, reporting, and SQL.
• Deep expertise in Oracle SQL and PL/SQL, along with experience in query optimization.
• Hands-on experience with BI tooling and designing effective reporting solutions.

Responsibilities

• Lead a scrum team focused on building and enhancing reporting capabilities.
• Manage engineering decisions, setting priorities, and ensuring quality delivery.
• Engage with client stakeholders to gather and clarify reporting requirements.

Skills

Hands-on software engineering experience

Deep Oracle SQL and PL/SQL expertise

BI tooling experience (Power BI, Tableau)

Technical lead experience

Fluent communication skills

Agile mindset with AI tools

Education

Bachelor’s degree in Computer Science or Engineering

Tools

GitHub Copilot

Microsoft technology stack (C#, .NET, Azure)

Job description

About the Role

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, your responsibilities split between hands-on technical work and leading the team — setting priorities, unblocking teammates, running scrum ceremonies, and holding the team accountable for high-quality delivery. You will also partner closely with the Sr Engineering Manager and interface directly with client stakeholders.

Responsibilities

Technical Leadership & 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 — SQL, Oracle, and the application tier — as an active, hands-on member of the team.
• Lead sprint ceremonies as scrum master: planning, refinement, daily stand-ups, demos, and retrospectives.
• Set daily priorities for the team; actively unblock teammates by removing dependencies, clarifying requirements, and resolving technical ambiguity.
• Hold the team accountable to engineering standards — query performance benchmarks, code review discipline, definition of done, and release readiness.

SQL & 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: 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; drive adoption of query review practices and performance benchmarks as part of definition of done.

AI-First Engineering Champion

• Target ≥50% AI-authored pull requests and ≥95% AI code review adoption as minimums for your team.
• Model an agentic development mindset — integrating AI tooling into your own workflow and coaching teammates to do the same.
• Push the team beyond baseline AI adoption into workflows and practices that improve delivery velocity and reporting quality.
• Stay current on agentic development tooling and bring forward-looking recommendations to the Sr Engineering Manager.

Team Leadership & People Management

• Directly manage four to five engineers, owning 1:1s, performance feedback, career development conversations, and day-to-day engagement.
• Partner with the Sr Engineering Manager on hiring decisions, onboarding, and performance management for the team.
• Identify and grow technical talent within your squad, coaching engineers on BI/SQL skills and professional development.
• Foster a collaborative, high-accountability culture that takes quality seriously and supports each other's success.

Client Engagement & Requirements

• Interface directly with client stakeholders on reporting requirements, asking the right questions, digging into root business problems, and challenging one-off solutions.
• Advocate for reporting solutions that solve the client's use cases while working generically across the broader CEM platform and client base.
• Partner with the Sr Engineering Manager and Product Management to ensure 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.

Qualifications

• 8-10+ years of hands-on software engineering experience, specializing in BI, reporting, and SQL development in enterprise SaaS environments.
• Deep Oracle SQL and PL/SQL expertise — query tuning, execution plan optimization, indexing strategies, materialized views, and large-dataset performance optimization.
• 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 (Power BI, Tableau, Cognos, or similar) and the ability to design effective reporting solutions against complex data models.
• Demonstrated experience in a technical lead or lead engineer capacity — setting priorities, running ceremonies, and holding teammates accountable.
• Demonstrated AI-first engineering mindset — hands-on experience with agentic development tooling (GitHub Copilot, Devin.AI, or similar) and a track record of driving AI adoption within an engineering team.
• Experience with direct people-management responsibilities — performance feedback, career development, and team engagement for a small team of engineers.
• Familiarity with Microsoft technology stack — 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 communication skills, able to engage credibly and directly with client stakeholders on complex reporting requirements and translate technical realities clearly.
• Experience working in global, distributed teams across multiple time zones.
• Bachelor’s degree in Computer Science, Engineering, or equivalent work experience.
• (Preferred) Direct hands-on experience with Logi Analytics (now Logi Symphony).
• (Preferred) Experience designing data cube architectures and pre-aggregation strategies to reduce real-time query load on non-flattened hierarchical data models.
• (Preferred) Experience with Oracle read-optimization patterns — materialized views, query rewrite, result cache, and analytical functions.
• (Preferred) Familiarity with Azure cloud data services and cloud-native reporting patterns.
• (Preferred) Background in financial services, equity compensation, or adjacent regulated domains where reporting accuracy and auditability are critical.
• (Preferred) Certified Scrum Master (CSM) or equivalent Agile certification.
• (Preferred) Experience mentoring mid-level engineers into senior or lead roles.

Compensation

Salary range in the United States of America: $124,000.00 to $156,000.00 annually. Your specific offer within this range will be determined by your skills, experience, and qualifications. For non-sales roles, you may be eligible for a bonus. For sales roles, this range includes a commission target.

Equal Opportunity Statement

All your information will be kept confidential according to EEO guidelines. insightsoftware is committed to equal employment opportunity regardless of race, color, ethnicity, ancestry, religion, national origin, gender, sex, gender identity or expression, sexual orientation, age, citizenship, marital or parental status, disability, veteran status, or other class protected by applicable law. We are proud to be an equal-opportunity workplace.