Associate Data Modeller

Company : Facctum It Solutions India

Job Type : Full Time

Bengaluru, India

Job Description - Associate Data Modeller

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

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.
Ability to use AI tools like Kiro and deliver tasks at speed
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.

Email address

Why are you reporting this job?

I think it’s a discriminatory or offensive

I think it’s fraudulent or a scam

I think it’s trying to sell something unrelated to the job / it’s asking for money

I think it contains incorrect or broken information

Other

All Job Ads are subject to GrabJobs’s Terms of Service. We allow users to flag postings that may be in violation of those terms. Job Ads may also be flagged by GrabJobs moderation team. However, no moderation system is perfect, and flagging a posting does not ensure that it will be removed.