Reporting & Insights- Specialist (Power BI + SQL)

placeBangalore calendar_month 

Overview:

We are an integral part of Annalect Global and Omnicom Group, one of the largest media and advertising agency holding companies in the world. Omnicom’s branded networks and numerous specialty firms provide advertising, strategic media planning and buying, digital and interactive marketing, direct and promotional marketing, public relations, and other specialty communications services.

Our agency brands are consistently recognized as being among the world’s creative best.

Annalect India plays a key role for our group companies and global agencies by providing stellar products and services in areas of Creative Services, Technology, Marketing Science (data & analytics), Market Research, Business Support Services, Media Services, Consulting & Advisory Services.

We are growing rapidly and looking for talented professionals like you to be part of this journey. Let us build this, together.

Responsibilities:

  • Requirement gathering and evaluation of clients’ business situations in order to implement appropriate analytic solutions.
  • Designs, generates and manages reporting frameworks that provide insight as to the performance of clients’ marketing activities across multiple channels.
  • Be the single point of contact on anything data & analytics related to the project.
  • QA process: Maintain, create and re-view QA plans for deliverables to align with the requirements, identify discrepancies if any and troubleshoot issues.
  • Prioritize tasks and proactively manage workload to ensure timely delivery with high accuracy.
  • Active contribution to project planning and scheduling.
  • Create and maintain project specific documents such as process / quality / learning documents.
  • Should be able to drive conversation with team, client and business stake holders

Qualifications:

  • 6-9 years experience in data management and analysis in Media or relevant domains with strong problem-solving ability.
  • Data visualization using power BI and Looker Studio must have. Other visualization tools like Tableau and etc., are good to have
  • Integration experience with 3^rd Party APIs must-have; prior experience in analysing data and dashboard output required
  • Strong working knowledge of DAX, SQL, ETL is desired
  • Data management and reporting using different tools like Alteryx, Datorama, R, Python, etc are good to have
  • Strong working knowledge of Excel is mandatory.
  • Working knowledge of VBA and Database Optimization are good to have skills
  • Knowledge of PostgreSQL (AWS) and Microsoft SQL (Azure) is good to have.
  • Strong knowledge on media metrics, custom calculations, and metrics co-relation
  • Ability to identify and help determine key performance indicators for the clients.
  • Excellent written and verbal communication skills.
  • Led delivery teams and projects to successful implementations
  • Familiarity working with large data sets and creating cohesive stories.
  • Able to work and lead successfully with teams, handling multiple projects and meeting timelines.
  • Maintaining positive client and vendor relationships.
  • Presentation skills using MS Power Point or any presentation platforms
check_circleNew offer

Power BI - Sr Manager Position

apartmentContinuServeplaceBangalore
to ensure successful project completion. The ideal candidate will have a strong background in data analytics, experience with Power BI, and a proven ability to manage and interpret complex datasets. Responsibilities Work with stakeholders to identify...
apartmentAccentureplaceBangalore
requirements using Microsoft Power BI. Your typical day will involve working with Power BI, developing and deploying applications, and collaborating with cross-functional teams. Roles & Responsibilities:  •  Lead the design, development, and deployment...
local_fire_departmentUrgent

Lead Power Bi Developer

placeBangalore
Overview: Job Title : Lead Power Bi Developer Location : Bangalore Aptean is changing. Our bespoke ERP solutions are transforming a huge range of global businesses, from food producers to manufacturers. In a world of generic enterprise software...