DBA / Data Engineering COOP

Who We Are:  

• CAE Vision: Our vision is to be the worldwide partner of choice in defense and security, and civil aviation by revolutionizing our customers’ training and critical operations with digitally immersive solutions to elevate safety, efficiency and readiness.  

• CAE Defense & Security Mission: CAE's Defense and Security business unit focuses on helping prepare military customers to develop and maintain the highest levels of mission readiness.  

• CAE Values: Empowerment, Innovation, Excellence, Integrity and OneCAE make us who we are and we strive to make a difference in the world while helping each other succeed.  

What We Have to Offer:  

• Comprehensive and competitive benefits package and flexibility that promotes work-life balance  

• A work environment where all employees are valued, respected and safe  

• Freedom to succeed by enabling team members to deliver, take initiatives and make decisions  

• Recognition, professional development, advancement and having fun!  

Summary   

Our team is seeking a motivated college intern who is passionate about data, eager to learn, and interested in pursuing a career as a Database Administrator (DBA) or Data Engineer. This internship provides hands-on experience across our Microsoft centric data environment, including SQL Server administration, Azure Data Factory pipelines, Azure Data Lake Storage, and Snowflake. The intern will work closely with senior DBAs and data engineers to support both operational database tasks and modern Data Lakehouse development. 

What you will learn in this role: 

• Core SQL Server administration skills such as backups, restores, monitoring, performance tuning, and security fundamentals 

• Data engineering workflows using Azure Data Factory, Azure Data Lake Storage, and Snowflake 

• Data modeling and transformation using dbt 

• Best practices for data governance, documentation, and operational reliability 

• How a modern Data Lakehouse architecture supports analytics and business intelligence 

This role offers a rare blend of traditional DBA experience and modern data engineering exposure. You’ll gain practical skills across the full data lifecycle — from managing mission critical SQL Server systems to building scalable pipelines in a cloud based Data Lakehouse environment. By the end of the internship, you’ll have Hands-on experience with tools and practices used by professional data teams across the industry. 

Essential Duties and Responsibilities   

Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.   

•  Assist DBAs with routine SQL Server tasks including health checks, index maintenance, job monitoring, and troubleshooting 

• Help build, test, and maintain data pipelines in Azure Data Factory and Snowflake 

• Support ingestion, organization, and optimization of data in Azure Data Lake Storage 

• Contribute to dbt models and transformations under guidance from senior engineers 

• Participate in code reviews, documentation updates, and team knowledge sharing sessions 

• Collaborate with team members to diagnose and resolve data quality or performance issues 

• Perform exploratory analysis and validation of datasets used in analytics and reporting 

Qualifications and Education Requirements   

• Currently pursuing a degree in Computer Science, Information Systems, Data Science, or a related field 

• Basic understanding of SQL 

• Familiarity with at least one programming or scripting language (Python preferred) 

• Strong analytical thinking and willingness to learn new technologies