By clicking the “Apply” button, I understand that my employment application process with Takeda will commence and that the information I provide in my application will be processed in line with Takeda’s Privacy Notice (https://jobs.takeda.com/privacynotice) and Terms of Use (https://www.takeda.com/terms-and-conditions/) . I further attest that all information I submit in my employment application is true to the best of my knowledge. **Job Description** **Responsibilities：** + Utilize platforms like MySQL, MS SQL, AWS (S3, Redshift etc.), & Informatica for data processing and storage solutions. + Design scalable and robust data architectures aligned with business needs. + Collaborate with development team and cross-functional stakeholders to ensure the seamless integration of data systems. + Monitor and optimize system and database performance, reliability, and cost-effectiveness. Provide expertise and support for database-related incidents and service requests + Conduct regular audits to ensure database compliance with organizational standards and regulatory requirements + Plan and manage database upgrades, migrations, and patching activities + Optimize database performance through tuning and query optimization + Develop and maintain scalable data pipelines and build new integrations using AWS native technologies to support increasing data sources, volumes, and complexity. + Collaborate with analytics and business teams to improve data models that enhance business intelligence tools and dashboards, fostering data-driven decision-making across the organization. + Implement processes and systems to ensure data reconciliation, monitor data quality, and ensure production data is accurate and available for key stakeholders, downstream systems, and business processes. + Write unit, integration, and performance test scripts, contribute to engineering documentation, and maintain the engineering wiki. + Perform data analysis to troubleshoot and resolve data-related issues. + Work closely with software development engineers, product managers, and analysts to deliver integrated data solutions. + Collaborate with enterprise teams, including Enterprise Architecture, Security, and Enterprise Data Backbone Engineering, to design and develop data integration patterns and models supporting various analytics use cases. + Partner with DevOps and the Cloud Center of Excellence to deploy data pipeline solutions in Takeda AWS environments, meeting security and performance standards. **Skills and Qualifications：** + Bachelor’s Degree from an accredited institution in Engineering, Computer Science, or a related field. + 4 + years of experience in data engineering, software development, data warehousing, data management, with a strong understanding of technologies like MYSQL, MS SQL, AWS (S3, Redshift etc.), and Informatica. + Strong expertise in Proficiency in PL/SQL scripting and database programming, data integration, data modeling, and modern database technologies (Graph, SQL, No-SQL) and AWS cloud technologies (e.g., DMS, Lambda, Databricks, SQS, Step Functions, Data Streaming, and Visualization). + Extensive experience in DBA, schema design & dimensional modeling, and SQL optimization. + Excellent written and verbal communication skills, with the ability to collaborate effectively with cross-functional teams. + Understanding of good engineering practices (DevSecOps, source-code versioning). + Fluency in English **Locations** CHN – Chengdu - Commercial **Worker Type** Employee **Worker Sub-Type** Regular **Time Type** Full time