Data Warehouse Architect

Astellas Pharma - Markham, IL

Full-time - Mid Level

Markham, IL

Management of Companies and Enterprises

About the position

As part of Astellas' commitment to delivering value for our patients, our organization is currently undergoing a transformation to achieve this critical goal. This is an opportunity to work on digital transformation and make a real impact within a company dedicated to improving lives. 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 Data Warehouse Architects to join our new FoundationX team, which lies at the heart of DigitalX. As a member of our team within FoundationX, you will be responsible for ensuring our data-driven systems are operational, scalable, and continue to contain the right data to drive business value. 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. As a FoundationX Data Warehouse Architect, you'll play a pivotal role in shaping the data architecture and analytics strategy for Astellas. Your expertise and proven experience will drive the design, development, and scalability of our data warehouse solutions. You will play a pivotal role in building, maintaining, and enhancing our data warehouse capabilities across the organization. This is a fantastic global opportunity to use your proven agile delivery skills across a diverse range of initiatives, utilize your development skills, and contribute to the continuous improvement/delivery of critical IT solutions.

Responsibilities

• Responsible for delivering a robust and scalable data architecture that aligns with business goals
• Design and build high-performance, adaptable solutions across modern platforms
• Integrate technical functionality seamlessly
• Adhere and define technical principles, vision and standards for the data warehouse that are aligned with agile practices
• Participate in smaller focused mission teams to deliver value driven solutions aligned to our global and bold move priority initiatives and beyond
• Design, develop and implement robust and scalable full stack applications using modern technologies
• Collaborate with cross functional teams and practices across the organization 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 optimize performance security and maintainability of existing data and platform architecture and other technology investments
• Participate in the continuous delivery pipeline Adhering to DevOps best practices 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.

Requirements

• Bachelor's degree in computer science, Information Technology, or related field (Master's preferred) or equivalent experience
• Minimum of 5 years of demonstrated relevant experience
• Any relevant cloud-based integration certification at professional level, such as AWS certified DevOps engineer (Professional), AWS Certified Developer (Professional), Mulesoft Certified integration architect Level 1 (Essential), Microsoft Certified Azure Integration and Security
• Proficient in RESTful APIs
• Experience with AWS, CDMP, MDM, DBA, SQL, SAP, TOGAF, API, CISSP, VCP (any relevant certification)
• Understanding of MuleSoft's Any point Platform and its components
• Experience with designing and managing API-led connectivity solutions
• Knowledge of integration patterns and best practices
• Proficiency in network architecture and security concepts
• Experience provisioning, operating, and managing AWS environments
• Experience developing code in at least one high-level programming language
• Understanding of modern development and operations processes and methodologies
• Ability to automate the deployment and configuration of infrastructure using AWS services and tools
• Experience with continuous integration and continuous delivery (CI/CD) methodologies and tools
• Fundamental understanding of Microsoft Azure and its services
• Experience with Azure services related to computing, networking, storage, and security
• Knowledge of general IT security principles and best practices
• Understanding of cloud integration patterns and Azure integration services such as Logic Apps, Service Bus, and API Management.

Nice-to-haves

• Subject Matter Expertise in data architecture/engineering/operations/reporting within Life Sciences/Pharma industry across Commercial, Manufacturing and Medical domains
• Other complex and highly regulated industry experience will be considered across diverse areas like Commercial, Manufacturing and Medical
• Proficient in identifying, standardizing, and automating critical reporting metrics and modelling tools
• Demonstrated ability to lead ad hoc analyses, identify performance gaps, and foster a culture of continuous improvement
• Strong coding skills in SQL, R, and/or Python, coupled with expertise in machine learning techniques, statistical analysis, and data visualization
• Adherence to DevOps principles and a proven track record with CI/CD pipelines for continuous delivery.

Benefits

• Health insurance
• Dental insurance
• 401k
• Flexible scheduling
• Professional development opportunities
• Paid holidays
• Remote work options