Systems Integration Manager

The Systems Integration Manager at Mill is responsible for transforming business data infrastructure. This includes gathering requirements from stakeholders, creating and maintaining data scripts, ensuring smooth data flow between various systems like PLM, ERP, and CRM, and serving as the main administrator for the Controlled Google workspace. The role also involves generating reports and training users on new workflows.

To qualify for the Systems Integration Manager position at Mill, candidates should possess strong scripting capabilities, ideally with an emphasis on Google applications. Experience with SQL systems and/or Snowflake for data querying is essential, along with a minimum of 5 years in Operations focused on business systems like PLM, CRM, and ERP, particularly in platforms such as Arena PLM and Netsuite ERP.

The Systems Integration Manager plays a pivotal role in Mill’s mission to prevent food waste and create a more sustainable environment. By ensuring accurate and efficient data flow, this position directly supports key decision-making processes vital to the company’s operations and sustainability initiatives.

While it is highly desirable for the Systems Integration Manager at Mill to have experience in a startup environment, it is particularly important to have strong communication and collaboration skills. Candidates should be able to engage with users effectively to gather requirements and train them on new systems.

The estimated base salary range for the Systems Integration Manager position at Mill is between $130,000 to $175,000. This compensation range does not include the additional value of benefits or potential equity grants. Factors influencing this range include skill sets, experience, and business needs.

In preparing for this question, you could outline a structured approach beginning with understanding the current data architecture, collaborating with stakeholders to gather their requirements, and then designing scripts that automate data transfers, reducing manual input errors.

When answering this question, you should highlight specific projects or experiences where you utilized SQL or Snowflake, focusing on how you performed data querying and management, and what outcomes this had on operational efficiency.

To effectively train users on new workflows, you could talk about creating user-friendly documentation, conducting hands-on training sessions, and following up to address any questions or challenges users might face.

A successful candidate would benefit from discussing techniques such as interviews, surveys, and workshops, along with emphasizing the importance of active listening and adaptability in understanding diverse stakeholder needs.

For discrepancies in business documents, you might explain your method of flagging these discrepancies through automated scripts and your strategies for communicating these issues to relevant stakeholders to ensure timely resolution.

In discussing challenges with integrating business systems, reflect on specific problems you encountered, such as conflicting data formats or stakeholder resistance, and how you effectively navigated through these situations.

You could mention subscribing to industry publications and blogs, participating in webinars, and attending relevant conferences to keep your skills current and stay informed about best practices in data integration.

When discussing automation, share specific examples of how you've successfully automated workflows in previous roles, what tools you used, and the impact it had on improving efficiency or reducing errors.

Provide a detailed example of a project where you focused on data accuracy, explaining the steps you took, the tools you employed, and how your actions contributed to improved outcomes.

In answering this, share your passion for sustainability and how it aligns with Mill's mission, along with discussing your excitement about contributing to a collaborative and innovative environment in the tech space.