Analyst Engineer - Melbourne
The Analyst Engineer is responsible for developing, maintaining, and optimizing IT systems, databases, and data workflows. This role involves scripting, automation, database development, and ETL processes using SQL, PL/SQL, UNIX Shell scripting, Perl, Python, and ETL workflows.
Additionally, the candidate will leverage Confluence for documentation, GIT for version control, and ITIL practices for service management to ensure system efficiency and reliability.
Key Responsibilities: Database Development & Management
Design, develop, and optimize database queries, stored procedures, and functions using SQL and PL/SQL.Perform database tuning, indexing, and optimization for improved performance.
Support database maintenance, backup, and recovery processes.
Scripting & AutomationDevelop and maintain UNIX Shell scripting, Perl, and Python scripts for process automation and system monitoring.
Automate data extraction, transformation, and loading (ETL) processes for improved efficiency.
Implement workflow automation to streamline operational tasks and reduce manual efforts.
ETL Workflows & Data ProcessingDesign, implement, and manage ETL workflows for seamless data integration across systems.
Perform data extraction, transformation, and loading from various sources into databases.
Ensure data accuracy, consistency, and performance optimization in ETL processes.
Version Control & DocumentationUtilize GIT for version control, managing code repositories and collaborative development.
Maintain technical documentation, process workflows, and best practices using Confluence.
Document database schemas, scripts, ETL workflows, and automation procedures.
System Administration & ITIL Best PracticesMonitor system performance, troubleshoot issues, and provide support for IT infrastructure.
Follow ITIL best practices for incident, problem, and change management.
Collaborate with IT teams to ensure compliance with security and governance policies.
Required Qualifications & Skills: Bachelor’s degree in Computer Science, Information Technology, or a related field.
Strong proficiency in SQL and PL/SQL for database querying and optimization.Hands-on experience with UNIX Shell scripting, Perl, and Python for automation.
Experience with ETL workflows for data transformation and integration.
Proficiency in GIT for version control and collaboration.
Familiarity with ITIL best practices for IT service management.
Experience using Confluence for documentation and knowledge sharing.
Strong analytical, troubleshooting, and problem-solving skills.
Perm roleMelbourne
- 100K