Barnes Group

Data Engineer

Barnes Group • $90K — $130K *
US-AnywhereRemote in United States
Information Technology
Less than 5 years of experience
Today
Be an Early Applicant
Job Overview by Ladders

Qualifications

  • 4-8+ years in data engineering or data warehousing
  • Strong SQL skills (T-SQL and/or Spark SQL)
  • Experience with SSIS and SQL Server
  • Familiarity with Azure Data Factory (ADF) or comparable tools
  • Hands-on knowledge of Databricks (Spark, Delta Lake)
  • Understanding of data warehousing concepts (star schema, fact/dimension modeling)
  • Experience in integrating data from multiple source systems, preferably ERP systems
  • Ability to convert business needs into technical solutions

Responsibilities

  • Maintain and enhance SSIS packages for data operations
  • Support SQL Server data warehouse processes
  • Troubleshoot data issues and performance bottlenecks
  • Optimize SQL queries and stored procedures
  • Ensure reliability of scheduled SQL jobs through SQL Server Agent
  • Design and develop data pipelines using Azure Data Factory
  • Ingest and organize data into Azure Data Lake layers
  • Build scalable data transformations with Databricks
  • Create analytics-ready datasets for Power BI
  • Implement Delta Lake and support data governance efforts
  • Design dimensional models aligned with business processes
  • Partner with stakeholders to identify valuable data use cases

Benefits

  • Flexible work environment
  • Opportunities for professional development
  • Health, dental and vision insurance
  • Retirement savings plan with employer match
  • Paid time off and holiday pay
Full Job Description
Core Responsibilities:

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)


Migration & Modernization

  • 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


Data Modeling & Business Value Creation

  • 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


Data Quality & Governance

  • 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


Collaboration & Stakeholder Engagement

  • 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


Qualifications:

Required Qualifications

  • 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


Preferred Qualifications

  • 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


Technical Skills

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


About Barnes Group

Barnes Group Inc. is a global industrial and aerospace manufacturer and service provider, serving a wide range of end markets and customers. The company operates through two business segments: Industrial and Aerospace. The Industrial segment designs and manufactures precision parts, products, and systems for critical applications in various industries, including transportation, industrial equipment, and packaging. The Aerospace segment designs and manufactures components and assemblies for commercial and military aircraft engines and airframes. Barnes Group was founded in 1857 and is headquartered in Bristol, Connecticut. The company is publicly traded on the New York Stock Exchange (NYSE).
Learn more about Barnes Group
Size
5,100 employees
Market Cap
$2 billion
Industry
Manufacturing & Automotive
Net Income
$63.3 million
Founded
1857
5 Year Trend
+0.5%
Revenue
$1.1 billion
NASDAQ
B
* Ladders Estimates

Similar Jobs

Ad banner background

Get Ready For Your
Next Interview

More Jobs at Barnes Group

More Information Technology Jobs

Find similar Data Engineer jobs:

NationwideRemote