Note: The job is a remote job and is open to candidates in USA. Barnes Aerospace is a company focused on data solutions, and they are seeking a Data Engineer to maintain and enhance data platforms. The role involves designing data pipelines, ensuring data quality, and collaborating with stakeholders to create scalable data solutions.

Responsibilities

• 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
• 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

Skills

• 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
• Experience migrating legacy ETL systems (SSIS) to cloud-based architectures
• Proficiency in Python or PySpark
• Familiarity with Medallion architecture (Bronze/Silver/Gold)
• Experience with Power BI data modeling and performance optimization
• Knowledge of data governance tools (e.g., Unity Catalog)
• Experience with Git and CI/CD pipelines
• Exposure to dbt or similar frameworks

Company Overview