Job Description

JOB DESCRIPTION The candidate must possess in-depth functional knowledge of the process area and apply it to operational scenarios to provide effective solutions. He/she must be able to identify discrepancies and propose optimal solutions by using a logical, systematic, and sequential methodology. It is vital to be open-minded towards inputs and views from team members and to effectively lead, control, and motivate groups towards company objects. Additionally, he/she must be self-directed, proactive, and seize every opportunity to meet internal and external customer needs and achieve customer satisfaction by effectively auditing processes, implementing best practices and process improvements, and utilizing the frameworks and tools available. Goals and thoughts must be clearly and concisely articulated and conveyed, verbally and in writing, to clients, colleagues, subordinates and supervisors. Associate Process Manager Roles and responsibilities: Understand the business model on why things are the way they are, ask relevant questions and get them clarified. Coordinate with business stakeholders to understand the campaign objective by participating in regular sync up calls. Understand and follow the campaign roadmap, plan data availability and coordinate with the campaign execution team to ensure a successful campaign launch. Enhance / optimize existing SQL queries, which have been created for data optimization. Setup data pipelines for migrating the data from one platform to another. Set up Power BI dashboards based on the requirements and priorities provided by business stakeholders. Prescribe suitable solutions with an understanding in limitations of toolsets and available data. Manage procurement of data from various sources and perform data audits. Fetch and analyze Campaign data from disparate sources and drive meaningful insights on customer behavior supported by appropriate statistical summaries. Visualize Campaign performance and provide recommendations on the business rules for effective campaign targeting. Interpret analytical results and provide insights present key findings and recommended next steps to clients. Develop tangible analytical projects communicate project details to clients and internal delivery team via written documents and presentations, in forms of specifications, diagrams, and data/process models. Audit deliverables ensuring accuracy by critically examining the data and reports against requirements. Collaborate on regional/global analytic initiatives and localize inputs for country campaign practices. Actively work on audience targeting insights, optimize campaigns and improve comm governance. Technical and Functional Skills: BS/BA degree or equivalent professional experience required Degree. Very strong advanced SQL skills for analyzing and optimizing the query. Minimum 2-3 years of relevant experience professional experience in advanced analytics for a Fortune 500-scale company or a prominent consulting organization. Hands-on experience in digital marketing and/or 1:1 marketing in any channel expert level knowledge in database marketing and CRM. Very strong advanced SQL skills expert level knowledge in database marketing and CRM, Working knowledge in data visualization tools (Power BI, Tableau),Knowledge on analyzing digital campaigns and the tools/technologies of performance marketing. Strong analytical and storytelling skills ability to derive relevant insights from large reports and piles of disparate data. Comfortable working autonomously with broad guidelines. Passion for data andanalytics for marketing and eagerness to learn. Excellent communications skills, both written and spoken ability to explain complex technical concepts in plain English. Working knowledge in data visualization tools (Power BI). Ability to manage multiple priorities and projects, aligning teams to project timelines and ensuring quality of deliverables. Strong in numerical and analytical skills. Participate in initiatives including campaign tracking, test-and-learn recommendations to improve performance of solutions delivered to the business. Manage regular reporting and ad-hoc data extract from other departments. Knowledge on analyzing digital campaigns and the tools/technologies of performance marketing. Experience with Google sheet/Excel. Reporting - Tableau, Data Extraction tools, Advanced SQL, CRM Analytics, Campaign Marketing, and Analytics knowledge - Campaign Analytics & Machine Learning. Working knowledge of analytical/statistical techniques. Experience in Hadoop environment - Hive, Presto is a plus. Experience in in Python / Airflow. Previous consulting experience is a definite plus. ABOUT THE TEAM eClerx provides critical business operations services to over fifty global Fortune 500 clients, including some of the world\'s leading companies across financial services, cable & telecom, retail, fashion, media & entertainment, manufacturing, travel & leisure, software, and high-tech. Incorporated in 2000, eClerx is one of India\'s leading process management and data analytics companies and is today traded on both the Bombay and National Stock Exchanges of India. eClerx employs 9,500-plus people across its global sites in the US, UK, India, Italy, Germany, Singapore, Thailand. eClerx Digital is the trusted partner of choice to the world\'s largest global brands for creative production, eCommerce/web operations, and analytics & insight services. We improve profitability for their digital businesses. Using the Follow the Sun delivery model, our team of 3,000+ full-time digital delivery employees - at our five productions hubs in Mumbai, Pune, Chandigarh, Verona, and Phuket - applies deep digital expertise to support the most demanding global clients effectively. eClerx Digital\'s innovative delivery model drives the \'metrics that matter\' for our clients: improved acquisition, conversion and retention, and overall lifetime value of your customer 24/7/365.

foundit