What You’ll Do
- Perform data warehouse testing to validate schemas, tables, views, and aggregations.
- Execute complex PostgreSQL queries to validate data accuracy, completeness, and consistency.
- Test ETL/ELT pipelines, including full loads, incremental loads, and data backfills.
- Perform source-to-target data reconciliation and transformation validation.
- Validate BI dashboards, reports, and KPIs against underlying warehouse data.
- Identify data defects, perform root-cause analysis, and verify fixes.
- Build and maintain Python-based automation for data validation and regression testing (nice to have).
- Document test cases, validation logic, and test results.
- Collaborate with engineering and analytics teams throughout the development lifecycle.
Core Skills & Technologies
- PostgreSQL (advanced SQL, joins, CTEs, window functions)
- Data warehouse & ETL testing
- BI/reporting validation
- Source-to-target reconciliation
- Data quality checks & defect analysis
- Python scripting for automation (nice to have)
What We’re Looking For
- 3–5+ years of experience in data warehouse, ETL, or BI testing.
- Strong hands-on experience with PostgreSQL and complex SQL queries.
- Solid understanding of data warehouse concepts (facts, dimensions, transformations).
- Experience validating ETL pipelines and BI reports.
- Strong analytical mindset with excellent attention to detail.
- Ability to collaborate effectively with data engineers and BI teams.
Why Join Us?
- Work on mission-critical data platforms and analytics systems.
- Strong focus on data quality, accuracy, and reliability.
- Opportunity to build and expand data testing automation.
- Collaborative, data-driven engineering culture.
- Growth opportunities in data quality and analytics engineering.
Similar Jobs
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.
