DataBricks Architect

Do you want to be part of an inclusive team that works to develop innovative therapies for patients? Every day, we are driven to develop and deliver innovative and effective new medicines to patients and physicians.  If you want to be part of this exciting work, you belong at Astellas!

Astellas Pharma Inc. is a pharmaceutical company conducting business in more than 70 countries around the world. We are committed to turning innovative science into medical solutions that bring value and hope to patients and their families. Keeping our focus on addressing unmet medical needs and conducting our business with ethics and integrity enables us to improve the health of people throughout the world. For more information on Astellas, please visit our website at www.astellas.com. 

This position is based in Ontario, Canada and may require on-site work from time to time.

Hybrid work from certain locations may be permitted in accordance with Astellas' Responsible Flexibility Guidelines.

Purpose and Scope:

DigitalX our new information technology function is spearheading this value driven transformation across Astellas.  We are looking for people who excel in embracing change, manage technical challenges and have exceptional communication skills.   

We are seeking committed and talented DataBricks Engineers with 8-10 years progressive experience to join our new InformationX team- which lies at the heart of DigitalX.  As a member of our team within InformationX, you will be responsible for ensuring our data driven systems are operational, scalable and continue to contain the right data to drive business value.   

Essential Job Responsibilities:

• End-to-End Data Solutions: 

• Design end-to-end scalable data streams, storage, data serving systems, and analytical workflows using Databricks. 

• Define overall architecture, capabilities, platforms, tools, and governing processes. 

• Data Pipeline Development: 

• Build data pipelines to extract, transform, and load data from various sources. 

• Set up metadata and master data structures to support transformation pipelines in Databricks. 

• Data Warehousing and Data Lakes: 

• Create data warehouses and data lakes for efficient data storage and management. 

• Develop and deploy data processing and analytics tools. 

• Collaboration with DataX and other key stakeholder value teams: 

• Collaborate with data modelers to create advanced data structures and models within the Databricks environment. 

• Develop and maintain Python scripts for data processing, transformation, and analysis.  

• Utilize Azure and AWS cloud services (e.g., Azure Data Lake, AWS S3, Redshift) for data storage and processing. 

• Apply expertise in Databricks to enhance data architecture, performance, and reliability.  Lead relevant data governance initiatives and ensure compliance with industry standards. 

• Work closely with data scientists to develop and deploy data-driven solutions. 

• Provide technical direction to Data Engineers and perform code reviews. 

• Continuous Learning: 

• Stay up to date on the latest data technologies, trends, and best practices. 

• Participate in smaller focused mission teams to deliver value driven solutions aligned to our global and bold move priority initiatives and beyond. 

• Collaborate with cross functional teams and practises across the organisation including Commercial, Manufacturing, Medical, DataX, GrowthX and support other X (transformation) Hubs and Practices as appropriate, to understand user needs and translate them into technical solutions. 

• Provide Level 3 and 4 Technical Support to internal users troubleshooting complex issues and ensuring system uptime as soon as possible. 

• Champion continuous improvement initiatives identifying opportunities to optimise performance security and maintainability of existing data and platform architecture and other technology investments.  

• Participate in the continuous delivery pipeline Adhering to DevOps best practises for version control automation and deployment. Ensuring effective management of the FoundationX backlog. 

• Leverage your knowledge of Machine Learning (ML) and data engineering principles to integrate with existing data pipelines and explore new possibilities for data utilization. 

• Stay up to date on the latest trends and technologies in full-stack-development, data engineering and cloud platforms.  

Qualifications:

Required

• Bachelor's or Master's degree in Computer Science, Engineering, or related field. 

  • 3-5 years+ of experience as a Data Engineer or DataBricks Developer. 
  • Proficiency in Python for data manipulation, scripting, and analytics. 
  • Strong understanding of data modelling concepts and practices. 

Any relevant cloud-based DataBricks, AWS or Azure certifications for example:   

• Databricks Data Engineer 

• AWS Certified Data Analytics Speciality – Professional / Associate (will be considered with relevant experience) 

• Microsoft Certified Azure Data Engineer Associate  

• Microsoft Certified Azure Database Administrator 

• Microsoft Certified Azure Developer 

• Experience using ETL tools like Talend / Talend Cloud and DataStage (Essential)  

• Knowledge and experience using Azure DevOps (Essential) 

• Knowledge and experience of working with SalesForce / SAP (Desirable) 

• Experience in working with MPP Databases like AWS Redshift 

• Experience of delivering architectural solutions effectively within Lifesciences or Pharma Domains.

Preferred

• Experience analysing and building star schema data warehouses 

• Experiencing writing SQL and creating stored procedures is essential 
  Data Analysis and Automation Skills: Proficient in identifying, standardizing, and automating critical reporting metrics and modelling tools. 

• Analytical Thinking: Demonstrated ability to lead ad hoc analyses, identify performance gaps, and foster a culture of continuous improvement. 

• Experience in integrating data from multiple Data sources like relational Databases, Salesforce, SAP and API calls. 

• Agile Champion: Adherence to DevOps principles and a proven track record with CI/CD pipelines for continuous delivery. 

• Understand and Interpret business requirements and can term them into technical requirements. 

• Create and maintain technical documentation as part of CI/CD principles   

Working Environment

• This is a Permanent position.
• Remote/ Hybrid: candidates must be located within commutable distance from the office.
• Astellas is a global company. Successful candidates will be expected to work across different time zones and according to regions or specific locations based upon demand.