Database Engineer

Job Description

The Data Engineer will serve as a key technical partner for building scalable and effective data automation & analytics solutions for marquee 360i clients. Working alongside our talented team of engineers, analysts, and data scientists, this role will have the opportunity to experiment with new technologies while building robust Analytics and Predictive Modeling solutions.

• Work closely with clients to identify business needs and analytics opportunities, scoping customized analyses to drive marketing and business performance
• Design systems to make data accessible & useful
• Build scalable analytics systems for clients across the agency
• Create advanced reporting through automated processes to more efficiently consolidate data from a multitude of internal, vendor, and application specific sources.
• Build large scale data warehousing solutions
• Utilize Python, SQL APIs, and Excel Macros to develop & manage data pipelines
• Design custom dashboards to showcase the most critical series of actionable business metrics Increase Marketing ROIs by helping to improve brand and channel specific performance.
• work in a nationally distributed team in an Agile/Scrum approach

Qualifications

• Bachelor’s degree in Computer Science Engineering, or related field; advanced degree preferred
• 2+ years of data engineering or other data-intensive development experience
• Demonstrated skills in ETL development, data modeling, and data warehousing.
• Advanced skills and experience using Python, SQL, Bash and other scripting/compiled languages.
• Experience with or exposure to MPP & Big Data technologies (Redshift, BigQuery, Spark, Hive/Hadoop, EMR, etc.)
• Experience with Linux/Unix operations in a cloud computing environment
• Experience with BI tools like Tableau, Datorama or similar
• Excellent written and oral communications skills and the ability to clearly define projects, objectives, goals, schedules and assignments

• Experience with AWS technologies including Redshift, RDS, S3 and EMR, as well as Git and Docker based continuous integration & deployment pipelines.
• Demonstrated experience with the R/Python data engineering & data science ecosystem, including Pandas, Airflow, Scikit, Statsmodels, and Tidyverse
• Experience with building marketing analytics pipelines, including display, search, and social
• Knowledge of algorithms and statistics and at least some experience in data mining, machine learning, and/or natural language processing

Additional Information

Dentsu is an equal opportunity employer. We do not discriminate based on sex, gender identity, race, color, national origin, religion, sexual orientation, disabilities or any other protected basis because we believe the best and brightest come from all walks of life. We aspire to foster a community in which diversity is valued in both our employees and our ideas.