Data Integration & Automation Analyst

Are you a technical problem-solver who enjoys bridging the gap between raw data and actionable insights? We are looking for a Data Integration & Automation Analyst to join our team in Cape Town. This hybrid role combines technical architecture, programming, and data science support to streamline our data lifecycle. The Role

As a Data Integration & Automation Analyst, you will be responsible for the end-to-end automation and integration of data solutions. Your work will range from architecting automated data feeds from external suppliers to developing sophisticated data wrangling scripts that empower our delivery teams. Key Responsibilities • Integration & Architecture: Engage with external data sources to secure automated feeds and design technical solutions for data receipt in required formats. • Technical Setup: Lead the configuration of onsite hardware and network infrastructure, including port forwarding and static IP setups. • Automation & Scripting: Use R or Python to create automation scripts, utilizing existing libraries to drive efficiency and reusability. • Systems Integration: Configure and troubleshoot connectors for various ERP/Accounting systems and write custom SQL extraction queries. • Data Science Support: Assist with research and projects involving statistical theory, machine learning concepts, and time series analysis. • Monitoring & Maintenance: Proactively monitor the health of automated feeds ("satellites") and resolve connectivity or data integrity issues promptly. What We’re Looking For • Education: A Tertiary Degree or Diploma in IT, Mathematics, Statistics, or a relevant technical certification. • Experience: 2–4 years in a technical role within a data-centric environment. • Programming Skills: Proficiency in R or Python with a solid grasp of core programming concepts (functions, loops, and variables). • Database Expertise: Advanced MS SQL Server skills, including joins, stored procedures, and relational warehousing knowledge. • Network Knowledge: A confident understanding of Windows file systems and network infrastructure (TCP/IP, DHCP). • Mathematical Foundation: University-level knowledge of probability, distributions, and linear algebra. • Tools: High proficiency in Excel and experience with JIRA, SharePoint, and Azure Cloud services. Personal Attributes • An analytical problem-solver who can gather information from multiple sources to make insightful decisions. • A strong communicator comfortable engaging with both internal IT teams and external clients. • An action-oriented professional with high attention to detail and a passion for innovation. Why Join Us?

You will be a vital part of a cross-functional team, working closely with Data Scientists, Engineers, and Delivery Managers to scale our automation capabilities. We value inquisitive minds who are motivated to solve daily challenges through research and collaboration. Apply now to help us transform how we integrate and automate data! #J-18808-Ljbffr