Software QA Test Engineer/ ETL Tester

Medpace; Cincinnati (OH); On-site; USD 70,000 - 95,000; Full time

Benefits offered by this job

Health insurance

On-site parking

Wellness programs

Job summary

Medpace is seeking a full-time, office-based Software QA Engineer / ETL Tester to join our Information Technology (IT) team in Cincinnati, Ohio. You will perform manual and automated testing on data warehouse tables and views, working closely with data engineering functions to ensure data integrity.

The role requires a Bachelor's degree and 1+ years in ETL/software testing, with experience in SQL/Snowflake and cross-department collaboration.

Qualifications

• Bachelor’s degree and 1+ years of ETL/software testing experience, preferably in an agile-like environment.
• Experience with databases such as SQL, Snowflake, etc.
• Experience communicating and working within cross-departmental teams of software developers, data engineers, department leads, and end users.
• Excellent computer skills and analytical thinking.
• Excellent written and oral communication skills; healthcare industry experience is a plus.

Responsibilities

• Analyze and understand business requirements and data mapping specifications.
• Create test plans and test cases for tables and views per documented requirements.
• Execute tests for source-to-target validation and data transformations.
• Report defects and work with the development team toward resolution.
• Write test summary reports and participate in daily stand-ups and refinement meetings.
• Collaborate with developers and end users throughout the software life cycle to ensure applications meet user needs.

Skills

ETL testing

SQL

Snowflake

Data analysis

Communication

Education

Bachelor’s degree

Job description

Job Summary

Voted a Top Cincinnati Workplace for 4 years running, Medpace is growing rapidly, and we are currently seeking a full-time, office-based Software QA Engineer / ETL Tester to join our Information Technology (IT) team. The Medpace IT department creates custom software solutions for our internal and external business users, including managing a data warehouse. The Software QA Engineer / ETL Tester is responsible for performing manual and automated testing related to tables and views built from the data in the data warehouse. This role works closely with data engineering functions.

Responsibilities

• Analyze and understand business requirements and data mapping specifications;
• Create test plans and test cases per documented requirements for tables and views;
• Execute tests for source-to-target validation, transformation validation, row count validation, etc.;
• Participate in constructive peer review of test cases;
• Report defects and work with the development team toward resolution of the defects;
• Write test summary reports;
• Attend regular project meetings (daily stand-ups, refinement meetings, etc.); and
• Work closely with developers and end users throughout the software life cycle to ensure that applications meet the needs of the users.

Qualifications

• Bachelor’s degree and 1+ years of experience in ETL/software testing, preferably in an agile-like environment;
• Experience with databases such as SQL, Snowflake, etc.
• Experience communicating and working within cross-departmental teams consisting of software developers, data engineers, department leads, and end users;
• Excellent computer skills;
• Excellent analytical thinking skills;
• Excellent written and oral communication skills; and
• Experience in the regulated healthcare industry is a plus!

Medpace Overview

Medpace is a full-service clinical contract research organization (CRO) providing phase l-lV clinical development services to the biotechnology, pharmaceutical, and medical device industries. Our mission is to accelerate the global development of safe and effective medical therapeutics through the advancement of clinical research. We leverage in-country regulatory and therapeutic expertise across all major therapeutic areas including oncology, cardiology, metabolic, endocrinology, central nervous system, and anti-viral and anti-infective. Headquartered in Cincinnati, Ohio, we employ more than 6,500 people across 40+ countries.

Why Medpace?

When you join Medpace, you become part of an innovative team that brings cutting-edge therapies to market while building a meaningful and rewarding career focused on scientific excellence and improving patient outcomes around the world through continuous learning and cross-functional collaboration.

Purpose-Driven Work

• Work alongside physicians, scientists, and industry-leading experts committed to advancing the global development of medical therapeutics through clinical research excellence

Collaborative Culture

• Contribute to an interactive team environment that empowers decision making, creative thinking, and continuous learning through open communication and mutual trust.
• Leadership throughout Medpace is both accessible and approachable

Continuous Growth & Development

• Office based environment with on-site mentors
• Defined career paths with clear advancement opportunities
• Industry renowned onboarding and training programs designed to accelerate professional development
• Ongoing training and continuous learning opportunities throughout your career
• An environment that encourages employees to influence change, contribute ideas, and grow quickly

Other Employee Benefits

• Competitive compensation programs that recognize and reward performance
• Comprehensive health, wellness, retirement, and PTO benefits
• Office based culture with occasional WFH that provides flexibility for eligible positions after training
• Company-sponsored social events and intramural sports

Cincinnati Headquarters Experience

• A modern corporate campus designed to support collaboration and productivity
• Multiple on-site dining options in the heart of Madison Square
• Free on-site parking
• Convenient access to on-site 24-7 fitness and wellness facilities