Data Engineer

Adhesives Research, Inc.; Pennsylvania; On-site; USD 90,000 - 120,000; Full time

Job summary

Adhesives Research, Inc. is seeking a Data Engineer to design, develop, and maintain scalable data solutions for analytics and reporting. You will ensure data quality and security while contributing to data strategy through efficient data pipelines.

The ideal candidate will have a Bachelor’s degree in Computer Science, 5+ years of relevant experience, and proficiency in SQL Server and Azure Data Factory. This full-time position is based in Glen Rock, PA.

Qualifications

• 5+ years of experience as a Data Engineer or DBA in enterprise environments.
• Hands-on experience with SQL Server and Azure Data Factory.
• Strong experience in relational databases and performance tuning.

Responsibilities

• Design and maintain ETL pipelines using Azure Data Factory.
• Manage lifecycle of on-prem and cloud-based databases.
• Monitor and optimize database performance.

Skills

SQL

Data Warehousing

Data Modeling

ETL Processes

Power BI

Scripting (PowerShell, Python)

Education

Bachelor’s degree in Computer Science or related field

Tools

SQL Server

Azure Data Factory

SSIS

Oracle EBS

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Full Time Glen Rock, PA, US

30+ days ago Requisition ID: 1563

Job Summary

The Data Engineer will design, develop, and maintain scalable data solutions that support enterprise analytics, reporting, and system integration. This role combines traditional database administration (DBA) responsibilities with modern data engineering, including ETL/ELT processes, data warehousing, and performance optimization. The ideal candidate will ensure data quality, security, availability, and contribute to the organization’s BI and data strategy by enabling robust and efficient data pipelines.

Essential Functions

• Design, develop, and maintain ETL pipelines using tools such as Azure Data Factory, or equivalent.
• Manage the lifecycle of on-prem and cloud-based databases (SQL Server, Oracle, or similar).
• Monitor, tune, and optimize database performance, indexing, and storage.
• Develop and publish dashboards, datasets, and data models using Power BI.
• Maintain enterprise data warehouse structures and support reporting platforms (e.g., Power BI).
• Develop and implement data governance, validation, and data quality frameworks.
• Work with application teams to define data requirements and integrations from ERP, MES, CRM, and other enterprise platforms.
• Automate recurring tasks using scripting tools (PowerShell, Python, etc.).
• Define and maintain data dictionaries, data lineage, and technical documentation.
• Ensure high availability, backups, and disaster recovery for all data systems.
• Secure sensitive data in compliance with company policies and frameworks like NIST, ISO 27001, and 21 CFR Part 11.
• Collaborate with business analysts and developers to support analytics use cases and dashboards.

Additional Responsibilities

• Provide Tier 3 support and troubleshooting for data-related issues.
• Document data architecture, transformations, and design patterns.
• Evaluate and recommend tools or platforms for data integration and visualization.
• Participate in audits and assessments related to data privacy and compliance.
• Collaborate with cross-functional teams to ensure alignment between business systems and operational needs.
• Support compliance with IT policies, procedures, and regulatory requirements.
• Participate in IT projects and system implementations.
• Performs other duties and responsibilities as assigned.

Job Specifications

• Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or a related field
• 5+ years of experience as a Data Engineer or DBA in enterprise environments
• Hands‑on experience with SQL Server, SSIS, and/or Azure Data Factory.
• Strong experience in relational databases, data modeling, and performance tuning.
• Solid understanding of data warehousing concepts and dimensional modeling.
• Experience working with ERP (preferably Oracle EBS), MES, and CRM systems (e.g., SugarCRM) for data extraction and integration.
• Proficiency with scripting languages such as PowerShell or Python.
• Familiarity with cloud platforms (Azure or AWS) and hybrid architecture.
• Experience with compliance frameworks like 21 CFR Part 11, ISO 27001, and NIST.
• Certifications in Azure Data Engineer, Oracle DBA, or project management (e.g., PMP).
• Experience with:
  • Custom connectors and external API integration
  • Integration of CRM with ERP, email, or marketing platforms
  • ITSM tools and structured change management processes
  • Working in validated or regulated environments
• Ability to work cross‑functionally with application, infrastructure, and support teams.

Physical Requirements

• Must be able to lift 50 lbs, bend, and climb stairs as needed.
• Ability to travel to company sites as required.