1. Database Development (30%)- Designed and implemented comprehensive Entity-Relationship Diagrams (ERD) to effectively visualize database structures.- Developed database schemas, models, and relationships using SQLModel, enhancing data organization and accessibility.- Managed data storage solutions using PostgreSQL, ensuring robust data integrity and efficiency in data operations.2. Data Pipeline Construction (30%)- Orchestrated data acquisition strategies by utilizing APIs to crawl and collect data, optimizing the breadth and depth of data resources.- Conducted advanced data preprocessing activities, including the elimination of duplicate data and rectification of missing data entries, which improved data quality significantly.- Transformed and integrate complex data sets into PostgreSQL databases, aligning data structures with business requirements and ensuring seamless data flow across systems.3. API Design and Implementation (40%)- Engineered and maintained robust API solutions, including the development of CRUD operations (POST, GET, DELETE, UPDATE), facilitating effective data management.- Implemented logical frameworks for CRUD operations that upheld data integrity and security, ensuring reliable and secure data transactions across various platforms.- Contributed to system architecture by designing APIs that support scalable interactions and enhance user experience, demonstrating a strong capability in backend development.