Data Modeling Architect

3 weeks ago


Chennai Tamil Nadu, India Gainwell Technologies LLC Full time

**Summary**:
As a **Data Modeling Architect** at Gainwell, you can contribute your skills as we harness the power of technology to help our clients improve the health and well-being of the members they serve — a community’s most vulnerable. Connect your passion with purpose, teaming with people who thrive on finding innovative solutions to some of healthcare’s biggest challenges. Here are the details on this position.

**Your role in our mission**:

- The Data Architect is responsible for managing the flow of data from various data sources.
- Develops Data Models on different data organization platforms like relational databases, big data that support the integration and organization of data across systems.
- Analyze and interpret data to create, review and ad hoc exhibits based on detailed data sets.
- Perform data mining and analysis that impacts forecasts and risk assumptions.
- Build and maintain actuarial models for analyzing healthcare claims, risk scores and demographic data.
- Work with Business, Architects and System Analysts to fully understand the business requirements and translate them into Conceptual, Logical and Physical models.
- Create and maintain conceptual, logical, and physical data models defining information requirements to meet end user needs.
- Partner with development and QA teams to communicate the business rules, data models and ensure test cases target the quality and integrity of the data model.
- Partner with DBAs to transform logical data models into physical database designs while optimizing the performance and maintainability of the physical database
- Works closely with DBA on the DDLs creation, maintenance, and optimization of the database.
- Analytical ability and business acumen to collect multiple sources of data and draw conclusions.
- Responsible for building solutions involving large data sets using SQL methodologies
- Has strong analytical SQL experience working with dimensional modeling.

**What we're looking for**:

- 8 to 14 years of experience working with datasets with strong understanding on how data should be optimized within transactional, reporting, and big data architectures.
- 4+ years of experience in health care industry working with extensive amounts of healthcare data (claim and clinical sides) and major databases.
- Expert knowledge of data modeling and understanding of different data structures and their benefits and limitations under particular use cases.
- Familiarity with Healthcare Industry models (IBM’s UDMH, Teradata’s HCDM etc.).
- Strong SQL skills to assist in the data analysis and discovery of the source data.
- Knowledge in Hadoop architecture, HDFS commands and experience designing & optimizing queries against data in the HDFS environment.

Tech Skills Needed:

- Expert in any data modelling tools like Erwin, ER studio.
- Experience with Unix/Linux and shell scripting.
- Relational Databases (DB2, MSSQL, Teradata, Oracle 8i/9i/10g/11i).
- Hadoop architecture & HDFS environment.
- Knowledge of Medicaid Industry and QNXT claims processing solution.
- Experience working in Agile environment.

**What you should expect in this role**:

