The Data Analyst/Engineer will be responsible for managing and analyzing data pipelines, developing data warehouse solutions, and creating visual dashboards. Key tasks include optimizing MySQL queries, automating workflows, and utilizing Google Cloud Platform for data management, with a focus on delivering actionable insights and recommendations.
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.
Location:
Chennai
Brand:
Paragon
Time Type:
Full time
Contract Type:
Permanent
Top Skills
Python
R
Similar Jobs
Cloud • Fintech • Food • Information Technology • Software • Hospitality
The Workforce Management Forecasting Analyst role entails analyzing and forecasting call-center metrics, conducting post-mortems to assess deviations, and collaborating with multiple teams to enhance forecast accuracy. Expertise in data visualization and performance projections is essential to communicate effectively with stakeholders. This position involves the integration of staffing movements across communication channels and continuous monitoring of casework volume for accurate predictions.
Top Skills:
PythonRSQL
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
The role involves analyzing credit risk, managing regulatory reporting such as IFRS9 and Basel 3, and delivering business transformation projects. Key responsibilities include executing complex change management initiatives and performing data and business analysis with a focus on finance-related regulations.
Top Skills:
SQL
Artificial Intelligence • Healthtech • Professional Services • Analytics • Consulting
The Decision Analytics Associate will develop and apply advanced statistical models, leverage analytic techniques for data-driven decision-making, and design custom analyses using tools like R and Tableau. They will synthesize results and maintain client relationships while mentoring team Associates, contributing to projects with effective communication and problem-solving skills.
Top Skills:
JavaPythonR
What you need to know about the Chennai Tech Scene
To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.
