Senior QA Engineer - Data Platform
Canada - Toronto
At the heart of Veeva are our values: Do the Right Thing, Customer Success, Employee Success, and Speed. We're not just any public company – we made history in 2021 by becoming a public benefit corporation (PBC), legally bound to balancing the interests of customers, employees, society, and investors.
As a Work Anywhere company, we support your flexibility to work from home or in the office, so you can thrive in your ideal environment.
Join us in transforming the life sciences industry, committed to making a positive impact on its customers, employees, and communities.
The Role
Veeva OpenData supports the industry by providing real-time reference data across the complete healthcare ecosystem, to support commercial sales execution, compliance, and business analytics. We drive value to our customers through constant innovation, using cloud-based solutions and state-of-the-art technologies to deliver product excellence and customer success. As a Senior QA Engineer in Opendata, you will lead the effort for building the QA framework from the ground up and the overall QA of the Data Platform for Opendata. We value end-to-end ownership, which gives you the freedom to determine the correct course of action, do all due diligence, and execute solutions in your own creative way.
What You'll Do
- Identify the project scope, expected outcome, data model, and relevant business rules
- Create test cases for applications that use ETL components
- Identify key ETL mapping scenarios and create SQL queries that simulate them
- Automate ETL test cases where possible
- Test the accuracy of the data and its completeness
- Check the data source locations and formats, perform a data count, and verify that the columns and data types meet the requirements
Requirements
- 5+ Years of experience with ETL Testing
- Experience creating test cases for applications that use ETL components
- Experience analyzing ETL mapping documents
- Proficient in writing advanced SQL queries
- Understanding the flow of data between the systems and their Data model
- Experience with Cloud infrastructure platforms like AWS
- Must possess strong analytical and problem-solving skills
- Experience automating features for better regression coverage
- Good verbal and written communication and proven experience of working and delivering in an Agile environment
- Bachelor’s degree in computer science/engineering or equivalent
- Familiar with object-oriented programming and scripting languages like Java, Python
Nice to Have
- Hands-on experience using DevOps tools and CI/CD
- Experience with PySpark
- Previous experience in the Life Sciences sector
Perks & Benefits
- Medical, dental, vision, and basic life insurance
- PTO and company-paid holidays
- Retirement programs
- 1% charitable giving program
Compensation
- Base pay: $75,000 - $150,000 CAD
- The salary range listed here has been provided to comply with local regulations and represents a potential base salary range for this role. Please note that actual salaries may vary within the range above or below, depending on experience and location. We look at compensation for each individual and base our offer on your unique qualifications, experience, and expected contributions. This position may also be eligible for other types of compensation in addition to base salary, such as variable bonus and/or stock bonus.
Veeva’s headquarters is located in the San Francisco Bay Area with offices in more than 15 countries around the world.
Veeva is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, sex, sexual orientation, gender identity or expression, religion, national origin or ancestry, age, disability, marital status, pregnancy, protected veteran status, protected genetic information, political affiliation, or any other characteristics protected by local laws, regulations, or ordinances. If you need assistance or accommodation due to a disability or special need when applying for a role or in our recruitment process, please contact us at talent_accommodations@veeva.com. Apply
Job Profile
Basic life insurance Charitable giving Charitable giving program Dental Employee success Growth potential Life Insurance Medical Medical, dental, vision, and basic life insurance Paid holidays PTO Remote-first company Retirement programs Vision Work anywhere Work From Home
Tasks- Automate ETL test cases
- Build QA framework
- Create test cases
- Test data accuracy
- Verify data formats
Agile Analytical Analytics AWS Business Analytics CI/CD Cloud Cloud-based solutions Cloud Infrastructure Communication Compliance Computer Science Customer Success Data DevOps Engineering ETL ETL testing Healthcare Infrastructure Java Life sciences Object-oriented Programming Organization Problem-solving Programming PySpark Python QA SaaS Sales Scripting Scripting Languages SQL Test Cases Veeva Writing Written communication
Experience5 years
EducationBachelor's degree in Computer Science Bachelor's degree in engineering Computer Science Engineering Equivalent
TimezonesAmerica/Edmonton America/Moncton America/Regina America/St_Johns America/Toronto America/Vancouver UTC-3 UTC-4 UTC-5 UTC-6 UTC-7 UTC-8