Cloud Engineer Internship Position
Ensign Services
About the Role
We are looking for an energetic and driven Cloud Data Engineering Intern to join our Data Engineering team. In this role, you will work hands-on with modern cloud, data warehousing, and ETL technologies to help build, optimize, and support our data pipelines and infrastructure. This is a fantastic opportunity to gain real-world experience across both the Microsoft Azure/SQL Server ecosystem and AWS cloud services.
Key Responsibilities
- Data Pipeline Development: Design, build, and maintain robust ETL/ELT pipelines using SSIS, Azure Data Factory, Microsoft Fabric data pipelines, and AWS Glue.
- Cloud Storage & Migration: Manage and interact with AWS S3 buckets and support data migration tasks using AWS DMS (Database Migration Service).
- Data Transformation & Modeling: Write efficient Python, PySpark, and dbt models to transform and process large datasets within our data warehouse environments.
- Database Management: Query, optimize, and manage Microsoft RDBMS and SQL Server databases.
- API Integration: Write or support data import/export processes by integrating with various external and internal APIs.
- Data Analysis & Problem Solving: Analyze complex data sets, troubleshoot data pipeline failures, and devise creative solutions to engineering challenges.
- Collaboration & Communication: Communicate technical findings clearly, document processes, and prepare presentations to share project outcomes with team members and stakeholders.
Qualifications & Requirements
- Education: Currently pursuing a degree in Computer Science, Data Science, Information Systems, Engineering, or a related technical field.
- Coursework or Project Experience in:
- Databases: Solid understanding of Microsoft RDBMS, SQL Server, and data warehousing concepts.
- ETL & Orchestration: Hands-on exposure to SSIS, Azure Data Factory, Microsoft Fabric data pipelines, or AWS Glue.
- Cloud Services (AWS): Familiarity with AWS S3 and AWS DMS.
- Modern Data Stack: Proficiency or coursework in Python, PySpark, and dbt.
- Integration: Basic knowledge of working with APIs for data ingestion.
- Analytical Mindset: A strong passion for data analysis, data wrangling, and solving complex technical problems.
- Interpersonal Skills: Excellent verbal and written communication skills, paired with strong presentation skills to effectively share insights with the team.
Eligibility & Education: Open to recent graduates or students currently enrolled in a Bachelor’s or Master’s degree program. Must be a US Citizen or US Permanent Resident (Green Card holder).
Schedule & Location: Full-time (40 hours/week) working in the Pacific Time Zone (PST).
Compensation: $25.00 / hour.