Job Summary
Must Haves
· Experience in the Clinical Development area, especially on Medidata Rave suite (preferably also back-end/ DB)
· Experience supporting systems and working with ticketing systems (i.e. Service Now)
· Python intermediate knowledge (RPA support and ad-hoc )
· Java Basic knowledge (JAR file for authentication)
· Troubleshooting analysis – advanced-expert skills
· Microsoft SQL Server – stored procedures development intermediate level
· SQL – advanced-expert skills
· API – REST webservices -intermediate level
Nice to haves
· Tableau intermediate level
· SAS language, intermediate level
· GIT - intermediate level
· Atlassian : Bitbucket, Jira, Confluence - intermediate level
· VisualCron – basic level (cron scheduling tool)
· MSDOS command line basic level
· Experience in building IWR trials
Key Responsibilities
2. Design and develop efficient and reliable etl processes for large datasets.
3. Collaborate with cross functional teams to understand business requirements and translate them into technical solutions.
4. Optimize data workflows, troubleshoot issues, and ensure data quality and integrity.
5. Implement best practices for data security, governance, and compliance.
6. Provide technical guidance, mentoring, and support to junior team members.
7. Stay uptodate with the latest trends and technologies in data engineering and analytics.
Skill Requirements
2. Strong skills in writing complex sql queries for data manipulation and analysis.
3. Experience with oracle pl/sql for database development and management.
4. Proficient in python programming language for automation and scripting tasks.
5. Solid understanding of data warehousing concepts, etl processes, and data modeling.
6. Ability to work in a fast paced environment and manage multiple priorities effectively.
7. Excellent problem-solving skills and attention to detail.
8. Strong communication and interpersonal skills for effective collaboration with team members and stakeholders.