Senior Data Engineer- P3

We're looking for a talented Senior Data Engineer to join our team. The team is involved in various activities ranging from data acquisition and validation, designing and implementing ETL / ELT data pipelines, designing and implementing databases, and evolving our next-generation data platform to fulfill the needs of our applications, data services, ad-hoc analytics, and self-service / POC initiatives.

If you're ready to take on new challenges and drive innovation in the world of data engineering, we'd love to hear from you.

Responsibilities :

• The Data Engineering team is looking to fill a Senior Data Engineer responsible for designing and implementing ETL / ELT data pipelines, designing and implementing database schema / tables / views, and building batch processes leveraging Airflow for several projects.
• This Senior Data Engineer will be responsible for partnering with our team members in various activities around data requirements gathering, data validation scripting and review, developing and monitoring ETL / ELT data pipelines, designing and implementing database schema / tables / views, plus deployment across multiple environments such as DEV, QA / UAT and PROD.
• The role will leverage a multitude of technologies to fulfill the work including, but not limited to SQL, Python, Docker, Gitlab, Airflow, Snowflake, Looker, and PostgreSQL.

Basic Qualifications :

• 3+ years experience with Python.
• 4+ years experience with SQL.
• 3+ years of experience designing, building, and maintaining ETL / ELT data pipelines.
• 2+ years experience with cloud-based technologies, preferably AWS and S3.
• Experience using Apache Airflow, and Databricks.
• 2+ years leveraging, designing, and building relational databases.
• 2+ years of experience using Gitlab / Github.

Preferred Qualifications :

• Experience with Snowflake, Airflow, Gitlab, and Tableau.
• Experience in streaming, media, or digital marketing domain.
• 3+ years experience in a Data Engineering role.
• SQL, Python, Snowflake, Gitlab, Airflow, AWS S3 and Relational Databases.
• 2+ years experience working on a cloud platform.
• 2+ years of experience working with data lakes, data warehouses, and application databases.
• Experience working with large datasets and big data technologies, preferably cloud-based, such as Snowflake, Databricks, or similar.
• Experience with SQL Query optimization based on runtime and cost.
• Participate in driving best practices around data engineering software development processes.

Required Education :

• Bachelor's degree in Computer Science and mathematics.
Benefits :
• 401(k).
• 401(k).
• Dental Insurance.
• Health insurance.
• Vision insurance.
• We are an equal opportunity employer and value diversity, equality, inclusion, and respect for people.
• The salary will be determined based on several factors including, but not limited to, location, relevant education, qualifications, experience, technical skills, and business needs.

Additional Responsibilities :

• Participate in OrangePeople monthly team meetings, and participate in team-building efforts.
• Contribute to OrangePeople technical discussions, peer reviews, etc.
• Contribute content and collaborate via the OP-Wiki / Knowledge Base.
• Provide status reports to OP Account Management as requested.

About us :

OrangePeople is an Enterprise Architecture and Project Management solutions company. Our most valuable asset is our people : dynamic, creative thinkers, who are passionate about doing quality work.

As a member of the OrangePeople team, you will have access to industry-leading consulting practices, strategies & and technologies, innovative training & and education.

An ideal Orange Person is a technology leader with a proven track record of technical achievements and a strong process / methodology orientation.