Data Engineer (Marketing)

Company:
Location: Newport News, VA

*** Mention DataYoshi when applying ***

Job Description:

Come and join Ferguson’s truly talented Marketing Intelligence Team where we are dedicated to facilitating data driven marketing to support omni-channel experiences for our customers.


Ferguson is a $19+ billion market leader. We realize that our greatest assets are our best-in-class associates, which is why we're dedicated to offering limitless opportunities for growth and advancement. We want to help you build a long-lasting career with Ferguson, so we can continue to lead the industry and help build our nation's infrastructure from the ground up. Join our team today.

Ferguson is currently seeking a standout junior level Data Engineer to work within the Data Governance and Orchestration Team in the Marketing Department. The Data Engineer will provide end-to-end assistance with data pipeline from Azure to our Marketing Cloud Technologies while supporting and optimizing the Marketing Data Architecture construct. This includes ETL, designing & building data models, data validation, and managing uptime. You will work closely alongside teams within our Marketing and IT departments to best align support for Marketing Technology data requirements.

Responsibilities:

  • Design and build data models using SQL

  • Maintain, modify, and build upon the current Marketing Database and Data Architecture in Azure

  • Identify, design, and implement internal process improvements: increase data integrity, automating manual processes and optimizing data delivery

  • Manage data refresh processes and uptime

  • Translate Marketing requirements into structured data flows

  • Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL, Python, Altreyx, Power BI, etc.

  • Build automated Processes using scripting tools

  • Perform extensive data validation

  • Communicate effectively with Marketing colleagues and business stakeholders

  • Ensure compliance with data privacy laws

Qualifications:

  • Proven experience building and validating data models

  • Self-motivated, team player, take initiative, quick learner, systematic, adaptable, etc.

  • Strong SQL skills required for building tables, views, and implementing complex logic

  • Ability to learn and use database software (SQL)

  • Outstanding organizational skills

  • Solid problem solving, numerical fluency, and analytical skills

  • Experience facilitating data flow within Cloud Marketing Technologies

  • Familiar with Marketing applications such as Saleforce, Oracle Marketing Cloud, Adobe Marketing Cloud, Marketo, etc.

  • BA or BS degree in Business, Marketing, Applied Math, Statistics, Computer Science or related field

  • Experience with Power BI / Tableau, Power Pivot, SAP, SAP Analysis for Office, BPC, Bex Query Designer.

  • Experience in analyzing data within relational database systems such as MS Access, MS SQL Server, and MySQL.

  • Experience with ETL Tools such as Alteryx, Paxata, DataGuru or equivalent technologies, preferred.

  • Experience with Data analysis in Python using Pandas/Numpy/Jupyter Notebooks, preferred.

  • Ability to quickly learn new technology and business logic.

  • Superior analytical and problem-solving skills with superb attention to detail.

  • Strong written and verbal communication skills.

  • Ability to work independently in a fast-paced and rapidly changing and ambiguous environment.

  • Ability to work well with others in fast paced, dynamic environment.

  • Ability to be respectful, approachable and team oriented while building strong working relationships and a positive work environment.

  • Collaborate in an agile manner with various teams such as email marketing, analytics, IT, etc for successful execution.

The Company is an equal opportunity employer as well as a government contractor that shall abide by the requirements of 41 CFR 60-300.5(a), which prohibits discrimination against qualified protected Veterans and the requirements of 41 CFR 60-741.5(A), which prohibits discrimination against qualified individuals on the basis of disability.

*** Mention DataYoshi when applying ***

Offers you may like...

  • inovex GmbH

    Data Engineer / Machine Learning Engineer*
    Home Office
  • XOi Technologies

    Data Engineer (Analytics)
    Nashville, TN
  • Cepheid

    Sr Data Engineer
    New York, NY 10001
  • Pacific Biosciences

    Engineer II, Software Data Engineer
    Remote
  • Health Catalyst

    Data Engineer (Life Sciences)
    Remote