Cogent Infotech Corporation is hiring: Business Analyst II in New York

• Manager would like to see someone that understands e-comm data and e-comm KPIs and CRM
• Need to be able use data manipulation and python and Google Worker for visualization and building of dashboards.
• General reporting with Excel. Manage time very well as this candidate will report into two managers. Interpret and analyze data to make recommendations
• This role will be responsible for leveraging global data sources to build and maintain e-commerce and CRM dashboards and reporting to support data-driven Brand strategies.

Key Responsibilities:
E-COMMERCE:

• Own, build and maintain monthly & quarterly global digital channels sales reporting and global eCommerce and KPI dashboards
• Leverage analytics to drive customer-centric action plans and maximize opportunities by cross-referencing and merging insights from diverse data sources, supporting multi-channel strategies
• Consolidate multiple Google Analytics property data for recurring monthly reporting, utilizing internal tools to analyze the state of business and provide key findings
• Collaborate closely with stakeholders, serving as a subject matter expert to lead KPI analyses of site performance, site feature performance, and digital marketing channels globally. Provide feedback on ways to enhance performance
• Possess a key understanding of on-site user journeys and conversion funnels to advise on delivering a consistent user experience and to improve conversion. Identify gaps or opportunities for improvement to support digital, content and site experience teams

CRM:

• Create and maintain CRM & loyalty reporting dashboards by aggregating and consolidating data from various platforms and data sources (Tableau, Power Bi, csv files, etc.)
• Own CRM & loyalty quarterly reporting and identify gaps to improve holistic view of our customers
• Lead data collection from various global market partners and KPI analyses on global CRM and loyalty activations (customer behavior, email channel performance, loyalty program performance, NPS, product purchase trends, etc.)
• Support data-aggregation, standardization, and analysis for loyalty program structural and financial modeling

TRANSVERAL:

• Deliver monthly digital dashboards and presentations (eCommerce + CRM) to provide business highlights and insights to the leadership team
• Collaborate with the internal global team to support ad-hoc data or analysis requests and develop business cases
• Consolidate and streamline the data needs of business stakeholders and Digital IT
• Compile data and research of online consumer behavior, monitor industry trends, and share insights with cross-functional teams to inform strategic decisions to inform strategic business decisions

Requirements:

• Background in E-Commerce and/or CRM data and web analytics
• Experience with on-site user journey, CRM KPIs (like retention, CLV), email, and SMS marketing
• Experience with Google Analytics 4
• Experience developing dashboards using Looker Studios (BigQuery experience preferred)
• Experience with SQL & Python (Databricks experience preferred)
• Advanced skills in excel is mandatory