BI & Integrations Developer (remote working) - JMK Resourcing Solutions : Job Details

Due to growth within the business and IT Team, my design and manufacturing client is looking to recruit an experienced Business Intelligence & Integrations Developer who will report into the Head of IT.

Remote working with attendance at the office when required.

Job Purpose

Working as part of the IT team, you will manipulate customers and suppliers data, enabling integration into or out of our ERP or other systems and then provide business data in many forms, to users, customers and suppliers, to help the business function more efficiently. The business currently has over 200 reports and integrations that need maintaining and updating.

Key Accountabilities

• Create new Integrations based on Customer/Supplier/Business requirements to enable data to flow with minimum interaction by staff.
• Create/Maintain Existing Report base, including Excel Refreshable, Power BI and SSIS.
• Create/Maintain Existing Integrations, including CSV, Excel, XML, API to/from Systems.
• Speak with Customer IT Integration Teams, to design, develop, test and implement new Integrations.
• Document Developments for users if needed and Technical Staff for reference.
• Look at new and better ways/tools to Report and Integrate the systems which will work with BC and other internal systems.
• Help the business to design and deploy SharePoint within Business Areas such as IT, HR, H&S to better communication around the business.

Key Challenges and Decisions

• Ensure Integrations and Reports continue to run successfully.
• Work closely with the IT team and users at all levels to understand issues and come up with solutions to problems.
• Maintain the IT SharePoint Project Planner with regards to your jobs and updates.
• Understand Database Schema for multiple systems.
• Have excellent time management skills to ensure tasks are completed on time.
• Manage multiple requests for information and technical data, dealing with multiple customers politely and professionally.

Internal and External Relationships

• Work with UK teams to understand what it is they require.
• Work with our customers and suppliers worldwide to capture all the information needed to fulfil requests.
• Interact with staff at ALL levels of the business and Group of Businesses.

Person Specification

• Good problem solving and solution design skills.
• Indepth experience with SSIS is required
• Proficiency in data warehousing, SQL, and data integration
• Experience with Power BI or similar tools
• Advanced use of Excel
• Experience of Derived Columns
• Experience of a supply chain / product focused / outsourced manufacturing environment would be beneficial
• Knowledge of invoice processing and supply chain functions
• Excellent attention to detail
• Excellent communication skills both written and verbal
• Able to complete tasks and deadlines effectively
• Able to work on own and drive self performance
• Able to communicate effectively to peers and management
• Knowledge of Dynamics NAV or Business Central (a plus)
• Knowledge of HubSpot (a plus)
• Knowledge of Microsoft 365 and Microsoft Fabric (a plus)
• Experience of working with colleagues from overseas countries (desirable)