QA Engineer - Data Platform

Veeva Systems, Inc.; Toronto; Hybrid; CAD 65,000 - 115,000; Full time

Job summary

An innovative company is seeking a QA Engineer to join their dynamic team focused on ensuring data integrity within their cloud-based solutions. In this role, you'll perform functional testing, create test cases, and automate processes to enhance efficiency. With a commitment to employee success and a flexible work environment, this organization offers a unique opportunity to contribute to cutting-edge projects in the life sciences sector. If you're passionate about quality assurance and eager to make a difference, this position is perfect for you.

Benefits

Medical Insurance

Dental Insurance

Vision Insurance

Paid Time Off

Company-paid Holidays

Charitable Giving Program

Qualifications

• 3+ years of experience with ETL Testing and SQL queries.
• Strong analytical and problem-solving skills required.

Responsibilities

• Identify project scope and create test cases for ETL components.
• Automate ETL test cases and validate data accuracy.

Skills

ETL Testing

SQL Queries

Analytical Skills

Problem-Solving

Agile Methodology

Education

Bachelor’s degree in Computer Science/Engineering

Tools

AWS

DevOps Tools

CI/CD

PySpark

Job description

Veeva Systems is a mission-driven organization and pioneer in industry cloud, helping life sciences companies bring therapies to patients faster. As one of the fastest-growing SaaS companies in history, we surpassed $2B in revenue in our last fiscal year with extensive growth potential ahead.

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.

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 QA Engineer in OpenData, you will be expected to perform functional testing to validate data pipelines and data systems, working closely with data engineering functions to ensure a sustainable test approach. 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

• 3+ 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
• Medical, dental, vision, and basic life insurance
• PTO and company-paid holidays
• 1% charitable giving program

Compensation

• Base pay: $65,000 - $115,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 [e-mail].

Work Where It’s Best for You

Work Anywhere means you can work in an office or at home on any given day. It’s about getting the work done in the way and place that works best for each person. This applies across all locations and departments.

Work Anywhere does not mean work at any time. We have predictable core hours where employees are generally available for meetings and collaboration. Employees are focused and available during core hours.

We invest in our offices to make them places where our employees like to go. If you work in the office three or more days a week, you will have a dedicated office workspace. Our offices function as hubs to draw people in, create social bonds, and where random connections and mixing of ideas happen. We’re investing more in offices, culture, and offsite meetings, not less.

Product teams are organized in regional product hubs for optimal collaboration and live within a time zone of their hub. Our current product hubs are located in Pleasanton, Columbus, Boston, Kansas City, New York City, Raleigh, and Toronto. We create opportunities for teams to get together in person regularly.

Customer-facing roles, such as Sales and Professional Services, live near and/or travel to their customers.

When an employee moves within a country it does not cause a change in salary. Where you live impacts you and your family. Not knowing if your compensation will change if you move can cause stress and uncertainty for everyone. We wanted to eliminate that.

Work at Veeva. Work where it’s best for you.

A different kind of company. A Public Benefit Corporation.

Unlike a traditional corporation, whose only legal duty is to maximize shareholder value, PBCs consider their public benefit purpose and the interests of those materially affected by the corporation’s conduct—including customers, employees, and the community—in addition to shareholders’ interests.

What sets us apart

In February 2021, Veeva became the first public company to convert to a Public Benefit Corporation (PBC).

Unlike a traditional corporation, whose only legal duty is to maximize shareholder value, PBCs consider their public benefit purpose and the interests of those materially affected by the corporation’s conduct—including customers, employees, and the community—in addition to shareholders’ interests.

Veeva’s public benefit purpose is to help make the industries we serve more productive and create high-quality employment opportunities.

“Veeva’s engineering teams take a pragmatic approach to software development. We offer an ideal environment for engineers who value focus, speed and integrity in their work.”