Data Engineer

🔥 0 minutes ago

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Barnes Aerospace

WebsiteLinkedInAll Job Openings

1001 - 5000 employees

🚀 Aerospace

Aerospace • Defense • Industrial

Barnes Aerospace is a global manufacturer and maintenance provider specializing in precision-machined and fabricated components and complex assemblies for aeroengines, airframes, and nacelles. The company also operates certified MRO repair stations (FAA, EASA and other authorities) offering component repair, overhaul, and modification services, and emphasizes strict compliance with industry standards (ISO, AS, Nadcap). With global facilities across the US, UK, Poland, Taiwan, and Singapore, Barnes serves commercial aviation, defense, industrial, and space customers and partners with OEMs on long-term manufacturing and aftermarket contracts.

📋 Description

• Legacy Data Platform Support • Maintain and enhance SSIS packages for data extraction, transformation, and loading • Support SQL Server data warehouse (staging, ODS, reporting layers) • Troubleshoot data issues, job failures, and performance bottlenecks • Optimize SQL queries, stored procedures, and indexing strategies • Ensure reliability of scheduled jobs via SQL Server Agent • Cloud Data Engineering (Azure + Databricks) • Design and develop data pipelines using Azure Data Factory (ADF) • Ingest and organize data into Azure Data Lake (Bronze/Silver/Gold layers) • Build scalable data transformations using Databricks (Spark SQL, PySpark) • Create curated, analytics-ready datasets for Power BI • Implement Delta Lake and support data governance (e.g., Unity Catalog) • Analyze and document existing SSIS/SQL pipelines • Translate legacy ETL processes into modern ELT patterns • Support phased migration strategy (coexistence of legacy and modern platforms) • Reduce technical debt and improve pipeline maintainability • Establish standards for data modeling, naming, and architecture • Design dimensional models (fact and dimension tables) aligned to business processes • Integrate and standardize data across multiple ERP systems • Translate business requirements into scalable data solutions • Partner with stakeholders to identify high-impact use cases for data and analytics • Deliver datasets that enable reporting, forecasting, and operational insights • Implement data validation, reconciliation, and monitoring processes • Ensure data accuracy and consistency across systems during migration • Define and enforce data quality standards and controls • Support data lineage, documentation, and transparency initiatives • Work closely with business stakeholders, analysts, and BI developers • Support Power BI semantic models and reporting solutions • Communicate technical solutions in business terms • Act as a 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 experience with SSIS and SQL Server • Experience with Azure Data Factory (ADF) or similar tools • Experience with Databricks (Spark, Delta Lake, or similar platforms) • Solid understanding of data warehousing concepts (star schema, fact/dimension modeling) • Experience integrating data from multiple source systems (ERP experience preferred) • Proven ability to translate business requirements into technical solutions

🏖️ Benefits

• Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities