Prototyping Specialist

**JOB TITLE**:Prototyping Specialist

**DEPARTMENT**:Data & Decision Science

**REPORTING TO**:Senior Prototyping Specialist**:
**LOCATION**:Bedfordview, South Africa

**PURPOSE OF POSITION**

**KEY RESPONSIBILITIES**
- Continuous improvement in how we deliver BAU Data, reports and other Information outputs that are published and/or distributed to our client base
- High proficiency in SQL in terms of:

- Writing optimised simple and complex queries
- Write or amend SSIS packages
- Build or amend SSRS reports
- Build or amend dashboards on PowerBI
- Write or amend procedures and functions
- Create tables or Views
- Automate repeat work that happens in the team, whilst ensuring consistency in terms of Data integrity and publication
- Investigate new automated mechanisms to monitor data daily diagnostics in terms of data quality, exceptions, completion and accuracy and alter diagnostic scripting accordingly
- Have internal Gilbarco interactions when required to keep abreast of our changing and evolving data assets and landscape so that DDS data management & solutions can be aligned
- Identify key challenges or business issues within DDS and the greater Gilbarco to pave the way for innovative technical and data solutions
- Use BI developer standards to ensure all development results in efficient processing
- Ensure all developed work is documented and stored on Vontier SharePoint: detailing proposed solutions which are tracked and comprehensively documented and updated to Vontier SharePoint so that all successes and failures can be used as reference material for any new development work
- Conduct multidimensional analysis to fully understand the client business issue(s) and then test best-fit solutions and dispense insight driven DDS products
- Build robust data structures and products that are industry-agnostic
- Adhere to good governance, risk and compliance within the DDS management function and within the broader Gilbarco governance standards
- Ensure Quality Assurance processes and checks are in place for all work outputs
- Manage, build and/or improve on the DDS reporting, analytics and data exploration capabilities.
- Partake in Bi-annual performance appraisals. Discuss development plans with manager and structure work in such a way that it enables for business continuity within the team by removing key person dependencies and fosters a culture of cross-skilling across various client portfolios Gilbarco Supports

**DELEGATION OF AUTHORITY**
- As per DOA

**POSITION RELATIONSHIPS**

**Internal**
- Interact at all levels internally.
- Develop solid internal service delivery relationships with each business unit leader and internal DDS team members

**MEASURES OF PERFORMANCE (INDICATORS)**

**Quality**
- 98% OTD of Data, Data Management & Business Intelligence projects and development solutions
- 98% Quality Target met for all outputs

**Best Team Wins**
- Increase engagement of reporting team by 5%
- Increase performance enablement of reporting team by 5%

**HSSE**
- HSSE NM/PI targets met

**PERSONAL QUALIFICATIONS & EXPERIENCE**

**Education/achievements**

**Required**
- A degree in computer science, Information Technology, Data Engineering or Data Management

**Preferred**
- An honours (or higher) degree in computer science, Information Technology, Data Engineering or Data Management

**Experience/Knowledge**
- A minimum of 5 years of progressive responsible experience in a directly related area, during which technical, analysis rapport has been established as a Data professional.
- Extensive experience in the Data, Analysis, Business Intelligence (Analysis and developer) space as Data professional.
- Demonstrated Experience in Influencing and directing conversations with others through storyboard telling
- Experience in Navigating known-unknowns as well as unknown-unknowns in a data trend/relationship at a technical level
- Technical skills:

- Extensive expertise in Microsoft data management technologies coupled with extensive expertise in data modelling, both logical and physical (Technologies: SSIS, SSRS, SSAS, Power BI)
- Extensive experience in multidimensional data modelling, such as star schemas, snowflakes, de-normalized models, handling “slow-changing” dimensions/attributes.
- Experience in optimising queries and storprocs
- Extensive Experience in large and structured or unstructured data sets
- Experience in Cloud technologies
- Experience in Database Administration and Management functions
- Experience and understanding of a wide variety of analytical processes (governance, measurement, etc.).
- Experience with relational - SQL - and/or multidimensional - MDX - query languages
- A solid understanding of data security and privacy technologies
- A solid understanding of key Data solutions trends.

**Specific Skills**
- High level of computer literacy, MS Excel, Data technologies (SQL: SSIS, SSMS, Power BI, (Master); SSRS & SSAS (Basic))
- Ability to operate in ambiguity and within the co