Design, optimize, and scale a data warehouse architecture. Responsibilities include PostgreSQL performance tuning, ETL pipeline development, and monitoring with Datadog. Collaborate with teams to ensure efficiency and reliability in data management.
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.
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.
Benefits & Perks That Support You:
Onit offers a comprehensive total rewards package designed to support the whole employee at work and beyond:
Health Coverage: Employee and immediate family members.
Time Away: Flexible paid time off and 10 company paid holidays annually.
Family Support: Exceptional paid leave for birth parents, non-birth parents, and caregivers. Onit also offers surrogacy and adoption reimbursement.
Income Protection: 100% employer-paid life and disability insurance.
Additional Coverage Options: Voluntary benefits including hospital indemnity, critical illness, accident.
Tax-Advantaged Accounts: Flexi, NPS.
Community Engagement: One paid volunteer day each year to give back to the community.
Our Commitment to Applicants
We know that not everyone will check every box in a job description. At Onit, we value diversity, inclusion, and authenticity. If you’re excited about this role but your experience doesn’t align perfectly with every qualification, we encourage you to apply. You may be exactly who we’re looking for.
Onit Values
Customer First - Customer success is our success. We deliver value, listen, and act on customer needs.
Purposeful Innovation - Innovation fuels our growth. We harness creativity to solve problems and lead with the intentions and expertise.
Win as One - Teamwork is how we win. We are accountable, act with integrity, and communicate openly.
Intentional Growth - Our people are the difference. We create an environment with compelling work, impactful contributions, and career growth.
Similar Jobs
Cloud • Information Technology • Internet of Things • Machine Learning • Software • Cybersecurity • Infrastructure as a Service (IaaS)
Design, deploy, and manage third-party infrastructure solutions, focusing on HPE and EMC server and storage infrastructure within SI delivery engagements, while administering RHEL systems and developing automation scripts.
Top Skills:
AnsibleEmcEsxiHpeKvmRhelVcenterVMwareVsphere
Blockchain • Fintech • Payments • Consulting • Cryptocurrency • Cybersecurity • Quantum Computing
The role involves leading security logging governance, ensuring compliance with regulations, managing audit readiness, and mentoring team members.
Top Skills:
GdprIso/Iec 27001Microsoft SentinelPci DssSoc 2Splunk
Blockchain • Fintech • Payments • Consulting • Cryptocurrency • Cybersecurity • Quantum Computing
The Senior Software Engineer will drive testing quality, automate processes, develop test scripts, and ensure high-quality software applications in a collaborative environment.
Top Skills:
CucumberEclipseGitJavaJbehaveJSONRestSeleniumSoap UiSpring Framework
What you need to know about the Pune Tech Scene
Once a far-out concept, AI is now a tangible force reshaping industries and economies worldwide. While its adoption will automate some roles, AI has created more jobs than it has displaced, with an expected 97 million new roles to be created in the coming years. This is especially true in cities like Pune, which is emerging as a hub for companies eager to leverage this technology to develop solutions that simplify and improve lives in sectors such as education, healthcare, finance, e-commerce and more.
