Jobs at Havas Chicago

Supports an agency account management team with project coordination, administrative tasks, competitive tracking, meeting preparation, status reporting, meeting notes, stakeholder recaps, and client and agency scheduling. Builds knowledge of client businesses and competitive markets while communicating project updates internally and with clients.

Designs, builds, and optimizes Azure and Microsoft Fabric data platforms, including lakehouses, warehouses, dimensional models, ETL/ELT pipelines, semantic models, and AI-ready data products. Develops RAG and LLM solutions with embeddings, retrieval, evaluation, and responsible AI controls. Establishes governance, security, data quality, observability, CI/CD, and Infrastructure as Code practices while optimizing performance and cost. Provides technical leadership, architecture guidance, mentoring, documentation, and cross-functional collaboration.

Owns the reliability, security, performance, availability, backup, recovery, and lifecycle management of enterprise Microsoft SQL Server environments. Responsibilities include troubleshooting, tuning, patching, upgrades, high availability, disaster recovery, security administration, automation, incident leadership, migrations, BI workload support, documentation, and mentoring. The role partners with developers and data engineers on schema design, query optimization, releases, and modernization initiatives including Azure SQL adoption.

Ensure accuracy and compliance of campaign setup and documentation across multiple clients by auditing campaign materials, verifying budgets, creative flighting, traffic instructions, and media buy details. Document audit results, escalate discrepancies, produce error reports, and collaborate with account teams and operations to implement process improvements and pilot automation/AI tools.

Produce high‑end photographic retouching and post‑production work—skin and makeup correction, object replacement, background removal, color correction, silhouetting, masking, and file prep for print and web—collaborating with Art Directors and the Imaging team to deliver multiple projects on tight deadlines while maintaining organized workflows and quality standards.

Design, build and maintain globally-consistent Power BI reports and dashboards. Translate business needs into semantic models and visuals, optimise performance (DAX, Power Query, models), manage deployment pipelines, troubleshoot data issues, support stakeholders with training and documentation, and ensure data quality for finance, operations and senior leadership.

Prepare and finalize print and digital creative assets ensuring brand consistency, correct technical specifications, and quality control. Adapt assets for various platforms, manage digital asset libraries, collaborate with creative teams, and perform image retouching and color correction as needed.

Build, test, and deploy HTML5 banners, responsive email templates, and interactive presentations for digital campaigns. Perform QA, optimization, cross-client/browser troubleshooting, and implement tracking/click-tags. Collaborate with designers, account teams, and production stakeholders to deliver pixel-accurate, performance-optimized assets on deadline.

Lead end-to-end reporting requirements, data definitions, integrations, and data models for global finance and operational reports. Bridge stakeholders, source systems, and Power BI team to ensure consistent KPIs, data quality, and single source of truth while defining integration specs, reconciliation rules, and governance.

Develop and execute design concepts across packaging, brand, corporate identity, mobile, digital and UX. Produce digital, print and environmental graphics, icons/illustrations, social assets, presentation templates, and maintain client brand guidelines while collaborating with design leads and teams.

Execute and produce visual creative across print, digital, motion and presentation channels within brand guidelines. Build layouts, retouch, prepare files for production, collaborate with art directors, train freelancers, and manage project deadlines and file hygiene.

Reviews and improves editorial and design materials across print and digital media to ensure spelling, grammar, punctuation, data accuracy, brand guideline compliance, correct trademark/logo usage, and consistent layout. Follows departmental SOPs, addresses client/legal/compliance annotations, and provides feedback on advertising and promotional projects.

Prepare and refine creative materials for print, web, presentations and digital. Produce composite artwork, correct and QA layouts, create print-ready and interactive PDF files, manage file organization and prepress steps, support brand consistency, and prepare presentation materials while meeting deadlines and agency guidelines.

Client-facing business analyst who gathers and documents requirements, performs process and impact analysis, maps as-is workflows, ensures data handling best practices, supports API integrations and data warehousing, and conducts QA and audits for marketing and campaign initiatives.

Lead end-to-end digital production projects: review requirements, plan and estimate, allocate resources, oversee development and QA, manage risks and stakeholder communications, validate feasibility, mentor project managers, improve processes and metrics, and assist with interviews when needed.

Execute and produce visual layouts and campaign assets across print, digital, motion, and presentation channels within brand guidelines. Translate concepts into production-ready designs, manage file standards, and assist in training and mentoring while meeting deadlines and agency processes.

Coordinate and prepare regulatory submission packages across client platforms (Veeva, Zinc, MAP). Serve as internal expert and QA gatekeeper for submission requirements, maintain process binders and calendars, perform QC checks (OPDP), and support project teams and junior specialists.

Develop, test, and maintain Drupal sites: build custom modules and themes, update existing sites, troubleshoot issues, integrate APIs, and ensure cross-browser/device compatibility using PHP, Twig, JS, and related tooling.