Data Architect

• Collaborating with functional teams including, but not limited to, requirement reviews to define solutions or alternatives according to the business need and technological capabilities/limitations
• Influencing technical and business members at different levels of the organization to ensure data models align to strategic objectives, considering current need and future potential (scalability/reusability)
• Promoting “data first” benefits to the organization and usage of Enterprise capabilities to relevant business groups
• Defining the data architecture framework, standards and principles, including modeling, metadata, security, reference data and master data
• Hands-on on experience in building conceptual, logical & physical dimensional data models
• Prepare designs for database systems and recommend improvements for performance
• Maintain and develop various database scripts and tools to facilitate automation process
• Assess database implementation procedures to ensure they comply with internal and external regulations
• Prepare accurate database design and architecture reports for management and executive teams
• Following all standard System Development Life Cycle processes and producing required documentation
• Producing guidelines and standards for E2E analytics implementation for both ETL & Reporting usage, manageability and maintainability within the organization
• Executing analysis, planning, right technology selection, prototyping, designing, developing, deploying, and assisting in end-user training of solutions to the user community for projects, changes and maintenance & evolutions
• Providing leadership, technical guidance, training and mentoring to others in areas of acquired/assigned expertise, including external consultant partners – knowledge sharing is key to our success
• Staying abreast of industry standard and cutting-edge technologies through whitepapers, vendor-based collaboration and literature, and technical newsgroups – sharing the research with all members of the local team and extended global community through our internal collaboration tools
• Communicates risks and ensures understanding of these risks
• Post go live support – via ticketing tool - of the full Enterprise B.I. & Analytics platforms’ capabilities – irrespective of technology
• The first contact point of our end users globally in run mode – optimal communication, resolution and issue closure
• Operational availability of our evolving technology portfolio, with a deep understanding of the various technical components/features of each technology and proactive trending of weaknesses/’areas to watch’ with proposals to Platform Owner of evolutions required
• Realizing (& exceeding) our SLAs and Service Delivery KPI targets by defining those KPIs, with daily monitoring and benchmarking on both quantitative and qualitative measures
• Once identified, contributing to upgrades/evolutions end to end on the portfolio of technologies
• Creation and Maintenance of the knowledge store of operational issues, trends, activities
• Applying Problem Management techniques to reduce recurring incidents and requests

• B.E / B TECH/MASTERS IN COMPUTER SCIENCE, ELECTRONICS, RELEVANT TECHNICAL CERTIFICATION
• 15+ years experience of the full software development lifecycle on BI projects and support experience
• 10+ years experience on working on data objects pertaining both master and transactional data in Purchasing, Material, Sales Orders and Supply chain in SAP & Oracle ERP is mandatory
• 8+ years in Dimensional Data modelling experience (STAR & Snowflake)
• Expertise in AWS services such as Redshift, Database Migration Service, Glue, S3, and Schema Conversion Tool
• Any one data modeling tool experience is mandatory (Erwin or any other tool)
• Need to be strong in SQL query writing and procedures
• Experience in following components (or similar): BI tools: Tableau, Oracle Business Intelligence, PowerBI…
• ETL tools: Informatica PowerCenter, PL/SQL, IICS…
• Data bases: RedShift, Oracle, PostgreSQL, Exasol,…
• Other: object-oriented programming language (python)
• Experience managing servers both Cloud and On-prem (ideally experienced in AWS
• Proven ability and initiative to learn and research new concepts, ideas, and technologies quickly
• Ability to communicate effectively, both verbal and written
• excellent presentation skills
• Ability to effectively move forward on tasks even with ambiguous or changing requirements
• Ability to work in a team-oriented, collaborative environment in a global context
• Willingness and ability to train and teach others
• Ability to facilitate meetings and follow up with resulting action items
• Ability to self-manage, prioritize and execute tasks in a high-pressure environment
• Strong systems/process orientation with demonstrated analytical thinking, organization skills and problem-solving skills
• The desire for growth and innovation, to bring rapid solutions to business challenges/opportunities
• Strong consultancy orientation and experience, with the ability to form collaborative, productive working relationships across diverse teams and cultures is a must
• The ability to work in a centralized/decentralized operating model, with varying implementation partners and implementation owners

Experience in industry model will be added advantage