At a Glance
- Tasks: Drive data quality with automation and collaborate in Agile teams.
- Company: Join Envision, a company focused on life-changing outcomes and community impact.
- Benefits: Competitive salary, supportive culture, and opportunities for personal growth.
- Why this job: Make a real impact by ensuring data integrity and quality in innovative projects.
- Qualifications: Experience in Python, SQL, and test automation in Agile environments.
- Other info: Dynamic team environment with a focus on AI and career advancement.
The predicted salary is between 36000 - 60000 £ per year.
Drive Data Quality with Automation: Join us as a Data Test Engineer and shape reliable, AI-powered data pipelines. Work shouldn't just be something we do; it should have a purpose. At Envision, we believe in creating life-changing outcomes through the work we do with our clients, giving back to our communities, while creating a company culture where our people thrive. We believe success starts with a workplace where everyone feels valued, supported, and empowered to grow.
Being part of a collaborative team means there's no limit to what you can achieve. With us, you can be a part of a growing company you want to work for.
Our Vision: To unleash the power of combined intelligence to accelerate patient access to life-changing treatments.
Our Mission: Delivering smarter and faster solutions to create, communicate, and commercialize value for our clients.
Our Values: Excellence, People, Growth
The opportunity
We are seeking a Data Test Engineer with strong expertise in test automation, data testing, and to support Agile sprint teams. This individual will drive in-sprint automation for backend components and data pipelines, build scalable automated regression suites, and ensure consistent quality and performance across data-driven systems.
The ideal candidate is a self-starter who thrives in fast-paced Agile environments, proactively identifies test coverage gaps, and works collaboratively with developers, QA, product owners, and Data teams to deliver high-quality releases.
You will collaborate to ensure quality is embedded into every stage of the development lifecycle, drive shift-left practices, enable AI for productive gains with a constant focus on increasing test automation ROI (return on investment).
How will you make an impact at Envision Pharma Group?
Role responsibilities
- Collaborate closely with developers, data engineers, and product owners in Agile ceremonies (daily stand-ups, planning, retrospectives).
- Design and automate end-to-end data validation tests across SQL warehouses, Snowflake datasets, Fivetran pipelines, and downstream reporting layers.
- Build automated data quality checks to validate schema changes, data drift, null propagation, duplicate records, and field-level integrity across ingestion and transformation layers.
- Develop Python-based automation test suites to validate transformation logic, stored procedures, DBT models, incremental loads, snapshot tables, and business KPIs.
- Conduct data reconciliation testing between source and target to ensure accuracy, completeness, timeliness and lineage consistency.
- Implement automated SQL validations to confirm record counts, joins, aggregations, lookups, referential integrity, and data dependency checks across staging, core and analytics layers.
- Ensure Power BI dashboards reflect correct business logic by validating measures, DAX calculations, joins, filters, rollups, and KPI alignment with backend data sources.
- Establish automation coverage for data freshness SLAs, load completion alerts, anomaly detection, and volume variance checks throughout daily and scheduled runs.
- Develop and maintain test automation suites in Python for backend, data and Regression testing efforts.
- Drive adoption of AI into automation frameworks, coding, test management.
- Establish metrics / dashboards to track test coverage, execution and quality trends.
Do you have what we are looking for?
Skills & expertise
- Bachelor's degree in Computer Science / Engineering or equivalent is preferred with a minimum of 2 years of hands-on experience with coding for test automation in an agile environment.
- Hands-on coding experience in Python, SQL, automation framework design and development.
- Hands-on development experience in Power BI.
- Experience with SQL and Snowflake Databases.
- Innovative mindset to enable AI using tools like Co-pilot, Jira AI agents, Cursor, etc., in test automation efforts and testing activities.
Do you have the experience we are looking for? If so, explore your place at Envision today!
Data Test Engineer (Python, Power BI) employer: Envision Pharma Group
Contact Detail:
Envision Pharma Group Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Test Engineer (Python, Power BI)
✨Tip Number 1
Network like a pro! Reach out to folks in the industry, attend meetups, and connect with people on LinkedIn. You never know who might have the inside scoop on job openings or can refer you directly.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your projects, especially those involving Python and Power BI. This gives potential employers a taste of what you can do and sets you apart from the crowd.
✨Tip Number 3
Prepare for interviews by practising common questions related to data testing and automation. We recommend doing mock interviews with friends or using online platforms to boost your confidence and refine your answers.
✨Tip Number 4
Apply through our website! It’s the best way to ensure your application gets noticed. Plus, it shows you’re genuinely interested in joining our team at Envision. Don’t miss out on this opportunity!
We think you need these skills to ace Data Test Engineer (Python, Power BI)
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Data Test Engineer role. Highlight your experience with Python, SQL, and automation frameworks. We want to see how your skills align with our mission of delivering smarter solutions!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Share your passion for data quality and automation, and explain why you want to join us at Envision. Let us know how you can contribute to our collaborative culture.
Showcase Your Projects: If you've worked on relevant projects, don’t hold back! Include examples of your test automation work, especially in Agile environments. We love seeing real-world applications of your skills!
Apply Through Our Website: We encourage you to apply through our website for a smoother process. It helps us keep track of your application and ensures you’re considered for the role. Plus, it’s super easy!
How to prepare for a job interview at Envision Pharma Group
✨Know Your Tech Inside Out
Make sure you brush up on your Python and SQL skills before the interview. Be ready to discuss your experience with automation frameworks and how you've used them in past projects. This will show that you're not just familiar with the tools, but that you can apply them effectively.
✨Showcase Your Agile Experience
Since the role involves working in Agile environments, be prepared to share specific examples of how you've collaborated in Agile ceremonies like stand-ups and retrospectives. Highlight any challenges you faced and how you overcame them, as this demonstrates your adaptability and teamwork.
✨Prepare for Scenario-Based Questions
Expect questions that ask you to solve real-world problems related to data quality and automation. Practice articulating your thought process when designing automated tests or handling data discrepancies. This will help you convey your problem-solving skills and technical expertise.
✨Align with Their Values
Familiarise yourself with Envision's mission and values, especially around excellence, people, and growth. Think about how your personal values align with theirs and be ready to discuss this during the interview. This shows that you're not just looking for a job, but that you genuinely want to contribute to their vision.