Solution Designers specialising in Integration and Analytics Required

Location: Australia, Melbourne, Sydney

Work Type: Permanent Full-time

LOB Reports to: General Manager

Project Reports to: Lead Consultant

Job Purpose

The role of Solution Designer is to work closely with the Developer/s and the Lead Consultant in designing the technical solution for integration and data analytics projects. The role involves working in a small highly skilled and experienced, but diversified team at the Interprit central development centre which requires staff to be adaptable to changing customer project needs.


Role Responsibilities

Working closely with the Developers and the Lead Consultant, the role includes:

        Gathering, documenting and analysis of detailed customer requirements

        Developing and maintaining requirements, and design document templates

        Development of detailed requirements and solution designs for Microsoft technology based solutions in systems integration and data analytics.

        Creating and ensuring traceability between requirements and solution design

        Communicating solution designs and development instructions to developers

        Involvement with the Developers in the development and testing of the solution as required

        Attending customer sites with the Lead Consultant for requirements gathering and design specification activities

        Involvement in sales activities such as solution estimation and architecture

        Producing SDLC documents such as solution designs and technical designs including support documents when required

        Ability to perform development build, unit testing and system testing when required

        Participating in SCRUM/AGILE team environments

        Mentoring Developers in developing their requirements analysis and solution design capability

        Keeping up-to-date with Microsoft Integration and Data Analytics related technology solutions

        Contributing to company IP via solution architecture and designs


Key Accountabilities (KPI’s)

        Effective ability to gather requirements

        Solution Design quality via peer review

        Proficiency in adopting new technologies

        Effectiveness within a development team


Essential Skills

        Must be experienced in determining customer requirements to understand what they need, and not what they say they want.

        Must be very experienced completing detailed technical solution designs in at least 4 of the following Microsoft technology areas and familiar with the remaining areas. Of those 4, at least one from each skill area (Integration and Data Analytics).


o       Enterprise Messaging

     BizTalk Server

     Azure Logic App, API App and Azure Service Bus

o       API - Web services including SOAP and ReST services (XML and JSON)

     ASP.NET MVC and related frameworks including Entity Framework, Web API

     IIS, Azure API Apps, API Management

o       ETL

     SQL Server Integration Services (SSIS)

o       IOT

     Azure IOT Suite, Event Hub and Stream Analytics

Data Analytics

o       Business Intelligence - Data warehouse

     SQL Server, including SQL Server Database, Analysis Services (SSAS) and Reporting Services (SSRS)

     Azure SQL Data warehouse

     Mobile reporting

o       Interactive Data Visualisation

     Power BI

o       Big Data Analytics

     HDInsight – Hadoop and/or Spark,

     Data Factory


     Machine Learning

        Must be generally familiar with the broad spectrum of Microsoft products and services

        Understand the SDLC and have embraced best practices from SCRUM/AGILE


Desirable Skills

        Has worked in a consulting environment previously

        Advanced Azure knowledge

        Advanced Integration knowledge

        Advanced Business Intelligence and Analytics knowledge

        A bachelor’s degree in Computer Science or equivalent

        Microsoft or Industry Certifications preferably in Design and Architecture


Personal Attributes

        Enjoys a varied and flexible role working on multiple projects at once

        Has a proactive and positive work ethic

        Enjoys working with and learning about the latest technology

        Show lots of initiative