Cloud Database Analyst

SUMMARY:
Cloud Database Analyst:

Applicants should be proficient in cloud platforms like Azure and AWS, data analysis tools such as Power BI and Python, and ETL processes like Apache Airflow. A Bachelor’s Degree in Computer Science or a related field is required, with prior experience in cloud data analysis. Responsibilities include analyzing companies  cloud database usage, optimizing performance and costs, ensuring security compliance, and providing scalability insights. This role offers the opportunity to shape the future of automotive technology in South Africa with a globally renowned brand.

POSITION INFO:
Essential Skills Requirements:

• Cloud Services and Databases: Proficiency in cloud platforms (Azure, AWS) and database services (Azure SQL Database, Amazon RDS, Amazon Redshift) and APIs.
• Data Analysis and Visualization Tools: Strong skills in data visualization and BI tools (Power BI, Tableau) for creating insightful dashboards and reports.
• Programming and Data Science: Knowledge of programming languages (Python, R) and related libraries (Pandas, NumPy) for data analysis.
• ETL and Data Pipeline Tools: Experience with ETL processes and tools (Apache Airflow, AWS Glue) for data extraction, transformation, and loading.

• Big Data Technologies: Experience with big data frameworks and querying tools (Apache Spark, Apache Hive) for handling large-scale data processing.
• DevOps and Infrastructure as Code (IaC): Understanding of DevOps practices and IaC tools (Jenkins, Terraform) for efficient cloud resource management and deployment.
• Scripting and Automation: Ability to write automation scripts (Bash, PowerShell) to streamline database operations and maintenance tasks.
• Collaboration and Version Control: Proficiency with version control systems (Git) and project management tools (JIRA, Confluence) to enhance team collaboration and workflow organization.

• Bachelor’s Degree in Computer Science, Information Technology, Data Science, or a related field.
• Proven experience in data analysis or a similar role with a focus on cloud environments.

• Conduct comprehensive research and analysis of our database usage across public cloud platforms, primarily Azure and AWS.
• Collect and interpret data related to database technologies, configurations, and performance to create a detailed footprint of our cloud databases.
• Evaluate and report on the cost implications of database usage in the cloud, identifying opportunities for cost savings and efficiency improvements.
• Analyze security parameters and compliance of databases in the cloud, ensuring that all data is protected according to industry standards and internal policies.
• Collaborate with internal stakeholders to gather requirements and deliver tailored reports that provide actionable insights on database technologies and usage.
• Stay up to date with the latest trends and best practices in cloud database management and operations.
• Provide insights into database optimization, scalability, and management based on thorough data analysis and expertise.