We are seeking a highly skilled and detail-oriented Data Analyst/Engineer with 4 to 5 years of relevant work experience in managing, analyzing, and optimizing complex data pipelines. The ideal candidate will have expertise in Python, R, MySQL, and BigQuery, along with proven experience in Google Cloud Platform (GCP) and dashboarding tools like Looker Studio and Power BI.
Job Description:
Key Responsibilities
Data Management and Analysis:
Design, develop, and manage data warehouse solutions using BigQuery.
Perform data analysis to uncover insights and provide actionable recommendations.
Develop and maintain database tables, views, and optimize MySQL queries.
Automate data workflows and processes with scripting and job automation tools.
Dashboard and Visualization:
Create compelling dashboards and visualizations in tools like Looker Studio and Power BI.
Version Control and Collaboration:
Implement and maintain version control best practices using Git for collaborative development.
Technical Expertise:
Write and optimize stored procedures for efficient database operations.
Utilize strong knowledge of data warehousing and designing concepts.
Qualifications
Must-Have Skills:
4 to 5 years of hands-on experience in data analysis/Data engineering
Proficiency in Python, R, MySQL, and BigQuery.
Hands-on experience with Google Cloud Platform (GCP).
Strong understanding of data warehousing and designing concepts.
Proficient in developing dashboards using Looker Studio and Power BI.
Expertise in database development, including table and view creation, stored procedures, and scripting.
Experience automating jobs and workflows.
Good-to-Have Skills:
Familiarity with applying basic machine learning algorithms(Classification/Regression) for insights and predictive modeling.
Ability to gather and transform stakeholder requirements into actionable scoping documents.
Strong analytical skills to identify optimization opportunities and recommend improvements for enhanced efficiency.
Desired Experience
Relevant work experience in the Media and Marketing (MMX) domain is a plus.
A collaborative mindset with strong problem-solving skills and attention to detail.