Data Modeling Architect (SQL)
Chennai, TN, IN, 600032
Applications have closed
Gainwell Technologies
Gainwell empowers you through innovative technologies and solutions to deliver better health and human services outcomes.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.
- Has strong knowledge of large-scale search applications and building high volume data pipelines.
- Knowledge in Hadoop architecture, HDFS commands and experience designing & optimizing queries against data in the HDFS environment.
- Ability to apply mastery knowledge in one of the relational data bases (DB2, MSSQL, Teradata, Oracle 8i/9i/10g/11i).
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%).
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Agile Architecture Big Data Data analysis Data Mining Data pipelines DB2 Hadoop HDFS Linux MS SQL Oracle Pipelines RDBMS Shell scripting SQL Teradata
Perks/benefits: Health care
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Data Manager jobs
- Open Lead Data Analyst jobs
- Open MLOps Engineer jobs
- Open Senior Business Intelligence Analyst jobs
- Open Data Science Manager jobs
- Open Principal Data Engineer jobs
- Open Data Engineer II jobs
- Open Power BI Developer jobs
- Open Sr Data Engineer jobs
- Open Data Scientist II jobs
- Open Product Data Analyst jobs
- Open Business Intelligence Developer jobs
- Open Data Analytics Engineer jobs
- Open Junior Data Scientist jobs
- Open Sr. Data Scientist jobs
- Open Senior Data Architect jobs
- Open Business Data Analyst jobs
- Open Data Analyst Intern jobs
- Open Big Data Engineer jobs
- Open Principal Data Scientist jobs
- Open Junior Data Engineer jobs
- Open Manager, Data Engineering jobs
- Open Data Product Manager jobs
- Open Data Quality Analyst jobs
- Open Research Scientist jobs
- Open GCP-related jobs
- Open Data quality-related jobs
- Open Business Intelligence-related jobs
- Open Java-related jobs
- Open ML models-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open Data visualization-related jobs
- Open Finance-related jobs
- Open Deep Learning-related jobs
- Open PhD-related jobs
- Open APIs-related jobs
- Open TensorFlow-related jobs
- Open PyTorch-related jobs
- Open NLP-related jobs
- Open Consulting-related jobs
- Open Snowflake-related jobs
- Open CI/CD-related jobs
- Open LLMs-related jobs
- Open Generative AI-related jobs
- Open Kubernetes-related jobs
- Open Data governance-related jobs
- Open Hadoop-related jobs
- Open Airflow-related jobs
- Open Docker-related jobs