Data Engineering Analyst

Caring. Connecting. Growing together.

Primary Responsibilities

• Data Ingestion: Develop, maintain, and optimize data ingestion pipelines from various sources including Adobe 1.4 and 2.0 APIs, NAS file drives, SQL servers, and Adobe datasets
• Workflow Orchestration: Design and manage data workflows using Airflow to ensure reliable data movement, transformation, and scheduling
• Database Development: Build and enhance data models in Snowflake using DBT (Data Build Tool) as well as Cosmos database development
• Business Intelligence: Create, maintain, and improve Power BI dashboards to deliver actionable business insights
• Pipeline Management: Monitor, troubleshoot, and optimize end-to-end data pipelines to ensure high availability and accuracy of data delivery
• Comply with the terms and conditions of the employment contract, company policies and procedures, and any and all directives (such as, but not limited to, transfer and/or re-assignment to different work locations, change in teams and/or work shifts, policies in regards to flexibility of work benefits and/or work environment, alternative work arrangements, and other decisions that may arise due to the changing business environment). The Company may adopt, vary or rescind these policies and directives in its absolute discretion and without any limitation (implied or otherwise) on its ability to do so
  

Required Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related technical field (or equivalent experience)
• 2+ years of hands-on experience in data engineering or analytics roles
• Hands-on experience with Snowflake and DBT for data transformation and modeling (exposure to Cosmos DB a plus)
• Solid experience with Apache Airflow for workflow orchestration and scheduling
• Expertise in building and maintaining ETL/ELT pipelines from diverse data sources
• Advanced SQL skills for querying, data manipulation, and database management
• Skilled in developing, managing, and optimizing dashboards using Power BI
• Skills in Python, Airflow, DBT, GitHub, ETL, Power BI, SQL, Adobe AEP/CJO
• Proficient in Python for data engineering, automation, and scripting tasks
• Proficient in version control and code management using GitHub
  

Preferred Qualification

• Familiarity or experience with Adobe AEP/CJO (Adobe Experience Platform / Customer Journey Analytics)