Sign In
 [New User? Sign Up]
Mobile Version

TaCIT- CDT-Data Modeller & Development (Customer Data )

Bengaluru, KA
Job Code:
  • Oil & Gas
Applying for this job will take you to an external site
  • Shortlist
  • Email Friend
  • Print

Job Details

Technical & Competitive IT (Tacit) Customer data and analytics team (CDA) is accountable to develop, deploy and sustain leading edge marketing and advanced analytics platform capabilities for Shell which (a) consolidates data from a variety of (internal and external) sources, (b) analyses that data to deepen our customer knowledge and build personalized, targeted campaigns, and (c) integrate those campaign offers through multiple channels such as mobile, web and e-mail direct to our customers using the channel with which they prefer to interact with Shell. This provides a truly leading edge customer experience which delivers sustainable competitive advantage and business value to Shell.PurposeData is essential for all the advanced customer data and analytics capabilities and customer marketing value propositions delivered through the CDA foundation platform.Data is essential for all the advanced customer data and analytics capabilities and customer CVPs delivered through the CDA foundation platform.The purpose of the position is to work in the capacity of data modeller to design, develop, support and manage the delivery of data management solutions (application data structure, storage and integration) in the Customer data and analytics group, sustain and improve the delivery of customer experiences, analytics and reporting done through the enterprise CRM and digital platform.AccountabilitiesUnderstand (and define) the data model of various source systems and destination CDA platform.Manage the mappings of source to destination data.Take input from the Data architect/Data Design Lead to design data mapping, logical data model and rulesProvide SME input into designs, change requests and defect resolutionDefine the data requirements and structure for the application. Model and design the application data structure, storage and integrationDevelopment of the data model, ETL processes and business rules to process and load data into the Data martsWork with Enterprise integration services team, CDA Data Business analysts to develop / update interface specifications.Work with key business representatives, data owners, end users, application designers and data architects from various parts of the organisation to model current and new datasourcesSupport wider offshore team to build knowledge and respond to specific design queriesHands-on developmentOversee and manage other data developersDimensionsGlobal scope with opportunity to work with multiple businesses across RDS in time (initial focus Downstream Retail)Wide range of internal and external stakeholders (Businesses, functional IT, IT support, Product Vendors etc).Special ChallengesNeeds to be able to deal with state of the art, differentiated and often unproven technologies which require some learning on the jobNeeds to be comfortable with sometimes vague and changing scope and priorities in a rapidly changing environmentAbility to interact and build relationships both within Shell (IT & Business teams) and external (IT partners and BPO partners)Additional CommentsOpportunity to work on enterprise platform across multiple CoB.Opportunity to work on Tier 1 high visibility program in Shell.Opportunity to work in truly multi-national, multi-cultural, fast paced environment.Opportunity to influence Shell's bottom line in a very measurable and meaningful way.Opportunity to shapeRequirementsExperience, Skills and Qualifications required9 12 years of total experience.SkillsExperience of Data Warehousing, BI &/or Advanced Analytics deliveryStrong knowledge of structured data management, RDBMS and ETL technologiesExperienced in SQL, SAS, (Python, HIVE, Spark knowledge desirable)Experience in translating requirements and defining KPIs/MetricsExperience in analysing, designing and supporting applications that interface with databaseStrong communication skillsDemonstrated experience in refactoring, testing, debugging, and optimizing SQL code.Knowledge of database architecture and design principles including relational database design, views, indexes and joinsStrong ETL experience with SAS DI knowledge desirableBusiness Partnering & Value- KnowledgeDevelop & Manage Suppliers - AwarenessIncident, Threat & Vulnerability Management- AwarenessI & D Design Integrity- KnowledgeIT Architecture- KnowledgeIT Service Delivery & Support Processes- SkillLandscape & Configuration Management- SkillProgramme Management- AwarenessSoftware Engineering- Skill
Degree: MCA/ PGDCA

Additional Degree: BE/ B.Tech (Engineering)

Experience: 9-12


Application Programming | Data Warehousing | Database Administration (DBA) | Software Engineer
Applying for this job will take you to an external site


© Copyright 2015 Al Nisr Publishing LLC - powered by Gulf News