Data Analyst

• Design and implement ETL architecture using PySpark and SQL in 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 user interaction with the database environment
• Follow client standards and best practices for deployment of AWS components and code using source control tools such as BitBucket, and DevOps tools (e.g., Terraform), apps, and CLI as appropriate
• Recommend improvements to existing approaches and practices within Data Governance forums and other meetings

Qualifications:

• Minimum of 4 years’ experience in Python
• Experience working with Python virtual environments
• At least 3 years’ experience in a similar role, preferably in financial services or a multinational 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)