> Markdown version of [/jobs/ext/1720718-data-engineer](https://www.wearedevelopers.com/jobs/ext/1720718-data-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Engineer - **Company:** Barnes Inc. - **Location:** Bristol, CT, United States - **Experience:** Experienced - **Contract:** Permanent contract - **Skills:** Microsoft Azure, Business Intelligence Development, Cloud Database, Data Validation, Information Engineering, Data Governance, Data Integration, Extract Transform Load (ETL), Data Mining, Data Warehousing, Database Queries, Apache Hive, Python (Programming Language), Microsoft SQL Server, Performance Tuning, Query Optimization, Power BI, Migration Manager, Azure Data Lake, SQL Stored Procedures, SQL Databases, SQL Server Agent, SQL Server Integration Services, Transact-SQL, Cloud Platform System, Azure Data Factory, Database Optimization, Apache Spark, Technical Debt, Git, Data Lakes, Pyspark, Data Lineage, Collibra, Data Analytics, Star Schema, Tools for Reporting, Software Version Control, Data Pipelines, Databricks - **Published:** July 3, 2026 - **Apply:** https://jobs.localjobnetwork.com/apply/add/87635068/1 ## About the Role * 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 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) ## Description * 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 ## Related Videos - [PySpark - Combining Machine Learning & Big Data](https://www.wearedevelopers.com/videos/44-pyspark-combining-machine-learning-big-data) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [Empowering Retail Through Applied Machine Learning](https://www.wearedevelopers.com/videos/976-empowering-retail-through-applied-machine-learning) - [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) ## Related Articles - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)