- Remote Opportunity.
- Fast-paced, challenging and rewarding work environment.
- Will require late evening work to overlap US work hours.
- Opportunities to travel through your work (0-10%).


  • Lead Data Architect

    1 week ago


    tamil nadu, India W Talent Full time

    We are looking for a passionate Lead Information Architect, who will play a leading role in ensuring that the businesses architects and builds solutions that deliver FAIR data products enabling both digital and data/AI.You will lead activities to define the information architecture for the domain, including data models, master data strategies, metadata...

  • Big Data Architect

    1 month ago


    Chennai, Tamil Nadu, India RiskInsight Consulting Pvt Ltd Full time

    **Responsibilities**: - Design and architect Big Data solutions to meet business requirements. - Collaborate with stakeholders to understand their data and analytics needs. - Create and maintain data models, data flow diagrams, and data integration strategies. - Develop and implement data ingestion, processing, and storage solutions using Big Data...

  • Data Architect

    1 month ago


    Siruseri, Chennai, Tamil Nadu, India Hub Work Full time

    10+ years experience in architecting, designing, and developing large scale data solutions. 10+ years experience in building and maintaining ETL/ELT pipelines 5 years experience in developing streaming processes / systems Proficiency in various data management concepts such as Master Data Management Data Architecture Data Modeling Data...

  • Data Architect

    4 weeks ago


    Mumbai/Chennai, IN Anlage Infotech Full time

    Job Description :- Architecting, designing and developing Data warehouse solutions- Define Architecture, data modelling, design, high-level design documentation - Assess, capture, and translate complex business issues and requirements into structured analytics use case- Identify and troubleshoot business process, data quality or performance issues that show...

  • Data Architect

    1 month ago


    Mumbai,Chennai, India Anlage Infotech Full time

    Job Description : - Architecting, designing and developing Data warehouse solutions- Define Architecture, data modelling, design, high-level design documentation - Assess, capture, and translate complex business issues and requirements into structured analytics use case- Identify and troubleshoot business process, data quality or performance issues that...


  • chennai, India Virtusa Full time

    Snowflake Architect, SQL, python,Data Modelling - CREQ186600 Description 10+ Years along with Data Architect SnowflakeSnowflake SQL Writing SQL queries against Snowflake Developing scripts Unix, Python, etc. to do Extract, Load, and Transform dataHands-on experience with Snowflake utilities such as SnowSQL, SnowPipe, Python, Tasks, Streams, Time travel,...

  • Data Architect

    4 weeks ago


    Chennai, Tamil Nadu, India Guardian Life Insurance Company Full time

    Job Description: Requirements Elicitation, Understanding, Analysis, & Management - Understand the project's Vision and requirements, and contribute to the creation of the supplemental requirements, building the low-level technical specifications for a particular platform and/or service solution. Project Planning, Tracking, & Reporting - Estimate the tasks...

  • Data Architect

    2 weeks ago


    tamil nadu, India CES Full time

    CES has 26+ years of experience in delivering Software Product Development, Quality Engineering, and Digital Transformation Consulting Services to Global SMEs & Large Enterprises. CES has been delivering services to some of the leading Fortune 500 Companies including Automotive, AgTech, Bio Science, EdTech, FinTech, Manufacturing, Online Retailers, and...


  • tamil nadu, India Tiger Analytics Full time

    Tiger Analytics is a global leader in AI and analytics, helping Fortune 1000 companies solve their toughest challenges. We offer full-stack AI and analytics services & solutions to empower businesses to achieve real outcomes and value at scale. We are on a mission to push the boundaries of what AI and analytics can do to help enterprises navigate uncertainty...

  • Senior Data Analyst

    4 weeks ago


    Chennai, India Exusia Full time

    About The PositionDepartment:Sales and Delivery Team - EmpowerIndustry:Information Technology & Services, Computer Software, Management ConsultingLocation:Pune/Hyderabad/ Remote (Anywhere in India)Experience Range: 3 - 12 yearsBasic Qualification:Master/Bachelor of Engineering or EquivalentTravel Requirements:Not requiredWebsite:What’s the Role?Full-time...

  • Senior Data Architect

    2 weeks ago


    tamil nadu, India Agilisium Consulting Full time

    Are you an architect passionate about building secure, scalable data lakes on AWS? Do you thrive in collaborating and leading to achieve peak data performance! If so, we want to hear from you!We're seeking a highly experienced Data Architect to join our growing team. In this role, you will leverage your deep knowledge of AWS cloud services to design, build,...

  • Python Architect

    2 weeks ago


    tamil nadu, India HCLTech Full time

    HCLTech is hiring for Python Architect for Chennai LocationExperience: 10+ YearsWork Mode: Work From OfficeRequirements:• Design and architect Python-based applications for efficiently handling large volumes of images and seamlessly integrating deep learning models.• Create scalable and modular solutions that accommodate growth in both data and...

  • Lead Data Architect

    1 week ago


    Chennai, India W Talent Full time

    We are looking for a passionate Lead Information Architect, who will play a leading role in ensuring that the businesses architects and builds solutions that deliver FAIR data products enabling both digital and data/AI. You will lead activities to define the information architecture for the domain, including data models, master data strategies, metadata...

  • Lead Data Architect

    1 week ago


    Chennai, India W Talent Full time

    We are looking for a passionate Lead Information Architect, who will play a leading role in ensuring that the businesses architects and builds solutions that deliver FAIR data products enabling both digital and data/AI. You will lead activities to define the information architecture for the domain, including data models, master data strategies, metadata...

  • Lead Data Architect

    1 week ago


    Chennai, India W Talent Full time

    We are looking for a passionate Lead Information Architect, who will play a leading role in ensuring that the businesses architects and builds solutions that deliver FAIR data products enabling both digital and data/AI. You will lead activities to define the information architecture for the domain, including data models, master data strategies, metadata...

  • Financial Modeler

    4 weeks ago


    Chennai, India Applied Data Finance Full time

    Company Description We are a Financial Services company focused on matching underserved consumers in the U.S. with loan products. We are pioneers in risk management through our cutting-edge data science and technology stack. Over $800 million in loans have been originated through our Personify platform, and we are focused on providing best in class customer...


  • Chennai, Tamil Nadu, India Wipro Limited Full time

    Overview: **Role Purpose** - The purpose of the role is to define and develop Enterprise Data Structure along with Data Warehouse, Master Data, Integration and transaction processing with maintaining and strengthening the modelling standards and business information_ **Do** - **Define and Develop Data Architecture that aids organization and clients in new/...

  • Data Modeler

    1 month ago


    Chennai, India Pozent Full time

    5 -6 Yrs of Experience in Data Modeling preferable with Databricks, Snowflake, Postgress, Oracle - Demonstrate capabilities in designing and creating data models including conceptual, logical and physical models, as per the requirements. - Collaborate with Database administrator to translate data models into physical database structures, ensuring optimal...


  • Chennai, India Ford Motor Company Full time

    Enterprise Technology is looking for a hands-on and highly motivated individual who can work with a global team that is developing & deploying SAP S/4HANA for Ford's core manufacturing plants. The Data Architect will provide data driven design leadership. You will work with a large cross-functional team of Supply Chain IT members, a System’s Integrator...

  • Data Modeller

    1 month ago


    Chennai, India Saama Technologies Inc Full time

    Analyzing and translating business needs into long-term solution data models. - Evaluating existing data systems. - Working with the development team to create conceptual data models and data flows. - Developing best practices for data coding to ensure consistency within the system. - Reviewing modifications of existing systems for cross-compatibility. -...