Data Engineer, TCIC, DD&T, Chengdu
Share
Job Location:
Monthly Salary:
Posted on:
9 hours ago
Vacancies:
1 Vacancy
Job Summary
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 Takedas Privacy Notice and Terms of Use. 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
- Bachelors 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 - CommercialWorker Type
EmployeeWorker Sub-Type
RegularTime Type
Full timeRequired Experience:
IC
Key Skills
- Apache Hive
- S3
- Hadoop
- Redshift
- Spark
- AWS
- Apache Pig
- NoSQL
- Big Data
- Data Warehouse
- Kafka
- Scala
About Company
Takeda is a patient-focused, R&D-driven global biopharmaceutical company committed to bringing Better Health and a Brighter Future.
