Senior Data Engineer

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 the data domains to provide quality data for decision-making. They analyze and document end‑user and technology‑user business requirements for data projects of varying complexity and 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 application maintenance projects related to upgrades, conversions, and modifications. They perform tasks such as design, development, running specific programs, generating reports, analyzing results, and providing support for production problems as assigned. They also serve as a final quality assurance analyst to conduct peer reviews and validate programmer analyst work 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 the Conservation Effectiveness, Finance, and Human Resources domains. Work with Data Governance to ensure data is properly registered in master data management systems and data catalogs. 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 resolve complex problems. Desired 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. 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 years of experience in data engineering OR an equivalent combination of education and/or experience. Five or more years of experience in SQL, including 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 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. Benefits Health care benefits Flexible spending accounts 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 Requirements The successful applicant must meet the requirements of The Nature Conservancy's background screening process. Equal Opportunity Employment 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. #J-18808-Ljbffr