BI & ETL Developer (Senior) at Discovery Limited

Key Purpose

• The core function of the position is to design and deliver state of the art business intelligence and data solutions to support analytics and reporting requirements according to provided specifications, standards, and procedures, using various tools and languages but within the architectural standards and guidelines as established within the Discovery group to obtain optimal systems performance.
• A highly skilled technical business intelligence developer with a desire to work in fast-paced environment, with the ability to consistently deliver exceptional results on demanding timelines.
• Development, maintenance and management of both production and development data warehouse environments.
• Produce complex specifications and implement systems enhancements. Work with the system architect to define the system design and then develop and test the necessary code that will be deployed.

Key outputs:

The successful applicant will be responsible for but not limited to the following job functions:

• Deliver effective technical documents, design, code, and data structures to integrate and prepare data within the warehouse environments to support business requirements for reporting and analytics requirements
• Design and delivery of high-quality automated reports and dashboards to support a variety of business needs
• Develop code and data structures in adherence with Agile principles, code, and configuration management standards
• Develop efficient and effective BI solutions on cloud and on-premise infrastructure
• Work with the requirements, architecture and business teams to deliver business intelligence solutions in line with requirements
• Support existing systems by Investigating, identifying and rectifying problems and identify potential BI improvements and implement appropriate solutions
• Define / Implement / Promote BI best practices
• Efficient time management ensuring delivery within the agreed timeframe as per the project plan and logging of time according to time keeping policy and daily admin on tasks
• Perform Test, debug and quality assure programmed code Ensure that unit testing is conducted successfully accordingly to the functional specification document, user requirements and test pack.
• Attend all technical, user and team meetings as required
• Liaise with stakeholders as required by the project including Development manager, Systems architect, Systems Analysts, Business analysts, to clarify requirements, review designs and obtain required approvals and provide updates
• May lead projects or project steps within a broader project or have accountability for ongoing activities or objectives
   

Competencies

• Strong technical experience and knowledge across multiple disciplines including Data warehouse ETL, design, modelling and methodologies,.
• Microsoft SQL Server technologies 2016 (Integration, Analysis and Reporting Services), Power BI, Visualization and reporting tools
• Oracle PL/SQL
• Prior Experience delivering BI/data structures on a cloud setup AWS
• Advanced SQL development skills, Advanced SSAS and SSIS development / support
• Understanding of dimensional modelling concepts
• Expertise in handling large amounts of data through such capabilities as SQL Server or open source databases and performing tuning across database platforms.
• In addition to querying traditional RDS instances, exposure and knowledge of acquiring data from API calls, xml, streaming events.
• Ability to communicate clearly and to guard all business relationships in a professional way
• Test methodologies.
• Programming logic must be on the highest level possible.
• Insurance Industry experience would be beneficial

Desirable

• Prior experience on Big Data appliances such as Hadoop.
• Hands-on/technical experience with high proficiency on Big Data technology and toolsets
• Python coding, Powershell scripting capability
• Understanding of Docker
   

Personal Attributes and Skills

• Ability to take ownership and accountability working independently, with minimal guidance
• Ability to work under pressure and to multi-task
• Excellent communication skills with the ability to communicate clearly and to guard all business relationships in a professional way
• Ability to work in a dynamic rapidly changing environment - Keep abreast of current technological trends and the application thereof
• Ability to work in a customer servicing environment across teams at all business levels
• Strong problem solving and Analytical skills.
• Able to work in conditions of change, flexible and open to learn new languages and architecture, learn quickly and share knowledge.
• Ability to deal with complexity and migrate between detail and high level requirements
• Work mostly within own team with ability to works across several teams, may act as a resource for colleagues with less experience
• Recognize unique demands of IT of non-conventional working hours
• Ability to deal with complexity and migrate between detail and high level requirements
   

Regulatory Responsibilities

You are required to understand and comply with all relevant rules, regulation and legislation applicable to your role.  This means:

• acting with integrity and due skill, care and diligence at all times.
• ensuring that customers are treated fairly at all times
• ensuring that communications via any medium meet the principle of 'clear, fair and not misleading'
• undertaking relevant internally arranged training on systems, processes and regulatory requirements relevant to your role
• identifying and escalating (through your line manager) risks that impact the business, customers or other third parties
• reporting (through your line manager) any issues and/or system/process failures that may impact on service to customers
• Further details of relevant regulation can be found on the vitality.co.uk intranet.
   

Education and Experience:

Education:

• Matric
• BSc (IT/Computer Science) or any other relevant Computer Science Degree
• Formal Qualification in related competencies
   

Experience:

• Must have a minimum of 5 years Systems Development experience
• Must have a minimum of 5 years Product (Oracle, Microsoft SQL Server) specific experience
• Must have a minimum of 3 years Oracle PL/SQL experience.
• Must have a minimum of 3 years Data Warehousing experience
• Technical Lead experience