Software Engineer II - Data QA

About Us

Abacus Insights is transforming how data works for health plans. Our mission is simple: make healthcare data usable, so the people responsible for care and cost decisions can act faster, with confidence.
We help health plans break down data silos to create a single, trusted data foundation. That foundation powers better decisions —so plans can improve outcomes, reduce waste, and deliver better experiences for members and providers alike.

Backed by $100M from top investors, we’re tackling big challenges in an industry that’s ready for change. Our platform enables GenAI use cases by delivering clean, connected, and reliable healthcare data that can support automation, prioritization, and decision workflows—and it’s why we are leading the way.

Our innovation begins with people. We are bold, curious, and collaborative—because the best ideas come from working together. Ready to make an impact? Join us and let's build the future together.

About the Role:

Our TechOps team is looking to bring on an experienced Data QA Engineer. If you are interested in being a guiding voice on a critical feature delivery team, this position is for you. The connector factory team is responsible for implementing and configuring the data pipelines that ingest and do the ETL and process diverse sources of data. This includes building large batch processing and streaming systems. You will be exposed to every area of our platform and AWS services (Serverless – Lambda, EMR – Hadoop/Spark, EKS – Kubernetes, etc.) but even more so, help drive the evolution of the product and team as we continue to grow rapidly. We believe heavily in architecture evolution, and you will bring your experience to best practices as we build out new components of the platform.

Your Day-to-Day:

• Review and Identify business requirement gaps from mapping specification document

• Effort estimation of QA activities/tasks

• Identify mapping test scenarios and authoring ETL test cases

• Understand the file layout of various input file formats and perform parser validation

• Write Source and Target SQLs for data validation

• Automation of Source to target validation in Pyspark, Databricks

• Identify data needs and perform test execution with Synthetic data that resembles real time data

• Writing SQLs for User Acceptance Criteria

• User Acceptance testing (UAT) support

• Perform day-to-day activities using Agile methodologies

• Capture QA activities using test management tools and Jira

• Onsite – offshore coordination on day-to-day activities

What you bring to the team:

• Bachelor’s degree in computer science, Engineering, Information Technology, Information Management, Computer Applications, or a closely related field.

• At least 2 years of hands-on experience in Data Quality Assurance or Data Engineering QA roles.

• Direct experience working with U.S. healthcare datasets is essential.

• Expert-level skills in SQL, including writing complex queries, performing data validation, executing joins and aggregations, and optimizing query performance.

• Advanced Python capabilities for data analysis, synthetic data creation, and automation of data QA processes.

• Strong analytical abilities to work with large datasets, detect inconsistencies, and verify business logic.

• Solid foundation in QA methodologies, with proven experience in designing test cases for data-centric systems.

• Familiarity with analytics platforms and reporting tools is advantageous.

• Understanding of HEDIS quality measures is a plus.

• Exceptional verbal and written communication skills, with the ability to clearly present technical insights and findings.

• Experience with Pyspark, Databricks, AWS services like Redshift, S3, Athena

What we would like to see, but not required:

• Experience with other Cloud Data Warehouses (Big Query, Snowflake)

• Hands on experience of API testing

• ETL testing automation experience

What you’ll get in return

• Competitive Leave & Benefits

• Comprehensive health coverage

• Equity for every employee – share in our success

• Growth-focused environment – your development matters here

Working Arrangements

• Standard hours: 9 hours/day, 5 working days

• Location: Onsite

• Shift: 10 AM – 7 PM local time

Our Commitment as an Equal Opportunity Employer

As a mission-led technology company helping to drive better healthcare outcomes, Abacus Insights believes that the best innovation and value we can bring to our customers comes from diverse ideas, thoughts, experiences, and perspectives. Therefore, we dedicate resources to building diverse teams and providing equal employment opportunities to all applicants. Abacus prohibits discrimination and harassment regarding race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.

At the heart of who we are is a commitment to continuously and intentionally building an inclusive culture—one that empowers every team member across the globe to do their best work and bring their authentic selves. We carry that same commitment into our hiring process, aiming to create an interview experience where you feel comfortable and confident showcasing your strengths. If there’s anything we can do to support that—big or small—please let us know.