Onit
Onit4mo ago

Senior Software Engineer - ETL

PuneFull-timesenior
Data EngineeringSoftware EngineerSoftware Engineering
0 views0 saves0 applied
Apply Now

Quick Summary

Overview

About Onit We're redefining the future of legal operations through the power of AI. Our cutting-edge platform streamlines enterprise legal management, matter management, spend management and contract lifecycle processes, transforming manual workflows into intelligent, automated solutions.

Technical Tools
datadogpostgresqlpythonsnowflakesqldatabase-designetlperformance-optimizationsql-optimization
About Onit
We're redefining the future of legal operations through the power of AI. Our cutting-edge platform streamlines enterprise legal management, matter management, spend management and contract lifecycle processes, transforming manual workflows into intelligent, automated solutions.

We’re a team of innovators using AI at the core to help legal departments become faster, smarter, and more strategic. As we continue to grow and expand the capabilities of our new AI-centric platform, we’re looking for bold thinkers and builders who are excited to shape the next chapter of legal tech.
If you're energized by meaningful work, love solving complex problems, and want to help modernize how legal teams operate, we’d love to meet you.

About the Role:
 
We are looking for a highly experienced Data Warehouse Architect to design, optimize, and scale our analytics platform. This role is hands-on and performance-focused, requiring deep expertise in PostgreSQL query tuning, strong experience using Datadog for performance analysis, and advanced Python scripting for ETL pipelines.
 
You will own the performance, reliability, and scalability of the data warehouse while partnering closely with engineering, analytics, and business teams.
 
  • Design and evolve a scalable data warehouse architecture for analytics and reporting.
  • Analyze and optimize PostgreSQL queries by reviewing execution plans and Datadog APM metrics.
  • Identify slow queries, bottlenecks, and resource hotspots; implement indexing, partitioning, and query rewrites.
  • Tune PostgreSQL configuration for large analytical workloads.
  • Build and optimize Python-based ETL/ELT pipelines for data ingestion and transformation.
  • Ensure ETL jobs are efficient, reliable, and well-monitored.
  • Create dashboards, alerts, and KPIs in Datadog to monitor warehouse health.
  • Enforce data quality, consistency, and governance standards.
  • Perform root-cause analysis for performance issues and production incidents.
  • Mentor engineers on SQL optimization, data modeling, and ETL best practices.
  • Data & Performance
  • PostgreSQL (expert-level query tuning)
  • Execution plan analysis (EXPLAIN / EXPLAIN ANALYZE)
  • Indexing, partitioning, schema optimization
    •  
  • Observability
  • Datadog (APM, DB monitoring, dashboards, alerts)
    •  
  • ETL & Scripting
  • Python (advanced scripting)
  • ETL / ELT pipeline design
  • Data validation and transformation logic
    •  
  • Architecture
  • Data warehouse modeling (star/snowflake schemas)
  • Performance-driven analytics design
  • 6-9+ years of experience in data engineering, data warehousing, or database architecture.
  • Proven expertise in PostgreSQL performance tuning at scale.
  • Strong hands-on experience using Datadog to analyze and troubleshoot database performance.
  • Advanced Python skills for ETL, automation, and data processing.
  • Deep SQL expertise with experience optimizing complex analytical queries.
  • Strong communication skills and ability to collaborate across teams.
  • Ownership mindset with a focus on reliability, performance, and quality.

    • Location & Eligibility

    Where is the job
    —
    Location terms not specified
    Who can apply
    Same as job location
    Listed under
    Worldwide

    Listing Details

    Posted
    December 18, 2025
    First seen
    April 17, 2026
    Last seen
    May 6, 2026

    Posting Health

    Days active
    19
    Repost count
    0
    Trust Level
    33%
    Scored at
    May 6, 2026

    Signal breakdown

    freshnesssource trustcontent trustemployer trust
    Apply for this position
    Onit
    Onit
    lever

    Build better ways to work for your unique business.

    Employees
    750
    Founded
    2011
    Domain
    onit.com
    Jobs
    View 18 jobs
    View company profile

    4 other jobs at Onit

    View all →

    Explore open roles at Onit.

    Onit
    Project Manager
    USD 120000–145000
    Onit
    Senior Software Engineer - Python (Fullstack)
    Full-time    Onit
    Solution Engineer II
    Full-time    Onit
    Solution Engineer I
    Full-time

    Similar Software Engineer jobs

    View all →
    SpeechifySpeechify
    Software Engineer, Data Infrastructure & Acquisition - New York, NY, USA
    $140k–$200k/yr
    SpeechifySpeechify
    Software Engineer, Data Infrastructure & Acquisition - Boston, MA, USA
    $140k–$200k/yr
    SpeechifySpeechify
    Software Engineer, Data Infrastructure & Acquisition - Berlin, Germany
    SpeechifySpeechify
    Software Engineer, Data Infrastructure & Acquisition - Madrid, Spain
    SpeechifySpeechify
    Software Engineer, Data Infrastructure & Acquisition - Sydney, Australia
    SpeechifySpeechify
    Software Engineer, Data Infrastructure & Acquisition - Brno, Czech Republic

    Browse Similar Jobs

    Solutions Architect642Full Stack Developer185Embedded Software Engineer124Java Developer105Laravel Developer103Salesforce Developer82Security Software Engineer78Search Engineer71Firmware Engineer69Cloud Platform Software Engineer62Build Engineer56Python Developer52Low-Code Developer49Data Platform Software Engineer47Robotics Software Engineer40Application Developer39Java Software Engineer38Web Developer38Android Developer35.Net Developer34
    Newsletter

    Stay ahead of the market

    Get the latest job openings, salary trends, and hiring insights delivered to your inbox every week.

    A
    B
    C
    D
    Join 12,000+ marketers

    No spam. Unsubscribe at any time.

    OnitSenior Software Engineer - ETL
    Apply Now