Data Architect

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 worklife 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 Architect will define the vision strategy and implementation of the companys data infrastructure ensuring seamless data integration governance and accessibility. This role will drive the design and optimization of enterprise data solutions supporting business analytics and forecasting to enhance datadriven decision making.

Essential Duties and Responsibilities

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

• Defines and plans database architectures for enterprise systems.

• Working with the Business to assess requirements the incumbent will design and implement an Enterprise Data solution to drive datadriven decision making optimize reporting accuracy and improve operational efficiency.

• Serve as the subject matter expert on data management emerging technologies and market trends advising leadership on best practices.

• Communicates effectively with endusers support staff management and other departments on all datarelated initiatives.

• Establish and maintain metadata management data lineage and cataloging to enhance discoverability and usability across the organization.

• Assist other teams with the integration implementation and troubleshooting of projects involving local cloud and hybrid network services.

• Develop disaster recovery and business continuity plans to protect data assets and ensure high availability

• Exercises independent judgment in the planning scheduling organizing controlling and monitoring of datarelated projects.

• Works under general direction of senior level management. Typically manages and mentors project leaders and/or technical staff. Works on multiple complex projects as a project leader and a subject matter expert

Qualifications and Education Requirements

• Bachelors Degree in a technology discipline or an equivalent combination of education and related experience.

• Expert/lead technical role and a seasoned architect with solid knowledge of the current technology trends

• Expertise in relational and nonrelational databases including Oracle MS SQL and modern cloudbased solutions (Snowflake Redshift etc.

• 7 to 10 years of experience with enterprise data architecture database management and data engineering

• Proven experience leading a data transformation project(s) from concept to delivery

• Deep understanding of SQL query optimization and performance tuning

• 7 years of database design and Modeling

• 5 years of experience in Data Warehouse Data Lake

• Knowledgeable in designing and constructing data architectures operational data stores data marts and lakehouses with a good understanding of AI foundational requirements

• Demonstrated ability to work effectively with management team members and users

• Leadership and/or management experience including project management experience

• Ability to work independently prioritize and solve problems proactively with creativity and attention to detail

• Familiarity with API management and ETL/ELT tools

• Strong skills in architecture business process information and systems development; familiarity with data modeling workflow rulesbased systems techniques and tools

• Ability to interface well with CAE users and customers at all levels.

• Ability to interface and work well with CAE Global IT Leaders and 3rd party vendors

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

Preferred Skills

• Experience designing and implementing serverless high availability and faulttolerant data architectures

• Strong understanding of existing and emerging Cloud Data Technologies in the marketplace

• Strong background in data visualization tools (Power BI Tableau Domo etc.

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 needtoknow. 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 offshifts as .

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

Physical Demands

• Employee is regularly required to sit talk or hear in person in meetings and by telephone.

• Manual dexterity to operate computers or other standard office equipment; and reach with hands and arms.

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 youd like more information about your EEO rights as an applicant under the law please click here Know Your Rights: Workplace Discrimination is Illegal.

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 contractors legal duty to furnish information.