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: CAEs 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. Youll 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 youll 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 complywith 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

About CAE

At CAE our mission is clear: to help make the world a safer place. For nearly 80 years weve 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 CAE everyone is welcome to contribute to our success. Applicants needing reasonable accommodations should contact their recruiter at any point in the recruitment you need assistance to submit your application because of incompatible assistive technology or a disability please contact us at .

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.