Cessna Aircraft Company
Senior Data Engineer/Architect
Cessna Aircraft Company, Cockeysville, Maryland, United States, 21030
Job Description - Senior Data Engineer/Architect (338410)
Job Number 338410
Who We Are Textron Systems is part of Textron, a $14 billion, multi‑industry company employing 35,000 talented makers, thinkers, creators and doers worldwide. We make things that fly, hover, zoom and launch. Things that move people. Protect soldiers. Power industries. We serve customers in industries spanning aerospace and defense, specialized vehicles, turf care and fuel systems.
This role is in Textron System’s
Information Technology
business area. Visit TextronSystems.com & Lycoming.com to read more about who we are and the products we make!
About This Role We are seeking an accomplished Senior Data Architect/Senior Data Engineer with deep expertise in architecting and delivering modern data platforms using Azure Databricks, Delta Lake, and Medallion Architecture. The ideal candidate has strong experience in data warehousing, lakehouse best practices, ACID transaction processing, and designing scalable data ecosystems that support advanced analytics, AI, and machine learning workloads.
Responsibilities Data Architecture & Platform Engineering
Design, develop, and implement large‑scale data processing systems and solutions using Azure Databricks.
Architect and build Medallion Architecture layers (Bronze, Silver, Gold) to ensure efficient data pipeline processing from raw data to cleaned and enriched datasets.
Build ACID‑compliant pipelines leveraging Delta Lake features such as transaction logs, schema enforcement, time travel, and versioning.
Develop and optimize ELT (Extract, Load, Transact) processes using Databricks and other Azure services to support data warehousing, analytics, and reporting requirements.
Create data architectures that support AI and machine learning cases, including feature engineering pipelines, large‑scale data preprocessing, and high‑performance data retrieval for model training inference.
Apply data modeling best practices including Kimball vs Inmon methodologies, 3NF normalization, denormalization, dimensional modeling, and hybrid lakehouse patterns.
Architect solutions that support both OLTP and OLAP workloads with appropriate storage, compute, and performance strategies.
Data Modeling, Performance, & Optimization
Develop logical and physical data models that scale for BI, analytics, predictive modeling, and ML training pipelines.
Apply principles such as normalization/denormalization, partitioning, indexing, constraints, and schema design to enable optimized data processing.
Conduct query tuning using execution plans, join optimization, Spark performance tuning, caching strategies, and workload segregation.
Review, optimize, and design complex transformations, including nested functions, window functions, CTEs, and ML feature creation logic.
Data Governance, Security, & Best Practices
Implement end‑to‑end data governance including metadata management, data quality, lineage, and documentation.
Apply security best practices including schema‑based security, ACLs, role‑based access control, and integration with Azure AD and Key Vault.
Ensure reliability, auditability, and recoverability across all layers of the lakehouse platform.
Monitor data pipelines and implement error handling, logging, and alerting mechanisms to ensure data quality and reliability.
Partner with data science, analytics, business, and engineering teams to deliver high‑quality datasets for BI, ML, and AI solutions.
Mentor and provide technical guidance to junior data engineers and team members.
Perform code reviews and ensure adherence to coding standards and best practices.
Provide documentation and training for end‑users and team members to ensure seamless adoption and usage of data solutions.
Bachelor’s or Master’s degree in Computer Science, Information Technology, or related field.
5+ years of experience in data engineering, data architecture, or enterprise analytics platform development.
Extensive hands‑on experience with Azure Databricks, including building and managing data pipelines.
Strong expertise in Medallion Architecture development, including the creation and optimization of Bronze, Silver, and Gold layers.
Proficiency in SQL, Python, PySpark, and other data processing/ETL languages and frameworks.
Experience with Azure Data Lake Storage, Azure Data Factory, and other related Azure services.
Familiarity with data warehousing concepts and technologies such as Azure Synapse Analytics.
Knowledge of data governance, security, and compliance best practices.
Excellent problem‑solving skills and the ability to work independently and in a team environment.
Strong communication skills, with the ability to articulate complex technical concepts to non‑technical stakeholders.
Experience with CI/CD and DevOps practices (DevOps, GitHub Actions, Terraform).
Experience with Oracle EBS data structures preferred but not required.
Certification in Azure Data Engineering or Azure Solutions Architecture is a plus.
Qualifications & Requirements
Bachelor’s or Master’s degree in Computer Science, Information Technology, or related field.
5+ years of experience in data engineering, data architecture, or enterprise analytics platform development.
Extensive hands‑on experience with Azure Databricks.
Strong expertise in Medallion Architecture.
Proficiency in SQL, Python, PySpark.
Experience with Azure Data Lake Storage, Azure Data Factory.
Knowledge of Azure Synapse Analytics.
Experience with data governance, security, compliance.
Strong communication skills.
Experience with CI/CD, DevOps practices.
Oracle EBS data structures preferred.
Azure Data Engineering or Azure Solutions Architecture certification is a plus.
Benefits & Perks
Flexible Work Schedules
Education Assistance
Wellness Program (including Fitness Reimbursement)
Medical, Dental, Vision & 401(K) with Company Funding
Veteran Support Textron's products and services are trusted everyday by those who protect our country. We are dedicated to hiring Veterans and aim to translate their skills to make an impact on our Company.
Textron’s compensation package includes competitive base pay and provides eligible employees with benefit programs. Benefits may include health insurance and prescription plan coverage, dental insurance, family building benefits, vision insurance, mental health resources, flexible spending accounts, health savings accounts, retirement savings plans, life and disability insurance programs, and programs that provide employees time away from work. The pay range for this position is $110,500 - $167,900 per yearp>
EEO Statement
Textron is committed to providing Equal Opportunity in Employment, to all applicants and employees regardless of race, color, religion, age, national origin, military status, veteran status, disability, sex (including pregnancy and sexual orientation), genetic information or any other characteristic protected by law.
#J-18808-Ljbffr
Job Number 338410
Who We Are Textron Systems is part of Textron, a $14 billion, multi‑industry company employing 35,000 talented makers, thinkers, creators and doers worldwide. We make things that fly, hover, zoom and launch. Things that move people. Protect soldiers. Power industries. We serve customers in industries spanning aerospace and defense, specialized vehicles, turf care and fuel systems.
This role is in Textron System’s
Information Technology
business area. Visit TextronSystems.com & Lycoming.com to read more about who we are and the products we make!
About This Role We are seeking an accomplished Senior Data Architect/Senior Data Engineer with deep expertise in architecting and delivering modern data platforms using Azure Databricks, Delta Lake, and Medallion Architecture. The ideal candidate has strong experience in data warehousing, lakehouse best practices, ACID transaction processing, and designing scalable data ecosystems that support advanced analytics, AI, and machine learning workloads.
Responsibilities Data Architecture & Platform Engineering
Design, develop, and implement large‑scale data processing systems and solutions using Azure Databricks.
Architect and build Medallion Architecture layers (Bronze, Silver, Gold) to ensure efficient data pipeline processing from raw data to cleaned and enriched datasets.
Build ACID‑compliant pipelines leveraging Delta Lake features such as transaction logs, schema enforcement, time travel, and versioning.
Develop and optimize ELT (Extract, Load, Transact) processes using Databricks and other Azure services to support data warehousing, analytics, and reporting requirements.
Create data architectures that support AI and machine learning cases, including feature engineering pipelines, large‑scale data preprocessing, and high‑performance data retrieval for model training inference.
Apply data modeling best practices including Kimball vs Inmon methodologies, 3NF normalization, denormalization, dimensional modeling, and hybrid lakehouse patterns.
Architect solutions that support both OLTP and OLAP workloads with appropriate storage, compute, and performance strategies.
Data Modeling, Performance, & Optimization
Develop logical and physical data models that scale for BI, analytics, predictive modeling, and ML training pipelines.
Apply principles such as normalization/denormalization, partitioning, indexing, constraints, and schema design to enable optimized data processing.
Conduct query tuning using execution plans, join optimization, Spark performance tuning, caching strategies, and workload segregation.
Review, optimize, and design complex transformations, including nested functions, window functions, CTEs, and ML feature creation logic.
Data Governance, Security, & Best Practices
Implement end‑to‑end data governance including metadata management, data quality, lineage, and documentation.
Apply security best practices including schema‑based security, ACLs, role‑based access control, and integration with Azure AD and Key Vault.
Ensure reliability, auditability, and recoverability across all layers of the lakehouse platform.
Monitor data pipelines and implement error handling, logging, and alerting mechanisms to ensure data quality and reliability.
Partner with data science, analytics, business, and engineering teams to deliver high‑quality datasets for BI, ML, and AI solutions.
Mentor and provide technical guidance to junior data engineers and team members.
Perform code reviews and ensure adherence to coding standards and best practices.
Provide documentation and training for end‑users and team members to ensure seamless adoption and usage of data solutions.
Bachelor’s or Master’s degree in Computer Science, Information Technology, or related field.
5+ years of experience in data engineering, data architecture, or enterprise analytics platform development.
Extensive hands‑on experience with Azure Databricks, including building and managing data pipelines.
Strong expertise in Medallion Architecture development, including the creation and optimization of Bronze, Silver, and Gold layers.
Proficiency in SQL, Python, PySpark, and other data processing/ETL languages and frameworks.
Experience with Azure Data Lake Storage, Azure Data Factory, and other related Azure services.
Familiarity with data warehousing concepts and technologies such as Azure Synapse Analytics.
Knowledge of data governance, security, and compliance best practices.
Excellent problem‑solving skills and the ability to work independently and in a team environment.
Strong communication skills, with the ability to articulate complex technical concepts to non‑technical stakeholders.
Experience with CI/CD and DevOps practices (DevOps, GitHub Actions, Terraform).
Experience with Oracle EBS data structures preferred but not required.
Certification in Azure Data Engineering or Azure Solutions Architecture is a plus.
Qualifications & Requirements
Bachelor’s or Master’s degree in Computer Science, Information Technology, or related field.
5+ years of experience in data engineering, data architecture, or enterprise analytics platform development.
Extensive hands‑on experience with Azure Databricks.
Strong expertise in Medallion Architecture.
Proficiency in SQL, Python, PySpark.
Experience with Azure Data Lake Storage, Azure Data Factory.
Knowledge of Azure Synapse Analytics.
Experience with data governance, security, compliance.
Strong communication skills.
Experience with CI/CD, DevOps practices.
Oracle EBS data structures preferred.
Azure Data Engineering or Azure Solutions Architecture certification is a plus.
Benefits & Perks
Flexible Work Schedules
Education Assistance
Wellness Program (including Fitness Reimbursement)
Medical, Dental, Vision & 401(K) with Company Funding
Veteran Support Textron's products and services are trusted everyday by those who protect our country. We are dedicated to hiring Veterans and aim to translate their skills to make an impact on our Company.
Textron’s compensation package includes competitive base pay and provides eligible employees with benefit programs. Benefits may include health insurance and prescription plan coverage, dental insurance, family building benefits, vision insurance, mental health resources, flexible spending accounts, health savings accounts, retirement savings plans, life and disability insurance programs, and programs that provide employees time away from work. The pay range for this position is $110,500 - $167,900 per yearp>
EEO Statement
Textron is committed to providing Equal Opportunity in Employment, to all applicants and employees regardless of race, color, religion, age, national origin, military status, veteran status, disability, sex (including pregnancy and sexual orientation), genetic information or any other characteristic protected by law.
#J-18808-Ljbffr