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
