Note: The job is a remote job and is open to candidates in USA. Publicis Groupe is a global data, technology and services company that powers the marketing and advertising ecosystem. They are seeking a Senior Data Analyst to develop analytics applications, manage data flows, analyze marketing performance, and create interactive dashboards for effective campaign measurement.
Responsibilities
- Develop and implement a set of techniques or analytics applications to transform raw data into meaningful information using data-oriented programming languages and visualization software
- Collaborate with internal and external stakeholders to manage incoming and outgoing data, understand business rules, changes to enable project execution
- Analyze the performances of multiple digital marketing channels and campaigns that are run every month and incorporate the necessary changes accordingly to improve performance
- Design and execute the sourcing, staging, processing and manipulation of the data using SAS programming and produce the output data for the various monthly campaigns
- Review QC the output data to ensure data correctness, ensuring efficient marketing campaigns for the clients
- Run ad hoc analysis on the marketing programs to ensure data correctness and to verify results
- Prepare monthly, quarterly and yearly results in the form of presentations explaining the results of all the analysis and data processing
- Discuss recommendations and right strategies with stakeholders to increase the revenue and profits for the clients
- Design and build interactive dashboards to measure retail marketing campaigns effectiveness
- Perform ad hoc activities and all incoming tasks concurrently
- Maintain timeliness and effectiveness of all the deliverables and improvise based on the feedback
Skills
- Master's degree in Computer Science, Engineering, Information Technology or related field
- One year of experience in the job offered or one year of experience in any occupation in which the required experience was gained
- Design and build interactive dashboards in Tableau and MS Excel for automotive clients
- Create complex SQL queries to track and analyze KPIs
- Automate tasks using MS Excel Macros and Python
- Manage administrative activities across Tableau Server infrastructure
- Import, manipulate and process multiple format source datasets using SAS programming
- Design and implement marketing campaign programs in SAS, ensure data correctness, and incorporate any ad hoc requirements
- Collaborate with internal stakeholders to manage data flow, understand and implement the business rules
- Contribute to monthly client presentations and report the results of analyses in MS Excel, providing strategic and tactical recommendations
- Migrate and analyze large legacy data sets from MS Excel to Python utilizing Pandas
- Create POCs and perform exploratory data analysis, profiling, and data mining using Pandas
- Create Tableau dashboards using filters, sets/groups, parameters, and calculated fields
- Implement data blending and create dual axis graphs with multiple measures in Tableau
- Execute and streamline ASC 606 revenue recognition and global revenue finance functions utilizing MS Excel, SQL/PL-SQL, and Alteryx
Benefits
- Flexible time off (FTO), 15 paid holidays
- Paid sick time
- Parental/new child leave, childcare & elder care assistance, adoption assistance
- Comprehensive health coverage
- 401(k)
- Tuition assistance
- Commuter benefits
- Professional development
- Employee recognition
- Charitable donation matching
- Health coaching and counseling
- Temporary roles may be eligible to participate in our freelancer/temporary employee medical plan through a third-party benefits administration system once certain criteria have been met
- Temporary roles may also qualify for participation in our 401(k) plan after eligibility criteria have been met
- For regular roles, the Company will offer medical coverage, dental, vision, disability, 401k, and paid time off
Company Overview