Back to jobs

Lead Engineer — Reporting/BI Engineering

Pay
USD 124,000–156,000/year — pay source
Experience mentoring mid-level engineers into senior or lead roles. The salary range in United States of America for this position is 124,000.00 to 156,000.00 USD Annual. 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.
Read the full posting
Work setting
Remote — work setting source
Listed location: USA - Remote
Read the full posting
Employment
Full-time — employment source
Employment type in the employer’s posting: Full time
From the employer’s posting

What you’ll work on

Full posting
  • Write and review production SQL and Oracle code across the BI and reporting stack

  • Tune slow queries and rebuild real-time data cube queries into optimized solutions

  • Run sprint ceremonies as scrum master and set the team's daily priorities

  • Manage four to five engineers, including 1:1s, feedback and career development

  • Interface with client stakeholders on reporting requirements

From the employer’s posting
Write, review, and contribute production-quality code across the BI and reporting stack — SQL, Oracle, and the application tier
Diagnose and rebuild poorly performing SQL — including real-time data cube queries against non-flattened hierarchical data models
Lead sprint ceremonies as scrum master: planning, refinement, daily standups, demos, and retrospectives.
Directly manage four to five engineers — owning 1:1s, performance feedback, career development conversations, and day-to-day engagement.
Interface directly with client stakeholders on reporting requirements

What you’ll bring

All qualifications

Core experience

  • 8-10+ years of hands-on software engineering experience with a strong specialization in BI, reporting, and SQL development in enterprise SaaS environments.
  • Experience designing data cube architectures and pre-aggregation strategies to reduce real-time query load on non-flattened hierarchical data models.
  • Demonstrated experience diagnosing and rebuilding poorly performing SQL against complex, non-flattened relational data models — including real-time reporting query optimization.
  • Experience with Oracle read-optimization patterns — materialized views, query rewrite, result cache, and analytical functions.
  • 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.
  • Familiarity with Azure cloud data services and cloud-native reporting patterns.
Qualification wording
8-10+ years of hands-on software engineering experience with a strong specialization in BI, reporting, and SQL development in enterprise SaaS environments.
Experience designing data cube architectures and pre-aggregation strategies to reduce real-time query load on non-flattened hierarchical data models.
Demonstrated experience diagnosing and rebuilding poorly performing SQL against complex, non-flattened relational data models — including real-time reporting query optimization.
Experience with Oracle read-optimization patterns — materialized views, query rewrite, result cache, and analytical functions.
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.
Familiarity with Azure cloud data services and cloud-native reporting patterns.

About Magnitudesoftware

insightsoftware is a global provider of reporting, analytics, and performance management solutions that unlock the potential of business data and transform the way finance and data teams operate.

In the employer’s words · Read in context

Apply at Magnitudesoftware

Posting record

Report an error

Open 6 monthsWe first saw this posting 198 days ago and it is still up. Roles open this long are often slow to fill or kept open to collect applications.

Status in our records
Live
First seen by us
May 7, 2026198 days ago
Recorded sightings
198
Last seen by us
Nov 15, 2026
Employer says posted
Apr 30, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Pay

In line with similar jobs

$124K–$156K against $95K–$145K, the middle half of what similar US postings state.

From 2,327 postings in the last year. Stated ranges, not salaries paid.

Time since we first saw it

Day 198

Up longer than most. Similar jobs usually come down between day 5 and day 43.

Well past Magnitudesoftware’s usual: its jobs come down by about day 41.

From 16,009 similar postings that came down, and 7 of Magnitudesoftware’s. Coming down is not always a hire.

Magnitudesoftware is hiring

1 open job

  • No new data jobs since August
  • Takes jobs down at a usual pace
Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • C#
  • PL/SQL
  • SQL
  • Azure
  • Cognos
  • Oracle
  • Power BI
  • Tableau
Where the posting names them
- 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.
- 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.
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 IC 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 also 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 — 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.
- 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.
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 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. AI-First Engineering
- Partner with the Sr Engineering Manager on hiring decisions, onboarding, and performance management for your team. - Identify and grow technical talent within your squad — coaching engineers on both BI/SQL technical skills and professional development. - Foster a collaborative, high-accountability team culture that takes quality seriously and supports each other's success.
Required - 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.
- 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.
- 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 with Oracle read-optimization patterns — 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 adjacent regulated domains where reporting accuracy and auditability are critical.
- 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.
- 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 — materialized views, query rewrite, result cache, and analytical functions. - Familiarity with Azure cloud data services and cloud-native reporting patterns.

Your next step

Complete your application on magnitudesoftware.wd1.myworkdayjobs.com. The employer’s form will show what is required.

Applying through Workday

  • You create an account with each employer before you can upload anything. Every Workday employer has its own account, so one sign-up doesn’t carry over.
  • “Autofill with Resume” comes right after sign-in, before the My Information and My Experience steps. Check every field it fills in those steps, since that’s what recruiters see.
  • Your application status lives in that employer’s Candidate Home, under the same sign-in.

Already applied? Track this application

Job description

View original posting ↗

About Us:


insightsoftware is a global provider of reporting, analytics, and performance management solutions that unlock the potential of business data and transform the way finance and data teams operate. We empower leaders from over 32,000 organizations to make timely and intelligent decisions. Our comprehensive solutions span Financial Planning and Analysis (FP&A), Controllership, and Data and Analytics. We deliver finance teams the insights required to navigate any economic climate and drive greater financial intelligence, while increasing productivity, visibility, accuracy, and compliance. Learn more at insightsoftware.com.

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 IC 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 also 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 & 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 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.
     

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 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.
     

AI-First Engineering

  • 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.
  • 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 your team.
  • Identify and grow technical talent within your squad — coaching engineers on both BI/SQL technical skills and professional development.
  • Foster a collaborative, high-accountability team 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 requests that represent one-off solutions rather than platform-generic capabilities.
  • 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 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.
Qualifications

Required

  • 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.
     

Preferred

  • Direct hands-on experience with Logi Analytics (now Logi Symphony) — this is a significant differentiator.
  • 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 — 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 adjacent regulated domains where reporting accuracy and auditability are critical.
  • Certified Scrum Master (CSM) or equivalent Agile certification.
  • Experience mentoring mid-level engineers into senior or lead roles.

 

 

 

The salary range in United States of America for this position is 124,000.00 to 156,000.00 USD Annual.

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.

We are committed to pay transparency and fair compensation practices. If you have questions about our compensation approach, please don't hesitate to ask during the interview process.

Additional Information

All your information will be kept confidential according to EEO guidelines.

Learn more about our high-energy, high-performance global team: Work With Us

insightsoftware About Us: Hear From Our Team

Background checks are required for employment with insightsoftware, where permitted by country, state/province.

At insightsoftware, we are 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.

Demand for Analyst roles

New Analyst postings at the employers we follow are up 26% over the last 6 weeks compared with the 6 before.

Weekly new Analyst postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 993, the most 1,510, and the latest week had 1,367.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Analyst, by the work the posting describes.

Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.

Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.

Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay
Experience mentoring mid-level engineers into senior or lead roles. The salary range in United States of America for this position is 124,000.00 to 156,000.00 USD Annual. 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.
Location & working pattern

USA - Remote

Working pattern and location restrictions need checking in the full posting.

Work authorization
Background checks are required for employment with insightsoftware, where permitted by country, state/province. At insightsoftware, we are 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.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.