Database Administrator / Data Engineer Location: Sydney, Australia
Company: 365 Assistance
Job Type: Hybrid (Office-based with flexibility)
About Us: At 365 Assistance, we are at the forefront of technology-driven roadside assistance, dedicated to transforming customer experiences with innovative solutions. Our commitment to exceptional service is backed by cutting-edge technology and a dynamic team focused on delivering reliability and efficiency.
Role Overview: Are you a passionate and experienced Database Administrator/Data Engineer looking for your next challenge? Join us at 365 Assistance and take charge of our comprehensive database management and data engineering needs. We are seeking a talented individual to oversee the integrity, security, and performance of our databases while driving innovative data solutions.
In this role hybrid role of Administrator and Data Engineer, you will design and implement data pipelines, build solid data orchestration mechanisms, manage and build ETL processes, and leverage AWS services for seamless data integration, flow and analytics. Proficiency in Microsoft PowerBI is a bonus. Your expertise will be instrumental in shaping our data strategy and ensuring that our systems meet the highest standards of quality and performance. The role has a focus area of real time reporting, data insights and reporting as well as data management with 70% Data Engineering and 30% Administration.
Key Responsibilities: Database Design and Implementation: Design and manage relational and non-relational databases using AWS RDS (PostgreSQL) and other AWS services. Develop and enforce database standards and best practices.ETL Processes and Data Pipelines: Implement ETL processes using AWS Glue for data integration and build robust data pipelines. Ensure data quality and consistency through automated workflows.Data Warehouse Development: Architect and deploy scalable data warehouse solutions, applying data modelling techniques to optimise storage and retrieval.Database Performance Optimisation: Monitor and tune database performance using AWS CloudWatch, conduct performance analysis, and implement caching strategies for high availability.Data Security and Compliance: Develop data security policies and use AWS security features to protect sensitive information. Ensure compliance with data protection regulations and industry standards.Documentation and Reporting: Create comprehensive documentation and deploy data visualisation and reporting solutions using AWS QuickSight and Microsoft PowerBI. Present actionable insights and business intelligence reports.Cross-Functional Collaboration: Work with business analysts and developers to understand data needs and deliver solutions. Provide technical expertise for database-related projects.Training and Support: Offer training and support to team members on database tools and best practices. Facilitate knowledge sharing within the team.Continuous Improvement: Stay updated on database technologies and recommend new tools and methodologies. Explore advanced data analysis technologies like machine learning and AI.Mobile Development Database Knowledge (Nice to Have): Experience with mobile databases for iOS and Android, integration with backend databases, and supporting mobile app teams with data synchronisation and offline handling. Required Skills and Qualifications: At least 7 years of experience in database administration or data engineering roles.Proven expertise with PostgreSQL.Python Programming Language is required for to successfully be considered.Advanced skills in ETL processes, data manipulation, and SQL optimisation.Proficiency in AWS services including Glue, RDS, S3, and QuickSight (AWS Redshift is a plus).Strong understanding of database security, governance, and compliance principles.Bachelor's degree in computer science, Information Technology, or a related field. Bonus Skills: Experience with Microsoft PowerBI for data visualisation.AWS Lambda knowledge is desirable.Knowledge of other cloud platforms like Azure or Google Cloud.Familiarity with NoSQL databases, such as MongoDB or DynamoDB.Experience with data modelling tools and mobile app databases for iOS and Android. Why Join Us? At 365 Assistance, you'll enjoy a collaborative and innovative work environment with hybrid working options. This is your opportunity to make a significant impact on our data management and analytics capabilities. We offer professional growth opportunities and a supportive team atmosphere.
Important Information: This role is based in Sydney, Australia, and requires weekly office attendance to foster collaboration. Only applicants currently residing in Sydney, NSW, Australia will be considered. Full working rights in Australia are required, as we are unable to offer sponsorship for this position now or in the future. Ready to make an impact? Apply today to join a forward-thinking company where your expertise will drive innovation and excellence.