Business Analyst II

Job Summary:

Designs and prepares reports, dashboards, and summaries for statistical analysis and planning purposes. Analyzes business issues using data from internal and external sources to provide insight to decision-makers. Identifies and interprets trends and patterns.

Principal Responsibilities:

• Collects, compiles and analyzes data from various databases and performs statistical analysis for internal customer groups.
• Develops reports and/or creates dashboards providing financial related information needed to make informed business decisions.
• Designs, creates and implements templates to collect, display and analyze data for assigned projects
• Communicates complex data in comprehensible ways. Evaluates information from multiple sources and clearly indicates quality of final analysis.
• Develops reports and other tools to deliver internal company information enabling business users to make informed decisions.
• Gathers, aggregates models, and analyzes information from multiple external sources regarding company financial performance, customer insights, competitor profiling, competitive threats, potential product or technical expansion, industry trends and other such business intelligence aspects.
• Establishes standards and procedures for a variety of processes, conducting business analysis resulting in detailed creation and maintenance of business process mapping, requirements and training materials documentation.
• May participate in or lead project teams.
• Identifies, investigates and participates in opportunities to improve processes and procedures, to include various key performance metrics.
• Other duties as assigned.

• Field: Marketing, Customer Analytics,
• Domains: Retail, Distribution, B2B, B2C, Marketplace.

Preferred candidate profile

• Customer/Marketing Analytics, Customer Life Cycle analytics, Customer Acquisition, Customer retention, Customer churn and Customer Life Time value analysis and Statistical Modeling.
• Metrics like CAC, conversion rates, AOV, and cart abandonment analysis.
• Marketing Campaign pre/post analysis, customer segmentation for marketing campaign, email marketing, digital marketing and ROI measurement.

Must have skillset and what are the tools he or she should be familiarized

Microsoft SQL Server - Expert in SQL query, performance tuning, SQL reporting,

• Power BI: Power BI Visualization, Data Model Optimization, Data Transformation, Power Query.
• Familiarity with ERP systems for inventory, order, and customer data integration.
• Expertise in Power BI, Tableau, or other visualization tools for dashboard creation .
• Creating insights-driven reports for non-technical stakeholders .
• Knowledge of Python or R for data processing and advanced analytics
• Ensuring data accuracy, completeness, and consistency across systems.

Education : Engineering/BE/BTech