Marketing Data Analyst/ETL Developer in Respect.Studio

As a data analyst, you will play a crucial part in developing the reporting module for the SaaS product. You’ll be responsible for data collection, optimization, and visualization to enhance and optimize the performance of customer marketing campaigns and internal pipelines. 

As an ETL Developer, you will be responsible for designing, developing, and maintaining ETL processes that extract data from various sources, enrich data via API when needed,  transform it into a suitable format, and load it into a data warehouse.

Your role will involve working closely with cross-functional teams to understand business objectives and provide data-driven insights and recommendations.

Key Responsibilities:

1. Data Analysis and Interpretation:

• Apply statistical methods and data mining techniques to analyze data and identify patterns, trends, and correlations
• Design regular reports and dashboards highlighting performance insights, trends, opportunities for improvement, and recommendations.

1. Data Preparation and Visualization:

• Transform the raw data into a consistent format suitable for analysis.
• Merge, join, and aggregate the datasets in an efficient way
• Build the designed dashboards and reports
• Enhance dashboard performance

1. ETL(Extract, Transform, Load) processes:

• Collecting data from different sources, such as databases, spreadsheets, APIs, etc.
• Data cleansing, enriching, formatting data types, etc.
• Loading data into data warehouses (PostgreSQL or GoogleBigQuery)
• Work on optimizing ETL processes for efficiency and performance, especially when dealing with large volumes of data
• Design error-handling mechanisms to capture, log, and handle data integration errors and exceptions
• Automation of processes via the building of Airflow workflows

Requirements:

• Prior experience in data management and ETL processes
• Experience with Python (2+ years), with expertise in using Airflow for orchestration
• Proficiency in SQL
• Experience in management data warehousing systems  (PostgreSQL, Google BigQuery)
• Experience with BI Tools (Superset is a plus)
• Understanding of statistics and mathematical modeling
• English at a strong intermediate level or higher

Soft Skills:

• Excellent problem-solving skills and ability to work in a fast-paced environment.
• Strong communication and collaboration skills to work effectively in cross-functional teams
•  Attention to detail and commitment to data quality and integrity
•  Learning agility

Preference Given to Candidates With:

• Working with cloud services (AWS)
• Experience in the marketing field, understanding of contemporary marketing trends
• Bachelor's degree in a relevant field, such as statistics, mathematics, economics, computer science, ordata science
• Experience with Superset