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 

• Ability to work collaboratively and communicate clearly 

Preferred Skills   

• Exposure to relational databases or cloud data tools 

• Coursework or personal projects involving Python, PowerShell, or data engineering concepts 

• Interest in database administration, data engineering, or cloud platforms 

Security Responsibilities   

Must comply with all company security and data protection / usage policies and procedures.  Personally responsible for proper marking and handling of all information and materials, in any form. Shall not divulge any information, or afford access, to other employees not having a need-to-know. Shall not divulge information outside company without management approval.  All government and proprietary information will be accessed and stored electronically on company provided resources.    

•  Incumbent must be eligible for DoD Personal Security Clearance.   

Due to U.S. Government contract requirements, only U.S. citizens are eligible for this role.   

Work Environment   

• Duties performed in an office environment and manufacturing facility. 

• Must be able to work overtime on and off-shifts as required. 

• The employee is on call 24x7 for the resolution of problems and issues. 

Physical Demands   

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job.    

• This job operates in a professional office environment. This role routinely uses standard office equipment such as computers, phones, photocopiers, filing cabinets and fax machines.   

 Other Duties   

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for their job. Duties, responsibilities, and activities may change at any time with or without notice.   

CAE USA Inc. is an equal opportunity employer, and all qualified applicants will be considered for employment without regard to any protected characteristic, including disability and protected veteran status, as defined under federal, state, or local laws.  

Applicants needing reasonable accommodations should contact their recruiter at any point in the recruitment process.  If you need assistance to submit your application because of incompatible assistive technology or a disability, please contact us at hrops@caemilusa.com 

About CAE

At CAE, our mission is clear: to help make the world a safer place. For nearly 80 years, we’ve driven innovation in simulation, training, and mission readiness to support critical operations worldwide. By leveraging advanced technologies, we empower our customers to operate smarter, faster, and more sustainably. Join a purpose-driven organization where bold ideas are encouraged, collaboration drives progress, and your growth fuels our shared success.

Position Type                      

Equal Opportunity Employer

CAE is an equal opportunity employer committed to providing equal employment opportunities to all applicants and employees without regard to race, color, national origin, age, religion, sex, disability status, protected veteran status, or any other  characteristic protected by federal, state or local laws. At CAE, everyone is welcome to contribute to our success. Applicants needing reasonable accommodations should contact their recruiter at any point in the recruitment process. If you need assistance to submit your application because of incompatible assistive technology or a disability, please contact us at CAECarrieres-Careers@cae.com.

Data Privacy

Privacy Statement | CAE

CAE thanks all applicants for their interest. However, only those whose background and experience match the requirements of the role will be contacted.