Analytics Engineer

Salary

For this position, the salary range is $104,000 to $110,000.

NRDC is a non-profit environmental advocacy organization. We use law, science, and the support of 3.1 million members and online activists to protect the planet's wildlife and wild places and to ensure the rights of all people to clean air, clean water, and healthy communities. NRDC was founded in 1970 and our people helped write some of America's bedrock environmental laws, including the Clean Water Act and many of the implementing regulations. Today, our team of more than 700 lawyers, scientists, economists, policy advocates, communications experts, and others work across the United States and the globe from our offices in Beijing; Bozeman, Montana; Chicago; New Delhi; New York; San Francisco; Santa Monica; and Washington, D.C.

NRDC is seeking an Analytics Engineer to work with the Operations team in our New York, Washington, D.C., San Francisco, Chicago, Santa Monica, or Bozeman office.‍

Position Summary

We are seeking an experienced Analytics Engineer to join the Data Infrastructure team at NRDC. Blending the roles of a Data Engineer and a Data Analyst, you will work on building a strong foundation in our modern data stack by ingesting data from various sources; writing complex SQL queries to perform data transformations using dbt; building reports and dashboards in Tableau on top of a performant data layer in our data warehouse, Snowflake; and updating or moving data into our CRM and email marketing automation platform using a reverse ETL tool. Your work will contribute to NRDC’s mission to safeguard the earth — its people, its plants and animals, and the natural systems on which all life depends.

We are looking for someone who is passionate about data and democratizing it for our internal stakeholders as well as think strategically about data infrastructure. One of your key internal clients will be the Development department of NRDC, which is responsible for all revenue generation for the organization. During the first 12 months, and ongoing as projects arise, you will be working closely with Development to build out on their reporting and analytics needs. This position reports to the Senior Director of the Data Infrastructure team in NRDC’s Information Technology Department.

Responsibilities

Design and build data pipelines to ingest data from numerous and varied sources into our data warehouse, Snowflake.
Build dbt data models from raw data sets into curated and reusable data sets in Snowflake to be used for analytics and visualizations.
Load data from Snowflake to our business applications (CRM, email marketing automation platform, and others) using a reverse ETL tool.
Using Tableau and other tools, build reports and design visualizations that convey meaningful stories and provide insights to facilitate fundraising strategies, scientific studies and policies that support the environment, and more.
Ensure all data pipeline and visualization work such as design implementation, whether managed internally or by a service provider, follows established standards, processes, application guidelines, and technical architecture.
Apply software engineering best practices such as version control and CI/CD on your analytics code in collaboration with your Analytics Engineer teammate.
Monitor existing pipelines, correct issues, and communicate unexpected delays with users.
Write and maintain robust documentation of all data processes, dbt models, and workflows.
Provide a timely response to any internal cases and user requests on analytics, Tableau, and other data projects.
Keep abreast of advancements and developments in the realm of the modern data stack as well as new Tableau updates, with a strong desire to continuously improve one’s own professional knowledge.
Work closely with and provide support as needed to other members of the Data Infrastructure team; comfortable working in a small, collaborative team environment and independently as needed.
Take initiative to address issues, as well as maintain and improve the entire data stack.
Commitment to NRDC’s.

Qualifications

4-7 years of experience working as an analytics engineer, data engineer, data analyst, or a similar data role.
Extensive and deep SQL knowledge; ability to write complex and performant SQL scripts and queries.
Experienced in using dbt to create data models.
3+ years of hands-on experience in using visualization tools such as Tableau to design reports and dashboards.
Familiarity in leveraging version control tools such as Git (GitHub).
Extensive hands-on experience in parts of our data stack (Snowflake, Fivetran, and Tableau).
Demonstrated experience in maintaining a data warehouse and handling large data sets in both relational and non-relational databases.
Excellent business communication skills; ability to provide instruction to audiences of varying technical abilities.
Strong interpersonal and organizational skills.
Commitment to NRDC’s values and mission.

Preferred

Familiarity with Python and Jupyter Notebook a plus.
Experience working with data from Salesforce and Salesforce Marketing Cloud desired.
Experience with reverse ETL tools such as Census desired.
Working experience in leveraging Agile methodologies is a plus.

‌