Data Modeler

1 month ago

Secunderabad, India Inspire Brands Hyderabad Support Center Full time

Position Overview:

As a Data Modeler, you will create and maintain conceptual, logical and physical data models for efficient and high-performance storage and retrieval of data from Cloud based, Enterprise grade, Big Data environments which enable Data Science, Data Analytics and Reporting functions on multi sourced, multi branded data. You will work with both Business users and Engineering teams composed of Data Engineers, Data Scientists, Data Architects, Data Analysts, and information technologists to understand data requirements and model critical data that supports reporting and analytics. You will produce designs that follow Inspire data modeling conventions and adhere to naming standards as set forth by the Lead Data Modeler.

Responsibilities:

  • Collaborate with business stakeholders and IT Data Analysts to understand source data and determine the optimal design to meet the organizations data management goals.
  • Cooperate with the other data modeling team members to identify and resolve any potential model conflicts between business domains supported by other modelers.
  • Create detailed logical models which identify all entities, attributes, and their relationships to each other.
  • Convert logical models to physical models which follow Inspire data modeling guidelines and naming standards.
  • Communicate design decisions to Business and IT stakeholders and ensure that designs meet requirements and goals.
  • Generate table and base view DDL scripts from the Physical data model and deploy changes to Development and QA testing environments.
  • Create presentation layer views for end users, which may involve manipulating data from multiple disparate data sources into a single homogenous output presentation.
  • Prepare table and view DDL scripts for inclusion in Git repositories for User Acceptance Testing and Production environments and initiate their deployment via Azure DevOps pipelines.
  • Monitor and manage table and view object versioning across each development Lifecycle environment ( Dev/QA/UAT/Production )
  • Work with the Production Support team to analyze and resolve errors and design defects.

Education and Experience Qualifications:

  • 4-year degree in Information Systems, Computer Science, or a related field.
  • At least 8 years of total IT experience.
  • 8+ years of writing high-performing complex SQL queries on large datasets.
  • 5-6 years of Data Modeling experience using a major Data Modeling tool, preferably Erwin Data Modeler.
  • 3-5 years of experience with Cloud-based Big Data Warehouses, preferably Snowflake and Azure Databricks.
  • Experience in ETL development would be a plus.

