• Job Description

  Req#: R1096137

  Job Description:

  Key Responsibilities

  • You will own end-to-end technical architecture and delivery of data engineering solutions

  • You'll design and implement scalable ETL architectures and data pipelines

  • You'll develop and optimize SQL procedures and ETL processes for batch and real-time data processing

  • You will lead a team of data engineers in a matrix organization

  • Provide mentoring in ETL best practices and data engineering methodologies

  • Estimate work effort and assist Project Managers with task planning and resource allocation

  • Collaborate directly with clients on technical requirements and solution design

  • Perform data modeling and schema design for efficient data processing

  • Create robust API integrations for real-time data ingestion from various sources

  • Review code and engineering solutions for performance, scalability, and compliance with standards

  • You'll create comprehensive technical documentation for data pipelines and integrations

  Outcomes

  The successful Senior Data Integration Engineer will:

  • Deliver sophisticated data integration solutions on time and within budget

  • Build efficient real-time and batch data processing pipelines

  • Design and implement API-based integration solutions

  • Effectively delegate tasks to development resources both onshore and offshore

  • Develop and mentor data engineers across the organization

  • Strengthen client relationships through high-quality technical solutions

  • Master core data engineering platforms and technologies

  Relationships

  This position regularly collaborates with cross-functional teams including Quality Assurance, Campaign Management, Business Intelligence, Information Technology, and Project Management to develop and maintain robust data engineering solutions.

  Key Skills / Experience

  • Experience with cloud data platforms (AWS, GCP, Azure) and big data technologies

  • 4+ years of experience with ETL tools (Talend, Informatica, SSIS, or DataStage)

  • 4+ years of experience with database technologies (SQL Server, Oracle, or other major RDBMS)

  • 2+ years of experience leading data engineering teams

  • Advanced knowledge of ETL architecture, processes, and best practices

  • Experience designing and implementing large-scale data warehouses with both relational and dimensional modeling

  • Expert-level SQL and database programming skills

  • Strong experience designing and implementing real-time data ingestion systems using APIs

  • Proven track record building RESTful and streaming API integrations

  • Proficiency with file transfer protocols and security mechanisms (sFTP, PGP Encryption)

  • Experience with automation, workflow orchestration, and scheduling tools

  • Strong knowledge of software engineering practices including version control (Git, SVN), issue tracking (Jira), and SDLC methodologies

  • Scripting/programming skills in Python, Java, Bash, or Perl

  Preferred Skills

  • Experience with cloud Data Warehouses (Snowflake, BigQuery, Synapse, Redshift, etc)

  • Experience with Customer Data Platforms or Master Data Management systems

  • Expertise with cloud-native ETL services (AWS Glue, Azure Data Factory, GCP Dataflow)

  • Experience with streaming data technologies (Kafka, Kinesis)

  • Experience with real-time data processing frameworks (Spark Streaming, Flink)

  • Experience with data marketing platforms and campaign management systems

  • Knowledge of BI visualization tools (Tableau, Power BI)

  • Technical consulting experience

  This position is 100% remote and will be reporting to the VP, Data Engineering Lead

  The annual salary range for this position is $94,000 - $152,375. Placement within the salary range is based on a variety of factors, including relevant experience, knowledge, skills, and other factors permitted by law.

  Benefits available with this position include:

  • Medical, vision, and dental insurance,

  • Life insurance,

  • Short-term and long-term disability insurance,

  • 401k,

  • Flexible paid time off,

  • At least 15 paid holidays per year,

  • Paid sick and safe leave, and

  • Paid parental leave.

  Dentsu also complies with applicable state and local laws regarding employee leave benefits, including, but not limited to providing time off pursuant to the Colorado Healthy Families and Workplaces Act, in accordance with its plans and policies. For further details regarding Dentsu benefits, please visit www.dentsubenefitsplus.com.

  #LI-Remote #LI-JH2

  Location:

  USA - Remote - Maryland

  Brand:

  Merkle

  Time Type:

  Full time

  Contract Type:

  Permanent

  Dentsu is committed to providing equal employment opportunities to all applicants and employees. We do this without regard to race, color , national origin, sex , sexual orientation, gender identity, age, pregnancy, childbirth or related medical conditions, ancestry, physical or mental disability, marital status, political affiliation, religious practices and observances, citizenship status, genetic information, veteran status, or any other basis protected under applicable federal, state, or local law.

  Dentsu is committed to providing reasonable accommodation to, among others, individuals with disabilities and disabled veterans. If you need an accommodation because of a disability to search and apply for a career opportunity with us, please send an e-mail to ApplicantAccommodations@dentsu.com by clicking on the link to let us know the nature of your accommodation request and your contact information. We are here to support you.

• About the company

  Dentsu Aegis Network Ltd. is a multinational media and digital marketing communications company headquartered in London, United Kingdom, and a wholly owned subsidiary of the Japanese advertising and public relations firm Dentsu.

Notice