Were 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 nextgeneration data platform to fulfill the needs of our applications data services adhoc analytics and selfservice/POC initiatives. If youre ready to take on new challenges and drive innovation in the world of data engineering wed 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 cloudbased 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 cloudbased 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:
- Bachelors degree in Computer Science and mathematics.
Benefits:
- 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 teambuilding efforts.
- Contribute to OrangePeople technical discussions peer reviews etc.
- Contribute content and collaborate via the OPWiki/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 industryleading 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.