Intermediate Data Engineer
Apply locations: Johannesburg
Time type: Full time
Posted on: Posted 3 Days Ago
Job requisition id: JR-61373
Let's Write Africa's Story Together! Old Mutual is a firm believer in the African opportunity and our diverse talent reflects this.
Job Description Build Pipelines: Build and maintain pipelines to meet business data needs by ensuring data is reliable, accessible, and aligned with strategic goals.
Data Champion: Understand the data needs of various business areas and guide in the use of data sources for reporting, management of dashboards, and scorecards.
Data Quality: Ensure data is correct, complete, consistent, up-to-date, valid, unique, and easy to track, while maintaining system reliability, accessibility, minimizing redundancy, documenting processes, and automating checks to ensure high-quality data.
Security: Ensure data security by implementing strong access controls, encryption, authentication, and compliance with regulations to protect sensitive data throughout the pipeline.
Stakeholder Management: Be responsive to stakeholder feedback, continuously optimizing processes to share reporting data with our partners to meet evolving customer needs within agreed timelines.
Service Levels: Collaborate and work with the Analytics, Distribution, Underwriting, Actuarial, Claims, Finance, HR, IT, and other teams to deliver required service levels.
Experience, Knowledge & Skills Required Bachelor's degree in Computer Science, Engineering, or a related field.
3–5 years of hands-on experience in designing data models, performing data transformation, and ensuring data quality through validation and analysis.
Proficient in Python, SAS, and SQL, with strong expertise in Apache Spark (PySpark/Spark SQL) and Databricks for big data processing.
Experienced in using Git for version control and implementing CI/CD pipelines, along with tools like Terraform for managing infrastructure-as-code.
Solid understanding of data architecture, including data lakes, data warehouses, and BI platforms.
Strong logical problem-solving abilities and excellent verbal and written communication skills for effective collaboration with teams and stakeholders.
Collect, analyze, report, and interpret data for use in the development of business strategies and tactics and in subsequent appraisal of results.
ResponsibilitiesBusiness Requirements IdentificationProactively collect business requirements using a variety of methods such as interviews, document analysis, workshops, and workflow analysis to express the requirements in terms of target user roles and goals, in order to garner the 'why' of the requirements and the benefits of such requirements.
Data Exploration & ManipulationConduct research and select relevant information to enable testing, experimental adjustment, and analysis of key themes and trends using primary data sources and business intelligence tools. Coordinates data exploration and manipulation input to strategic projects where integrated data sets are required.
Advanced AnalyticsRun advanced analyses and perform model assessments, validation, and enhancement activities, using software tools and functionalities.
Performance Improvement through Business IntelligenceMake recommendations to improve data and analytics systems and platforms, contributing to the continuous improvement and refinement of data and analytics strategy by conducting root cause analyses.
Insights and ReportingPrepare and coordinate the completion of various data and analytics reports. Generate and test hypotheses and provide measurable and actionable insights and present dashboards to stakeholders in presentations.
Data ArchitectureConsult and educate stakeholders on methods for streamlining and standardizing data recording to ensure quality and accuracy.
Data Collection and AnalysisCollate and analyze data using preset tools, methods, and formats. Involves working independently.
Personal Capability BuildingDevelop own capabilities by participating in assessment and development planning activities as well as formal and informal training and coaching; gain or maintain external professional accreditation where relevant to improve performance and fulfill personal potential. Maintain an in-depth understanding of relevant industry best practices, business acumen, and broadening of individual skills such as presentation, communication, and visualization through ongoing education, attending conferences, and reading specialist media.
Skills Action PlanningBusiness Requirements AnalysisComputer LiteracyDatabase AdministrationDatabase ReportingData CompilationData ControlsData ManagementData ModelingExecuting PlansGaps AnalysisInformation Technology (IT) SupportIT ArchitectureIT ImplementationIT Network SecurityMarket AnalysisTest Case ManagementUser Requirements DocumentationCompetencies Action OrientedBusiness InsightCultivates InnovationDrives EngagementDrives ResultsManages AmbiguityManages ComplexityOptimizes Work ProcessesEducation NQF Level 7 - Degree, Advance Diploma or Postgraduate Certificate or equivalent
Closing Date 23 December 2024, 23:59
The appointment will be made from the designated group in line with the Employment Equity Plan of Old Mutual South Africa and the specific business unit in question. Old Mutual Limited is pro-vaccination and encourages its workforce to be fully vaccinated against Covid-19. All prospective employees are required to disclose their vaccination status as part of the recruitment process. Please refer to the Old Mutual's Covid-19 vaccination policy for further detail. Kindly note that Old Mutual reserves the right to reinstate the requirement to vaccinate at any point if it is of the view that it is imperative to do so. The Old Mutual Story! About UsOld Mutual is a premium African financial services organisation that offers a broad spectrum of financial solutions to retail and corporate customers across key market segments in 14 countries. The lines of business include Life and Savings, Property and Casualty, Asset Management, and Banking and Lending.
We are rooted in our purpose of Championing Mutually Positive Futures Every Day and believe that a great customer experience is anchored in a great employee experience.
#J-18808-Ljbffr