Senior Exchange, Transform, and Load (ETL), Data Warehouse Engineer

The Sr. ETL / Data Warehouse Engineer leads the development of data warehousing solutions to power business intelligence for the International Membership program of The Nature Conservancy. As a part of the Global Membership team, they will synthesize business requirements for all fundraising information and create / implement solutions to integrate data from various internal and external systems (Financial, HR, CRM, Google Analytics, etc.) and build / maintain our customer data warehouse.

This position analyzes the data needs of the International Membership leadership and other stakeholders seeking business intelligence 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, dashboards and predictive models by optimizing the underlying data structures. They collaborate with IT staff to leverage their expertise in ensuring the reliability, accuracy, and performance of all custom data sources that feed the flow of global business information for the program. They will be responsible for designing and implementing these solutions in a creative, collaborative team environment. In collaboration with TNC IT and external vendors, they operate and maintain the International Membership programs’ ETL and Warehouse systems. This position is the first-tier support for resolving incidents and processing change requests.

• Bachelor’s degree in information technology or computer science or related field and/or combined equivalent of education and experience.

• 5 years of combined experience as a business or technical profession in Information Technology or a related field.

• Experience with SQL in an analytical or data engineering role.

• Experience in designing, building, maintaining and continuously improving data intake and ETL processes geared toward delivering Business Intelligence.

• Experience with at least one general purpose programming language.

• Experience in Project Management methodologies and tools

• Experience in defining and documenting complex systems requirements.

• Experience working closely with data vendors, business stakeholders and analytic teams to gather business requirements and implement continuous improvements.

Desired Qualifications

• Experience working with Azure or AWS cloud data warehouses.

• Experience with building database objects in Microsoft SQL Server, optimizing queries and writing stored procedures.

• Experience in data modeling and data warehouse design.

• Experience designing and implementing a program to continuously improve the completeness, quality and accuracy of all captured data elements in the warehouse; and, automate the detection and repair of all data anomalies.

• Experience working with CRM systems and integrating multiple sources of customer data.

• Ability and desire to mentor and train others.

• Experience implementing SDLC development principles.

• Demonstrated team-building skills.

• Experience with the development and execution of test plans.

• Experience with PowerBI, Tableau or other dashboarding tool.

• Experience with Google Analytics.

• Exceptional customer services skills.

• Strong organizational skills and attention to detail.

• Superior planning and problem-solving skills.

• Excellent communication and presentation skills.

• Demonstrated experience working across cultures and countries.

• Willingness to occasionally travel internationally (2-3 times per year).

• Willingness to work non-traditional hours and across time zones.

The starting pay range for a candidate selected for this position is generally within the range of $91,600 - $133,400 . 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 includes a Commitment to Diversity and Respect for People, Communities, and Cultures. Whether it’s career development, flexible schedules, or a rewarding mission, there’s lots of reasons to love life #insideTNC. Want a better insight to TNC? Check out our TNC Talent playlist on YouTube or on Glassdoor .

Our 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. We know we’ll only achieve our Mission by hiring and engaging a diverse workforce that reflects the communities in which we work. In addition to the requirements in our postings, we recognize that people come with talent and experiences outside of a job. Diversity of experience and skills combined with passion is a key to innovation and a culture of inclusion! Please apply – we’d love to hear from you. To quote myriad TNC staff members, “you’ll join for our mission, and you’ll stay for our 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. Thanks to more than 1 million members, over 400 scientists, and the dedicated efforts of our diverse staff and partners, we impact conservation around 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.

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

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.

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

Do you have military experience? Visit our U.S. Military Skills Translator to match your military experience with our current job openings!

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.