UPS Capital Data Engineer

Key Skills

Java Programming, Python Programming, SQL, Azure, PowerBI, Apache Hadoop, NoSQL, Tableau, Apache Hive, R Programming, Sqoop, Database testing, Artifactory, Apache Oozie, Data Lake, ETL frameworks

Job Description

The Data Engineer is responsible for the continued development and optimization of the company’s Data Lake and/or Customer Data Platform (CDP) to support data driven decision making within Marketing. The incumbent leads the collection, cleaning, and transformation of data from multiple channels into the Data Lake and/or Customer Data Platform in support of the segmentation, analytics, reporting, and activation needs of marketers. This position is responsible for cultivating new data sources and synthesizing them into the current data lake, enhancing the identity graph as they relate this data.

The Data Engineer is responsible for bringing the strategy and roadmap to life through data engineering and data activation processes, and oversees the delivery of high quality data to marketing stakeholders and data scientists. This role interacts regularly with IT on development of new ETL (Extract, Transform, and Load) jobs, maintenance, and troubleshooting. The Data Engineer also provides key input in support of the overall marketing data architecture and ensures that quality performance data is captured, tools are developed to support performance reporting/audience insights mining.

Responsibilities

• Designs and develops ETL processes within CDP in support of the segmentation, analytics, and reporting needs of the business
• Develops processes to clean and transform data into the processed data store within the CDP and build aggregated views in the analytical data store in support of reporting and business intelligence needs of Marketing stakeholders
• Supports the Data Engineering Manager in creating reporting and data visualization dashboards
• Develops automated quality assurance processes to monitor quality of inbound data and ensure the continued accuracy of data processing within the platform
• Plays a significant role as a contributor to projects involving marketing stakeholders, software vendors, IT, and data owners to specify and execute new data feeds into the CDP and/or Data Lake from internal repositories and marketing applications (web analytics, data warehouse, etc.)
• Develops and manages data processing jobs to assign customers to marketing segments in the CDP using demographic data, behavioral data, and intent signals and works with data scientists to incorporate machine learning outcomes into the overall customer segmentation model

Preferences

• Possesses strong coding skills in SQL, Spark, R and Python
• Demonstrates technical knowledge of Hadoop and Spark ecosystem, including Hive, Sqoop, and Oozie 
• Possesses strong knowledge of data modeling principles and best practices in building analytics repositories in SQL and NoSQL environments
• Experience with cloud computing in the Azure environment with Databricks and Data Factory, or similar technologies
• Diagnoses and troubleshoots complex data quality issues
• Translates marketing stakeholder requirements into technical specifications and is familiar with documentation skills, and is organized 
• Experience building and managing data pipelines and repositories in cloud environments such as Microsoft Azure
• Experience in dashboard development (Power BI, Tableau)
• Experience with Intermediate Operating System Fundamentals, Agile Development, Database Administration, Data Security and Data Analytics
• Bachelor's degree (or internationally comparable) in Computer Science or related field/experience

UPS is an equal opportunity employer. UPS does not discriminate on the basis of race/color/religion/sex/national origin/veteran/disability/age/sexual orientation/gender identity or any other characteristic protected by law