Lead Engineer – Reporting, BI Engineering

Job not on LinkedIn

🕒 May 1

🌐 United States, Canada – Remote

🇺🇸 United States – Remote 🇨🇦 Canada – Remote

💵 $124k - $156k / year

⏰ Full Time

🟠 Senior

📊 Business Intelligence Developer

🦅 H1B Visa Sponsor

This company has sponsored H1B visas in the past.

👻 Ghost score 30%

What it means: how likely this posting is sitting open without active hiring.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

insightsoftware

WebsiteLinkedInAll Job Openings

1001 - 5000 employees

☁️ SaaS

💸 Finance

🏢 Enterprise

💰 $798.6M Private Equity Round - insightsoftware on 2021-07

SaaS • Finance • Enterprise

insightsoftware is a provider of financial and operational reporting software and data analytics solutions for the Office of the CFO. Its cloud-enabled platform and pre-built connectors integrate with major ERPs (Oracle, SAP, Microsoft and 140+ others) to deliver financial reporting, budgeting/planning, consolidation, tax and lease lifecycle management, embedded analytics, and automation tools. The company serves finance, accounting, and operations teams with AI-enabled features, data virtualization, and turnkey templates to accelerate reporting, planning, and compliance.

📋 Description

• 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

• 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

• 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