Required Skills: MySQL, PostgreSQL, Python
Job Description
- Build and operationalize complex data solutions, correct problems, apply transformations, and developing data cleansing and quality solutions.
- Design complex data solutions, including incorporating new data sources and ensuring designs are consistent across projects and aligned to data strategies.
- Perform analysis of complex sources to determine value and use and recommend data to include in analytical processes.
- Build new ETL pipelines from different data structures and resources, helping to build and automate the different kind of reports and analysis.
- Maintain and monitor current data and reports and help to resolve the different kinds of issues.
Core Technical Requirements
- Languages: Strong proficiency in Shell Scripting and Python is essential.
- Database Management: Expert-level SQL skills are mandatory for both relational (MySQL, PostgreSQL) and NoSQL (DynamoDB) systems.
- Data Pipelines & ETL: Designing, testing, and managing Extract, Transform, Load (ETL) pipelines.
- Cloud Platforms: Experience with platforms like AWS S3, EC2 administration, AWS Security best practices, and AWS Quick Suite.
- Data Warehousing: AWS RDS database administration, Database performance tuning, Table and query optimization. AWS NoSQL service implementation and administration is a Plus.