Job
Description
About the Role: As a Lead ETL QA Engineer, you will drive the QA strategy and execution for a major data pipeline modernization initiative on Azure and Snowflake. This role requires a deep understanding of data quality frameworks, test planning, and stakeholder engagement. The candidate should possess leadership capabilities and be hands-on with SQL and automation. The job responsibilities are as follows: Own QA strategy and execution for Azure-based data engineering projects. Define test plans and ensure traceability across test artifacts, requirements, and defects. Lead validation of Snowflake-based data lakes, transformations, and Power BI dashboards. Guide the QA team in testing complex SQL logic, Data Vault structures, and downstream integrations. Coordinate with product owners, architects, and developers to align test coverage with business logic. Manage test data setup, environment readiness, and pipeline triggers for testing in CI/CD workflows. Mentor junior team members and review their test deliverables for completeness and accuracy. Drive test automation initiatives using Python and Selenium, where applicable. Prepare quality metrics and test status reports for leadership and stakeholders. Desired skills and experience Must Have: 610 years of QA experience with strong exposure to Azure Data Factory pipelines. Expert in SQL, data profiling, complex joins, set operations, and anomaly detection. Experience validating Snowflake external/internal tables and pipeline integrations. Knowledge of Power BI reporting and back-end data validation. Experience in test management tools, Agile ceremonies, and client interaction. Ability to lead end-to-end test planning and delivery for large data programs. Good to Have: Working knowledge of Data Vault modeling and related test patterns. Automation knowledge using Selenium with Python for data workflow and Business Logic validations. Familiarity with DevOps pipelines for test integration and execution. Why work here Be a key part of this fast-growing team of smart and passionate people who strive continuously to build a great place to work with, and work for. We were recently named #914 in the Inc.5000 fastest growing companies in America and have no plans on slowing down. After the recent acquisition by AT Kearney, this journey is about to get even more exciting. If you are looking to move your career into the fast lane, look no further. Cervello is a dynamic technology company that is focused on business analytics and planning. We take an innovative approach to making complex solutions simple so our clients can focus on running their businesses. Our services and applications enable our clients to gain the benefits of a world-class analytics and planning capability without the headaches. Equal Employment Opportunity and Non-discrimination Cervello prides itself on providing a culture that allows employees to bring their best selves to work every day. Our people can feel comfortable, confident, and joyful to do great things for our firm, our teams, and our clients. Cervello aims to build diverse capabilities to help our clients solve their most mission critical problems. Cervello is committed to building a diverse,unbiased, and inclusive workforce. Cervello is an equal opportunity employer; we recruit, hire,train, promote, develop, and provide other conditions of employment without regard to a person’s gender identity or expression, sexual orientation, race, religion, age, national origin, disability, marital status, pregnancy status, veteran status, genetic information, or any other differences consistent with applicable laws. This includes providing reasonable accommodation for disabilities, or religious beliefs and practices. Members of communities historically underrepresented in analytics and consulting are encouraged to apply. CERVELLO Version 21.05.2025
