• Designing and implementing the architecture of ETL using PySpark and SQL language in AWS Glue.

• Designing and developing transactional and analytical data structures.

• Aligning the Data technical capabilities to business objectives.

• Developing reporting solutions to support Business Intelligence, including resolving problems related to data analysis and reporting services.

• Establishing and maintaining policies, operational procedures, and associated documentation for user interaction with the database environment.

• Following client’s standards and best practice for the deployment of AWS components and code using source code controls such as BitBucket, and utilizing  DevOps tools (e.g., Terraform), apps, and CLI as appropriate.

• Recommending improvements to existing approaches and practices within Data Governance forums and other appropriate meetings.

• Python 3+ including Virtual environments, PIP, Pypy, Package development, Boto3, sqlalchemy, Pytest

• ETL / ELT experience with SQL & Python within a big data environment.

• Experience with SQL and NoSQL databases

• Excellent coding skills, source control management (ie git) across programming languages with a strong focus on unit and integration testing

• SQL (ANSI, TSQL, PL/pgSQL)

• Experience in deploying AWS components remotely using AWS CLI Ability to perform database modelling and design, develop, debug, troubleshoot database objects, stored procedures and functions

• Knowledgeable on LINUX with the ability to program shell scripts

• Experience in developing and maintaining software solutions within the AWS ecosystem (S3, Redshift, DynamoDB).

• Minimum Basic Requirement (must be declined if no experience in any items below)

• Minimum 4 years’ experience in Python

• Must have experience in Python and its virtual environments.

• Must have experience in ETL/ ELT with SQL & Python within a big data environment.

• Must have experience in Terraform or IaC/ CICD

• Experience in Power BI and reports.

Equipment & Internet: Client will provide Company Laptop by November 2024. Applicant must have existing equipment as back-up and if considered for the role before November 2024. Internet Speed must be at least 75MBPS. Internet Allowance will be provided (P300.00/ week)