Syneos Health® is a leading fully-integrated life sciences services organization built to accelerate customer success. We partner with innovators at every point across the drug development and commercialization continuum, helping them navigate complexity, anticipate change and accelerate progress.
 
Our Clinical Solutions team members act with a drug development mindset, applying their years of experience and deep expertise to truly understand customer needs and represent those in the solutions we shape.
 
Whether you join us in a Functional Service Provider partnership or a Full-Service environment, you’ll collaborate with passionate problem solvers, innovating as a team to help our customers achieve their goals. We are agile and driven to deliver – for one another, our customers, and, most importantly, for those in need.
 
Discover what your 25,000 future colleagues already know:
 
Why Syneos Health
• We are passionate about developing our people, through career development and progression; supportive and engaged line management; technical and therapeutic area training; peer recognition and total rewards program.
• We are committed to building an inclusive culture – where you can authentically be yourself. Central to this is our purpose – Driven to Deliver – which captures the passion of our colleagues to show up each day and shape solutions that have the ability to dramatically impact someone’s life. 
• We are continuously building the company we all want to work for and our customers want to work with. Why? Because we know that when we bring together smart colleagues from across the world, we can shape the future of healthcare, driving impact for customers and defining the pace of patient progress. 

Job Responsibilities

Primary Roles and Responsibilities: -

• Develop and optimize complex SQL queries, including joins and Common Table Expressions (CTEs), for data extraction and transformation.
• Proven ability to lead client engagements and present complex findings.
• Able to work independently without the needs for close supervision and collaboratively as part of cross team efforts
• Extremely strong organizational and analytical skills with strong attention to details
• Ensure business logic and data quality checks are implemented and functioning correctly within ADF and Databricks pipelines.
• Troubleshoot and resolve data-related issues by conducting detailed root cause analysis and implementing corrective actions.
• Ensure timely data delivery by tracking system performance and proactively addressing issues within defined SLAs.
• Collaborate with technical and business stakeholders to support operational and analytical data needs.
• Maintain strong documentation practices to ensure continuity and clarity across the team.
• Work closely with Azure DevOps for CI/CD and understand release processes (Dev to Ops Handover) and have experience on release management.
• Understand data integrations with third-party platforms such as Veeva CRM and Salesforce.
• Provide support during shift hours as per business requirements in EST time zones.
• Communicate effectively within team and across departments to align on objectives and tasks.

Preferred Qualifications: -

• Bachelor’s degree in Computer Science, Engineering, IT, or a related field.
• 2–4 years of professional experience in data analysis, data engineering, or ETL processes.
• Must hold an Azure Data Engineer Associate (DP-203) certification.
• Databricks certifications are highly desirable.
• Experience with root cause analysis and troubleshooting in production environments.
• Strong communication, collaboration, and teamwork skills.

Technical Skills: -

• Primary Skills:
  • Azure Data Factory
  • Azure Databricks
  • Azure Data Lake Gen2(ADLS)
  • SQL
  • Python/PySpark
• Secondary Skills: -
  • Unity Catalog
  • Lakehouse Architecture

• Nice to Have: -
  • Salesforce
  • JIRA
  • Azure Logic Apps
  • Azure Key Vault
  • Azure Automation Account

Get to know Syneos Health

Over the past 5 years, we have worked with 94% of all Novel FDA Approved Drugs, 95% of EMA Authorized Products and over 200 Studies across 73,000 Sites and 675,000+ Trial patients.

No matter what your role is, you’ll take the initiative and challenge the status quo with us in a highly competitive and ever-changing environment. Learn more about Syneos Health.

http://www.syneoshealth.com

Additional Information

Tasks, duties, and responsibilities as listed in this job description are not exhaustive.  The Company, at its sole discretion and with no prior notice, may assign other tasks, duties, and job responsibilities. Equivalent experience, skills, and/or education will also be considered so qualifications of incumbents may differ from those listed in the Job Description.  The Company, at its sole discretion, will determine what constitutes as equivalent to the qualifications described above.   Further, nothing contained herein should be construed to create an employment contract.  Occasionally, required skills/experiences for jobs are expressed in brief terms.  Any language contained herein is intended to fully comply with all obligations imposed by the legislation of each country in which it operates, including the implementation of the EU Equality Directive, in relation to the recruitment and employment of its employees.  The Company is committed to compliance with the Americans with Disabilities Act, including the provision of reasonable accommodations, when appropriate, to assist employees or applicants to perform the essential functions of the job.