Business Data Analyst - Iii

Summary:
The VCG Data & Analytics Hub - Reporting COE team is looking to hire a Business Data Analyst to deliver value to the Client's organization through business intelligence reporting and deep analytics by driving insights to actions. The team manages the analysis and insights for new and existing Client's customers across all Omni channels including online (desktop & mobile), chat, and call centers. This full-time role will be responsible for developing and building reporting solutions, guiding data-driven decisions and recommending Next Best Actions, analyzing Customer journey touchpoints, driving personalization of behavioral insights, cross-channel analytics, segmentation, assessment of overall impact for use cases and help define, refine, and measure business outcomes to transform customer experience.
Responsibilities:

• Collaborate and partner with Digital and Omni channel stakeholders to identify analytics and reporting requirements and baseline metrics prior to executing new use cases
• Develop Digital KPIs and reporting dashboards in ThoughtSpot/Tableau/Qlik/Looker to measure, analyze and report trends on App and Web Engagement, App Adoption, Digital Channel Hops and E2E CX journey metrics with path analysis, cohort segmentation, SQL automation.
• Source and analyze data from various data repositories, validate data for consistency, and partner with IT teams to ensure data integrity and KPI calculations
• Stitch together data from multiple channels to formulate a complete customer journey 360 view.
• Create and deploy actionable dashboards for business owners to gauge performance and assist with omni channel optimization decisions such as CX KPIs, NPS, Revenue, Churn, Call-in Rate
• Develop VCG Reporting visualizations to highlight insights on opportunities to reduce journey fallout, channel hops, post digital assisted contact rate and optimizing human interactions
• Stakeholder scorecards and dashboards with executive leadership to gain alignment and promote usage and maintain consistent KPI definitions in Collibra for Data Governance
• Perform A/B Testing, measure success metrics of new releases over existing flows, run simulations for Omni insight personalization, holistically analyze end-to-end journey paths
• Correlate, interpret and summarize scorecard reports for Omni, Assisted and Cross-Channel metrics and quantify business outcomes for data-driven campaigns and business performance.

Education and Experience:

• Bachelor’s degree or four or more years of work experience.
• Six or more years of relevant work experience.
• Ability to create complex SQL queries to pull data from relational and non-relational data sources like Teradata, Google Cloud Platform (GCP)/BigQuery, Hadoop/HIVE SQL and EDW.
• Data visualization skills and good experience using Tableau/ThoughtSpot/Qlik to develop reports
• Experience conducting research or analysis and managing projects for multiple stakeholders.
• A/B Testing experience and KPI measurements for deriving insights from customer behavior and data patterns from Omni channels

Compensation:
The pay rate range above is the base hourly pay range that Aditi Consulting reasonably expects to pay someone for this position (compensation may vary outside of this range depending on a number of factors, including but not limited to, a candidate’s qualifications, skills, competencies, experience, location and end client requirements).
Benefits and Ancillaries:
Medical, dental, vision, PTO benefits and ancillaries may be available for eligible Aditi Consulting employees and vary based on the plan options selected by the employee.