DWH Architect – Azure AWS Data Warehouse

General Information

Job Advert Title: DWH Architect – Azure AWS Data Warehouse

Location: Nihonbashi, Tokyo

Division: DigitalX

Employment Class: Permanent

Description

【About Astellas】 As part of the Astellas commitment to delivering value for our patients, our organization is currently undergoing 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.
Your role will be critical to the continuous improvement/ continuous development (CI/CD) of strategic IT assets and services. You will be supporting the development of data warehouse architecture, design and delivery across Astellas. You will also ensure that data infrastructure supports critical business processes, regulatory compliance, and data-driven decision-making.
As a Data Warehouse Architect, you will play a crucial role in designing, building, and maintaining our data infrastructure. Your expertise in Azure, AWS and other related technologies, will be instrumental in driving data-driven decision-making across the organization. You will play a pivotal role in building maintaining and enhancing our systems across the organisation. This is a fantastic global opportunity to use your proven agile delivery skills across a diverse range of initiatives, utilise your development skills, and contribute to the continuous improvement/delivery of critical IT solutions.
【職務の内容 / Essential Job Responsibilities】 （雇入れ直後） Data Modelling and Integration: • Collaborate with cross-functional teams to analyze requirements and create technical designs, data models, and migration strategies. • Design, build, and maintain physical databases, dimensional data models, and ETL processes specific to pharmaceutical data. Cloud Expertise: • Evaluate and influence the selection of cloud-based technologies such as Azure, AWS (essential), or Google Cloud (Desirable). • Implement data warehousing solutions in a cloud environment, ensuring scalability and security. Qlik Expertise: • Leverage Qlik for data visualization, dashboards, and self-service analytics. • Create Qlik applications to empower business users with insights. • Pharmaceutical Data Governance: • Ensure compliance with industry-specific regulations (e.g., FDA, HIPAA) related to data privacy, security, and audit trails. • Implement data quality, integrity, and standardization efforts across pharmaceutical products and databases. Advanced Analytics: • Work with analytics teams to enable advanced data analytics, predictive modelling, and AI applications specific to drug discovery, clinical trials, and patient outcomes. • Collaboration and Communication: • Engage with business stakeholders, including researchers, clinicians, and regulatory affairs teams, to understand their data needs. • Translate technical information into actionable insights for non-technical audiences. Additional focus areas • 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 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. • Ensure compliance with industry-specific regulations (e.g., FDA, HIPAA) related to data privacy, security, and audit trails. • Implement data quality, integrity, and standardization efforts across pharmaceutical products and databases. • 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＞ Any relevant cloud-based AWS or Azure certifications for example: • AWS Certified Solutions Architect – Professional / Associate (will be considered with relevant experience) • Microsoft Certified Azure Solutions Architect Expert • Microsoft Certified Azure Database Administrator • Microsoft Certified Azure Developer • Knowledge and experience of working with SalesForce / SAP (Desirable) • Experience using ETL tools like Talend / Talend Cloud and DataStage (Essential) • Knowledge and experience using Azure DevOps (Essential) • Experience in working with MPP Databases like Redshift • Experience of delivering architectural solutions effectively within Lifesciences or Pharma Domains.
＜歓迎 / Preferred＞ • Experience analyzing 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. • Technical Proficiency: Strong coding skills in SQL, PLSQL. Experience in AWS and Azure. • Agile Champion: Adherence to DevOps principles and a proven track record with CI/CD pipelines for continuous delivery. • Code and version control experience and best practices • 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 position is based in India and will require on-site work. • (OR) At Astellas we recognize the importance of work/life balance, and we are proud to offer a hybrid working solution allowing time to connect with colleagues at the office with the flexibility to also work from home. We believe this will optimize the most productive work environment for all employees to succeed and deliver. Hybrid work from certain locations may be permitted in accordance with Astellas’ Responsible Flexibility Guidelines.
【応募書類 / Application Documents】 和文履歴書・和文職務経歴書・英文レジュメ Both Japanese and English Resumes are needed
【選考プロセス / Selection details】 書類選考 → 1次面接 → 2次面接 → 最終面接 ※変更の可能性もございますので、予めご了承下さい。 CV screening → First interview → 2nd Interview → Final interview *Please be advised that there might be a change in the process.
【勤務地 / Location】 （雇入れ直後） 東京都中央区　アステラス製薬　日本橋事業所　本社 Nihonbashi, Tokyo
（変更の範囲） 会社の定める事業場および自宅
【勤務開始日 / Start Date】 応相談 Will be decided according to the candidate's flexibility
【契約期間 / Contract Duration】 期間の定めなし Not limited to specified period
【試用期間 / Probation Period】 試用期間原則なし No probation period in principle
【給与 / Salary】 ①基本給：当人の経歴・技術・技能等を考慮して決定 ②裁量労働制の場合：裁量労働手当として職務グレードに応じて50,000～100,000円支給 ③フレックスタイム制の場合：月間の所定労働時間を超えて勤務する時間に対して時間外勤務手当を支給 ①Base salary: will be decided by the candidate's experience, skill and capability. ②When Discretionary Work System is applied: Discretionary work allowance will be paid.(50,000～100,000yen, based on the Grade) ③When Flextime System is applied: Overtime allowance will be paid for time worked in excess of prescribed working hours.
【昇給 / Salary Raise】 有り
【賞与 / Bonus】 有り
【諸手当 / Allowance】 裁量労働手当、住宅手当、通勤手当　等 Discretionary work allowance, Housing allowance, Commutation allowance, etc.
【勤務時間 / Working Hours】 8:45～17:45（月～木）、8:45～16:00（金）、企画業務型 裁量労働制 裁量労働制の場合、所定労働時間を働いたものとみなす 8:45～17:45（Mon～Thu）、8:45～16:00（Fri） Discretionary Work System
【休日 / Holidays】 完全週休２日制（土曜・日曜）、祝日、5月1日、夏季、年末年始 Weekends(Sat and Sun), holidays, May 1st, summer vacation, New Year holidays
【休暇 / Vacation Leave】 年次有給休暇、育児休業制度、介護休業制度　等 Annual paid leave, childcare leave system, nursing care leave system, etc.
【福利厚生 / Welfare】 雇用保険、労災保険、厚生年金、健康保険、共済会制度、社宅制度、持株会制度、財形貯蓄制度　等 Employment Insurance, Industrial Accident Compensation Insurance, Welfare Pension Insurance, Health Insurance, Mutual Aid Association System, Company Housing System, Employee Shareholder Association System, Property Accumulation Savings System
【アステラス製薬　採用サイト/ Career web site】 https://re-jp.astellas.com/jp/recruit/newgraduates/
For more information about Astellas, please visit our career web site. "We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law."