Data Engineer

Data Engineer (Legacy + Cloud Data Platforms)

You’ll support and modernize Barnes Aerospace’s data platform—maintaining legacy SSIS/SQL Server pipelines while designing new cloud-based ingestion and transformation workflows.

Responsibilities

Legacy Data Platform Support

• Maintain and enhance SSIS packages for extraction, transformation, and loading
• Support SQL Server data warehouse layers (staging, ODS, reporting)
• Troubleshoot data issues, job failures, and performance bottlenecks
• Optimize SQL queries, stored procedures, and indexing
• Ensure reliability of scheduled jobs via SQL Server Agent

Cloud Data Engineering (Azure + Databricks)

• Design and develop pipelines using Azure Data Factory (ADF)
• Ingest and organize data into Azure Data Lake using Bronze/Silver/Gold patterns
• Build scalable transformations with Databricks using Spark SQL and PySpark
• Create curated, analytics-ready datasets for Power BI
• Implement Delta Lake and support data governance (e.g., Unity Catalog)

Migration & Modernization

• Analyze and document existing SSIS/SQL pipelines
• Translate legacy ETL into modern ELT patterns
• Execute phased migration with coexistence of legacy and modern platforms
• Reduce technical debt and improve maintainability
• Establish standards for data modeling, naming, and architecture

Data Modeling & Business Value

• Design dimensional models (fact/dimension tables) aligned to business processes
• Integrate and standardize data across multiple ERP systems (ERP experience preferred)
• Partner with stakeholders to identify high-impact data/analytics use cases
• Deliver datasets supporting reporting, forecasting, and operational insights

Data Quality & Governance

• Implement data validation, reconciliation, and monitoring
• Ensure data accuracy and consistency during migrations
• Define and enforce data quality standards and controls
• Support data lineage, documentation, and transparency

Collaboration & Stakeholder Engagement

• Work with business stakeholders, analysts, and BI developers
• Support Power BI semantic models and reporting solutions
• Communicate technical solutions in business terms
• Bridge between IT/data teams and business functions

Requirements

• 4–8+ years of experience in data engineering or data warehousing
• Strong SQL skills (T-SQL and/or Spark SQL)
• Hands-on SSIS and SQL Server experience
• Experience with Azure Data Factory (ADF)
• Experience with Databricks (Spark, Delta Lake, or similar)
• Solid understanding of data warehousing concepts (e.g., star schema)
• Experience integrating data from multiple source systems (ERP preferred)
• Ability to translate business requirements into technical solutions

Nice to Have

• Migrating legacy SSIS ETL to cloud-based architectures
• Python / PySpark proficiency
• Medallion architecture (Bronze/Silver/Gold)
• Power BI data modeling and performance optimization
• Data governance tools such as Unity Catalog
• Git and CI/CD pipelines
• dbt (or similar) frameworks

Key Skills & Tools

• SQL Server (T-SQL), SSIS
• Azure Data Factory, Azure Data Lake Storage (ADLS)
• Databricks (Spark SQL, PySpark, Delta Lake)
• Dimensional modeling (Kimball preferred)
• Performance tuning, query optimization
• Git version control