Data Modeler (Pune, India)
ACS-I India is looking for an experienced Data Modeler who would be responsible for creating and maintaining high quality physical and conceptual data models and schemas. This individual will also work to identify and define common information requirements and design conceptual structures and plan to meet the current and long-term data requirements of the assigned data domains.
About ACS-I India:
ACS International India Pvt Ltd. (ACS-I India) is a wholly owned subsidiary of ACS International Ltd, USA and a part of the American Chemical Society. ACS-I India represent products and services provided by ACS divisions, including CAS to the world’s most important scientific companies, government organizations, global patent offices and academic institutions to promote research and discovery.
About CAS:
CAS is a division of the American Chemical Society and is a source of chemical information. CAS provides products and services, solutions for researchers and professional searchers, and support and training. CAS has provided the most comprehensive repository of research in chemistry and related sciences for over 100 years. CAS finds, collects and organizes all publicly disclosed substance information and creates the world's most valuable chemistry databases. Scientists and patent professionals across the world rely on this database.
Job Responsibilities:
- Create, manage, and modify logical and physical data models using a variety of data modeling philosophies and techniques.
- Closely partner with Data Stewards to understand the needs of the business and what data relationships the models represent along with helping to identify what relationships and dependencies also need to be reflected.
- Establish and maintain comprehensive data model documentation.
- Profile source data and meet regularly with IT partners to develop complete source to target data mappings.
- Develop requirements and perform data collection, cleansing, transformation, and loading to populate facts and dimensions for data warehouse.
- Interact with application development, enterprise architecture, business intelligence, and technology services on a regular basis.
- Model Entities, Attributes, Relationships and Keys that logically matrix to the conceptual models
- Coordinate with the database administration group to ensure day-to-day activities (statistics collection and reporting) are performing in the most efficient manner (data warehouse and big data environments).
- Investigate data quality issues to determine root cause, resolve any data issues and recommended process change to prevent reoccurrence.
- Perform other duties as assigned.
Job Requirements:
- 4 Year BA/BS degree in Computer Science, MIS, or Business Administration
- 2-3 years working experience in a data modeling role.
- Understanding of various data modeling techniques (for example Inmon and Kimball)
- 1-2 years working experience with ER Studio or comparable data modeling tool experience.
- Strong understanding of relational databases, querying and building
- Experience with data in a large-scale service architecture
- SQL knowledge
- Experience analyzing data profiling, data mining, data cleansing, data content, scrubbing data, and translating data via rules from one database to another.
- Strong Data Modeling skills to include data quality, source systems analysis (DB2, Oracle, VSAM, etc.) business rules validation, source to target mapping design, and preparation of sample data examples.
- Effective interview and meeting facilitation skills are required.
- Strong analytical ability and problem-solving skills.
- Strong organizational skills.
- Ability to work effectively both in a team environment and independently.
- Strong written and verbal communication skills.
Desired, but not required:
- Knowledge and experience in chemistry, drug discovery/development, or medical related industry
If interested, please send your cover letter and CV to hrdtech@acs-i.org.