Senior Data Engineer

The Nature Conservancy

Arlington (VA)

On-site

USD 80,000 - 126,000

Full time

3 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

The Senior Data Engineer at The Nature Conservancy develops analytics-oriented data models and ingestion pipelines spanning Fundraising, Conservation Effectiveness, Finance, and HR. The role combines design, implementation, and QA to deliver reliable data for decision-makers.

You will lead data integration efforts with Workday, CRM, and a centralized data lake, while ensuring governance and security. Collaboration with business partners is essential.

Qualifications

  • Bachelor's degree in computer science or related field with at least three years of programming and systems design experience or equivalent.
  • Three or more years of data engineering experience.
  • Five or more years of SQL experience, including window functions, subqueries, and multi-layer joins.
  • Three or more years of Python experience with data-focused packages (PySpark, Pandas, or similar).
  • Three or more years of fact/dimension modeling experience.
  • Three or more years in a data role with extensive interaction with non-technical business partners.

Responsibilities

  • Gather requirements for new data attributes with Analytics, Data Governance, and end users.
  • Create data pipelines to ingest data from Workday, CRM, and the conservation Hub into a shared data lake.
  • Design, build, and maintain datamarts across Fundraising, Conservation Effectiveness, Finance, and Human Resources.
  • Work with Data Governance to register data in master data management systems and catalogs.
  • Ensure access controls and masking for sensitive data.
  • Produce data structure documentation for technical and business audiences.
  • Provide production support as needed.
  • Lead projects or provide technical leadership with accurate plans and estimations.

Skills

SQL (window functions)
Python data packages
Data modeling
Data engineering
Non-technical collaboration

Education

Bachelor's degree in CS or related field

Tools

Databricks
Workday data
Profisee MDM
Microsoft Purview

Job description

YOUR POSITION WITH TNC

The Senior Data Engineer focuses on the development of analytics-oriented data models and data ingestion pipelines related to four potential data domains: Fundraising, Conservation Effectiveness, Finance, and Human Resources.

ESSENTIAL FUNCTIONS

The Senior Data Engineer plans, manages, and performs data engineering tasks within a focused set of data domains to provide quality data to those who need it for decision-making. They analyze and document end user and technology-user business requirements for data projects with wide range of complexity at varying levels of impact on organization-wide initiatives. They design and develop new, complex technology systems and solutions according to system requirements following TNC methodology and development best practices. The Senior Data Engineer acts as a lead technologist on technology application maintenance projects related to application upgrades, conversion and modifications. They perform tasks assigned as required to complete project including design, development, running specific programs, generating reports and analyzing results. They provide support for production problems as assigned. They also act as a final quality assurance analyst to conduct peer reviews and validate programmer analyst work done for moderately complex matters.

RESPONSIBILITIES & SCOPE

  • Gather requirements for new data attributes in collaboration with Analytics, Data Governance, and end users.
  • Create data pipelines to ingest data from Workday, CRM, and the conservation Hub into a shared data lake for future analysis.
  • Utilize fact/dimension design principles to design, build, and maintain datamarts across a set of four potential core data domains: Fundraising, Conservation Effectiveness, Finance, and Human Resources.
  • Work with Data Governance to ensure data in the above domains are properly registered in master data management systems and data catalogs, where applicable.
  • Ensure access to sensitive data is restricted and masking is applied where needed.
  • Produce data structure documentation for both technical and business audiences.
  • Provide support for production problems as assigned.
  • Act as Project or Technical Lead as assigned. Develop accurate project plans with realistic estimations and provide technical expertise to team members and users to help resolve complex project-related problems.

MINIMUM QUALIFICATIONS

  • Bachelor's degree in computer science, or a related field and three years of experience in programming and systems design OR an equivalent combination of education and/or experience.
  • Three or more years of experience in data engineering OR an equivalent combination of education and/or experience.
  • Five or more years of experience in SQL, including experience with advanced topics such as window functions, subqueries, and traversing multiple layers of many-to-many joins.
  • Three or more years of experience in Python using data-focused packages (PySpark, Pandas, or similar).
  • Three or more years of fact/dimension modeling experience.
  • Three or more years of experience in a data role involving extensive interaction with non-technical business partners.

DESIRED QUALIFICATIONS

  • Demonstratable experience reconciling financial data from multiple systems (such as credit card receipts against a general ledger) highly desired.
  • Experience using Databricks for data ingestion and curation.
  • Experience with Workday financial and/or Workday HR data.
  • Experience with the Profisee Master Data Management tool.
  • Experience with Microsoft Purview data catalog.
  • Multi-lingual skills and multi-cultural or cross-cultural experience appreciated.

This description is not designed to be a complete list of all duties and responsibilities required for this job.

