IT Data Analyst

We are seeking an IT Data Analyst to join our team. As an IT Data Analyst at Syneos Health, you will develop and optimize complex SQL queries for data extraction and transformation. You will lead client engagements and present complex findings, work independently and collaboratively as part of cross-team efforts, and ensure business logic and data quality checks are implemented and functioning correctly within ADF and Databricks pipelines.

Responsibilities:

• Develop and optimize complex SQL queries, including joins and Common Table Expressions (CTEs), for data extraction and transformation.
• Lead client engagements and present complex findings.
• Work independently without close supervision and collaboratively as part of cross-team efforts.
• 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.