Lead Engineer – Reporting, BI Engineering

insightsoftware

Lead Engineer in Reporting/BI Engineering at insightsoftware, overseeing technical leadership and team delivery for BI capabilities. Engaging with clients and driving AI-first engineering practices.

Posted 5/1/2026full-timeRemote • 🇺🇸 United StatesSenior💰 $124,000 - $156,000 per yearWebsite

Tech Stack

Tools & technologies

AzureCloudCognos.NETOracleSQLTableau

About the role

Key responsibilities & impact

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 standups, 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
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 that are 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
Champion ≥50% AI-authored PR targets and ≥95% AI code review adoption as organizational minimums for your team
Model an agentic development mindset — 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

Requirements

What you’ll need

8-10+ years of hands-on software engineering experience with a strong specialization 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
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 — 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 — 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 communicator — 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

Benefits

Comp & perks

For non-sales roles, you may be eligible for a bonus
For sales roles, this range includes a commission target
We are committed to pay transparency and fair compensation practices

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLOracle SQLPL/SQLquery tuningexecution plan optimizationindexing strategiesmaterialized viewsreal-time reporting optimizationBI developmentAI tooling

Soft Skills

leadershipcommunicationteam accountabilityproblem-solvingcoachingprioritizationperformance feedbackteam engagementagentic development mindsetcollaboration

Certifications

Bachelor's degree in Computer ScienceBachelor's degree in Engineering