Description

You will manage data extraction, transformation, and reporting processes centered around ProfitKey ERP systems.

Responsibilities

• Extract data from ProfitKey ERP for reporting, analysis, and integration.
• Develop and maintain ETL processes for regular and ad hoc reporting.
• Build SQL queries and scripts to retrieve data from ProfitKey databases.
• Support data migration and cleansing initiatives, including legacy system conversions.
• Develop dashboards and reports using Power BI, Crystal Reports, or Excel.
• Document extraction processes and maintain data dictionaries.

Required Skills

• 3+ years of experience in data extraction, analysis, or database management.
• Direct experience with ProfitKey ERP.
• Strong knowledge of SQL, stored procedures, and relational databases including SQL Server and Oracle.
• Proficiency with reporting tools such as Power BI, Crystal Reports, SSRS, or Excel VBA.
• Familiarity with manufacturing workflows, BOMs, inventory, and production planning data structures.
• Ability to translate business requirements into technical data solutions.

Preferred Skills

• Experience integrating ProfitKey data with other ERP systems or CRMs.
• Familiarity with data warehousing or business intelligence practices.
• Exposure to Python for automation.
• Experience working in manufacturing or industrial settings.

Key Skills

Education

Not specified