Haystack
← Back to Jobs
Operations & Project Management

Data Modeler-Business Analyst

Factspan IncUnited States🇺🇸United StatesPosted 24 Jul 2026

Why This Role Stands Out

This mid-senior Data Modeler-Business Analyst role at Factspan Inc. offers a fantastic opportunity to drive impactful data solutions and mentor aspiring modelers within a collaborative environment. If you possess strong expertise in data modeling and a passion for translating business needs into scalable designs, this position is perfect for you to further develop your skills and contribute to exciting projects. Apply today to join a dynamic team!

Quick Overview

Work Type
On Site
Level
Mid Senior

Job Description

Summary:
Data Modeler plays a critical role in data and analytics life cycle and significantly contributes to production grade data and analytics solutions. The role requires one to demonstrate expertise in conceptual, logical and physical data modeling and translate business requirements to data. This role mentors Data modelers. It is an individual contributor role, expected to solve wide ranging business problems.

Requirements:
8-10+ years of relevant experience
Bachelors degree in computer science, information technology or equivalent educational qualification

Role & responsibilities:
• Translate business requirments into scalable data model designs.
•  Design and maintain logical, physical data models to support business and analytics needs.
• Ensure data model consitency, integrity and adherence to best practices
• Develop and optimze dimensional data models for performance, scalaibility and deployment in on-prem and cloud (Azure Synapse, Databricks) for analytical processing
• Perform data profiling and validation to ensure models accuracy & completeness
• Build and maintain data dicitonaries, metadata respositories and ER diagrams.
• Mentor Data Modelers
• Independently lead design, solutioning & estimations
• Collaborate with multiple partners from Business,Technology, Operations and D&A capabilities (Data Governance, Data Quality, Data Modeling, Data Architecture, Data science, DevOps, BI & insights)

Technical skills:
• Data modeling tools such as ERwin 
• SQL/NOSQL for schema design , validation and optimization
• Dimensional modeling (3NF,star schema, snowflake)
• Relational databases (SQL, Oracle) Cloud platforms (Azure Synapes, Databricks, Cosmos DB)
• Designing models for ETL and analytics workflows
• API Design and Ingestion (REST, SOAP, JSON, XML).
• Normalization, denormlization principles  and performance tuning techniques
•  Domain based modelling
• Mentorship experience
• Communication skills, analytical skills, structured problem-solving skills.
• Storytelling, Partner, Stakeholder engagement experience

Similar jobs

Browse related jobs

Apply now