{"schemaVersion":"jobsearcher.job.v1","id":"79ab13ced77b2cf3a09406c5","url":"https://jobsearcher.com/jobs/79ab13ced77b2cf3a09406c5","canonicalUrl":"https://jobsearcher.com/jobs/79ab13ced77b2cf3a09406c5","title":"Lead Engineer — Reporting/BI Engineering","description":"About Us:\n\ninsightsoftware 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.\nJob Description:\nAs 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.\nThis 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.\nYou 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.\nResponsibilities\nTechnical Leadership & Delivery\nServe 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.\nWrite, 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.\nLead sprint ceremonies as scrum master: planning, refinement, daily standups, demos, and retrospectives.\nSet daily priorities for the team; actively unblock teammates by removing dependencies, clarifying requirements, and resolving technical ambiguity.\nHold the team accountable to engineering standards — query performance benchmarks, code review discipline, definition of done, and release readiness.\n\nSQL & Reporting Performance\nDiagnose and rebuild poorly performing SQL — including real-time data cube queries against non-flattened hierarchical data models — into optimized, maintainable, production-grade solutions.\nLead Oracle query tuning and optimization initiatives: execution plan analysis, indexing strategies, materialized views, partitioning, and read-optimization patterns.\nDesign and advocate for reporting data models and query architectures that are built for BI consumption — reducing real-time computation overhead and improving report responsiveness.\nEstablish SQL quality standards for the team; drive adoption of query review practices and performance benchmarks as part of definition of done.\n\nAI-First Engineering\nChampion 50% AI-authored PR targets and\n95% AI code review adoption as organizational minimums for your team.\nModel an agentic development mindset — integrating AI tooling into your own daily workflow and actively coaching teammates to do the same.\nPush the team beyond baseline AI adoption into workflows and practices that measurably improve delivery velocity and reporting quality.\nStay current on agentic development tooling and bring forward-looking recommendations to the Sr Engineering Manager.\n\nTeam Leadership & People Management\nDirectly manage four to five engineers — owning 1:1s, performance feedback, career development conversations, and day-to-day engagement.\nPartner with the Sr Engineering Manager on hiring decisions, onboarding, and performance management for your team.\nIdentify and grow technical talent within your squad — coaching engineers on both BI/SQL technical skills and professional development.\nFoster a collaborative, high-accountability team culture that takes quality seriously and supports each other's success.\n\nClient Engagement & Requirements\nInterface 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.\nAdvocate for reporting solutions that solve the client's use cases while working generically across the broader CEM platform and client base.\nPartner with the Sr Engineering Manager and Product Management to ensure reporting requirements are well-defined, properly scoped, and sequenced for delivery.\nBuild credibility with client stakeholders through delivery consistency, clear communication, and a track record of solving the right problems.\n\nCross-Functional Collaboration\nCoordinate with matrixed QA engineers to ensure test coverage, quality gates, and release readiness are met.\nCollaborate with Principal Engineers, the Solution Architect, and peer Lead Engineers on cross-team technical decisions and data architecture standards.\nSurface delivery risks, technical blockers, and scope concerns to the Sr Engineering Manager early and clearly.\nQualifications\nRequired\n8-10+ years of hands-on software engineering experience with a strong specialization in BI, reporting, and SQL development in enterprise SaaS environments.\nDeep Oracle SQL and PL/SQL expertise — query tuning, execution plan optimization, indexing strategies, materialized views, and large dataset performance optimization.\nDemonstrated experience diagnosing and rebuilding poorly performing SQL against complex, non-flattened relational data models — including real-time reporting query optimization.\nHands-on experience with enterprise BI tooling — Power BI, Tableau, Cognos, or similar — with the ability to design effective reporting solutions against complex data models.\nDemonstrated experience in a technical lead or lead engineer capacity — setting priorities, running ceremonies, and holding teammates accountable.\nDemonstrated 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.\nExperience with direct people management responsibilities — performance feedback, career development, and team engagement for a small team of engineers.\nFamiliarity with Microsoft technology stack — C#, .NET, and Azure cloud services — sufficient to engage in full-stack technical discussions.\nStrong code review discipline and engineering quality standards — including SQL review, query performance benchmarking, and definition-of-done rigor.\nFluent communicator — able to engage credibly and directly with client stakeholders on complex reporting requirements and translate technical realities clearly.\nExperience working in global, distributed teams across multiple time zones.\nBachelor's degree in Computer Science, Engineering, or equivalent work experience.\n\nPreferred\nDirect hands-on experience with Logi Analytics (now Logi Symphony) — this is a significant differentiator.\nExperience designing data cube architectures and pre-aggregation strategies to reduce real-time query load on non-flattened hierarchical data models.\nExperience with Oracle read-optimization patterns — materialized views, query rewrite, result cache, and analytical functions.\nFamiliarity with Azure cloud data services and cloud-native reporting patterns.\nBackground in financial services, equity compensation, or adjacent regulated domains where reporting accuracy and auditability are critical.\nCertified Scrum Master (CSM) or equivalent Agile certification.\nExperience mentoring mid-level engineers into senior or lead roles.\nThe salary range in United States of America for this position is 124,000.00 to 156,000.00 USD Annual.\nYour 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.\nWe 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.\nAdditional Information\nAll your information will be kept confidential according to EEO guidelines.\nLearn more about our high-energy, high-performance global team: Work With Us\ninsightsoftware About Us: Hear From Our Team\nBackground checks are required for employment with insightsoftware, where permitted by country, state/province.\nAt 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.","company":"Insight Software","rawCompany":"insight software","city":"Remote","state":"OR","isRemote":false,"isActive":false,"createdAt":"2026-08-06T13:30:47.765Z","occupations":[{"code":"15-1252.00","title":"Software Developers","slug":"software-developers"},{"code":"15-2051.01","title":"Business Intelligence Analysts","slug":"business-intelligence-analysts"},{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"}],"industries":[{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"},{"code":"513210","title":"Software Publishers","slug":"software-publishers"},{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Lead Engineer — Reporting/BI Engineering","description":"About Us:\n\ninsightsoftware 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.\nJob Description:\nAs 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.\nThis 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.\nYou 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.\nResponsibilities\nTechnical Leadership & Delivery\nServe 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.\nWrite, 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.\nLead sprint ceremonies as scrum master: planning, refinement, daily standups, demos, and retrospectives.\nSet daily priorities for the team; actively unblock teammates by removing dependencies, clarifying requirements, and resolving technical ambiguity.\nHold the team accountable to engineering standards — query performance benchmarks, code review discipline, definition of done, and release readiness.\n\nSQL & Reporting Performance\nDiagnose and rebuild poorly performing SQL — including real-time data cube queries against non-flattened hierarchical data models — into optimized, maintainable, production-grade solutions.\nLead Oracle query tuning and optimization initiatives: execution plan analysis, indexing strategies, materialized views, partitioning, and read-optimization patterns.\nDesign and advocate for reporting data models and query architectures that are built for BI consumption — reducing real-time computation overhead and improving report responsiveness.\nEstablish SQL quality standards for the team; drive adoption of query review practices and performance benchmarks as part of definition of done.\n\nAI-First Engineering\nChampion 50% AI-authored PR targets and\n95% AI code review adoption as organizational minimums for your team.\nModel an agentic development mindset — integrating AI tooling into your own daily workflow and actively coaching teammates to do the same.\nPush the team beyond baseline AI adoption into workflows and practices that measurably improve delivery velocity and reporting quality.\nStay current on agentic development tooling and bring forward-looking recommendations to the Sr Engineering Manager.\n\nTeam Leadership & People Management\nDirectly manage four to five engineers — owning 1:1s, performance feedback, career development conversations, and day-to-day engagement.\nPartner with the Sr Engineering Manager on hiring decisions, onboarding, and performance management for your team.\nIdentify and grow technical talent within your squad — coaching engineers on both BI/SQL technical skills and professional development.\nFoster a collaborative, high-accountability team culture that takes quality seriously and supports each other's success.\n\nClient Engagement & Requirements\nInterface 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.\nAdvocate for reporting solutions that solve the client's use cases while working generically across the broader CEM platform and client base.\nPartner with the Sr Engineering Manager and Product Management to ensure reporting requirements are well-defined, properly scoped, and sequenced for delivery.\nBuild credibility with client stakeholders through delivery consistency, clear communication, and a track record of solving the right problems.\n\nCross-Functional Collaboration\nCoordinate with matrixed QA engineers to ensure test coverage, quality gates, and release readiness are met.\nCollaborate with Principal Engineers, the Solution Architect, and peer Lead Engineers on cross-team technical decisions and data architecture standards.\nSurface delivery risks, technical blockers, and scope concerns to the Sr Engineering Manager early and clearly.\nQualifications\nRequired\n8-10+ years of hands-on software engineering experience with a strong specialization in BI, reporting, and SQL development in enterprise SaaS environments.\nDeep Oracle SQL and PL/SQL expertise — query tuning, execution plan optimization, indexing strategies, materialized views, and large dataset performance optimization.\nDemonstrated experience diagnosing and rebuilding poorly performing SQL against complex, non-flattened relational data models — including real-time reporting query optimization.\nHands-on experience with enterprise BI tooling — Power BI, Tableau, Cognos, or similar — with the ability to design effective reporting solutions against complex data models.\nDemonstrated experience in a technical lead or lead engineer capacity — setting priorities, running ceremonies, and holding teammates accountable.\nDemonstrated 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.\nExperience with direct people management responsibilities — performance feedback, career development, and team engagement for a small team of engineers.\nFamiliarity with Microsoft technology stack — C#, .NET, and Azure cloud services — sufficient to engage in full-stack technical discussions.\nStrong code review discipline and engineering quality standards — including SQL review, query performance benchmarking, and definition-of-done rigor.\nFluent communicator — able to engage credibly and directly with client stakeholders on complex reporting requirements and translate technical realities clearly.\nExperience working in global, distributed teams across multiple time zones.\nBachelor's degree in Computer Science, Engineering, or equivalent work experience.\n\nPreferred\nDirect hands-on experience with Logi Analytics (now Logi Symphony) — this is a significant differentiator.\nExperience designing data cube architectures and pre-aggregation strategies to reduce real-time query load on non-flattened hierarchical data models.\nExperience with Oracle read-optimization patterns — materialized views, query rewrite, result cache, and analytical functions.\nFamiliarity with Azure cloud data services and cloud-native reporting patterns.\nBackground in financial services, equity compensation, or adjacent regulated domains where reporting accuracy and auditability are critical.\nCertified Scrum Master (CSM) or equivalent Agile certification.\nExperience mentoring mid-level engineers into senior or lead roles.\nThe salary range in United States of America for this position is 124,000.00 to 156,000.00 USD Annual.\nYour 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.\nWe 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.\nAdditional Information\nAll your information will be kept confidential according to EEO guidelines.\nLearn more about our high-energy, high-performance global team: Work With Us\ninsightsoftware About Us: Hear From Our Team\nBackground checks are required for employment with insightsoftware, where permitted by country, state/province.\nAt 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.","datePosted":"2026-08-06T13:30:47.765Z","dateModified":"2026-08-06T13:30:47.765Z","hiringOrganization":{"@type":"Organization","name":"Insight Software","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Remote","addressRegion":"OR","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"79ab13ced77b2cf3a09406c5"},"url":"https://jobsearcher.com/jobs/79ab13ced77b2cf3a09406c5"}}