Publicis Collective · 7 hours ago
Senior Analyst, Platforms
Birmingham, MI
Full-time
Onsite
Mid, Senior Level
$72K/yr - $95K/yr
2+ years expPublicis Collective is a forward-thinking company focused on redefining the future of marketing through innovative solutions. The Senior Analyst will design, develop, and support a data-driven software platform while managing multiple projects in a fast-paced environment.
AdvertisingAnalyticsCRMDigital Marketing
Responsibilities
Take provided requirements and identify any gaps to create a solution
Database development including stored procedures, user defined functions, triggers and ETL packages
Uphold quality standards and create monitoring tools to ensure high fidelity data
Troubleshoot database issues, identify root causes, and implement optimal solutions
Extract, transform, and load data from multiple data sources using languages and tools such as Python
Design, build, best, debug, monitor, and troubleshoot ETL and software processes in Python
Serve as an escalation point for any issues that may arise
Design testing requirements and prepare test plans and test modules
Ability to follow implementation standards, develop documentation and transfer of knowledge
Qualification
Required
2+ years' experience with ETL, databases, and Python
Familiarity with cloud technologies such as Amazon Web Services (Redshift, S3, Glue, Lambda) or Databricks
SQL programming skills (stored procedures, functions, etc.)
Experience with complex processing logic against large data sets
Excellent data modelling skills and experience working with multiple datasets
Possession of strong communication and presentation skills as well as an analytical mindset
Problem solving and testing skills
Familiarity with code versioning tools such as Git
Strong organizational skills & attention to detail
Possess a desire to work for a fast-paced, results-based company
Experience managing multiple projects simultaneously
Self-driven/entrepreneurial spirit with the ability to think outside of the box
Preferred
Experience with marketing data and digital media
Experience with Business Intelligence software (Tableau, PowerBI)
Experience and thorough understanding of a variety of APIs
Experience supporting analytics and data science teams/tools (Pandas, R, Alteryx)
Benefits
Medical coverage
Dental
Vision
Disability
401K
Parental and family care leave
Family forming assistance
Tuition reimbursement
Flexible time off
Company
Publicis Collective
Publicis Collective is a creative agency that provides web analytics, internet marketing, CRM, and digital technology services.
5001-10000 employees
Funding
Current Stage
Late StageLeadership Team
Meghan Grant
Chief Client Officer, Global Integrated Media
Recent News
2025-03-11
2024-04-10
Company data provided by crunchbase