What You’ll Do
- 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.
Core Skills & Technologies
- 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
What We’re Looking For
- 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.
Top Skills
What We Do
Onit is a global leader of enterprise software and artificial intelligence platforms and products for legal, compliance, sales, IT, HR and finance departments. Our software transforms best practices into smarter workflows, better processes and operational efficiencies. With a focus on enterprise legal management, matter management, legal spend management, contract lifecycle management and legal holds, we operate worldwide and help global companies and billion-dollar legal departments bridge the gap between systems of record and systems of engagement.
Onit is the only company in our space with two platforms: Our leading no-code business process automation platform, Apptitude, and our business intelligence platform, Precedent. Apptitude allows customers to create, modify and deploy new software products and custom workflows. Onit’s legal AI platform, Precedent, enables our software products to read, write, and reason like a lawyer. Combined, the two platforms enable customers to digitally transform legal operations by automating processes, reducing costs and maximizing productivity with industry-leading cloud-based software.
