Jr. Data Engineer
Koantek
06.2023 - 10.2023
- Company Overview: Data and AI Company
- Cleaned and preprocessed raw data using Excel, preparing it for ingestion into data pipelines to enhance data quality
- Created visually appealing and informative Excel spreadsheets and presentations for internal and external stakeholders, ensuring clarity and engagement
- Fostered a customer service-oriented approach, focusing on client satisfaction and timely responses to inquiries
- Developed and maintained comprehensive technical documentation, including data dictionaries, process diagrams, and system documentation, facilitating knowledge transfer and project clarity
- Managed contact lists, customer databases, and lead information in Excel, ensuring accuracy and up-to-date records
- Tracked customer interactions, sales activities, and follow-up tasks through organized spreadsheets, improving team efficiency in managing client relationships
- Organized data into structured formats, such as tables and databases, to streamline access and analysis
- Responsible for ETL and ELT activities, ensuring effective data processing and integration across systems
- Built complex SQL queries in databases utilizing joins and constraints, and managed error handling to maintain data integrity
- Data and AI Company