GCP Data Architect

Egen is a fast-growing and entrepreneurial company with a data-first mindset. We bring together the best engineering talent working with the most advanced technology platforms, including Google Cloud and Salesforce, to help clients drive action and impact through data and insights. We are committed to being a place where the best people choose to work so they can apply their engineering and technology expertise to envision what is next for how data and platforms can change the world for the better. We are dedicated to learning, thrive on solving tough problems, and continually innovate to achieve fast, effective results.

Responsibilities:

• Design, architect, develop, and support GCP data pipelines to extract, load, and transform data
• Maintain a holistic view of information assets by creating and maintaining artifacts that illustrate how information is stored, processed, and supported (i.e. documentation)
• Work with the project team, estimate and plan the work effort
• Attend daily team standups
• Work with business analysts and project management to review business requirements and and produce technical design specs that will meet the requirements

What we're looking for:

• 5+ years of experience as a Data Engineer/Data Architect
• Proficient with GCP tools Google Cloud Storage (GCS), BigQuery, and Cloud Composer/Airflow
• Proficient developing Python ELT data pipelines
• Proficient writing optimized GCP BigQuery SQL data translation queries and scripts
• Advanced SQL skills, including the ability to write, tune, and interpret SQL queries
• Experience writing and maintaining Unix/Linux scripts
• CI/CD
• Experience with DBT