What are the responsibilities and job description for the Database Analyst Intern (Unpaid) position at Viceroy Solutions,Inc.?
Job Description: Database Analyst Intern (Unpaid)
Position: Database Analyst Intern.
Company: Viceroy Solutions Inc.
Position Overview:
We are seeking a motivated and detail-oriented Database Analyst Intern to join our team. This unpaid internship offers a unique opportunity to gain hands-on experience in database management, data analysis, and visualization. The ideal candidate should be proficient in MongoDB, Tableau, and familiar with a variety of other database technologies and analytical tools. A strong interest in data analysis and a passion for learning are essential.
Key Responsibilities:
- Assist in managing and maintaining databases, with a focus on MongoDB.
- Perform data extraction, transformation, and loading (ETL) tasks using various tools.
- Create and maintain dashboards and reports using Tableau to visualize data insights.
- Analyze and interpret data using tools such as Excel, SQL, Python, or R to support business decision-making processes.
- Collaborate with the IT and analytics teams to ensure data accuracy and integrity.
- Participate in the design and implementation of database solutions using technologies like MySQL, PostgreSQL, and Oracle Database.
- Support in optimizing database performance, including indexing, query optimization, and data partitioning.
- Explore and implement NoSQL databases like Cassandra or Redis based on project requirements.
- Work with data warehousing solutions such as Amazon Redshift, Google Big Query, or Snowflake.
- Utilize data integration tools like Apache Kafka, Talend, or Alteryx for data migration and transformation.
- Assist in documenting database structures, procedures, and best practices.
Qualifications:
Education: Currently pursuing or recently completed a degree in Computer Science, Information Technology, Data Science, or a related field.
What You Will Gain:
- Hands-on experience with a wide range of industry-standard database technologies and analytical tools.
- Opportunity to work on real-world projects that impact business outcomes.
- Mentorship and guidance from experienced professionals in the field.
- Exposure to a dynamic work environment and potential networking opportunities.