Yesterday
Data Engineer
Ad Talent
South Africa, Johannesburg
Who are we: An international group of companies within the hospitality industryWho are we looking for:  A data Engineer with a high degree of proficiency in SSIS, SQL, SSAS Cubes, DAX, MDX and building stored proceduresWhat will you do:The Data Engineer will be responsible for designing data models, maintaining, and optimizing data infrastructure for data collection, management, transformation, and access. They will be responsible for building and maintaining data pipelines from source systems to the data warehouse and data lake. They will work closely with the data scientist to build machine learning and analytics infrastructure.Collaborate with data scientists to prepare data sets for analytical modellingContribute to and ensure solutions align to the design and direction of the company technology evolutionEnsure adherence to data standards, principles, preferences & practices. Short term deployment must align to strategic long-term delivery.Assess external data management opportunities and threats and develop security, back-up, and recovery specifications.Project manage and document installations and actions taken around the development and amendment to databases and dashboardsDefine requirements for the Datawarehouse scaling to optimize performance and cost management.Maintains database performance by identifying and resolving production and application development problemsCheck the conformance of the delivered data warehouse to standards and architectural decisions and resolve design and architectural conflicts by explaining and justifying design and architectural decisionsConduct investigations and analyses into potential technology innovations, and deliver a data architecture to support the future business growth and streamline processesCollaborate with business process owners and management to determine database structural requirements by analysing client operations, applications, and programming; reviewing objectives with clients; evaluating current systemsDesign solutions and update the data warehouse infrastructure to manage data requirements in the organisation, including the daily monitoring and management of the functionality and optimal performance of various databasesDevelop algorithms and manage data warehouse processes, visualisation and reporting using application lifecycle management (ALM) tools to ensure predictability and reliabilityDevelop data management reports for various business stakeholders in order for them to complete required analyses and make business decisionsDevelop standards and processes for database management aligned to legislation, gaming regulation requirements and security protocols – ensuring they are updated and communicatedImplement sufficient control measures (including systems and processes) & checks to mitigate any risk to the businessEnsure own competence to meet changing technology and database architecture requirements remains relevant, and receive necessary training and updatesConduct testing and audit compliance of new or enhanced products to ensure requirements of key stakeholders (customers, staff and gambling boards) are met.Ensure a complete understanding of information flow and system architecture and how it relates to underlying data structuresReview the interfaces tracking dashboards and reports in order to resolve any data issues timeouslyLiaise with Compliance function to discover data regulatory requirements for inclusion when integrating key data policies and standardsEstablish appropriate levels of co-ordination, communication and liaison with internal stakeholders to ensure database changes and functionalities in the warehouse remain up to date and relevantWhat do you need:BSc Degree (in Computer Science, Engineering, Mathematics, Statistics, Information Systems or other technical/quantitative discipline).Post graduate degree is an advantageMicrosoft certified: Azure Data Engineer/Azure Solutions Architect Associate or any equivalent cloud certificationsAny certification in data modelling, data warehousing, project management will be advantageous.Minimum 5 years of building data pipelines including at least 3 years of experience developing both multidimensional and tabular models with large and complex datasetsExperience with data migration and integrationExperience building data dictionaries, dimensional data models, architecture diagrams, meta data repositories, data integration processes, ETL processes and data qualityExperience with developing enterprise data warehouse solutions, data modelling and developmentMust be passionate about data and analyticsHigh degree of proficiency in SSIS, SQL, SSAS Cubes, DAX, MDX and building stored proceduresPower BIAdvanced knowledge and skills in Oracle databasesProject managementVerbal and written communication skillsKnowledge of Agile SDLC methodologyAzure Synapse SQLExperience in DevOps an advantageAbility to learn new applications and technologies quickly
Attention! You will be redirected to another site