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 :

- Minimum 3 years of experience in data modelling, database development, and SQL programming.

- Expertise in Postgres (complex queries, indexing, optimization) and MongoDB (schema design, aggregation).

- Strong hands-on experience with Python and related libraries (pandas, NumPy, SQLAlchemy, PyMongo, boto3). Shell scripting must have.

- Proficiency in AWS cloud services : RDS, S3, CloudWatch, VPC, IAM, ASM, EC2, Event bridge and any other data-based services.

- Experience with Routing, Peering, Inbound/Outbound rules, and security group configuration.

- Strong problem-solving, analytical, and communication skills.

- Knowledge of data governance and compliance frameworks.