Data Engineer

ARx, LLC; Pennsylvania; On-site; USD 80,000 - 100,000; Full time

Job summary

ARx, LLC is looking for a Data Engineer to design, develop, and maintain scalable data solutions that drive enterprise analytics and reporting. The successful candidate will ensure data quality and security, and work on various data pipelines within a collaborative environment.

This position requires a bachelor’s degree in a relevant field along with 5+ years of experience in data engineering, particularly with SQL Server and Azure Data Factory. Competitive compensation and benefits offered.

Qualifications

• 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.
• Experience working with ERP (preferably Oracle EBS), MES, and CRM systems.

Responsibilities

• Design and maintain ETL pipelines using Azure Data Factory.
• Monitor and optimize database performance, indexing, and storage.
• Develop dashboards and datasets using Power BI.

Skills

SQL Server

Data Modeling

ETL Processes

Scripting (PowerShell, Python)

Data Warehousing

Data Governance

Performance Tuning

Education

Bachelor’s degree in Computer Science or related field

Tools

Azure Data Factory

Power BI

Oracle

Job description

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.
• Perform 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.