Marco Lötter Email & Phone Number

Cape Town, Wc, Za

Cape Town, Western Cape, South Africa

Achievements:Onboarded and trained team members, improving effectiveness and knowledge sharing.Closed month-end processes in the first week, reducing reporting time by 150%.Completed Q3 2024 audit reconciliations in 2 days, ensuring accuracy and compliance.Streamlined month-end and audit processes through collaboration with DGC team.Upskilled from limited engineering experience to delivering impactful data engineering solutions.Responsibilities:Betway Finance and Compliance:Design, develop, and maintain scalable data infrastructure using Azure and data technologies.Ensure data quality, performance, and reliability through automated testing and monitoring.Collaborate with cross-functional teams to deliver optimized data solutions.Proficient in SQL Server for efficient data retrieval and manipulation.Utilize C# and Python for optimized ETL processes and real-time data pipelines.Apply DevOps principles and tools like Azure DevOps for integration and deployment.Support development in Azure, utilizing technologies like Databricks, Event Hubs, and Function Apps.Maintain on-premises SQL server databases for data availability and security.Build robust CI/CD pipelines with automated tests for reliable data operations.Collaborate through pair programming to enhance code quality and efficiency.Effective communication and collaboration with stakeholders.DGC Finance & Audits:Conduct audits and month-end processes, ensuring compliance and resolving discrepancies.Collaborate with teams to streamline processes and drive efficiency.Proactively seek process improvement opportunities for effectiveness.Manage time and resources effectively, meeting deadlines for projects.Contribute insights in data-driven discussions for strategic decision-making.

Cape Town, Western Cape, South Africa

Joined Betway as the inaugural Regulatory Data Analyst based in Cape Town. Responsible for delivering data analytics support and solutions to drive compliance and licensing efforts, including areas such as Data Protection, Anti Money Laundering, Customer Welfare, and Compliance & Licensing.Achievements:Successfully onboarded and trained 4 team members, ensuring seamless integration and knowledge transfer.Significantly improved efficiency by rebuilding the EDD Data Workflow, reducing processing time from 2 hours to just 20 minutes.Established a Confluence Workspace for the team, enhancing collaboration and knowledge sharing.Implemented automation-driven solutions for all reporting requirements, streamlining processes and saving time.Took ownership of Regulatory Tools, Anti Money Laundering EDD, and Data Protection operations data, ensuring accuracy and compliance.Advocated the use of Spark SQL, Databricks, and Python solutions, promoting advanced analytics capabilities over Alteryx.Responsibilities:Implement and maintain continuous monitoring and alerting solutions to ensure compliance.Support Compliance teams with data and fulfilling ad-hoc requests.Collaborate closely with department heads (AML, Data Protection, Compliance, Licensing & Compliance Operations, Customer Welfare) to define key operational metrics and provide regular analysis to inform strategic decision-making.Utilize SQL, SparkSQL, Databricks, Python, Pandas, Alteryx, and Tableau to deliver data analytics and reporting solutions.Develop and enhance data governance policies and procedures to ensure data accuracy, integrity, and security.Identify and address data quality issues, working with relevant teams to resolve them.Conduct regular audits and assessments to ensure adherence to regulatory requirements and industry standards.Stay updated with regulatory changes and industry trends to proactively recommend improvements and updates to compliance processes and systems.

Cape Town, Western Cape, South Africa

Contracted to support the Learning and Development department in automating and enhancing their data infrastructure for training data of 145,000 employees. Collaborating during the transition from SAP LSO to SuccessFactors, driving efficiency and effectiveness.Achievements:Semi-automated reporting landscape for departments, improving efficiency and accuracy.Led the transition towards automated data analytics and self-service capabilities.Successfully generated SETA Government reports within tight timelines for training data of 145,000 employees.Rebuilt Budget Forecasting Reports for all divisions within Shoprite.Identified and mapped reporting and field requirements for the Success Factors project within the department.Responsibilities:Redesign Learning & Development data and reporting landscape.Create dynamic reporting using Data Studio, Google BigQuery, Alteryx, and Tableau.Automate divisional and senior management reporting.Investigate data quality in SAP BW and extracts from stakeholders.Build data warehouse for external supplier reporting in BigQuery.Provide consulting on analytics best practices.Create SETA Government submission reports.Own training data requirements for business and senior management.Conduct data analysis to identify issues and trends.Collaborate with SAP BW team and IT to improve data quality and requirements.

Cape Town Area, South Africa

