Data Engineer Specialist
Job Description
- Experience in at least one programming language (i.e. Python, Java, Scala, C#, etc.).
- Experience in data integration projects and automation via ETL Tools (i.e. Talend, Informatica, SSIS, etc.).
- Experience in Amazon Redshift is a plus.
- Experience with marketing data (Google Double-Click, Site Analytics, Paid Search, etc.) is also a plus.
- Deliver quality work on defined tasks with little oversight and direction.
- Ensure all deliverables are of high quality by adhering to coding standards and best practices and participating in code reviews.
- Participate in integrated test sessions of components and subsystems on test and production servers.
- Serve as technical resource during software development life cycle to solve business issues through identifying and analyzing detailed requirements.
- Solve business issues through the process of identifying and analyzing detailed requirements that translate business requirements into technical system designs.
- Use information gained through prior experience, knowledge sharing, education and training to resolve issues and remove project barriers.
- Provide status updates to team members on a regular basis and clearly escalate issues and risks to project management as needed.
- Responsible for the maintenance, improvement, cleaning, and manipulation of data in the business’s operational and analytics databases.
- Works with the business’s data analytics teams, data scientists, and software engineers in order to understand and aid in the implementation of database requirements.
- Analyze performance, and troubleshoot any issues related to databases.
- Defines and builds the data pipelines that will enable faster, better, data-informed decision-making within the business.
- BS in Computer Science or equivalent education/professional experience is required.
- 5+ years in a data engineering role with demonstrable experience with data integration and data warehouse projects.
- Experience designing and building data warehouses, customer profile databases, data marts, etc.
- Experience with data modeling, warehouse design, and fact/dimension concepts.
- Experience working with different query languages (i.e. T-SQL, PostgreSQL, PL-SQL).
- Understanding and experience working with cloud platform services: Redshift, Aurora, Data Factory, SQL DW, Azure Datawarehouse, Data Lake, BigQuery, etc.
- Experience working with code repositories and continuous integration (i.e. Git, Jenkins, etc.).
- Understanding of development and project methodologies.
- Ability to work collaboratively in teams with other specialized individuals.
- Able to work in a fast-paced, technical environment.
- Good verbal and written communication skills.
- English B2 proficiency.
Company description
Publicis Global Delivery (PGD); Publicis Groupe’s industry leading globally connected capability platform. Where talent, technology & operations combine to delivery amazing solutions for our clients. Expertise across Media, Data, Technology, Commerce & Production in all regions of the world.
PGD is comprised of the best talent, and ways-of-working, which enables global scale, innovation and transformation, each day.
Culture, growth and wellbeing underline all aspects of Publicis Global Delivery.
#WeArePGD
Overview
Deliver quality work on defined tasks with little oversight and direction.
Ensure all deliverables are of high quality throughout the project by adhering to coding standards and best practices and participating in code reviews.
Participate in integrated test sessions of components and subsystems on test and production servers.
Serve as technical resource during software development life cycle to solve business issues through the process of identifying and analyzing detailed requirements that translate into data integration and database system designs.
Solve business issues through the process of identifying and analyzing detailed requirements that translate business requirements into technical system designs.
Use information gained through prior experience, knowledge sharing with other Technology Associates, education and training to resolve issues and remove project barriers
Provide status updates to team members on a regular basis and clearly escalate issues and risks to project management as needed.
Responsibilities
Responsible for the maintenance, improvement, cleaning, and manipulation of data in the business’s operational and analytics databases. Works with the business’s data analytics teams, data scientists, and software engineers in order to understand and aid in the implementation of database requirements, analyze performance, and troubleshoot any issues. Defines and builds the data pipelines that will enable faster, better, data-informed decision-making within the business.
Qualifications
- BS in Computer Science or equivalent education/professional experience is required.
- 5+ years in a data engineering role with demonstrable experience with data integration and data warehouse projects.
- Experience designing and building data warehouses, customer profile databases, data marts, etc.
- Experience with data modeling, warehouse design, and fact/dimension concepts.
- Experience working with different query languages (i.e. T-SQL, PostgreSQL, PL-SQL).
- Prefer some experience in at least one programming language (i.e. Python, Java, Scala, C#, etc.).
- Prefer some experience in data integration projects and automation via ETL Tools (i.e. Talend, Informatica, SSIS, etc.)
- Experience in Amazon Redshift is a plus.
- Experience with marketing data (Google Double-Click, Site Analytics, Paid Search, etc.) is also a plus.
- Understanding and experience working with cloud platform services: Redshift, Aurora, Data Factory, SQL DW, Azure Datawarehouse, Data Lake, BigQuery, etc.
- Experience working with code repositories and continuous integration (i.e. Git, Jenkins, etc.)
- Understanding of development and project methodologies.
- Ability to work collaboratively in teams with other specialized individuals.
- Able to work in a fast-paced, technical environment.
- Good verbal and written communication skills.
- English B2
