Database Administration Specialist

About Us:

Datacor is the leading provider of software solutions, including ERP, CRM, Asset Tracking, Simulation and Formulation, to the process manufacturing space. We are on a mission to better equip the industry with software solutions and move it forward by building thoughtful, intuitive products that solve our customers’ most difficult problems.

We are passionate about serving our customers and helping them use data as a competitive advantage. Our customers make products that extend and sustain lives by sanitizing, fertilizing, beautifying, cleaning, and recycling the world we live in. We at Datacor help our customers make those products you use every day more safely, cost effectively and more efficiently through our technology platforms and applications.

The Role:

The Database Administration Specialist will work with Datacor’s Implementation and Consulting team.

Within the first year of employment, a successful Database Administration Specialist will…

• Develop and maintain accurate and up-to-date documentation on data migration procedures, including data mapping, transformation rules, and data validation rules.
• Conduct data analysis to identify patterns and trends and use this information to improve data quality and recommend process improvements to enhance overall data migration efficiency.
• Consistently contribute to Datacor’s knowledge base.

Responsibilities:

• Manage multiple data migration projects concurrently
• Extract data from various database formats, including but not limited to SQL Server, QuickBooks, MySQL, Microsoft Access, and Excel spreadsheets
• Modify or design reports in Microsoft Access
• Work closely with stakeholders to understand data requirements and ensure that data is accurately mapped to the appropriate fields within our company's ERP data schema
• Develop and execute data migration plans, including identifying and resolving any data quality issues, to ensure the successful migration of data from legacy systems to Datacor's ERP software
• Collaborate with Datacor’s Support team during handoff of the project post go-live
• Provide Datacor’s Support team with assistance on tickets as needed

Qualifications:

• Bachelor'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