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
Similar Jobs
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.
Big Data • Fintech • Information Technology • Business Intelligence • Financial Services • Cybersecurity • Big Data Analytics
The Financial Services Business Analyst will leverage extensive datasets to develop strategic analyses, create statistical models, and prepare financial reports. This role requires analyzing market trends and client revenue, conducting market research, and effectively communicating analytical results. The analyst will work with business intelligence tools, SQL, and statistical software to derive insights and support financial forecasting.
Top Skills:
MS OfficePythonRSASSQLTableau
Artificial Intelligence • Cloud • Internet of Things • Software • Cybersecurity • Industrial
As a Lead Data Scientist at Caterpillar, you will provide thought leadership in ML and AI solutions, oversee data processing, develop machine learning models, and mentor junior data scientists while driving business improvements through data analytics.
What you need to know about the Bengaluru Tech Scene
Dubbed the "Silicon Valley of India," Bengaluru has emerged as the nation's leading hub for information technology and a go-to destination for startups. Home to tech giants like ISRO, Infosys, Wipro and HAL, the city attracts and cultivates a rich pool of tech talent, supported by numerous educational and research institutions including the Indian Institute of Science, Bangalore Institute of Technology, and the International Institute of Information Technology.
