{"id":10559,"date":"2025-05-19T10:00:38","date_gmt":"2025-05-19T10:00:38","guid":{"rendered":"https:\/\/jobs.dataaxisnode.com\/southafrica\/job\/data-warehouse-engineer\/"},"modified":"2025-08-20T00:24:34","modified_gmt":"2025-08-20T00:24:34","slug":"data-warehouse-engineer","status":"expired","type":"job_listing","link":"https:\/\/jobs.dataaxisnode.com\/southafrica\/?post_type=job_listing&p=10559","title":{"rendered":"Data Warehouse Engineer"},"content":{"rendered":"<p>About our client:<\/p>\n<p>\tOur 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&#8217; continuous learning. Using Agile, they provide diverse services with a focus on research, innovation and improvement.<\/p>\n<p>What you will be doing:<\/p>\n<p>\tDesign, develop, and modify database structures, relationships, data flows, and data interfaces within the data warehouse.<br \/>\n\tAnalyse, create and modify data structures to adapt to business needs and add enhanced functionality.<br \/>\n\tDevelop and modify ETL processes to load data from various sources into the data warehouse.<br \/>\n\tUse programming languages, software development methods, and best practices to develop new data warehouse structures and reports and modify existing ones.<br \/>\n\tUnit test and debug code.<br \/>\n\tParticipate in requirements gathering, analysis, technical design, testing, documentation and project planning.<br \/>\n\tConsult with clients to gather information about needs, objectives, and requirements.<br \/>\n\tIdentify and propose technical solutions to client requests and system problems.<br \/>\n\tFollow department standards and create written documentation and diagrams as required.<br \/>\n\tThorough understanding of data warehouse architecture, data structures, and fundamental design principles.<br \/>\n\tAbility to work independently with general supervision, which may include providing guidance and support to entry-level professionals or support staff.<br \/>\n\tContribute to the development of data warehouses for clients in the Insurance, Lending, and Employee Benefits sectors.<br \/>\n\tResponsible for software development, production support, and providing expertise in Data Warehouse and Reporting Applications.<\/p>\n<p>What our client is looking for:<\/p>\n<p>\tA relevant tertiary degree would be ideal (Computer Science, IT, Data Science, Information Systems, etc.)<br \/>\n\tStrong interest in analytical \/ dimensional modelling, and data analytics tools. Insurance knowledge is a plus.<br \/>\n\tIn-depth knowledge of business intelligence tools including data warehousing, and ETL (Extraction, Transformation, and Load). Yellowfin knowledge is beneficial.<br \/>\n\tKnowledge and understanding of the software development life cycle.<br \/>\n\tKnowledge and experience in relational databases, SQL, PostgreSQL.<br \/>\n\tExperience in database design and modelling for data warehouse and business intelligence applications, including relational database structures and normal forms.<br \/>\n\tAnalytical and troubleshooting skills for complex technical issues and tasks.<br \/>\n\tAbility to present and explain complex technical topics, problems, and alternative solutions to others.<br \/>\n\tExperience estimating solution development and delivering solutions within those estimations.<br \/>\n\tKnowledge of Insurance Systems.<br \/>\n\tExperience 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.<\/p>\n<p>Apply via company website ( http:\/\/www.parvana.co.uk ) or<\/p>\n<p>www.linkedin.com<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"author":2,"featured_media":0,"template":"","meta":{"_promoted":"","_job_location":"","_application":"http:\/\/www.linkedin.com","_company_name":"Parvana","_company_website":"http:\/\/www.parvana.co.uk","_company_tagline":"Who are we? Parvana was launched in 2006 by Sinead and David Baker. The market responded incredibly well to our passionate, high energy and fast response approach. Honesty, integrity and providing a great service are our key values. The Parvana team share in the same values. Our team is dedicated a... read morend committed to finding you your dream job. We have hired the best recruitment agents in Cape Town & the UK to work together to achieve these goals. Our team approach means every member of the Parvana staff is able to help you immediately no matter what your question. \"YOUR\" consultant being on leave or lunch won't ever hold you up. Why choose us? We would only refer you to clients that we ourselves would work for - our clients are carefully selected & share our values. We offer a career counselling service to all candidates with the goal of doing all we can to find your next \"home\u201d. We do our best to ensure the best possible cultural fit where staff are valued & well looked after. We have over 20 years of IT knowledge, contacts and reputation - we understand what you do & are committed to helping you define & your goals. We will always give prompt and regular feedback. How We Work: How We Search We like to understand what your goals are - career wise and financial, we will introduce suitable clients to you that offer you the challenges you crave and the rewards you deserve. We do all we can to provide you with as much information as we can to best enable you to make the right decision for your future. 40 Upper Torquay Avenue Bishopscourt Cape Town, Western Cape South Africa 7708","_company_twitter":"","_company_video":"","_filled":0,"_featured":0,"_remote_position":0,"_job_salary":"","_job_salary_currency":"","_job_salary_unit":""},"job_listing_region":[11],"job-types":[12],"class_list":{"0":"post-10559","1":"job_listing","2":"type-job_listing","3":"status-expired","4":"hentry","5":"job_listing_region-gauteng","7":"job-type-full-time"},"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/jobs.dataaxisnode.com\/southafrica\/wp-json\/wp\/v2\/job-listings\/10559","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jobs.dataaxisnode.com\/southafrica\/wp-json\/wp\/v2\/job-listings"}],"about":[{"href":"https:\/\/jobs.dataaxisnode.com\/southafrica\/wp-json\/wp\/v2\/types\/job_listing"}],"author":[{"embeddable":true,"href":"https:\/\/jobs.dataaxisnode.com\/southafrica\/wp-json\/wp\/v2\/users\/2"}],"wp:attachment":[{"href":"https:\/\/jobs.dataaxisnode.com\/southafrica\/wp-json\/wp\/v2\/media?parent=10559"}],"wp:term":[{"taxonomy":"job_listing_region","embeddable":true,"href":"https:\/\/jobs.dataaxisnode.com\/southafrica\/wp-json\/wp\/v2\/job_listing_region?post=10559"},{"taxonomy":"job_listing_type","embeddable":true,"href":"https:\/\/jobs.dataaxisnode.com\/southafrica\/wp-json\/wp\/v2\/job-types?post=10559"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}