The company needs to design, develop, and maintain scalable data solutions to support enterprise analytics, reporting, and system integration. This involves ensuring data quality, security, and availability, and enabling robust and efficient data pipelines to support the organization's BI and data strategy.
Requirements
- 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.
Responsibilities
- 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.
Other
- 5+ years of experience as a Data Engineer or DBA in enterprise environments
- Ability to work cross-functionally with application, infrastructure, and support teams.
- Must be able to lift 50 lbs, bend, and climb stairs as needed.
- Ability to travel to company sites as required.
