Data Engineering & Analytics Lead
1 day ago
Jacksonville
The Alfred I. duPont Charitable Trust is seeking an exceptional professional to join a leading investment management organization that invests exclusively for the benefit of pediatric healthcare. Today, the Trust’s dedicated team manages over $10 billion in assets that provides support to The Nemours Foundation, a premier children’s healthcare system that includes the Nemours Children’s Hospital in Wilmington, Delaware and Orlando, Florida as well as Nemours Children’s Clinics in Delaware, Florida, Pennsylvania, and New Jersey. Our work has provided nearly $5 billion for the care and treatment of children. With your help, we can continue our mission of serving hundreds of thousands of children each year. The Trust’s headquarters is in Jacksonville, a fast-growing and affordable city in vibrant Northeast Florida. The Trust seeks professionals who embody our values. We seek those who recognize that first and foremost, we are stewards of Mr. duPont’s mission. We are a professionally run asset management firm whose mission is to be a best-in-class investment organization. Across our team, there is alignment around our common purpose of having a meaningful and immediate impact on our business and the lives of children through our support of The Nemours Foundation. We have a mindset that we win together as one team and know that we can achieve more collectively than individually. We foster a collaborative, professionally humble, team-oriented work environment that encourages constructive debate, continuous improvement, and taking initiative. The Trust is an organization that values and rewards high performance and great results with competitive compensation and excellent benefits. We are purposeful about the decisions we make, always mindful that decisions must be made with care and must reflect the strategy and the priorities of the organization and our stakeholders. We are fundamental investors operating within small teams under a collaborative decision-making process that values intellectual honesty and transparency in our process. The business team plays a critical role in providing timely information in support of our investment process and automating reporting and information availability that maximizes our investors’ time spent finding exceptional investments. We proactively protect our assets namely, capital, people, property, and reputation. We execute our strategy with accuracy and efficiency while staying forward looking and innovative to be ready to meet tomorrow’s challenges. Importantly, we are a team that shares responsibility for our outcomes. We value independent thinkers who communicate effectively and approach situations holistically with an eye toward efficiency without sacrificing quality and rigor. As a forward-thinking organization, we value intellectual curiosity and those who invite, challenge, and engage in discussion. The Trust environment is one in which team members are expected to develop professionally, share openly, and enjoy collaborating. The Data Engineering & Analytics Lead role is a unique opportunity to architect and build a comprehensive data platform and software ecosystem on a modern tech stack. You will collaborate with leadership to shape the technical vision, strongly influencing the critical infrastructure that powers our investment decision-making. THE ROLE • 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. WHAT YOU BRING Educational and Professional Experience: • 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). Technical Skills: • 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. Leadership Skills: • 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 WHAT WE BRING • Professional Growth and Mentorship: Significant interaction with the Trust’s senior professionals who bring a wealth of experience and are excited to mentor and support your career development., • Exposure to Leading Technology and Experts: Gain hands-on experience with top-tier technology, modern data and analytics solutions, and cutting-edge AI while expanding your expertise and network., • Purpose-Driven Impact: A shared commitment to making a meaningful difference in our business and in the lives of children through our support of the Nemours Foundation., • Collaborative Work Environment: A team-oriented culture where we believe in achieving more together than individually. We foster constructive debate, continuous improvement, and encourage taking initiative., • Competitive Compensation and Benefits: We value high performance and reward great results with a competitive base salary, excellent benefits, and bonus opportunities.