Source description
About the role
Job Summary: You are sought after to join our growing analytics team as a detail-oriented and highly skilled Data Analytics Specialist. Your expertise in SQL, BI tools, and scripting (Python / AppScript) will be vital in deriving actionable insights from large volumes of structured and unstructured data. Collaborating across business teams, you will play a crucial role in driving strategic decisions through data. Key Responsibilities: - Data Analysis & Insights - Analyze large datasets to identify trends, patterns, and business insights. - Perform exploratory data analysis (EDA) using SQL, Python, PySpark. - Support A/B testing design, execution, and analysis for product/marketing initiatives. - Reporting & Visualization - Develop, maintain, and optimize interactive dashboards and reports using Quicksight or Looker. - Create calculated fields, parameters, and custom visualizations in BI tools. - Automate recurring reports to improve efficiency. - Optimize dashboard efficiency. - Data Extraction & Processing (ETL) - Write and optimize complex SQL queries (joins, subqueries, window functions) across databases (MySQL, BigQuery). - Extract, clean, and transform data from structured/unstructured sources. - Implement and maintain data quality checks at each stage of the ETL process to ensure accuracy and consistency across reports. - Optimize query performance. - Collaboration & Stakeholder Management - Partner with business teams (travel) to define KPIs and deliver data-driven solutions. - Present findings to stakeholders in a clear, actionable manner. - Identify and resolve data quality issues in collaboration with engineering teams. - Optimize query performance and dashboard efficiency. Technical Skills Required: Core Tools & Languages: - SQL: Advanced querying (joins, subqueries, CTEs), performance tuning, and optimization. - BI Tools: Quicksight, or Looker (calculated fields, parameters, dashboard design). - Spreadsheets: Excel/Google Sheets (VLOOKUP, pivot tables, macros, Google Apps Script). - Programming: Python/PySpark (for data cleaning, manipulation, and basic automation). Databases & Warehousing: - SQL Databases: MySQL (Preferred). - NoSQL (Nice-to-have): DynamoDB. - Cloud Data Warehouses: BigQuery. - Cloud Services: S3, Athena, RDS. Bonus Skills: - Cloud Platforms: AWS (S3, Glue), GCP. Nice-to-Have: - Domain experience (e.g., Travel, Leisure). - Knowledge of data modeling. - Scripting automation (Python/PySpark). Job Summary: You are sought after to join our growing analytics team as a detail-oriented and highly skilled Data Analytics Specialist. Your expertise in SQL, BI tools, and scripting (Python / AppScript) will be vital in deriving actionable insights from large volumes of structured and unstructured data. Collaborating across business teams, you will play a crucial role in driving strategic decisions through data. Key Responsibilities: - Data Analysis & Insights - Analyze large datasets to identify trends, patterns, and business insights. - Perform exploratory data analysis (EDA) using SQL, Python, PySpark. - Support A/B testing design, execution, and analysis for product/marketing initiatives. - Reporting & Visualization - Develop, maintain, and optimize interactive dashboards and reports using Quicksight or Looker. - Create calculated fields, parameters, and custom visualizations in BI tools. - Automate recurring reports to improve efficiency. - Optimize dashboard efficiency. - Data Extraction & Processing (ETL) - Write and optimize complex SQL queries (joins, subqueries, window functions) across databases (MySQL, BigQuery). - Extract, clean, and transform data from structured/unstructured sources. - Implement and maintain data quality checks at each stage of the ETL process to ensure accuracy and consistency across reports. - Optimize query performance. - Collaboration & Stakeholder Management - Partner with business teams (travel) to define KPIs and deliver data-driven solutions. - Present findings to stakeholders in a clear, actionable manner. - Identify and resolve data quality issues in collaboration with engineering teams. - Optimize query performance and dashboard efficiency. Technical Skills Required: Core Tools & Languages: - SQL: Advanced querying (joins, subqueries, CTEs), performance tuning, and optimization. - BI Tools: Quicksight, or Looker (calculated fields, parameters, dashboard design). - Spreadsheets: Excel/Google Sheets (VLOOKUP, pivot tables, macros, Google Apps Script). - Programming: Python/PySpark (for data cleaning, manipulation, and basic automation). Databases & Warehousing: - SQL Databases: MySQL (Preferred). - NoSQL (Nice-to-have): DynamoDB. - Cloud Data Warehouses: BigQuery. - Cloud Services: S3, Athena, RDS. Bonus Skills: - Cloud Platforms: AWS (S3, Glue), GCP. Nice-to-Have: - Domain experience (e.g., Travel, Leisure). - Knowledge of data modeling. - Scripting automation (Python/