Baxter Spec, IT in Karnataka, India
Job title: Data Modeler SUMMARY The Data Modeler will work with business and/or technical analyst in effectively translating the business requirements into conceptual, logical, and physical data models. ESSENTIAL DUTIES AND RESPONSIBILITIES • Work with lead data architect to determine a high-level data strategy for the Enterprise Data Warehouse. • Work with business partners on the full lifecycle of data-related projects from requirements analysis and design through development. • Responsible for creating, and maintaining, conceptual, logical and physical data models defining information requirements for management and business intelligence purpose. • Participate in ETL design and act as SME on source and target data structures • Pull data from databases on different platforms (i.e. Oracle, SQL Server, Teradata, Hadoop) to integrate data and build an analytic data mart. • Assist developers, ETL, BI team and end users to understand the data model. • Working with OLTP and OLAP systems. • Responsible for summarizing complex findings clearly and concisely with stakeholders. • Should be responsible for working as an individual contributor for the project. • Successful management of project delivery to agreed outcomes and time frames. • Work with the project & change management team to develop training materials.
Education/Experience • 10-12 year experience working with BI technology. • Minimum 4 years of experience in database development and administration; Experience with data integration and database design, knowledge of Data Warehousing methodologies. • Minimum 4 Year of experience working with planning, designing of data model. • Strong SQL skills to analyze, manipulate data, investigate data problems, and develop reports • Good experience on ETL tools like IBM Data Stage etc. • Strong skills required in Oracle DB design. • Well versed with Reverse/forward engineering in creating data models in Visio or any other tool preferable. • Good experience working with OLTP (ODS, data marts etc.) and OLAP systems. • Experience with enterprise reporting tools such as Cognos or Business Objects or Tableau. • Excellent data interpretation and communication skills. • Ability to communicate effectively to all levels of management • Able to work in virtual teams and international exposure is a must.
Job: *Information Technology
Organization: *Application Svcs
Title: Spec, IT
Requisition ID: 1700047N