Note: The job is a remote job and is open to candidates in USA. Barnes is seeking a Data Engineer to support their data engineering initiatives. The role involves maintaining and enhancing data pipelines, optimizing SQL queries, and ensuring data quality across systems while collaborating with stakeholders to deliver impactful 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