The starting pay range for a candidate selected for this position is generally within the range of $80,000 - $125,700. This range only applies to candidates whose country of employment is the USA. Where a successful candidate’s actual pay will fall within this range will be based on a variety of factors, including, for example, the candidate's location, qualifications, specific skills, and experience. Please note countries outside the USA would have a different pay range in the local currency based on the local labor market and not tied to USA pay or ranges. Your geographic location will be confirmed during the recruitment

Who We Are

The Nature Conservancy’s mission is to protect the lands and waters upon which all life depends. As a science-based organization, we create innovative, on-the-ground solutions to our world’s toughest challenges so that we can create a world in which people and nature thrive. We’re rooted in our mission and guided by our values, which include respect for all people, communities, and cultures. Whether it’s career development, flexible schedules, or a rewarding mission, there’s many reasons to love life inside TNC. Want a better insight to TNC? Check out our TNC Talent playlist on YouTube to hear stories from staff or visit Glassdoor. One goal is to cultivate an inclusive work environment so that all our colleagues around the globe feel a sense of belonging and that their unique contributions to our mission are valued. In addition to the requirements in our job postings, we recognize that people come with talent and experiences outside of a job and consider each applicant’s unique experience. Please apply – we’d love to hear from you. To quote a popular saying at TNC, “you’ll join for the mission, and stay for the people.”

What We Bring

Since 1951, TNC has been doing work you can believe in. Through grassroots action, we have grown from a small non-profit into one of the most effective and wide-reaching environmental organizations in the world.

TNC offers a competitive, comprehensive benefits package including health care benefits, flexible spending accounts, a 401(k) plan with an 8% employer match, parental leave, accrued paid time off, life insurance, disability coverage, employee assistance program, other life and work well-being benefits.

  • health care benefits
  • flexible spending accounts
  • a 401(k) plan with an 8% employer match
  • parental leave
  • accrued paid time off
  • life insurance
  • disability coverage
  • employee assistance program
  • other life and work well-being benefits

Learn more about our Benefits and Perks.

We’re proud to offer a flexible work environment that supports of the health and well-being of the people we employ.

Our recruiting process includes a rolling interview process to ensure we engage applicants in a timely manner. This means we may review applications in the order in which they are received. Once a strong candidate pool is identified, the role will be unposted. The timeline may vary depending on the expressed interest in the role, so we highly encourage candidates to apply as soon as possible.

The Nature Conservancy is an Equal Opportunity Employer. Our commitment to equal employment opportunity includes the recognition that our conservation mission is best advanced by the leadership and contributions of people of all backgrounds, beliefs, and culture. Recruiting and mentoring staff to create an inclusive organization is a priority, and we encourage applicants from all cultures, races, colors, religions, sexes, national or regional origins, ages, disability status, sexual orientation, gender identity, military, protected veteran status or other status protected by law.

The successful applicant must meet the requirements of The Nature Conservancy's background screening process.

TNC is committed to offering accommodations for qualified individuals with disabilities and disabled veterans in our job application process. If you need assistance or an accommodation due to a disability, please send a note to applyhelp@tnc.org with Request for Accommodation in the subject line.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Engineer
Senior Data Engineer

The Nature Conversancy • Arlington (VA)

On-site
USD 80,000 - 126,000
Senior Data Engineer
Senior Data Engineer

USA The Nature Conservancy • Virginia

On-site
USD 80,000 - 126,000
Health care benefits
401(k) with employer match
Parental leave
+4
Senior Data Engineer
Senior Data Engineer

Nature • United States

Remote
USD 80,000 - 126,000
Development Specialist
Development Specialist

The Nature Conversancy • Tallahassee (FL)

Hybrid
USD 41,000 - 48,000
Health care benefits
Flexible spending accounts
401(k) plan with 8% employer match
+5
Executive Assistant, Finance and Operations
Executive Assistant, Finance and Operations

The Nature Conversancy • Arlington (VA)

Hybrid
USD 67,000 - 78,000
Health care benefits
401(k) plan with employer match
Flexible work arrangement
Finance Manager (Idaho, Montana, Wyoming)
Finance Manager (Idaho, Montana, Wyoming)

The Nature Conservancy • Montana

On-site
USD 93,000 - 104,000
Finance Manager (Idaho, Montana, Wyoming)
Finance Manager (Idaho, Montana, Wyoming)

The Nature Conservancy • Nevada

On-site
USD 93,000 - 104,000
Sustainability Science Fellow
Sustainability Science Fellow

The Nature Conversancy • Arlington (VA)

On-site
USD 75,000 - 105,000
Finance Manager
Finance Manager

The Nature Conversancy • Atlanta (GA)

Hybrid
USD 80,000 - 100,000
Health care benefits
401(k) plan with 8% employer match
Parental leave
+4
Associate, GEF Partnership and Public Funding
Associate, GEF Partnership and Public Funding

The Nature Conservancy • Arlington (VA)

Remote
USD 61,000 - 96,000
Health care benefits
Flexible spending accounts
401(k) plan with employer match