Facctum - Data Modeler

Description :

We are looking for a Data Modeller with at least 3 years of professional experience in designing scalable data models and writing complex SQL queries in Postgres and MongoDB. The ideal candidate must also have hands-on expertise in Python and data-related libraries along with strong working knowledge of AWS data services and strong AWS fundamentals like VPC, subnets, routing, peering and configuring inbound / outbound rules.

Key Responsibilities :

• Design, develop, and maintain conceptual, logical, and physical data models across relational (Postgres) and NoSQL (MongoDB) systems.
• Write and optimize complex SQL queries, stored procedures, and views in Postgres; build advanced queries and aggregation pipelines in MongoDB.
• Develop and automate ETL / ELT data pipelines using Python and libraries such as pandas, NumPy, SQLAlchemy, PyMongo, boto3.
• Manage and optimize AWS Data related services. Experience in other cloud providers like Azure, GCP is good to have.
• Configure network routing, inbound / outbound rules, and security groups for secure data access.
• Monitor performance, troubleshoot issues, and ensure scalability, data quality, and security.
• Collaborate with data engineers, analysts, and business teams to translate requirements into effective data solutions.

Requirements :

Required Skills & Experience :

(ref : hirist.tech)