Data Engineer

Tampa, United StatesOn-site

Responsibilities

Build, enhance, and maintain scalable data pipelines using Azure Data Factory Develop, test, and optimize dbt models for Snowflake and Azurebased lakehouse workloads Engineer ingestion, transformation, and orchestration workflows across Azure Data Lake Storage Implement best practices for Snowflake performance tuning, cost optimization, and data modeling Integrate SQL Server data sources and collaborate with DBAs on operational data flows Write highquality SQL, Python, and PowerShell to automate and

experience with Azure Data Factory, Snowflake, dbt, and SQLdriven data engineering.
You will collaborate with DBAs, analysts, and business stakeholders to design scalable data pipelines, improve data quality, and support enterprise analytics across our cloud data platform.
experience in data engineering or a related field Strong expertise with Azure Data Factory (pipelines, triggers, integration runtimes) and other Handson
experience with Snowflake (warehousing, Snowpipe, RBAC, performance tuning) Proficiency with dbt (models, tests, macros, documentation) Advanced SQL skills and
experience working with large, complex datasets
Experience with Azure Data Lake Storage and modern Data Lakehouse architecture Scripting
experience with Python and/or PowerShell Solid understanding of ETL/ELT patterns, data modeling, and CI/CD workflows Preferred Skills
Experience working in Azure GCCHigh, IL5, or other highersecurity cloud environments Familiarity with SQL Server administration concepts or collaboration with DBA teams
Experience with Azure DevOps, Git, or similar version control and deployment tools Knowledge of data governance frameworks, lineage, and cataloging tools Background in performance optimization for cloudbased data platforms Security
Must be able to work overtime on and off-shifts as required.

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.
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 We are seeking an experienced Data Engineer to join our data architecture team and help expand and optimize our modern data lakehouse environment.

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
This role is ideal for someone who thrives in a Microsoftcentric ecosystem and has deep handson
Responsibilities Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
requirements into robust engineering solutions Contribute to data governance, documentation, and metadata management initiatives Participate in code reviews and help establish engineering standards and reusable patterns
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.