Alfred I. duPont Charitable Trust ยท 1 month ago
Data Engineering & Analytics Lead
The Alfred I. duPont Charitable Trust is a leading investment management organization focused on pediatric healthcare. The Data Engineering & Analytics Lead will architect and build a comprehensive data platform, collaborating with leadership to shape the technical vision and influence the critical infrastructure that supports investment decision-making.
Responsibilities
Manage the cloud data platform (Snowflake, Azure) and serve as the central architect for data integrity and storage
Guide system modernization efforts and assist with "buy vs. build" decisions to ensure technology remains innovative
Design and optimize end-to-end data pipelines and system integrations using SQL, Python (Fivetran), and APIs, implementing automated workflows, monitoring, and alerting to ensure pipeline stability and timely data refreshes
Design and deliver high-quality custom software solutions and application layers, including Streamlit and Snowflake apps, to address specific business requirements
Integrate AI solutions and develop customized workflows using LLM pipelines, RAG, text-to-SQL, embeddings, vector databases, and prompt engineering
Lead the swift development of Power BI dashboards to provide actionable insights for multi-asset class portfolios
Collaborate with internal and external partners to translate organizational needs into data solutions, working closely with stakeholders to refine and iterate on requirements
Assist with the design, implementation, and configuration of core business systems, focusing on optimizing data input structures to ensure efficient downstream reporting
Support a fast-paced environment by prioritizing quick iteration and continuous improvement while taking ownership of complex, high-visibility initiatives
Qualification
Required
Bachelor's degree (required) in Computer Science, Information Systems, Data Science, Engineering, or a related quantitative field
5+ years of progressively responsible experience in data engineering, analytics, or BI platform development
3+ years hands-on experience with Snowflake or comparable modern data warehouse (BigQuery, Redshift, Databricks)
Data Engineering: Advanced Python, SQL, dbt, orchestration tools, APIs/Fivetran, and CI/CD automation for complex multi-source ELT pipelines
Analytics Engineering: Deep understanding of dimensional modeling, semantic layer design, data marts, and metric standardization for Power BI
BI & Visualization: Expert Power BI development (DAX, tabular models, data lineage, and performance optimization at scale)
Data Governance & Reliability: Ability to design and enforce data quality frameworks, testing processes, and documentation standards
AI & Automation: Working knowledge of LLM pipelines, RAG, text-to-SQL, embeddings, vector databases, and prompt engineering
Cloud & DevOps: Strong environment management, containerization, monitoring, and automated alerting using modern cloud tools
Excellent communication and collaboration skills with technical and non-technical teams
Proven project management and delivery experience
A generalist mindset that is comfortable wearing multiple hats across data engineering, analytics, and AI
Passionate and self-motivated with genuine curiosity about data and a drive to learn new technologies and solve problems creatively
Benefits
Professional Growth and Mentorship
Exposure to Leading Technology and Experts
Purpose-Driven Impact
Collaborative Work Environment
Competitive Compensation and Benefits
Company
Alfred I. duPont Charitable Trust
Alfred I. duPont Charitable Trust is a nonprofit organization that supports pediatric healthcare services.
Funding
Current Stage
Early StageRecent News
2025-05-10
Company data provided by crunchbase