Jobs

Interviews
Job Alerts
Tools

Upskill and Grow with AI

Mock Interview Practice interviews in realistic simulations

Coding Practice Improve your coding skills with challenges

Certification Earn certifications to validate your skills

AI Learning Get trained with AI expert sessions

Career Path AI insights for smarter career decisions

AI Job Match Score AI-Powered Job Match Against Your Resume and Optimize Your Resume

Career Tools and Resources

Resume Builder Build Professional Resume with Ease

ATS Friendliness Check Check Resume Friendliness for Applicant Tracking Systems

Auto Apply Apply to hundreds of jobs on any platform effortlessly

Co-Pilot (Chrome Extension) Your AI Assistant for Seamless Browsing Efficiency

Interview Questions Streamline interviews with ready-to-use questions

Salaries Discover market-driven salary insights across skillsets and geographies

Companies Explore leading companies actively hiring talent
For Employers

Home
>
Jobs in bengaluru
>
Facctum
>
Data Modeller

Data Modeller

Facctum

3 years

0 Lacs

bengaluru karnataka india

Posted:6 days ago| Platform:

Apply

Skills Required

data writing sql python aws vpc routing design logical relational nosql mongodb aggregation automate etl numpy sqlalchemy azure gcp network security scalability database development indexing optimization scripting iam communication governance compliance

Work Mode

On-site

Job Type

Full Time

Job Description

Summary

Job DescriptionWe 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.

check(event) ; career-website-detail-template-2 => apply(record.id,meta)" mousedown="lyte-button => check(event)" final-style="background-color:#9647FD;border-color:#9647FD;color:white;" final-class="lyte-button lyteBackgroundColorBtn lyteSuccess" lyte-rendered="">

More Jobs at Facctum

HR Intern

Pune, Maharashtra, India

Experience: Not specified

Salary: Not disclosed

Data Developer

Bengaluru

2.0 - 5.0 yrs

INR 4 - 7 Lacs

MI / Analytics Developer

Bengaluru

6.0 - 7.0 yrs

INR 8 - 12 Lacs

Data Platform Test Lead

Bengaluru

10.0 - 12.0 yrs

INR 12 - 16 Lacs

Engineering Lead

Bengaluru

8.0 - 11.0 yrs

INR 12 - 16 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.