job specification

Specialist - Software Engineering

Location: Costa Rica, Brazil, or Mexico (Remote)

Type: Contract

Education

• Bachelor's Degree in Computer Science or a related discipline

Experience

• 12-15 years overall experience
• 7-9 years of applicable engineering experience

Technical Skills

• GCP Big Query
• Python
• Airflow
• Composer
• Github
• CICD
• Familiarity with data warehousing concepts star schemas dimensional modeling
• OLTP vs OLAP
• Adobe

Key Responsibilities

• i. The migration and expansion of Adobe-based pipelines
• ii. Integration of Orion datasets into existing datasets
• iii. Creation of new pipelines for Orion Event collection
• iv. Proficiency in Python and SQL
• v. Familiarity with data warehousing concepts star schemas dimensional modeling OLTP vs OLAP
• vi. Design build and maintain ETL/ELT pipelines that move and transform data across hybrid environments AWS GCP Snowflake
• vii. Establish data quality checks validation logic and data reconciliation processes
• viii. Optimize pipeline runtime compute usage storage tiering and query costs especially in BigQuery
• ix. Create and maintain documentation for the data pipelines bui