Senior ETL / Data Warehouse Engineer

The Nature Conservancy

Arlington, Virginia

Job Type Permanent
Salary Details Competitive

About Us

Since 1951, The Nature Conservancy has been doing work you can believe in protecting the lands and waters that all life depends on. 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 includes a Commitment to Diversity and Respect for People, Communities, and Cultures. We know we’ll only achieve our Mission by hiring and engaging a diverse workforce that reflects the communities in which we work. Whether it’s career development, work/life balance, or a rewarding mission, there’s lots of reasons to love life #insideTNC. Our goal is to cultivate an inclusive work environment so that all of our colleagues around the globe feel a sense of belonging, and that their unique contributions to our mission are valued.

Although you’ll see requirements in our postings, we recognize that people come with talent and experiences outside of a job. Passion, innovation, and diversity are all key components to advancing our Mission and we encourage you to apply.

Position Summary

The Sr. ETL / Data Warehouse Engineer analyzes the data needs of internal clients seeking business intelligence solutions, and builds custom data sources and data models to address those needs. They gather and document requirements, design and improve data schemas, and build efficient and streamlined ETL processes. They enhance the performance of reports and dashboards by optimizing the underlying data structures. They collaborate with other IT staff to leverage their expertise in ensuring the reliability, accuracy, and performance of all custom data sources that feed the flow of business information at The Nature Conservancy. They will be responsible for designing and implementing these solutions in a creative, collaborative team environment. They operate and maintain TNC’s ETL and Warehouse systems, resolve incidents and process change requests.

RESPONSIBILITIES & SCOPE

  • Write code to build ETL processes to integrate information from various enterprise IT systems.
  • Design new data structures, add to and optimize existing data schemas.
  • Ability to analyze upstream and downstream effects of a change in existing data structures and planning for change management.
  • Understand key strategies and business processes of internal clients across the organization in order to provide the best solution to achieve their outcomes.
  • Conduct analyses of business or technical user needs, document requirements and design tailored data solutions.
  • Monitor performance of ETL processes and build in redundancies to avoid risk of an information outage.
  • Provide support and troubleshoot questions arising from report developers and business users of these data solutions.
  • Track and document work done and communicate progress with business users in a timely manner.
  • Ability to adapt and/or modify processes in response to changing circumstances.
  • Well versed in specific industry best practices, and an ability to adapt them to TNC’s environment.
  • Ability to work effectively across multiple complex projects.
  • Research and recommend innovative and automated approaches.

Skills & Experience

  • Bachelor’s degree in computer science, information systems or related field and/or combined equivalent of education and experience.
  • 5 or more years experience with SQL in an analytical or data engineering role.
  • 3 or more years experience in designing, building, and maintaining ETL processes geared toward delivering Business Intelligence.
  • 2 or more years experience with at least one other data-oriented or general purpose programming language.
  • 2 or years experience in data modeling, data warehouse design, or related areas.
  • 2 or years experience extracting and querying JSON or XML data from web services.
  • Experience working with Amazon Web Services (AWS), including Amazon Redshift.
  • Experience working with SAS Products.
  • Experience with building database objects in Microsoft SQL Server, optimizing queries and writing stored procedures.
HOW TO APPLY

To apply for job ID 50365, submit your materials online by using the Apply Now button at https://careers.nature.org/. Need help applying? Visit our recruitment page or contact applyhelp@tnc.org.

The Nature Conservancy is an Equal Opportunity Employer. Our commitment to diversity includes the recognition that our conservation mission is best advanced by the leadership and contributions of people of diverse backgrounds, beliefs and culture. Recruiting and mentoring staff to create an inclusive organization that reflects our global character 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.

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.

When you apply, please indicate that you are responding to the posting on Conservation Job Board.