Data Analyst SQL Tableau & ETL
- Lokalify
- 2 - 4 years
- Pune
- 2 months ago
- Email to a friend
- Report this job
Job Description
Job Title: Analyst - Global Reporting
Department: Analytics
Reporting To: Manager - Analytics
Job Location: Pune (Work from Office)
Interview Mode: Walk-in Interviews at Pune
Company Overview
We are a global marketing services company catering to top-tier clients like Johnson & Johnson, Coke, Cathay Pacific, GoPro, FitBit, and Sony. Our centralized digital operations unit in India supports campaign implementation and reporting for global clients.
We seek a dynamic Analyst - Global Reporting to enhance our data analytics capabilities, automate reporting, and build interactive dashboards.
Job Summary
As an Analyst - Global Reporting, you will play a crucial role in transforming raw data into actionable insights. Your expertise in data visualization, ETL processes, SQL queries, and Excel-based reporting will be leveraged to develop interactive dashboards and reports. You will collaborate with global stakeholders, troubleshoot data anomalies, and implement process automation.
Key Responsibilities
- Data Analysis & Reporting:
- Design, develop, and maintain automated dashboards and reports using Tableau, Datorama, Power BI, or QuickSight.
- Aggregate and analyze data from multiple sources to generate key business insights.
- Retrieve and manipulate data using SQL queries and join multiple datasets.
- ETL & Data Processing:
- Support ETL processes using MSSQL, Alteryx, and other data processing tools.
- Manage data extraction, transformation, and loading processes efficiently.
- Stakeholder Collaboration & Reporting Optimization:
- Work closely with global business teams to understand reporting needs and develop customized reports.
- Ensure reports are formatted correctly and meet delivery deadlines.
- Investigate data discrepancies and provide actionable resolutions.
- Dashboard Maintenance & Data Visualization:
- Update and maintain Tableau, Excel, or similar dashboards for daily/weekly reporting.
- Identify and integrate new data sources to improve visualization effectiveness.
- Assist in taxonomy classification, data cleansing, and reformatting of reports.
Required Qualifications & Skills
- Experience: Minimum 2+ years in Data Analytics, Reporting, and Visualization.
- Technical Skills:
- SQL Strong experience in writing complex queries and handling large datasets.
- Data Visualization Hands-on experience with Tableau, Power BI, QuickSight, or Datorama.
- Excel VBA & Advanced Excel Experience in automating reports and handling complex formulas.
- ETL Tools Familiarity with MSSQL, Alteryx, or similar platforms.
- Soft Skills:
- Strong verbal and written communication skills.
- Ability to interpret data and present insights effectively.
- Comfortable working in a fast-paced, dynamic environment.
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: IT & Information SecurityRole Category: IT Infrastructure ServicesRole: Configuration and Deployment ManagementEmployement Type: Walk-insContact Details:
Company: LokalifyLocation(s): Pune
Keyskills: Data Visualization Etl Process SQL Queries Tableau Python Power Bi Quicksight Alteryx Datorama MSSQL Excel Vba
Similar positions
Lokalify
Amazon is guided by four principles: customer obsession rather than competitor focus, passion for invention, commitment to operational excellence, and long-term thinking. We are driven by the excitement of building technologies, inventing products, and providing services that change lives. We embrac...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in