Beghou brings over three decades of experience helping life sciences companies optimize their commercialization through strategic insight, advanced analytics, and technology. From developing go-to-market strategies and b…
Skills: SQL, ETL Testing, Data Warehouse, Databricks, Snowflake
Beghou brings over three decades of experience helping life sciences companies optimize their commercialization through strategic insight, advanced analytics, and technology. From developing go-to-market strategies and b…
Skills: Resource management, Data analysis, Microsoft Excel, PowerPoint, Business intelligence
Beghou brings over three decades of experience helping life sciences companies optimize their commercialization through strategic insight, advanced analytics, and technology. From developing go-to-market strategies and b…
Skills: Data analytics, Data engineering, ETL design, Schema design, Python
Beghou brings over three decades of experience helping life sciences companies optimize their commercialization through strategic insight, advanced analytics, and technology. From developing go-to-market strategies and b…
Skills: Tableau Desktop, Tableau Server/Cloud Administration, SQL, Data Visualization, BI Solution Architecture
Beghou brings over three decades of experience helping life sciences companies optimize their commercialization through strategic insight, advanced analytics, and technology. From developing go-to-market strategies and b…
Skills: Platform Engineering, Security Engineering, DevOps, Azure, Identity and SSO
Beghou brings over three decades of experience helping life sciences companies optimize their commercialization through strategic insight, advanced analytics, and technology. From developing go-to-market strategies and b…
Skills: Power BI, DAX, Power Query, SQL, Data Visualization
Beghou brings over three decades of experience helping life sciences companies optimize their commercialization through strategic insight, advanced analytics, and technology. From developing go-to-market strategies and b…
Skills: Python, TypeScript, AI Automation, RAG, MCP Servers
Beghou brings over three decades of experience helping life sciences companies optimize their commercialization through strategic insight, advanced analytics, and technology. From developing go-to-market strategies and b…
Skills: Data Science, AI/ML, Generative AI, Python, Alteryx
Beghou brings over three decades of experience helping life sciences companies optimize their commercialization through strategic insight, advanced analytics, and technology. From developing go-to-market strategies and b…
Skills: Incentive Compensation, Commercial Analytics, Field Enablement, Python, R
Beghou brings over three decades of experience helping life sciences companies optimize their commercialization through strategic insight, advanced analytics, and technology. From developing go-to-market strategies and b…
Beghou brings over three decades of experience helping life sciences companies optimize their commercialization through strategic insight, advanced analytics, and technology. From developing go-to-market strategies and b…
Skills: Incentive Compensation, Commercial Analytics, Field Enablement, Python, R
Beghou brings over three decades of experience helping life sciences companies optimize their commercialization through strategic insight, advanced analytics, and technology. From developing go-to-market strategies and b…
Skills: Master Data Management, Commercial Data Strategy, Reltio, Python, Advanced Excel
Senior Consultant- Life Sciences Customer Engagement
Bengaluru, Karnataka, India · Hybrid
Senior
Beghou brings over three decades of experience helping life sciences companies optimize their commercialization through strategic insight, advanced analytics, and technology. From developing go-to-market strategies and b…
Skills: Customer Engagement Design, Field Force Sizing, Sales Force Optimization, Stakeholder Management, Data Analysis
Beghou brings over three decades of experience helping life sciences companies optimize their commercialization through strategic insight, advanced analytics, and technology. From developing go-to-market strategies and b…
Skills: Data Processing, Data Visualization, Analytical Problem Solving, Client Communication, Project Management
Beghou brings over three decades of experience helping life sciences companies optimize their commercialization through strategic insight, advanced analytics, and technology. From developing go-to-market strategies and b…
Skills: Commercial Operations, Data Analytics, Project Management, Pharmaceutical Commercial Functions, Microsoft Excel
Beghou brings over three decades of experience helping life sciences companies optimize their commercialization through strategic insight, advanced analytics, and technology. From developing go-to-market strategies and b…
Skills: Data Science, AI/ML, Python, Alteryx, Tableau
Manager, Experience & Business Strategy, Lifesciences
Evanston, Illinois, United States · Hybrid
$140k–$240k/yr
Senior+
Beghou brings over three decades of experience helping life sciences companies optimize their commercialization through strategic insight, advanced analytics, and technology. From developing go-to-market strategies and b…
Beghou brings over three decades of experience helping life sciences companies optimize their commercialization through strategic insight, advanced analytics, and technology. From developing go-to-market strategies and b…
Skills: Python, PySpark, Data Aggregation, Tokenization, HIPAA Compliance
Beghou brings over three decades of experience helping life sciences companies optimize their commercialization through strategic insight, advanced analytics, and technology. From developing go-to-market strategies and b…
Senior Consultant- Life Sciences Customer Engagement- 466
Pune, Maharashtra, India · Hybrid
Senior
Beghou brings over three decades of experience helping life sciences companies optimize their commercialization through strategic insight, advanced analytics, and technology. From developing go-to-market strategies and b…
Skills: Customer Engagement Design, Field Force Sizing, Sales Force Optimization, Stakeholder Management, Data Analysis
Sign up with Clera and we'll reach out the moment a role actually fits you — no more spraying applications into the void.
Full-time
Posted 6d ago
~40 hrs/week
Responsibilities
You will be responsible for ensuring data accuracy and reliability by designing test scenarios and executing source-to-target validations within ETL pipelines. You will also collaborate with data engineers and business analysts to validate transformation logic and track defects using industry-standard tools.
Requirements
The role requires 3–5 years of experience in ETL and data warehouse testing with strong proficiency in SQL and data validation techniques. Candidates should have experience with tools like Databricks or Snowflake and familiarity with Agile methodologies.
Full job description
Beghou brings over three decades of experience helping life sciences companies optimize their commercialization through strategic insight, advanced analytics, and technology. From developing go-to-market strategies and building foundational data analytics infrastructures to leveraging artificial intelligence to improve customer insights and engagement, Beghou helps life sciences companies maximize performance across their portfolios. Beghou also deploys proprietary and third-party technology solutions to help companies forecast performance, design territories, manage customer data, organize, and report on medical and commercial data, and more. Headquartered in Evanston, Illinois, we have 10 global offices.
Our mission is to bring together analytical minds and innovative technology to help life sciences companies navigate the complexity of health care and improve patient outcomes.
Purpose of Job:
As an ETL Tester, you will play a critical role in ensuring the accuracy, consistency, and reliability of data as it moves through our ETL pipelines — from extraction and transformation through to loading into the data warehouse. You'll be responsible for designing test scenarios, executing source-to-target validations, and writing advanced SQL queries (joins, subqueries, window functions, aggregations) to catch data quality issues such as duplicates, nulls, and referential integrity gaps before they reach production. Working within an Agile team, you'll partner with data engineers, and business analysts to validate transformation logic and business rules, support UAT and production validation, and track defects through tools like Jira or Azure DevOps or GitHub. This role is ideal for someone with 3–5 years of ETL/DW testing experience who thrives on precision, enjoys solving data puzzles, and wants to grow into cloud, Big Data, or automation-driven testing.
Basic understanding of APIs and automation is an added advantage.
3–5 years in ETL/Data Warehouse testing
Nice-to-Have Skills
Python or PySpark
Cloud platforms (Azure, AWS, GCP)
CI/CD tools (Jenkins, Git)
Big Data testing (Hive, Hadoop, Spark)
\n
At Beghou Consulting, you'll join a highly collaborative, values-driven team where technical excellence, analytical rigor, and personal growth converge. Whether you're passionate about AI innovation, building commercialization strategies, or shaping the next generation of data-first solutions in life sciences, this is a place to make an impact!
A long-term, agile partner for life sciences commercialization
Industry
Business Consulting and Services
Company size
201-500 employees
Founded
1993
Headquarters
Evanston, IL
LinkedIn followers
55,106
Beghou is a life sciences consulting and technology company with 30+ years of experience and 200+ client partnerships. We connect the dots between strategy, data, technology, and teams - helping clients accelerate launches, deepen customer engagement, and advance patient access.
Our clients succeed when we support them to:
➡ Build strong, flexible data and technology foundations
➡ Enable agile and aligned execution across roles and functions
➡ Engage providers, payers, and patients with precision and value
Offices: 1880 Oak Ave, Suite 200, Evanston, IL 60201, US · 1900 Powell Street, Suite 880, Emeryville, CA 94608, US · 6-3-552, 4th Floor, Sri Ram Towers, Hyderabad, A.P. 500 082, IN · 100 Wall Street, 14th Floor, New York, NY 10005, US · 51 Monroe Street, Suite 501, Rockville, Maryland 20850, US
A long-term, agile partner for life sciences commercialization
Industry
Business Consulting and Services
Company size
201-500 employees
Founded
1993
Headquarters
Evanston, IL
LinkedIn followers
55,106
Beghou is a life sciences consulting and technology company with 30+ years of experience and 200+ client partnerships. We connect the dots between strategy, data, technology, and teams - helping clients accelerate launches, deepen customer engagement, and advance patient access.
Our clients succeed when we support them to:
➡ Build strong, flexible data and technology foundations
➡ Enable agile and aligned execution across roles and functions
➡ Engage providers, payers, and patients with precision and value
Offices: 1880 Oak Ave, Suite 200, Evanston, IL 60201, US · 1900 Powell Street, Suite 880, Emeryville, CA 94608, US · 6-3-552, 4th Floor, Sri Ram Towers, Hyderabad, A.P. 500 082, IN · 100 Wall Street, 14th Floor, New York, NY 10005, US · 51 Monroe Street, Suite 501, Rockville, Maryland 20850, US