Data Administrator II - Johannesburg at FNB South Africa

Purpose

• To gather data, store and maintain data and ensure its integrity and quality, processing it into structured presentation as information.

Experience and Qualifications

• Relevant Degree.
• 2 to 3 years related.

Additional Requirements

• 3 Years’ experience in Data & Analytics in a digital media agency
• Knowledge of warehouse tables and SQL queries.
• Knowledge of Microsoft Reporting Services.
• Knowledge of the data structures in Google Marketing Platform incl Google Analytics 4 & Firebase
• Knowledge of BigQuery data transfers, tables & queries
• Knowledge of Ads Data Hub
• Improve business decisions by providing accurate and reliable business intelligence (information) together with analyzing trends and data for around digital media performance, audience performance and conversion rate and user journey optimisations.
• Ensure production support on First level BigQuery and SQL problem diagnosis and resolution to ensure a well performing production environment and do database maintenance by maintaining digital data databases to accommodate new business functions and improve existing business functions around digital media data, analytics and reporting.
• Manage digital media data, analytics and reporting roadmap by identifying what data currently exists, what data needs to be carried over into the new systems and/or analysis around what can be achieved with a new system by applying extensive experience in database administration, maintenance and data warehousing to the function.
• Administer digital media databases that includes set up, back up processes, documentation updates, monitoring, performance tuning and optimisation and ensure change management are implemented so that the production environments remain technically stable.
• Provide data & analytical support by assisting application developers with problem analysis and resolution of development and production failure that is impacting the digital media data.

Responsibilities

• Manage costs / expenses within approved budget to achieve cost efficiencies.
• Deliver exceptional service that exceeds customers’ expectations through proactive, innovative and appropriate solutions.
• Cultivate and manage objective working relationships with a variety of stakeholders, including end-users, SME’s, project managers and senior staff members.
• Ensure production support on First level SQL database problem diagnosis and resolution to ensure a well performing production environment and do database maintenance by maintaining databases to accommodate new business functions and improve existing business functions.
• Comply with governance in terms of legislative and audit requirements.
• Ensure all documentation have produces data flow definitions, rules and instructions as a basis for the work of designers and programmers.
• Manage data by identifying what data currently exists, what data needs to be carried over into the new systems and/or analysis around what can be achieved with a new system by applying extensive experience in database administration, maintenance and data warehousing to the function.
• Administration of Databases that includes set up, back up processes, documentation updates, monitoring, Performance tuning and optimisation and ensure Change Management are implemented so that the production environments remain technically stable.
• Ensure Developer Support by assisting application developers with problem analysis and resolution of development and production failure.
• Manage own development to increase own competencies.
• Increase IT capabilities: Computer programming experience and expertise.
• Software Technology: Develop working knowledge of the latest technologies and architecture required for web development