Data Engineer

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.

Desirable:

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