Data Engineer

We pride ourselves on our culture that is made up of impeccably skilled, passionate professionals. Our team varies from veterans of the industry to fresh faced young bloods who are ready to shape the future. If you believe that you’re a fit and feel as if Dotcom is an environment you can thrive in... then WE WANT YOU!

BI: Our portfolio spans all the way from visualisation, Bi and data analytics to customer journey and data science solutions. This allows our customers to effortlessly explore data through automated predictive analytics that provide business insights.

We are currently recruiting for a Data Engineer with extensive experience working in the Short Term Insurance industry. Key responsibilities:

• Data Ingestion, Transformation, ETL, Data Modelling, Data Architecture and Storage management.
• Translation of business requirements into usable cloud hosted data architecture, which will include an enterprise data model, associated metadata and common business glossary that are used to guide enterprise solution development and achieve consistency of data assets 
• Take business requirements, knowledge of current and future state architecture on data platform design and business capabilities, knowledge of enterprise data standards and deep data expertise into account, to design data architecture solutions that can be implemented in a cost- effective manner. The specific tasks performed will include analyzing business requirements and translate them into data solutions to address complex business needs.
• Provide month-end production rotational support to ensure data is consumed and ingested to ensure reports are generated within agreed SLAs with business.
• ETL development into staging and data warehouse environments.
• Develop and maintain data sets, ETL processes and reports related in order to support operations and decision making related to commercial and personal insurance, provide direct support to end-users.
• Collaborate with business users and application developers to provide required data. Validate data and test routines developed & provision of ongoing maintenance and support of assigned ETL applications
• Analyze the systems environment to understand how the business systems enable these business processes and how the related data is captured and stored. Analyze the structures in which the data is stored to understand what data can be extracted and how it would be done in an efficient manner.
• Analyze the existing reporting environment to understand what reporting is available and how this can be utilized or amended to inform the specific Business decisions involved.
• Test all developments for data accuracy, performance and system impact & engage relevant Business users, train them on report usage and guide them in doing user testing.
• Schedule data extracts and report runs as required to deliver the required information to users at the necessary frequency. 
• Update technical documentation on data extracts and report functionality to facilitate future understanding to the extent required for ongoing support. Respond to user queries, error logging and further enhancement requests to ensure reports are used and serve their intended purpose.
• Provide OLAP support and end-user training on the various cubes used for reporting downstream
• Data Modelling - emphasizes on what data is needed and how it should be organized instead of what operations need to be performed on the data. 
• Data Architecture – ensures that we have composed of models, policies, rules or standards that govern which data is collected, and how it is stored, arranged, integrated, and put to use in data systems and in organizations. 

Experience and Skills required:

• 5+ years’ experience of delivering Business Intelligence projects using Microsoft & Informatica tools, Visualization Tools (SSRS, Power BI). 
• 5 years+ Experience in cloud computing infrastructure (e.g., MS Azure, Amazon Web Services etc.) and considerations for scalable, distributed systems
• 5 – 7 years’ experience delivering business capabilities in the short-term insurance business, including hands on experience in the development and design of functional and non-functional technical specifications for complex systems
• Short-term insurance business is a key requirement and not negotiable.

• Ability to produce solutions using:
  • Microsoft SQL Integration Services, MS SQL Analysis Services, MS SQL Reporting Services, MS PowerBI, Qlikview, Informatica (Power-center & PWX CDC)
  • Knowledge of & Scaled Agile Framework (SAFe) practices will be advantageous
  • Knowledge of Cloud Services (Azure & AWS) is critical