Data Engineer Job at Norstella

Norstella is hiring for the role of Data Engineer!

Responsibilities of the Candidate:

• Design and optimization of database solutions that sit upstream of main production 
  environment.
• Creation of optimised upstream database systems in Snowflake / RDS, e.g. 
  consolidated/standardised clinical trial or pricing database (across multiple 
  geographies).
• Pulling, processing and structuring new data sets, from public and private sources, e.g. 
  research abstracts.
• Automate data pipelines using Step Function, Airflow and AWS serverless compute 
  services.
• Develop & maintain data publication and synchronization processes, supporting 
  Norstella Data platform (NDP).
• Production sing Snowflake Data Warehouse for all data platforms.

Requirements:

• Bachelor’s degree in computer science, similar technical field of study or equivalent 
  practical experience.
• Excellent SQL querying skills and stored procedure creation skills.
• Experience handling large data sets in formats such as XML, JSON and CSV.
• Building data pipelines.
• Good Python knowledge, with a focus on data manipulation.
• AWS Data services (S3, Glue, MWAA, Lambda, Step Functions, Secrets Manager, SQS, 
  SES, etc.)
• Superior communication skills, friendly approach to business and the ability to grow and 
  adapt as business does.
• Finger on the pulse with new & emerging technologies.
• AWS certifications.
• Snowflake / Any Columnar / Any RDS certifications.
• Experience with data visualisation tools such as Tableau, Power BI or QuickSight.