Senior Data Warehouse Developer

RequirementsStrong experience in design and development of Data Warehousing Dimensional Models (using for example PostgreSQL/Teradata/Oracle/Microsoft/Amazon Redshift/BigQuery/Snowflake etc.)Strong skills in any ETL tool (Airflow, SSIS, etc.)A strong database knowledge and experience, including development, maintenance, optimization, troubleshooting (PostgreSQL, Oracle, MS SQL Server, etc.)Strong skills in SQL and PythonExperience pulling data from REST APIsExperience with Tableau is a plusExperience in design and management of data integrity / data validation processesBachelor’s degree in computer sciences is considered a plusAttention to detail, strong problem solving and communication skillsStrong level of English Prior to submitting your resume, the firm requests that you do the following: Ensure you are eligible to work in South Africa (no sponsorship)Review the firm’s website thoroughly at http://www.fxcm.com/ Company DescriptionThe FXCM group of companies (collectively, the “FXCM Group”) is a leading provider of online foreign exchange (forex) trading, CFD trading, spread betting and related services. Our mission is to inspire global traders with access to the world’s largest and most liquid market. By offering the most innovative trading tools, hiring the best trading educators, and meeting strict financial standards to protect trader funds, we strive for the best online trading experience in the market.FXCM is an Equal Opportunities EmployerJob DescriptionResponsibilities related to the position:We are looking for a Senior Data Warehouse Developer to join our growing Data Science and Analytics team. The role would involve working with our data warehouse and ETL processes to support the data needs of our team, as well as analysts from various departments all over the company. This would be ideal for somebody that is passionate about data — getting it, storing it, monitoring it, and turning it into something that can drive impact and value. The data will cover a wide range of information as needed from Sales, Operations, Compliance, Dealing, Marketing and more. We are continually looking to learn more, improve and expand, and are looking for candidates that have the same values. We need somebody who is detail oriented, focused on continually learning, and very importantly, must be proactive.Main Responsibilities: Work with business intelligence, data science and other analysts to manage and expand on the data warehouse architectureWrite and manage ETLs in order to extract data from multiple internal and external data sourcesConduct performance optimization and monitoring on the data warehouseMonitor data warehouse work and provide subject matter expertiseEstablish internal processes in order to ensure data integrity and consistencyAnalyze and test new data sources for availability and quality, and integrate with the data warehouseShare knowledge and expertise with other team members to enable continued team skills development