Associate Director, Data Engineering
New York City, United States
Applications have closed
Publicis Groupe
Company Description
Both Performance Collective and PHM sit under the Publicis Media pillar, which is a collective group of agencies that specifically focus on Media advertising under the Publicis Groupe network. Within this collection of agencies as well as the broader network, we are uniquely positioned to not only deliver innovation to our clients as we partner together but also deliver the best-in-class opportunities and benefits to our employees. We deliver the atmosphere of a startup company, with the stability of having a parenting company in Publicis Groupe. As you can see, we are growing; in the past year alone, we have hired 1/3 of our current workforce. Currently, we operate out of four locations across the US which are New York, Chicago, Detroit, Philadelphia, and Los Angeles. LifeSpeed in particular will be based out of our New York office.
Job Description
Responsible for developing and supporting data products, this resource plays a critical role in the design, development and management of modern, cloud-based data engineering and data warehouse solutions utilized by internal and external stakeholders.
Key Responsibilities:
Create high performance data products by monetizing BI solutions, warehouse and ETL technologies
Work closely with different teams such as client, sales, IT, media planning and buying
Design, develop and productionize data engineering pipelines on a massively parallel processing (MPP) and cloud-based tech stack, utilizing solution aspects from hybrid-clouds (Azure, AWS), data lakes and multiple data warehouses.
Data management functions including:
ETL/data feed management
Metadata management
Create database objects as needed (e.g. Stored procedures, Stages, Indexes)
Optimization of data pipelines
Maintain best practices for handling, storing and using data
Tools:
Apache Spark (Pyspark), Pandas, Python
Any modern database (Oracle, SQL Server, Postgres)
Good to have exposure to data visualization tools such as Tableau, PowerBI
Data engineering stack on public clouds – AWS, Azure, Google
Qualifications
BS Degree in one of the following subject areas; Computer Science, Information Technology or related field preferred
Minimum of 5+ years of experience designing and developing BI solutions
Strong understanding of database structures, theories, principles, and practices
Strong understanding of ETL and data warehouse principles
Good interpersonal, written and oral communication skills
Technical documentation skills
Ability to present complex ideas in user-friendly language
Self-motivated and directed, with keen attention to detail
Able to prioritize and execute tasks in a team-oriented, high-pressure environment
Specific Skills Required:
Minimum 5 years SQL experience, 3 years of ETL experience
Python based data wrangling experience highly desired.
Strong data warehouse knowledge
Experience with large data sets
Experience with Web and Digital marketing data a plus
BS Degree in one of the following subject areas; Computer Science, Information Technology or related field preferred
Minimum of 5+ years of experience designing and developing BI solutions
Strong understanding of database structures, theories, principles, and practices
Strong understanding of ETL and data warehouse principles
Good interpersonal, written and oral communication skills
Technical documentation skills
Ability to present complex ideas in user-friendly language
Self-motivated and directed, with keen attention to detail
Able to prioritize and execute tasks in a team-oriented, high-pressure environment
Specific Skills Required:
Minimum 5 years SQL experience, 3 years of ETL experience
Python based data wrangling experience highly desired.
Strong data warehouse knowledge
Experience with large data sets
Experience with Web and Digital marketing data a plus
Additional Information
All your information will be kept confidential according to EEO guidelines.
Compensation Range: $106,500 - $167,500 annually. This is the pay range the Company believes it will pay for this position at the time of this posting. Consistent with applicable law, compensation will be determined based on the skills, qualifications, and experience of the applicant along with the requirements of the position, and the Company reserves the right to modify this pay range at any time. For this role, the Company will offer medical coverage, dental, vision, disability, 401k, and paid time off.
Tags: AWS Azure Computer Science Data management Data pipelines Data visualization Data warehouse Engineering ETL MPP Oracle Pandas Pipelines PostgreSQL Power BI PySpark Python Spark SQL Tableau
Perks/benefits: Health care Startup environment
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open AI Engineer jobs
- Open MLOps Engineer jobs
- Open Data Science Manager jobs
- Open Data Engineer II jobs
- Open Senior Business Intelligence Analyst jobs
- Open Data Manager jobs
- Open Sr Data Engineer jobs
- Open Power BI Developer jobs
- Open Principal Data Engineer jobs
- Open Junior Data Scientist jobs
- Open Data Analytics Engineer jobs
- Open Business Intelligence Developer jobs
- Open Data Scientist II jobs
- Open Senior Data Architect jobs
- Open Product Data Analyst jobs
- Open Business Data Analyst jobs
- Open Sr. Data Scientist jobs
- Open Big Data Engineer jobs
- Open Manager, Data Engineering jobs
- Open Data Analyst Intern jobs
- Open Data Quality Analyst jobs
- Open Junior Data Engineer jobs
- Open Data Product Manager jobs
- Open Azure Data Engineer jobs
- Open ETL Developer jobs
- Open Data quality-related jobs
- Open Business Intelligence-related jobs
- Open ML models-related jobs
- Open Data management-related jobs
- Open GCP-related jobs
- Open Java-related jobs
- Open Privacy-related jobs
- Open Finance-related jobs
- Open Data visualization-related jobs
- Open APIs-related jobs
- Open Deep Learning-related jobs
- Open PyTorch-related jobs
- Open Snowflake-related jobs
- Open Consulting-related jobs
- Open TensorFlow-related jobs
- Open PhD-related jobs
- Open CI/CD-related jobs
- Open NLP-related jobs
- Open Data governance-related jobs
- Open Kubernetes-related jobs
- Open Airflow-related jobs
- Open Data warehouse-related jobs
- Open LLMs-related jobs
- Open Databricks-related jobs
- Open Hadoop-related jobs