Talent.com
Senior Data Modeler

Senior Data Modeler

Neutrino Advisory, an Inc 5000 Companylucknow, uttar pradesh, in
22 days ago
Job description

Role Overview :

We are seeking a Senior Data Modeler with over 12 years of IT experience, including 8–10 years in data modeling and database design. The role involves designing and optimizing data models across transactional, analytical, and cloud environments using platforms such as SQL Server, Oracle, Snowflake, and Azure Synapse . The ideal candidate will collaborate with ETL and BI teams to ensure efficient data integration, governance, and performance tuning. This position requires strong expertise in conceptual, logical, and physical data modeling, metadata management, and modern data architecture concepts like data lakes and lakehouses.

Core Technical Skills

1. Database Design & SQL

  • Strong Expertise in SQL (DDL, DML, DCL).
  • Deep understanding of RDBMS platforms (e.g., SQL Server, Oracle, PostgreSQL, MySQL).
  • Experience with cloud databases such as Azure Synapse, Snowflake, Amazon Redshift etc.
  • Knowledge of NoSQL systems (MongoDB, Cassandra) and modeling for semi-structured data (JSON, Parquet).

2. Data Modeling Tools & Techniques

  • Proficiency with any of the tools such as Lucidchart, Erwin, Toad Data Modeler.
  • Strong command of conceptual, logical, and physical data modeling.
  • Ability to model for OLTP (transactional) systems and OLAP (analytical / data warehouse) environments.
  • Familiarity with dimensional modeling (star / snowflake schemas) for BI / analytics.
  • 3. ETL / Data Integration

  • Understanding of ETL pipelines and data ingestion processes.
  • Collaboration experience with ETL developers to align data flows with models.
  • Familiarity with tools like Azure Data Factory, Informatica, Talend, dbt, SSIS.
  • 4. Metadata, Data Governance & Lineage

  • Experience defining data dictionaries, business glossaries, and metadata repositories.
  • Awareness of data quality, governance, and master data management (MDM) principles.
  • Understanding of data lineage and impact analysis.
  • 5. Performance Optimization

  • Knowledge of indexing, partitioning, normalization / denormalization.
  • Ability to optimize query performance through model design and database tuning.
  • Analytical & Business Skills

  • Ability to translate business requirements into data structures.
  • Experience working with business analysts and stakeholders to understand KPIs and reporting needs.
  • Strong analytical mindset with attention to data accuracy and consistency.
  • Understanding of domain data (e.g., finance, supply chain, healthcare).
  • Cloud, Modern Data Stack & Emerging Skills

  • Familiarity with modern data architectures — data lakes, lakehouses, and data mesh concepts.
  • Exposure to data integration patterns.
  • Exposure to data catalog tools (e.g., Collibra).
  • Understanding of data modeling for BI / Analytics tools like Power BI, or Tableau.
  • Knowledge of Python / SQL for data transformations is increasingly valuable.
  • Experience with CI / CD for data models (e.g., dbt or Git-based version control).
  • Soft Skills

  • Excellent communication — able to explain technical models to non-technical stakeholders.
  • Collaboration with data engineers, analysts, and architects.
  • Strong documentation and attention to detail.
  • Ability to work in agile environments with iterative delivery.
  • Education

  • Bachelor’s or Master’s in Computer Science, Information Systems, or a related field.
  • Create a job alert for this search

    Data Modeler • lucknow, uttar pradesh, in

    Related jobs
    • Promoted
    Lead Anaplan Modeler

    Lead Anaplan Modeler

    Innova ESIlucknow, India
    Lead Anaplan Modeler (9 months).Anaplan, FPPM(Financial Planning and Performance Management) or EPM(Enterprise Performance management). Agile, Scrum, Data integration.General Shift(11 AM- 7 PM IST)-...Show moreLast updated: 1 day ago
    • Promoted
    Senior Data Engineer (AWS / Databricks)

    Senior Data Engineer (AWS / Databricks)

    Accoladelucknow, uttar pradesh, in
    The multifamily real estate industry is undergoing a massive transformation, and Accolade is at the forefront.We are building the industry's first AI-native Operations Centralization Platform, desi...Show moreLast updated: 30+ days ago
    • Promoted
    Senior Cloud Data Fusion

    Senior Cloud Data Fusion

    Technocrats Domain IncLucknow, IN
    Migration from DataStage to Cloud Data Fusion.Visual Studio (Wrangler, Joiner, GroupBy, Aggregator, etc.Compare results between source and target (output from DataStage).Show moreLast updated: 1 day ago
    • Promoted
    • New!
    Senior Tableau Developer (with Strong Power BI Experience)

    Senior Tableau Developer (with Strong Power BI Experience)

    Dataplatr Inc.Lucknow, IN
    Job Title : Senior Tableau Developer (with Strong Power BI Experience).Immediate joiners or candidates with a notice period of one week or less only may apply • • •. The ideal candidate will have hands-...Show moreLast updated: 20 hours ago
    • Promoted
    • New!
    Senior Data Engineer

    Senior Data Engineer

    QuantiphiLucknow, Republic Of India, IN
    Quantiphi is an award-winning Data Science and Machine Learning Software and Services Company focused on helping organizations translate the big promise of Machine Learning technologies into quanti...Show moreLast updated: 15 hours ago
    • Promoted
    Senior Data Modeler

    Senior Data Modeler

    Neutrino Advisory, an Inc 5000 CompanyLucknow, IN
    The role involves designing and optimizing data models across transactional, analytical, and cloud environments using platforms such as SQL Server, Oracle, Snowflake, and Azure Synapse.The ideal ca...Show moreLast updated: 22 days ago
    • Promoted
    Data Modeler

    Data Modeler

    Tredence Inc.Lucknow, Uttar Pradesh, India
    About the Company : Tredence focuses on last-mile delivery of powerful insights into profitable actions by uniting its strengths in business analytics, data science and software engineering.The lar...Show moreLast updated: 12 days ago
    • Promoted
    Senior MLOps Engineer

    Senior MLOps Engineer

    Mitchell Martin Inc.lucknow, India
    Include, but are not limited to, the following : .Own productionizing models—from tracked experiments to governed releases—ensuring resilient services with clear SLOs, runbooks, and fast, safe rollba...Show moreLast updated: 16 days ago
    • Promoted
    Data Modeler

    Data Modeler

    Bits In Glasslucknow, India
    SQL, MS-Office tools, GCP Big Query, Erwin, and Visual Paradigm.Company Description : Bits in Glass - India.Bits in Glass(BIG) has been in business for more than 20 years. Bits in Glass joined hands ...Show moreLast updated: 1 day ago
    • Promoted
    Coastal Modeler | ISIR.AI

    Coastal Modeler | ISIR.AI

    ISIR AIlucknow, India
    Turn Simulations into Impact — Join ISIR.AI is advancing coastal and marine analytics across Asia, and we’re looking for a driven Coastal Modeler. This is not a routine modeling job — it’s an opport...Show moreLast updated: 14 days ago
    • Promoted
    AI Developers (Senior Level) - 7+ Yrs

    AI Developers (Senior Level) - 7+ Yrs

    OptiLnXlucknow, India
    Strong background in LLMs, NLP, and RAG pipelines.Experience in Machine Learning (Mandatory).Strong Machine Learning & NLP expertise : classification, sequence models, transformers (BERT, RoBERTa), ...Show moreLast updated: 23 hours ago
    • Promoted
    • New!
    Senior Tableau Developer (With Strong Power Bi Experience)

    Senior Tableau Developer (With Strong Power Bi Experience)

    Dataplatr Inc.Lucknow, Republic Of India, IN
    Job Title : Senior Tableau Developer (with Strong Power BI Experience).Immediate joiners or candidates with a notice period of one week or less only may apply • • •. The ideal candidate will have hands-...Show moreLast updated: 11 hours ago
    • Promoted
    Data Modeler

    Data Modeler

    RecroLucknow, IN
    NoSQL) to support enterprise information management, BI, analytics, machine learning, and other business use cases.They drive data strategies, build models (conceptual, logical, physical), ensure p...Show moreLast updated: 23 days ago
    • Promoted
    Senior Data Engineer

    Senior Data Engineer

    Guidanz IncLucknow, IN
    BI Connector is the industry leading solution for integrating Oracle Fusion Cloud data into modern BI platforms like Power BI, Tableau, and Data Warehouse, without complex ETL.Our Data Architecture...Show moreLast updated: 2 days ago
    • Promoted
    Senior Architect - Data

    Senior Architect - Data

    Quantiphilucknow, uttar pradesh, in
    Quantiphi is an award-winning Data Science and Machine Learning Software and Services Company focused on helping organizations translate the big promise of Machine Learning technologies into quanti...Show moreLast updated: 30+ days ago
    • Promoted
    Senior AI Developer

    Senior AI Developer

    PioVation GmbHLucknow, Uttar Pradesh, India
    We’re building production-grade LLM / AI capabilities into our Cloud Operating System and we need someone who can ship.If you like taking AI from prototype → scalable product, this is for you.What ...Show moreLast updated: 1 day ago
    • Promoted
    Senior Data Scientist LLM [T500-20568]

    Senior Data Scientist LLM [T500-20568]

    ANSRlucknow, uttar pradesh, in
    ANSR is hiring for one of its clients.Headquartered in Berlin, Germany, 4flow provides consulting, software and services for logistics and supply chain management. More than 1300 team members levera...Show moreLast updated: 30+ days ago
    • Promoted
    ML Ops

    ML Ops

    EXLlucknow, uttar pradesh, in
    Deploy, monitor, and scale ML models on.GCP (Vertex AI, GKE, Cloud Functions).GitHub Actions / Jenkins / cloud-native tools. Containerize and orchestrate workloads with.MLflow, Feast, Prometheus / Gra...Show moreLast updated: 30+ days ago