Job Details

Lead Data Designer

This role analyzesbusiness and IT requirements and formulate solutions in the area of data analytics, transforming data into information and into intelligence. This role requires an excellentknowledgeon spear heading e2e data integration and business intelligence solutionsthatwarrant quality solutiondesign.

Technical Responsibilities

• Analyze business requirements and translate into end to end technical solution with detail architecture blueprint, design specifications, data interfaces and integration approaches, infrastructure requirements, etc.
• Conduct solution assessment to determine the overall project scope, work breakdown, solution cost, implementation effort and timeline, etc.
• Must be well versed with defining the technology roadmap for setting up the Data integration strategy and developing data models using ERWIN for operational data stores, MDM& client 360 data warehouse/business intelligence solutions
• Excellent knowledge on data integration tools like ETL (Informatica), databases (SQL server, Oracle) scheduling tools (Control-M, Autosys)
• Must be very comfortable in delivering data visualization& BIsolutions using tools  like Tableau, Qliksense or SAS Visual analytics
• Knowledge ofdelivering big data solutions using Horton Works, SAS analytical tools, Real Time Decision Management, Artificial Intelligence with Machine Learning, and other evolving technologies is an added advantage
• Should have implemented projects on data quality using products like Informatica IDQ
• Must have experience in developing the data automation, devops& CI/CD strategy for the data/ETL teams. Proven experience in implementing the framework is a must

Leadership responsibilities:

• Comes with a can-do attitude and takes full accountability and ownership of the projects
• Should be a go getter and must have proven experience on navigating the organization to deliver projects as per estimated timelines
• Provide leadership to the team on all aspects of the solution including functional requirements, design, integration, implementation, deployment and hands on trouble shooting.
• Able to communicate clearly to both Senior Business and Technology Executives on the solution and the benefits
• Technically coaches and leads a team of 3-5 ETL, database & visualization experts
• Out of box thinking and must have demonstrated experience in delivering proof of concepts on new and innovative ideas to senior management
• Provide thought leadership on various data analytics solutions / technologies in the market along with best practice methodologies and industry standards.
• Conduct prototyping with the solutions and drive the requirements to closure with the business users.  Able to use “Open Analytics” solutions for quick prototyping and then implement and operationalize with SLF technologies.

Requirements

• Undergraduate degree in Computer Science, Engineering or related fields.
• Extensive practical experience in Information Technology and software development projects of which at least 8-10 years in Operational data store, data warehousing & data visualization/BI solutions.
• At least 7-9 years of experience in implementing& architecting data solutions using  the informatica, SQL server/Oracle
• At least 2 years of experience in implementing data quality solutions using IDQ or similar technologies
• At least 2 years of experience in implementing data ETLautomation solutions using DevOps and CI/CD technologies
• At-least 1 year of experience in handling the migration from traditional technologies to big data technologies for implementing data lake solution
• At least 3-5 years of experience inleading e2e solutions for Data enablement solutions like ODS, Warehousing (includingdata modelling anddata schema design), Data Integration with ETL (preferably Informatica) and Change Data Capture, BI Reporting and/or Master Data Management.
• At least 3years’ experience in various Data Management practices including Data Governance, Data Standardization, Data Quality& Cleansing, etc.
• Knowledge of SAS platform and tools is an added advantage
• Atleast 1-2 yrs of experience in handling data visualization tools like SAS VA, Tableau to develop business insight dashboards
• At least 3 years implementation experience for Financial Services Institutions in Client Analytics, Sales & Marketing Analytics, Risk Analytics, Finance Intelligence, etc.
• Solid experience in database technologies (i.e. Oracle, SQL, DB2, etc), data / visual modelling tools (e.g. Erwin, Spark Enterprise Architect, etc), operating systems (i.e. Linux / UNIX and Windows), performing monitoring and tuning.
• Familiar with architectural terminology and awareness of architectural frameworks (e.g. TOGAF, Zachman, etc.)