In the DataOps team, I played a crucial role in migrating from MSSQL Server to Google BigQuery, transferring all business dashboards and views. Leveraging Tableau and Google Data Studio, I designed and implemented user-friendly dashboards for various departments within the company.Responsibilities:Investigated, prioritized, and escalated helpdesk tickets to ensure timely resolution.Provided business analysis support to facilitate data-driven decision-making.Developed SQL scripts to facilitate data extract requests from senior management.Conducted initial data analysis to assess data quality.Tested, visualized, and analyzed data, presenting key findings to relevant stakeholders.Analyzed incident requests, collaborating with the team to identify opportunities for reducing future queries.Assisted in data governance initiatives, ensuring compliance with data privacy regulations and best practices.Worked closely with stakeholders to understand their reporting requirements and deliver tailored dashboards and visualizations.Achievements:Successfully automated dynamic reports for global marketing and Travelstart using SQL, BigQuery, and Data Studio.Played a pivotal role in training the company on the migration to Google Data Studio.Developed and presented real-time data visualization dashboards for Travelstart offices worldwide.Led the migration of all reports and data sources from SQL/Tableau to Google BigQuery/Data Studio.Earned the Data Analyst Certification from the University of Cape Town.

Cape Town Area, South Africa

As a leader, I was responsible for overseeing daily operations, revenue management, and booking optimization. Led a high-performing team of 3 individuals, driving bookings and content to achieve company KPIs and targets across Middle Eastern markets. Utilized market behavior, demographics, and travel trends to optimize prices and content for enhanced customer satisfaction and profitability.- Provided comprehensive support for online data collection, analytics, and business development activities.- Acted as the primary account manager and first point of contact for all Middle Eastern business partners.- Conducted market research and competitor analysis using data extracted from scrapers and Meta sources.- Utilized SQL to collect data and facilitate reporting requests from senior management.- Executed ad hoc queries on data collection to generate insightful reports.- Leveraged tools such as Google Data Studio, Tableau, Excel, and Google Sheets for data visualization and trend analysis.- Effectively planned and prioritized work to meet deadlines, KPIs, and growth targets.- Supported all business units and departments by delivering consulting services that provided relevant data and information.- Identified and resolved gaps in content and pricing requirements through proactive analysis and problem-solving.Achievements- Presented ad hoc and monthly performance reports to senior management, driving informed decision-making.- Consistently achieved booking and revenue KPI targets on a monthly basis.- Developed and implemented policies and procedures to drive and maintain target attainment.- Successfully managed a small team across global offices, ensuring collaboration and high-quality output.- Served as primary account manager for META/Middle East region.

Cape Town Area, South Africa

Contributed to a cross-functional team involved in the development, maintenance, and documentation of systems administration processes. Assumed responsibility for creating and updating procedures, business system rules, and configurations. Effectively managed business rule tables and supplier content. Conducted thorough investigations and analysis of issues, leveraging system logs, data patterns, and engaging technical stakeholders. Identified root causes and provided recommendations for resolutions.

Cape Town Area, South Africa

Initiated a first line support team which focused on providing frontline support for bug and issue reports from business and operations teams. As a specialist, I collaborated closely with the development team to thoroughly assess, replicate, and document bugs in Jira. Took complete responsibility for all reported bugs, ensuring prompt resolution within defined timeframes.

Cape Town, Western Cape, South Africa

Managed and led a team responsible for resolving failed bookings and payment issues. Established and built the team from scratch, taking ownership of all aspects of their performance and development. Collaborated closely with cross-functional stakeholders to investigate, analyse, and resolve failed bookings and payment incidents, ensuring a seamless customer experience.

Cape Town Area, South Africa

Joined as a customer service representative in 2015 and progressed to become a key member of the team responsible for handling Lufthansa Group Travel bookings from European Markets. Provided coaching and training during the onboarding process for new colleagues.

Cape Town Area, South Africa

Jan 2012 – May 2014: Miles and More Consultant & CoachOct 2010 – Dec 2011: General Reservations Consultant & Coach

Cape Town Area, South Africa

Sep 2009 – Aug 2010: Duty Manager: Front of House, Food & BeverageJan 2009 – Aug 2009: Front of House Duty ManagerJul 2008 – Dec 2008: Reception InternCommenced an internship at Tsogo Sun Century City (formerly Southern Sun) in 2015, eventually transitioning to a permanent management role. Oversaw operations for the Front of House and Food & Beverage departments.

Certificate, Data Analysis, 91%

Bachelor'S Degree, Hotel, Motel, And Restaurant Management

Matric Certificate, High School/Secondary Diplomas And Certificates