Data Modeller

Fractal Analytics Ltd.; Bengaluru; On-site; INR 900,000 - 1,600,000; Full time

Job summary

Fractal Analytics Ltd. in Bengaluru seeks a seasoned Data & Solution Architect to lead modeling across VLDB data warehouses, NoSQL, and Graph DB environments. You will engage in JAD sessions with the business and work with ETL teams to map requirements to scalable data solutions.

The role requires strong Oracle SQL/PL/SQL, Cypher, Databricks Spark, and AWS cloud skills, with hands-on ERWIN experience to drive enterprise data architecture.

Qualifications

• Bachelor's degree in Computer Science, Engineering, or related field with 3+ years as a Data/Solution Architect for large-scale enterprise solutions.
• 3+ years of experience in Big Data Infrastructure and tuning in Lakehouse Data Ecosystem (Data Lake, Data Warehouses, Graph DB).
• AWS Solutions Architect Professional certification.
• Experience analyzing enterprise systems like SAP, ERP, SFDC, and eCommerce platforms.

Responsibilities

• Participate in requirements definition, analysis, and the design of data models for Dimensional, NoSQL, or Graph models.
• Lead data discovery discussions with Business in JAD sessions and map requirements to data modeling solutions.
• Conduct data model reviews with project teams.
• Capture technical metadata through data modeling tools.
• Ensure database designs support BI and end-user requirements.
• Collaborate with ETL/Data Engineering to create data pipelines for ingestion and transformation.
• Collaborate with Data Architects for data model management, documentation, and version control.

Skills

Data modeling

VLDB Data Warehouse

Graph DB design

NoSQL modeling

Oracle SQL/PLSQL

Cypher

ERWIN

AWS Cloud basics

Education

Bachelor's degree in CS/Engineering

AWS Solutions Architect Professional

Tools

ERWIN

Databricks Spark

AWS Redshift

Informatica ETL

Cypher

Job description

Responsibilities

• Participate in requirements definition, analysis, and the design of logical and physical data models for Dimensional Data Model, NoSQL, or Graph Data Model.
• Lead data discovery discussions with Business in JAD sessions and map the business requirements to logical and physical data modeling solutions.
• Conduct data model reviews with project team members.
• Capture technical metadata through data modeling tools.
• Ensure database designs efficiently support BI and end user requirements.
• Drive continual improvement and enhancement of existing systems.
• Collaborate with ETL/Data Engineering teams to create data process pipelines for data ingestion and transformation.
• Collaborate with Data Architects for data model management, documentation, and version control.
• Maintain expertise and proficiency in the various application areas.
• Maintain current knowledge of industry trends and standards.

Required Skills

• Strong data analysis and data profiling skills.
• Strong conceptual, logical, and physical data modeling for VLDB Data Warehouse and Graph DB.
• Hands-on experience with modeling tools such as ERWIN or another industry-standard tool.
• Fluent in both normalized and dimensional model disciplines and techniques.
• Minimum of 3 years' experience in Oracle Database.
• Hands-on experience with Oracle SQL, PL/SQL, or Cypher.
• Exposure to Databricks Spark, Delta Technologies, Informatica ETL, or other industry-leading tools.
• Good knowledge or experience with AWS Redshift and Graph DB design and management.
• Working knowledge of AWS Cloud technologies, mainly on the services of VPC, EC2, S3, DMS, and Glue.
• Bachelor's degree in Software Engineering, Computer Science, or Information Systems (or equivalent experience).
• Excellent verbal and written communication skills, including the ability to describe complex technical concepts in relatable terms.
• Ability to manage and prioritize multiple workstreams with confidence in making decisions about prioritization.
• Data-driven mentality.
• Self-motivated, responsible, conscientious, and detail-oriented.
• Effective oral and written communication skills.
• Ability to learn and maintain knowledge of multiple application areas.
• Understanding of industry best practices pertaining to Quality Assurance concepts and procedures.

Education / Experience Level

• Bachelor's degree in Computer Science, Engineering, or relevant fields with 3+ years of experience as a Data and Solution Architect supporting Enterprise Data and Integration Applications or a similar role for large-scale enterprise solutions.
• 3+ years of experience in Big Data Infrastructure and tuning experience in Lakehouse Data Ecosystem, including Data Lake, Data Warehouses, and Graph DB.
• AWS Solutions Architect Professional Level certifications.
• Extensive experience in data analysis on critical enterprise systems like SAP, E1, Mainframe ERP, SFDC, Adobe Platform, and eCommerce systems.

At Fractal, towards our goal of “powering every human decision in the enterprise”, our partnerships and alliances help in creating and delivering a compelling suite of solutions to unlock value. We partner with companies from around the globe, leaders in their respective fields. With Fractal’s expertise in artificial intelligence, design, engineering, and digital transformation, combined with the data, technology, and software platforms from our partners, we create cutting-edge solutions to problems in the business world. We understand how critical and timely decision triggers, and information, empower our clients to create, unlock, deliver, and realize value. Together with our partners, our goal is to serve each client in their end-to-end data-to-decision journey.