Data Engineer - Onsite Position

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.

Please note - this position is 100% onsite. Business is located in Glen Rock, PA.

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 :

Job Specifications :

Desirable :

Custom connectors and external API integration

Physical Requirements