• Design and implement ETL architecture using PySpark and SQL within AWS Glue
• Design and develop transactional and analytical data structures
• Align data technical capabilities with business objectives
• Develop reporting solutions to support Business Intelligence, resolving issues related to data analysis and reporting services
• Establish and maintain policies, operational procedures, and documentation for database environment interactions
• Follow client standards and best practices for AWS component deployment and code management using source control (e.g., BitBucket) and DevOps tools (e.g., Terraform, CLI applications)
• Recommend improvements to existing approaches and practices within Data Governance forums and other relevant meetings

Job Requirements:

• Minimum of 4 years of experience in Python
• Experience working with Python virtual environments
• At least 3 years of experience in a similar role, preferably in financial services or a multinational company with digital capabilities
• Experience working with databases and analyzing data insights
• Proficient with BI software such as JasperSoft and Tableau for creating interactive web-based reports, dashboards, and analyses
• ETL/ELT experience within a big data environment
• Experience with both SQL and NoSQL databases
• Strong coding skills with source control management (e.g., Git) and a focus on unit and integration testing
• Proficient in SQL (ANSI, T-SQL, PL/pgSQL)
• Experience deploying AWS components remotely using AWS CLI
• Skilled in database modeling, design, development, debugging, and troubleshooting, including stored procedures and functions
• Knowledgeable in Linux with the ability to write shell scripts
• Experience developing and maintaining software solutions within the AWS ecosystem (S3, Redshift, DynamoDB)