P

Publicis Groupe

Runs advertising and digital transformation services

Senior Data Engineering Analyst

Data EngineeringConfirmed live in the last 24 hours
Full-timeBirmingham, MI, USA$72.4k - $95.2k /yrIn-person

About the Job

Requirements

  • A BS in Computer Science or equivalent education or professional experience is required.
  • Experience in a database administrator or developer role, preferably in a professional services environment.
  • Experience working with or general knowledge of relational database management systems such as DB2, Oracle, MySQL, and SQL Server.
  • Experience working with or general knowledge of Big Data or NoSQL database systems such as DynamoDB, MongoDB, Redshift, BigQuery, and Azure is a plus.
  • Understanding of cloud infrastructure services such as Amazon Web Services and Google Cloud Platform is a plus.
  • Experience with data modeling and normalization concepts.
  • Experience or knowledge of query languages such as PL/SQL and T-SQL.
  • Knowledge and experience with ETL toolsets such as SSIS and Talend.
  • Knowledge and experience writing ETL processes.
  • Understanding of application programming and interactions with database technologies.
  • Ability to estimate level of effort for tasks.
  • Ability to learn new languages, tools, and techniques as needed to meet project requirements.
  • Ability to work collaboratively with others in a fast-paced, technical environment.
  • Good verbal and written communication skills.
  • Attention to detail and quality.
  • Problem-solving skills.

Responsibilities

  • Deliver quality work on defined tasks with infrequent oversight and on undefined tasks with frequent oversight from a senior-level data engineer.
  • Implement and maintain relational and columnar databases such as BigQuery, Redshift, and Azure, including database clustering and partitioning.
  • Implement tables, indexes, stored procedures, and functions, and provide ad hoc query support.
  • Implement data-related activities such as standardized automated ETL processes, reports, dashboards, and models.
  • Provide regular status updates to team members and clearly escalate issues and risks to project management as needed.
  • Serve as a technical resource during the software development life cycle by identifying and analyzing detailed requirements and translating them into system designs to solve business issues.
  • Estimate own work when provided with sufficient task definition.
  • Apply best practices daily to ensure quality deliverables.
  • Troubleshoot, diagnose, and respond quickly to database and application issues to minimize service disruption, escalating to third-party vendors for support as needed.
  • Monitor and report database performance and capacity proactively and provide trend analysis for all environments.
  • Understand Razorfish data capabilities and how data fits into a client's overall strategy.
  • Understand the breadth of data services and crafts.
  • Manage data team responsibilities within cross-capability projects.
  • Use SQL and understand Python coding best practices.
  • Architect data structures.
  • Understand cloud platforms including AWS, GCP, and Azure.
  • Mentor Associate Data Engineers.

Desired Qualifications

  • Experience in a database administrator or developer role in a professional services environment is preferred.
  • Experience working with or general knowledge of Big Data or NoSQL database systems such as DynamoDB, MongoDB, Redshift, BigQuery, and Azure is a plus.
  • Understanding of cloud infrastructure services such as Amazon Web Services and Google Cloud Platform is a plus.

About the Company

Publicis Groupe

Runs advertising and digital transformation services

Publicis Groupe runs advertising, media buying and digital transformation services for companies that want to reach consumers, coordinate campaigns and improve their business systems. Its agency network includes creative and media specialists, while Publicis Sapient builds and modernizes the technology behind clients' operations. Epsilon adds customer data and marketing technology that connect brands with audiences and measure campaign results. Clients pay for consulting, campaign creation and execution, with production and media costs billed through alongside the group's service work. Founded in 1926, Publicis Groupe is headquartered in Paris, France.

Company size
10,001+
Company stage
IPO
Headquarters
Paris, France
Founded
1926

Recently Posted Jobs

Explore more opportunities at Publicis Groupe

See more jobs