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