Lead - Reporting and Insights

OverviewOmnicom Global Solutions (OGS) is an agile innovation hub of Omnicom Group, a leading global marketing and corporate communications company. Guided by the principles of Knowledge, Innovation, and Transformation, OGS is designed to deliver scalable, customized, and contextualized solutions that meet the evolving needs of our Practice Areas within Omnicom.OGS India plays a key role for our group companies and global agencies by providing stellar products, solutions, and services in the areas of Creative Services, Technology, Marketing Science (Data & Analytics), Advanced Analytics, Market Research, Business Support Services, Media Services, and Project Management. We currently have 4000+ awesome colleagues in OGS India who are committed to solving our clients’ pressing business issues. We are growing rapidly and looking for talented professionals like you to be part of this journey. Let us build this, togetherResponsibilitiesObtain a functional understanding of the use of Snow’s systems and applications.Export, consolidate, and analyze data sets from multiple marketing/database platforms.Audit data for consistency, accuracy, completeness, and regulatory adherence.Identify key insights and make strategic recommendations based on findings from data analysis.Utilize excellent writing skills and independent judgment to condense information quickly and present analysis and conclusions in an efficient, logical manner.Must be able to utilize discretion and judgment and think through the lens of what clients and accounts need.Independently produce weekly/monthly/quarterly/EOY & ad hoc reports and dashboards to tell the story of a campaign effectively and efficiently with minimal oversight and errorsMonitor and track key email marketing metrics including delivery, open rates, click rates, conversion, and opt-outs.Generate insightful visualizations to depict trends in data and inform recommendations.Demonstrate a holistic understanding of both multi- and omnichannel marketing strategies by guiding their implementation to optimize engagement and increase audience retention.Partner with key internal stakeholders, including account services, event management, call centers, digital, technology solutions, and database management to design and implement measurement plans for direct-to-patient marketing programs.Independently prepare for, run and present all client work within the analytics umbrella.Consistently and confidently interact with clients and advise them, while keeping manager informed before and afterward.While keeping supervisor informed, drive timelines and next steps with account team, project management team, and shared services team, operating with a full understanding of the project.Own and understand client and patient-specific insights, wants, and needs and incorporate them into briefs and client work with little to no coaching and supervision while keeping supervisor informed.Develop company benchmark goals and case studies.Provide technical guidance to Senior Marketing Analytics Managers I and II and Marketing Analytics ManagersRegularly provide solutions to manager, teammates, and clientsCollaborate positively with clients and teammatesQualifications6–8 years of experience in data management, analysis, and reporting, preferably in the media or marketing analytics domain.Proven expertise in exporting, consolidating, and analyzing datasets from multiple marketing or database platforms.Strong skills in data auditing for consistency, accuracy, completeness, and adherence to regulatory standards.Hands-on experience with Salesforce, Power BI, PowerPoint, Excel, and Outlook for reporting, data visualization, and stakeholder communication.Advanced proficiency in Microsoft Excel (Power Query, Pivot Tables, complex formulas) for data cleaning, transformation, and analysis.Experience in cleaning and preparing data in Salesforce and exporting to Excel or Power BI for analysis and reporting.Strong critical thinking and problem-solving abilities to identify and resolve data inconsistencies or inaccuracies.Excellent oral and written communication skills, with the ability to present insights and actionable recommendations clearly.Demonstrated ability to interact effectively with cross-functional teams including marketing, internal stakeholders, and clients.Ability to prepare comprehensive reports and presentations highlighting key insights and findings.Strong organizational and time-management skills to ensure all deliverables meet client timelines and expectations.