Data Warehouse Engineer

About our client:
Our client offers financial service solutions helping their clients achieve their dreams. With an emphasis on culture fit, they boast a dedicated team of over 600 employees, many with over a decade of tenure. They have built their culture on a feeling of togetherness, trust and respect and are always looking to support employees' continuous learning. Using Agile, they provide diverse services with a focus on research, innovation and improvement.

What you will be doing:

• Design, develop, and modify database structures, relationships, data flows, and data interfaces within the data warehouse.
  
• Analyse, create and modify data structures to adapt to business needs and add enhanced functionality.
  
• Develop and modify ETL processes to load data from various sources into the data warehouse.
  
• Use programming languages, software development methods, and best practices to develop new data warehouse structures and reports and modify existing ones.
  
• Unit test and debug code.
  
• Participate in requirements gathering, analysis, technical design, testing, documentation and project planning.
  
• Consult with clients to gather information about needs, objectives, and requirements.
  
• Identify and propose technical solutions to client requests and system problems.
  
• Follow department standards and create written documentation and diagrams as required.
  
• Thorough understanding of data warehouse architecture, data structures, and fundamental design principles.
  
• Ability to work independently with general supervision, which may include providing guidance and support to entry-level professionals or support staff.
  
• Contribute to the development of data warehouses for clients in the Insurance, Lending, and Employee Benefits sectors.
  
• Responsible for software development, production support, and providing expertise in Data Warehouse and Reporting Applications.
  

What our client is looking for:

• A relevant tertiary degree would be ideal (Computer Science, IT, Data Science, Information Systems, etc.)
  
• Strong interest in analytical / dimensional modelling, and data analytics tools. Insurance knowledge is a plus.
  
• In-depth knowledge of business intelligence tools including data warehousing, and ETL (Extraction, Transformation, and Load). Yellowfin knowledge is beneficial.
  
• Knowledge and understanding of the software development life cycle.
  
• Knowledge and experience in relational databases, SQL, PostgreSQL.
  
• Experience in database design and modelling for data warehouse and business intelligence applications, including relational database structures and normal forms.
  
• Analytical and troubleshooting skills for complex technical issues and tasks.
  
• Ability to present and explain complex technical topics, problems, and alternative solutions to others.
  
• Experience estimating solution development and delivering solutions within those estimations.
  
• Knowledge of Insurance Systems.
  
• Experience with or knowledge of most of the following software, languages and tools, or similar products would be preferred: SQL Server DBMS, T-SQL (ANSI), PostgreSQL, Python.
  

Job ID:

• J106874
  

For a more comprehensive list of opportunities that we have on offer, do visit our website - https://www.parvana.co.uk/careers