Required Knowledge Skills or Abilities:

  • Solid experience with Agile development methodology and managing multiple design deliverables at different development stages ( Dev/QA/UAT/Production ) within a single Agile Sprint.
  • Reasonable familiarity with Data Integration, Metadata Management and Data Warehousing concepts.
  • Experience building normalized relational models and deformalized OLAP dimensional models with a data modeling tool, preferably Erwin Data Modeler.
  • Experience with reverse engineering models from existing databases.
  • Ability to write complex SQL queries on large databases comprised of billions of rows.
  • Familiarity with Cloud data integration, data modeling, and data warehousing concepts.
  • Effective communication and collaboration skills to work with cross-functional teams and convey technical concepts to non-technical stakeholders.

  • Sr. Data Scientist

    1 month ago

    secunderabad, India Corporate Resources Full time

    Job Description Ideate, conceptualize and formulate Data Science use case of significant impact for the business Develop and evaluate various Machine Learning models before zero in on the best one and ability to run Machine Learning models on huge amount of data Drive discussions with Business to...

  • Data Analyst Advanced Analytics

    1 month ago

    secunderabad, India Corporate Resources Full time

    Job Description Responsibilities: Understanding and synthesize the client requirements and information Decide approach while thinking through possible deadlocks in advance Get actionable insights from data with analytical tools like Project R, SQL, R, Python etc. which can be used in real time...

  • Data Scientist

    3 weeks ago

    Hyderabad/ Secunderabad, India timesjobs Full time

    Desired Requirements: Graduate degree in Data Science or another quantitative field is preferred.7 years of experience in applications development in a complex, multi-platform distributed environment.Knowledge of RDMS Systems (MySQL, MS SQL Server, Postgres, Oracle).Data Modeling Expertise (Conceptual, Logical & Physical in both Relational &...

  • Data Analyst Level 3

    3 weeks ago

    secunderabad, India Certara Full time

    Overview This job entails interpretation (analyzing and reviewing) of Clinical trials data across various therapeutic areas and actively contribute to the development of database products that support informed decision making at various stages of clinical development and post approval phases using modelling and simulation approaches. This job necessitates...

  • Data Analyst Level 3

    1 month ago

    Secunderabad, India Certara Full time

    Overview This job entails interpretation (analyzing and reviewing) of Clinical trials data across various therapeutic areas and actively contribute to the development of database products that support informed decision making at various stages of clinical development and post approval phases using modelling and simulation approaches. This job...

  • Data Analyst Level 2

    1 month ago

    Secunderabad, India Certara Full time

    Overview About Certara Certara is a growing company that provides a dynamic and exciting place to work. Our purpose is to assist in accelerating the development of meaningful medicines that make an impact on our society and the people that need them most. Innovation and creativity are highly valued, and everyone is given the opportunity for training...

  • Data Analyst Level 2

    3 weeks ago

    secunderabad, India Certara Full time

    Overview About Certara Certara is a growing company that provides a dynamic and exciting place to work. Our purpose is to assist in accelerating the development of meaningful medicines that make an impact on our society and the people that need them most. Innovation and creativity are highly valued, and everyone is given the opportunity for training...

  • Data Scientist

    2 weeks ago

    Hyderabad/ Secunderabad, India timesjobs Full time

    SALARY: 5LPA - 6LPALOCATION:Hyderabad, Telangana, IndiaVACANCIES: 11) Understanding busisness objectives and developing models that help to achieve them, along with metrics to track their progress.2) Utilize the existing frameworks, standards, patterns to create architectural foundation and services necessary for AI applications that scale from multi-user to...

  • Data Analyst

    1 month ago

    Secunderabad, India Corporate Resources Full time

    Job DescriptionKnowledge of Human Resource Headcount Analysis, Survey Analysis, headcount forecasting.Knowledge of statistical programming languages like python/R/SQL in Mandatory.Working knowledge of Dashboarding tools like Power BI/ Tableau.Ability to create minimal and meaningful presentation to communicate your findings.Good Experience of data crunching...

  • Executive Flow Modeling

    1 month ago

    secunderabad, India Corporate Resources Full time

    Job Description 1. Wind data analysis, raw data cleaning /synthesizing 2. Layout optimization, Energy Yield Estimation and Site suitability assessment 3. Evaluation of various sites on offer from developer/OEM 4. Time series energy capture for hybrid assessment 5. Co-ordination with execution...

  • Senior Data Analyst

    1 month ago

    secunderabad, India Corporate Resources Full time

    Job Description Execute daily/weekly/monthly analysis of business performance reports Create ad-hoc business analysis and present to stakeholders Contribute to analytical projects by implementing tasks and developing models Apply analytics to business problems and use cases Corelate data points,...

  • Data Engineer

    4 days ago

    Hyderabad/ Secunderabad, India timesjobs Full time

    JOB DETAILS1) Data Engineers lead and deliver the technical aspects of our analytics projects and solutions into clients and work on projects to:2) Build and configure our Data Science environment platform, its algorithms and its data feeds3) Support our Data Scientists and Analytical Consultants working on projects4) Provide technical expertise and...

  • Data Engineer

    1 week ago

    Hyderabad/ Secunderabad, India timesjobs Full time

    JOB DETAILS1) Data Engineers lead and deliver the technical aspects of our analytics projects and solutions into clients and work on projects to:2) Build and configure our Data Science environment platform, its algorithms and its data feeds3) Support our Data Scientists and Analytical Consultants working on projects4) Provide technical expertise and...

  • Business Data Analyst

    3 weeks ago

    Secunderabad, India DATAECONOMY Full time

    Job DescriptionRole: Business Data AnalystExperience: 4 – 10 YearsJob Location: Hyderabad/PuneQualification: BTech/MTech/MCAMode Of work: HybridFirst preference for immediate joiners.Job Description:·We are seeking a skilled Business Data Analyst with expertise in SQL and experience in banking risk management to join our dynamic team. The ideal candidate...

  • Data Analyst

    1 month ago

    secunderabad, India Corporate Resources Full time

    Job Description Knowledge of Human Resource Headcount Analysis, Survey Analysis, headcount forecasting. Knowledge of statistical programming languages like python/R/SQL in Mandatory. Working knowledge of Dashboarding tools like Power BI/ Tableau. Ability to create minimal and meaningful...

  • Vice President Data Lead

    3 weeks ago

    Hyderabad/ Secunderabad, India timesjobs Full time

    Skills Required:10 years of professional experience in building Reports, Dashboards, and ScorecardsStrong knowledge of any of the Visualization tools like Tableau, Business Objects XI3.1, QlikView, Crystal ReportAbility to understand and analyze data to find patterns and valuable Business InsightsUnderstanding of the Data warehouse life cycle right from data...

  • Business Data Analyst

    3 weeks ago

    secunderabad, India DATAECONOMY Full time

    Job Description Role: Business Data Analyst Experience: 4 – 10 YearsJob Location: Hyderabad/PuneQualification: BTech/MTech/MCAMode Of work: HybridFirst preference for immediate joiners. Job Description: ·        We are seeking a skilled Business Data Analyst with expertise in SQL and experience in banking risk management to join our dynamic team....

  • Business Data Analyst

    4 weeks ago

    Secunderabad, India DATAECONOMY Full time

    Job DescriptionRole: Business Data AnalystExperience: 4 – 10 YearsJob Location: Hyderabad/PuneQualification: BTech/MTech/MCAMode Of work: HybridFirst preference for immediate joiners. Job Description:·        We are seeking a skilled Business Data Analyst with expertise in SQL and experience in banking risk management to join our dynamic team. The...

  • Lead Data Engineer

    1 month ago

    Secunderabad, India ANSR Full time

    About ANSRLand O'Lakes has partnered with ANSR to setup their GCC in India. You will be employed by ANSR until Land O'Lakes GCC is operationally ready. The transition from ANSR to Land O'Lakes GCC is targeted to be completed within the next two years.About our Client Land O'LakesFor over 100 years, Land O'Lakes, while primarily known for its contributions to...

  • Lead Data Engineer

    1 month ago

    Secunderabad, India ANSR Full time

    About ANSRLand O'Lakes has partnered with ANSR to setup their GCC in India. You will be employed by ANSR until Land O'Lakes GCC is operationally ready. The transition from ANSR to Land O'Lakes GCC is targeted to be completed within the next two years.About our Client Land O'LakesFor over 100 years, Land O'Lakes, while primarily known for its contributions to...