Tech Stack
ERPMS SQL ServerMySQLSQLVBA
About the role
- Datacor is a provider of ERP, CRM, Asset Tracking, Simulation and Formulation software for process manufacturers
- Work with Datacor9;s Implementation and Consulting team
- Within the first year: develop and maintain documentation on data migration procedures, including data mapping, transformation rules, and data validation rules
- Conduct data analysis to identify patterns and trends and recommend process improvements to enhance data migration efficiency
- Consistently contribute to Datacor9;s knowledge base
- Manage multiple data migration projects concurrently
- Extract data from various database formats including SQL Server, QuickBooks, MySQL, Microsoft Access, and Excel
- Modify or design reports in Microsoft Access
- Work with stakeholders to map data to Datacor9;s ERP schema
- Develop and execute data migration plans and resolve data quality issues
- Collaborate with Support team during project handoff and assist with support tickets as needed
Requirements
- Bachelor9;s degree in Business Administration, Accounting, Computer Science, Mathematics, or Engineering preferred
- Microsoft Access, VBA, and/or Microsoft SQL Server database experience
- Knowledge of relational databases and experience writing SQL queries
- Strong analytical and problem-solving skills
- Strong organizational and project management skills
- Self-directed with the ability to work in a fast-paced environment
- Exceptional time management
- Proficiency with Microsoft Office Suite