Job Description

Description

Overview 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 SummaryWe 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 values and mission. 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. NRDC is committed to advancing diversity, equity, and inclusion, both in our work and in our workplace. We believe that celebrating and actively welcoming diverse voices and perspectives is essential to solving the planet's most pressing environmental problems, and we encourage applications from candidates whose identities have been historically under-represented in the environmental movement. We are an equal opportunity employer and do not discriminate in hiring or employment on the basis of race, color, religion, gender, gender identity or expression, marital status, sexual orientation, national origin, citizenship, age, disability, veteran status, or any other characteristic protected by federal, state, or local law. Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records. We offer competitive salaries, excellent benefits, and a supportive working environment. Salary is based on a nonprofit scale and is commensurate with skills and experience. Internal equity will be reviewed and considered to determine a final offer. For this position, the salary range is $104,000 to $110,000. Our offices are open and we are operating in a hybrid model. We offer NRDCers flexibility, and we ask them to come into the office and spend meaningful time there in collaboration with their colleagues. We call this purposeful presence. As a science-based organization, NRDC aims to do our part to help contain the COVID-19 public health crisis. For the sake of health, safety, and equity, we ask that people be vaccinated unless they have an approved medical or religious accommodation or other exemption in accordance with state and local law. We consider a person to be vaccinated two weeks after receiving one full course of a CDC-approved vaccine. In accordance with state or local law, new hires will be asked to attest to vaccination, those wishing to do so may request medical or religious accommodations or other exemptions via NRDC Employee Relations. NRDC treats all vaccine-related data confidentially, in keeping with local, state, and federal laws. To apply, visit www.nrdc.org/careers and upload your résumé and cover letter. Please mention where you saw this posting and upload any additional materials that showcase your abilities. Due to the high volume of applications, we will contact only those candidates we would like to interview. Please no phone calls, emails, or in-person résumé drop-offs. If you experience technical problems while applying or if you are a person with a disability and need assistance applying online, please reach out to iCIMS Customer Care at 1-800-889-4422. For more about NRDC, visit www.nrdc.org.