Data Engineer (Remote)

The Opportunity

We are looking for a data engineer with a strong background in building and maintaining data pipelines to integrate and process diverse data sources and data formats. This role will join our technology team and will work with a group of highly motivated and talented individuals that collaborate across NRG to positively impact our clients. If you are excited to make an impact through innovation and collaboration and come to work with a passion to facilitate in delivering high quality data to our teams and clients, this is a great role for you.

Your Impact

• Build, test and maintain data pipelines that support the data sciences team and customer-facing client teams.
• Track and manage pipeline efficiency and stability.
• Evaluate, parse, clean, and integrate raw data sets including third party APIs. Help build sophisticated ETL processes around first party data such as survey data, second and third-party data sources such as IP addresses, clickstream data, movie meta data.
• Provide recommendations for data storage, configurations, data access tools and new technologies/architectures.
• Develop code-based data transformation/aggregation in data warehouses, relational databases, and possibly non-relational databases, as well as for the purpose of integration with BI tools such as Tableau.
• Participate in developing data APIs for data ingestion of NRG data into client-side applications or client-side data systems.
• Assist application developers in the effective use of database query and programming languages.
• Facilitate and collaborate with external third party vendors in data engineering and data architecture projects
• Contribute to managing data integrity, data storage efficiency and data ecosystem efficiency.

Who We’re Looking For

• You are a team player who is able to work collaboratively and initiate and drive projects to completion with minimal oversight.
• You are a team asset who can describe data structures, relationships, and flows behind organization database servers and applications.
• You are a key individual that the technology team looks to for advice related to data organization and planning.
• You are an innovator, up to date on the latest data-related best practices and technologies, and always looking to learn more.
• You are an internally motivated self-starter who continuously strives to get things done, regardless of any challenges encountered.
• Able to understand and respond to complex questions or issues that may arise, and able to demonstrate willingness to experiment with new technologies.
• You are detail oriented, with an eye on validation of pipelines and data accuracy.

Required Technical Qualifications

• 3+ year of experience in Snowflake
• 3+ years of experience with dbt
• 3+ years of experience in building data pipelines or ETL
• 3+ years of experience in cloud technologies/infrastructure (GCP or AWS).
• 3+ years of experience in SQL and database technologies.

Desired Technical Qualifications

• Experience using git/Github or other version control tools.
• Experience with Dagster or other orchestration tools.
• A solid foundation with end-to-end development and the desire to further their technical knowledge.
• Working knowledge of Python.
• Knowledge of PII (personally identifiable information) data security standards
• Experience in Terraform.

Experience in databases structured against survey data.