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.
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.
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.
Requirements
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.