About this role
Syneos Health® is a leading fully integrated biopharmaceutical solutions organization built to accelerate customer success. We translate unique clinical, medical affairs and commercial insights into outcomes to address modern market realities.
Our Clinical Development model brings the customer and the patient to the center of everything that we do. We are continuously looking for ways to simplify and streamline our work to not only make Syneos Health easier to work with, but to make us easier to work for.
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 accelerate the delivery of therapies, because we are passionate to change lives.
Discover what our 29,000 employees, across 110 countries already know:
WORK HERE MATTERS EVERYWHERE
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 our Total Self culture – where you can authentically be yourself. Our Total Self culture is what unites us globally, and we are dedicated to taking care of our people.
- We are continuously building the company we all want to work for and our customers want to work with. Why? Because when we bring together diversity of thoughts, backgrounds, cultures, and perspectives – we’re able to create a place where everyone feels like they belong.
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.
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.