Description

Key Responsibilities and Duties

Data Acquisition and Preparation:

• Extract, Transform, and Load (ETL) data from various primary and secondary data sources (e.g., internal databases, cloud platforms, external APIs).
• Clean and preprocess raw data to ensure accuracy, consistency, and completeness, including identifying and correcting errors, managing missing data, and transforming formats.
• Design and maintain databases (e.g., data warehouse models) and data systems to optimize data access and quality.

Data Analysis and Interpretation:

• Apply statistical methods and data analysis techniques to perform exploratory and diagnostic analysis to uncover trends, anomalies, and relationships within complex datasets.
• Conduct hypothesis testing and develop models (e.g., regression analysis) to support business questions and predict outcomes.
• Define, track, and report on Key Performance Indicators (KPIs) and metrics across various business functions (e.g., Marketing, Sales, Operations).

Reporting and Visualization:

• Design, develop, and maintain interactive dashboards and reports using visualization tools to present data in a clear, digestible format for both technical and non-technical audiences

Collaboration and Improvement:

• Collaborate with cross-functional teams (e.g., Data Engineering, Product, IT) to understand data requirements and deliver targeted, timely insights.
• Proactively identify and recommend process improvements, system modifications, and operational changes based on data analysis.

Required Qualifications and Skills

Essential Technical Skills (Hard Skills)

• SQL (Structured Query Language): Advanced proficiency in writing complex queries, stored procedures, and managing relational databases.
• Statistical Programming: Expertise in at least one statistical programming language (Python or R) for complex data analysis, statistical modeling, and automation (e.g., using libraries like Pandas, NumPy, Scikit-learn).
• Data Visualization Tools: High proficiency in industry-standard tools like Tableau, Power BI, or Google Looker Studio for creating interactive dashboards.
• Spreadsheet Tools: Advanced knowledge of Microsoft Excel (Pivot Tables, VLOOKUPs, functions, modeling).
• Statistical Analysis: Strong foundation in descriptive and inferential statistics

Key Skills

Education

Any Gradute