Note: The job is a remote job and is open to candidates in USA. insightsoftware is a global provider of reporting, analytics, and performance management solutions that unlock the potential of business data. They are seeking a Senior Software Engineer to contribute to the reporting and business intelligence capabilities of the Certent Equity Management platform, focusing on database-heavy development using Oracle SQL and PL/SQL.
Responsibilities
- Implement new reporting features, enhancements, and bug fixes — owning your work items from requirements through production under the technical direction of the Lead Engineer
- Write, optimize, and maintain complex Oracle SQL and PL/SQL — stored procedures, packages, functions, triggers, and views — that power financial reports and BI output across the CEM platform
- Diagnose and resolve poorly performing queries — analyzing execution plans, applying indexing strategies, and rebuilding problematic SQL against complex, non-flattened hierarchical data models into optimized, maintainable solutions
- Design and implement reporting data structures that are built for BI consumption — reducing real-time computation overhead and improving report responsiveness under the architectural direction of the Lead Engineer
- Build and maintain reporting solutions using enterprise BI tooling — contributing to Logi Analytics (Logi Symphony) reports and dashboards against CEM data models
- Contribute C#/.NET application-tier code for reporting services, data access layers, and integrations that support BI output
- Participate actively in agile ceremonies — sprint planning, refinement, standups, demos, and retrospectives
- Leverage AI tooling actively throughout development — from accelerating SQL authoring and query optimization analysis to generating application-tier code, tests, and documentation
- Apply query performance best practices in all work — writing SQL that is correct, readable, and optimized from the start rather than treating performance as a post-delivery concern
- Participate actively in SQL code reviews — applying and contributing to the team’s query performance benchmarks and review standards under the Lead Engineer’s direction
- Support Oracle performance optimization initiatives — contributing to execution plan analysis, index assessment, and materialized view evaluation as directed by the Lead Engineer
- Validate data accuracy end-to-end — ensuring that report output matches source data correctly and that query logic handles edge cases, nulls, and hierarchical traversal without silent errors
- Champion ≥50% AI-authored PR targets and ≥95% AI code review adoption as organizational minimums
- Integrate agentic development tooling — GitHub Copilot, Claude Code, Devin.AI, or similar — into your daily workflow as a genuine force multiplier, including for SQL authoring, query analysis, and application-tier development
- Use AI to accelerate delivery, improve code quality, expand test coverage, and push the boundaries of what you can accomplish as an individual contributor
- Stay current on emerging agentic development tooling and share forward-looking practices with your team
- Build quality into all tasks — write thorough unit tests, validate query correctness against expected data sets, and support QA engineers in testing completed reporting work
- Participate in code and SQL reviews — using AI-assisted review practices to provide thorough, actionable feedback and holding work to the quality standards set by the Lead Engineer
- Follow and contribute to engineering standards — SQL coding patterns, query review practices, CI/CD processes, definition of done, and release readiness
- Ensure reporting accuracy and auditability — understanding the compliance implications of financial data and treating data correctness as a hard requirement, not a best effort
- Work closely with the Lead Engineer, product management, QA, and peer engineers to ensure clarity of reporting requirements and alignment on solution design
- Surface technical blockers, delivery risks, and data model questions to your Lead Engineer or Sr Engineering Manager early and clearly
- Mentor junior engineers on Oracle SQL and PL/SQL best practices, BI development patterns, AI-first development workflows, and professional growth
- Coordinate with matrixed QA engineers to support test coverage and data validation for reporting features you own
Skills
- 6+ years of hands-on software engineering experience with a strong specialization in SQL development, reporting, or BI in enterprise SaaS environments
- Deep Oracle SQL and PL/SQL proficiency — stored procedures, packages, functions, triggers, views, and complex multi-join queries against large datasets. This is the primary skill requirement for this role
- Demonstrated experience diagnosing and optimizing poorly performing SQL — reading execution plans, applying indexing strategies, and rebuilding queries against complex relational data models
- Experience with Oracle-specific performance features — execution plan analysis, index types, hints, and query tuning at production scale
- Demonstrated AI-first engineering mindset — hands-on experience with agentic development tooling such as GitHub Copilot, Claude Code, Devin.AI, or similar, with a track record of integrating AI into daily development workflows
- Experience with enterprise BI tooling — Power BI, Tableau, Cognos, Logi Analytics, or similar — building reports and dashboards against complex relational data models
- Familiarity with C# and .NET — sufficient to contribute to application-tier reporting services and data access code
- Experience validating data accuracy end-to-end — ensuring report output matches source data and query logic handles edge cases correctly
- Experience working within agile/scrum teams — participating in ceremonies and contributing to sprint delivery
- Experience with Git-based version control and PR-based development workflows
- Experience mentoring junior engineers in SQL best practices and technical growth
- Strong written and verbal communication skills
- Experience working in global, distributed teams across multiple time zones
- Bachelor's degree in Computer Science, Engineering, or equivalent work experience
- Direct hands-on experience with Logi Analytics (now Logi Symphony) — this is a significant differentiator
- Experience with Oracle read-optimization patterns — materialized views, query rewrite, result cache, and analytical functions
- Experience designing or contributing to reporting data models and pre-aggregation strategies to reduce real-time query load
- Background in financial services, equity compensation, or adjacent regulated domains where reporting accuracy and auditability are critical
- Familiarity with Azure cloud data services and cloud-native reporting patterns
- Experience with CI/CD pipelines and DevOps practices — Azure DevOps preferred
- Experience with .NET (Framework and/or Core) beyond familiarity — able to independently build and maintain reporting services and APIs
- Familiarity with observability and monitoring tooling — Datadog, Application Insights, or similar — for diagnosing reporting pipeline failures
- Experience working across multi-repo, multi-product platforms sharing a common Oracle database and internal package ecosystem
Benefits
- For non-sales roles, this is a base salary only range; additional bonus eligibility may apply.
- Background checks are required for employment with insightsoftware, where permitted by country, state/province.
Company Overview
Company H1B Sponsorship