Senior Data Integration Analyst

Job Description

This position is responsible to support data integration and extraction needs for the creation of automated visualizations and reports. The right candidates need experience in working with traditional relational databases and others like AWS, Big Data technologies like Redshift. The analyst / data engineer will work to provide a unified view of data that resides in multiple sources like Marketo, Salesforce CRM, Web analytics, Events & Campaigns data etc. The candidate is expected to takeover existing data mart management & will also participate on other BI projects as and when needed.We look for an analyst that will work with large amounts of data: facts, figures, and number crunching. You will need to make data easily available with relevant measures and metrics that allow measure success and develop insightful reporting. You will work closely with Project Leaders that prioritize a full portfolio of dashboards in our Customer Journey and Digital capabilities. The Analyst will also help identify issues with data quality, process defects, form hypothesis, and make recommendations to optimize performance.RESPONSIBILITIES: - Ability to work independently with large amounts of information and see the bigger picture - Develop and support ETL for BI and Data marts (Transforming, improving and integrating data, depending on the business requirements) - Comfortable in working on Big data technologies. - Making large and/or complex data more accessible, understandable and usable - Combining the data result sets across multiple sources (also known as the data federation) - Understand the current and future state of business requirements and tool capabilities - Work collaboratively to design and develop visualizations and/or reports in a dynamic global environment - Integrate quality practices in all aspects of technology delivery; audit work products to ensure quality and sustainability - Maintain appropriate documentation, traceability and configurations; follow record retention policies - Execute tasks in all phases of an analysis development lifecycle - Craft stories that present learnings in a visual and compelling format using data visualization tools/toolkits like Tableau. - Works with the Project Leader to obtain user acceptance on the overall solution - Expertise in the global analytics tools and data structure to provide support as needed, like identify gaps in data capture strategy and recommend enhancements. - Deliver routine reporting based on clients needs as well as quickly responding to ad hoc requests.QUALIFICATIONS: Business / Soft Skills and Experience: - Exceptional relationship management and communication skills with the ability to influence - Solid communication and inter-personal skills; ability to work effectively with global teams - Ability to work closely with globally dispersed stakeholders from Business - Ability to manage multiple priorities in a fast-paced environment - Ability to work in a matrix environment with multiple Business groups - Ability to translate business needs into requirements for visualization and reporting needs - Ability to tell a story through data - A data-driven mindset with ability to influence behaviour based on analyticsTechnology Skills and Experience: - Strong Mastery of Excel - Strong Knowledge of database and data warehousing concepts (SQL, AWS, Amazon Redshift, SSIS) - Strong Knowledge of data integration tools will be a must on different environments like: Tableau Prep, Alteryx and Informatica. - Technical expertise in data modelling using R, database design development, data mining and segmentation techniques - Data visualization using Tableau/Power BI/ Birst or any other BI tool - 5-8 years of experience in Data Integration, supporting and executing ETL and data management - Knowledge of Web Analytics platforms preferred.Education: - B.E./B.Tech in Computer Science, Bachelor s/Master s Degree in Marketing or Statistics or Data Science, *QUALIFICATIONS: Business / Soft Skills and Experience: - Exceptional relationship management and communication skills with the ability to influence - Solid communication and inter-personal skills; ability to work effectively with global teams - Ability to work closely with globally dispersed stakeholders from Business - Ability to manage multiple priorities in a fast-paced environment - Ability to work in a matrix environment with multiple Business groups - Ability to translate business needs into requirements for visualization and reporting needs - Ability to tell a story through data - A data-driven mindset with ability to influence behaviour based on analyticsTechnology Skills and Experience: - Strong Mastery of Excel - Strong Knowledge of database and data warehousing concepts (SQL, AWS, Amazon Redshift, SSIS) - Strong Knowledge of data integration tools will be a must on different environments like: Tableau Prep, Alteryx and Informatica. - Technical expertise in data modelling using R, database design development, data mining and segmentation techniques - Data visualization using Tableau/Power BI/ Birst or any other BI tool - 5-8 years of experience in Data Integration, supporting and executing ETL and data management - Knowledge of Web Analytics platforms preferred.Education: - B.E./B.Tech in Computer Science, Bachelor s/Master s Degree in Marketing or Statistics or Data Science

Keyskills :
amazon redshiftdata modelingautomationsalesforce crmbig dataapidata miningdata qualitydatabase designeambusiness processdata martsweb analyticsjava