Data Engineering & Analytics Lead jobs in United States
cer-icon
Apply on Employer Site
company-logo

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.

CharityHealth CareNon Profit
Hiring Manager
Kimberly Hickey
linkedin

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

SnowflakePythonSQLPower BIData EngineeringAnalytics EngineeringAI & AutomationCloud & DevOpsCuriosity about dataCommunication skillsProject management

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

twittertwitter
company-logo
Alfred I. duPont Charitable Trust is a nonprofit organization that supports pediatric healthcare services.

Funding

Current Stage
Early Stage

Leadership Team

leader-logo
Kara Riley
Chief Operating Officer
linkedin
leader-logo
Travis Angevine
Deputy Chief Investment Officer
linkedin
Company data provided by crunchbase