Position: CRM Data Analyst
Company: AboutHR recruiting agency
Category: Data Analyst
Experience required: 3y
English level: intermediate

Purpose of the job:

Creation, support of the data warehouse as a single holistic ecosystem of customer knowledge. Identification of patterns of customer behavior based on existing data, as a result of automating the processes of identifying new segments / groups of customers and the main triggers for influencing them in order to improve customer experience, customer journey, expand the shopping basket and increase company revenue.

Skills, knowledge, experience:
● 5+ year relevant experience (customers’ database management, customers segments).
● 5+ year experience in areas with high data-centricity processes.
● Knowledge of building statistical models.
● Knowledge of automatization ETL processes.
● Advanced level of SQL.
● Base knowledge Python/R.
● Knowledge BI systems (Power BI or other).
● English – Intermediate.

Main responsibilities:
Database across all segments:
● Creating, maintaining and scaling the data warehouse, automating ETL processes from various systems.
● Automates the process of checking the relevance of uploaded data.
● Creates procedures, views necessary to automate database maintenance.
● Provides regular filling of the database with information about clients received from external sources.
● Automates and creates the scripts needed to generate regular reports and execute ad-hoc queries.
Data analysis:
● Transforming large datasets into a business idea with data analytics.
● Explores and applies statistical learning techniques to discover patterns in data.
● Implements statistical methods to solve specific business problems.
● Generates predictive statistics and user behavior patterns to improve and optimize business operations, customer experience, and other business outcomes.
● Develops and implements predictive and scoring models to identify churn-prone customers, upselling and cross selling opportunities.
● Improves existing methodologies by developing new data sources, testing model enhancements, and fine-tuning model parameters.
● Improves various stages of the current process of building predictive models.
● Convert large datasets into business insights through data analysis.
● Research and apply statistical learning techniques to discover patterns in data.
● Implement statistical methods to solve specific business problems.
● Building predictive statistics and customer behavioral models to increase and optimize business operations, customer experience and other business outcomes.
● Improve upon existing methodologies by developing new data sources, testing model enhancements, and fine-tuning model parameters.
● Contribute to improve various stages of current process of building predictive models.
Reports and dashboards:
● Identifies and analyzes the factors that affect the main performance indicators of the company, presents and visualizes the results for making business decisions.
● Responsible for the creation and release of regular analytical reports and dashboards necessary to understand customers, change their behavior or buying preferences over time.
● Fulfills ad-hoc requests for data provision or customer analysis.
● Analyzes the effectiveness of holding campaigns, company initiatives.