Senior Data Engineer

USA The Nature Conservancy

Arlington, Virginia

JOB DETAILS
SALARY
$77,920–$125,732
SKILLS
Analysis Skills, Best Practices, Computer Programming, Computer Science, Conservation, Data Lake, Data Management, Data Mart, Data Modeling, Data Structures, Detail Oriented, Develop Methodologies, Finance, General Ledger Accounting, Human Resources, Master Data Management (MDM), Operational Support, Production Support, Project Design, Project Development, Project Planning, Python Programming/Scripting Language, Quality Assurance, Reporting Skills, Requirements Management, SQL (Structured Query Language), Software Administration, Software Development Lifecycle (SDLC), Software Engineering, Software Upgrades, Team Player, Technical Leadership, Technical Writing
LOCATION
Arlington, Virginia
POSTED
30+ days ago
What We Can Achieve Together:

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

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
  • Create data pipelines to ingest data from Workday and the conservation Hub into a shared data lake for future analysis.
  • Utilize fact/dimension design principles to design, build, and maintain datamarts across three core data domains: 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.
  • Gather requirements for new data attributes in collaboration with Analytics, Data Governance, and end users.
  • 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.

We're Looking for You:

Looking for a data job with meaning? Come help The Nature Conservancy measure the effectiveness of its global conservation efforts! We're looking for experienced data engineering professionals who want to flex their engineering and modeling skills in SQL, Python, and Databricks in the areas of conservation effectiveness, finance, and HR.

If you are a detail oriented, responsible team-player passionate about building data pipelines and modeling data for reporting, then you are the type of person we are looking for! We are looking for a talented Senior Data Engineer to come join our fast-paced, fun and rewarding agile team of professionals performing full lifecycle software development and operational support. Come join our team and be a part of an organization that creates innovative, on-the-ground solutions to our world's toughest challenges so that people and nature can thrive together.

The ideal candidate will have all or some of the qualifications. If you don't have all of them, please apply anyway and tell us about your skills and experience:
  • Experience using Databricks for data ingestion and curation.
  • Experience with Workday financial and/or Workday HR data.
  • Multi-lingual skills and multi-cultural or cross-cultural experience appreciated.

What You'll Bring:

  • 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 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.
  • Two or more years of experience working with financial general ledger data
  • 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.
Salary Information:

The starting pay range for a candidate selected for this position is generally within the range of $77,920.00 - $125,732.00. This ran

About the Company

U

USA The Nature Conservancy

The Nature Conservancy is the leading conservation organization working around the world to protect ecologically important lands and waters for nature and people. The mission of The Nature Conservancy is to conserve the lands and waters on which all life depends.

We address the most pressing conservation threats at the largest scale. Thanks to the support of our more than 1 million members, we’ve built a tremendous record of success since our founding in 1951:
  • We've protected more than 119 million acres of land and thousands of miles of rivers worldwide — and we operate more than 100 marine conservation projects globally.
  • We work in all 50 states and more than 72 countries — protecting habitats from grasslands to coral reefs, from Australia to Alaska to Zambia.
  • We address threats to conservation involving climate change, fresh water, oceans, and conservation lands.
COMPANY SIZE
2,500 to 4,999 employees
INDUSTRY
Nonprofit Charitable Organizations
FOUNDED
1951
WEBSITE
http://www.nature.org