Data Engineer III with Security Clearance

Role and Responsibilities Who We Are: CAE Vision: Our vision is to be the worldwide partner of choice in defense and security, civil aviation, and healthcare 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 The Data Engineer III will support software developers, data analysts, and data scientists deliver robust data solutions from the ground up in support of applications and advanced analytics pipelines. Essential Duties and Responsibilities Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Identify, design, and implement internal process improvements for the automation of data flow, optimizing data delivery, re-designing infrastructure for greater scalability, etc
Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and 'big data' technologies
Build processes supporting data transformation, data structures, metadata, dependency and workload management
Perform engineering tasks including writing and testing software, creating software tools, updating drawings and documentation
Develop documentation to support objectives of operationally-focused team members
Effectively Interface with customer personnel at varying organizational levels
Effectively report status on tasks and assignments and to support business development team in the production of winning proposals
Qualifications and Education Requirements BS degree in Engineering discipline, Computer Science, Mathematics, or related field required
Experience manipulating, processing and extracting value from large disconnected datasets
Experience integrating data from diverse sources to a structured data repository ensuring the quality and consistency of data is maintained at all times
Advanced working knowledge of SQL language and experience with RDBMS, NoSQL DBs, Data Warehouses, big data repositories, and unstructured datasets
Strong analytic skills related to working with unstructured datasets
Advanced working knowledge of Python with the ability to write high performance code
Minimum 5 years' experience implementing high performant data ingestion pipelines using one or more ETL/ELT tools (Talend, Informatica, etc) or workflow tools (Argo, AirFLow, etc)
You will be expected to support a diverse set of projects and teams. The skillsets required for this role will vary based on what systems you are working on. To be considered, you should have strong skills in 1 or more of the following categories
Programming language (Rust, C , C , C, Julia)
Database systems (PostgreSQL, MongoDB, Oracle, MSSql, etc)
Devops (Docker, Kubernetes, Jenkins, etc)
Cloud Systems (Azure, GCP, AWS)
Ability to effectively prepare and present information and respond to questions from peers, and customers
Must be able to perform effectively as part of a project "team"
Must be self-motivated and expected to work independently with minimal supervision
Desired Skills Experience with Agile Development
Experience using Git or other source code management system
Security clearance 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. Due to U.S. Government contract requirements, only U.S. citizens are eligible for this role. Work Environment and Physical Demands May be required to sit down for long lengths of time.
May be required to climb stairs. 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 EOE/AA employer and gives consideration for employment to all qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status. If you'd like more information about your EEO rights as an applicant under the law, please click here EEO is the Law poster. PAY TRANSPARENCY NONDISCRIMINATION PROVISION The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. Position Type Regular CAE thanks all applicants for their interest. However, only those whose background and experience match the requirements of the role will be contacted. Equal Employment Opportunity At CAE, everyone is welcome to contribute to our success. With no exception. As captured in our overarching value "One CAE", we're proud to work as one passionate, boundaryless and inclusive team. At CAE, all employees are welcome regardless of race, nationality, colour, religion, sex, gender identity or expression, sexual orientation, disability, neurodiversity or age. The masculine form may be used in this job description solely for ease of reading, but refers to men, women and the gender diverse.