Lead Data Engineer

Description Job Location: The primary work location for this role is Raleigh, NC with a hybrid work model. About Envestnet Envestnet is an adaptive WealthTech company that is redefining the future of wealth management by helping advisors meet the moment with its comprehensive technology, actionable insights, and industry leading support. Backed by over 25 years of experience and approximately $7.0 trillion in platform assets, Envestnet is trusted by over one third of financial advisors across leading banks, wealth managers, brokerages, and RIAs. For a deeper look at how Envestnet is shaping the future of financial advice, visit The Team You’ll Join The Lead Data Engineer will play a critical implementation role on the Data Engineering and Data Services team and be responsible for data pipeline solutions design and development, troubleshooting, and optimization tuning on the next generation data and analytics platform being developed with leading edge big data technologies in a highly secure cloud infrastructure. The Data Engineer will serve as a liaison to platform user groups ensuring successful implementation of capabilities on the new platform. The Lead Data Engineer will also take a lead role on functional teams or projects. How You’ll Contribute Deliver end-to-end data and analytics capabilities, including data ingest, data transformation, data science, and data visualization in collaboration with Data and Analytics stakeholder groups. Design and deploy databases and data pipelines to support analytics projects. Develop scalable and fault-tolerant workflows. Clearly document issues, solutions, findings and recommendations to be shared internally & external. Learn and apply tools and technologies proficiently, including: Languages: SQL (standard and DB-specific), Python, Scala, Bash Frameworks: Hadoop, Spark, Kafka Gen AI: RAG, Embedding, Agents, LLMs, Parameter Tuning Cloud Computing: AWS Tools/Products: Data Science Studio, Alteryx, Jupyter, Tableau, PowerBI Performance optimization for queries and dashboards. Develop and deliver clear, compelling briefings to internal and external stakeholders on findings, recommendations, and solutions. Analyze client data & systems to determine whether requirements can be met. Test and validate data pipelines, transformations, datasets, reports, and dashboards built by team. Develop and communicate solutions architectures and present solutions to both business and technical stakeholders. Provide end user support to other data engineers and analysts. Be a team leader and take lead role on functional teams or projects. Leads others to solve complex problems; uses sophisticated analytical thought to exercise judgment and identify innovative solutions. Interprets internal/external business challenges and recommends best practices to improve products, processes or services. Adherence to and application of Envestnet legal, compliance, risk, business continuity and administrative policy within the role and department(s) including the timely completion of training & awareness, affirmations and testing as requested. As part of the responsibilities for this role, you will understand and readily support Envestnet's established corporate business practices, policies, internal controls and procedures designed to create value or minimize risk. What You’ll Need to Bring 8-12 years of relevant experience or equivalent combination of experience and education. Expert experience in the following: SQL, Python, PySpark. Other programming languages (R, Scala, SAS, Java, etc.) are a plus. Data and analytics technologies including SQL/NoSQL/Graph databases, ETL, and BI. Knowledge of CI/CD and related tools such as Gitlab, AWS CodeCommit, etc. AWS services including EMR, Glue, Athena, Batch, Lambda Cloudwatch, DynamoDB, EC2, Cloudformation, IAM and EDS. Solid scripting skills (e.g., bash/shell scripts, Python). Proven work experience in the following: Data streaming technologies Using LLMs, creating RAG, choosing vector vs graph db for embedding, etc. Big Data technologies including, Hadoop, Spark, Hive, Teradata, etc. Linux command-line operations. Networking knowledge (OSI network layers, TCP/IP, virtualization). Candidate should be able to lead the team, communicate with business, gather and interpret business requirements. Experience with agile delivery methodologies using Jira or similar tools. Experience working with remote teams Nice-to-Haves AWS Solutions Architect / Developer / Data Analytics Specialty certifications, Professional certification is a plus. Bachelor Degree in Computer Science or relevant field, Masters Degree is a plus. Why You’ll Enjoy Working at Envestnet Help shape the future of WealthTech. At Envestnet you’ll gain hands‑on experience and collaborate with some of the industry’s brightest minds to deliver meaningful, innovative solutions that make a real difference. We value flexibility in how and where work gets done, and we recognize strong performance with meaningful rewards—because your contributions should drive both business success and your own personal growth. If you’re looking for a place where your work has impact, your development is supported, and your contributions are truly valued, Envestnet is where you can build your future. The opportunity is now! Sponsorship This position is not open to candidates requiring visa sponsorship. Our Investment in You At Envestnet, our total rewards philosophy is designed to attract, motivate, and grow exceptional talent. We offer competitive, market‑aligned compensation complemented with performance‑linked incentives and rewards programs that recognize and reward impact. We provide a comprehensive suite of benefits - subject to Envestnet’s plan eligibility rules - that support your overall well‑being including, medical insurance, paid time off (PTO), 401k company match, paid parental leave, education reimbursement, disability coverage and mental health & wellness support. Our investment in you means supporting you professionally, financially, and personally at every stage of your journey with us. Please visit our benefits page on our career site to learn more. Our Commitment to Inclusion & Belonging Envestnet is an Equal Opportunity Employer and is committed to creating an inclusive environment for all employees and applicants. We welcome and value individuals of all backgrounds and do not discriminate based on race, color, religion, creed, sex (including pregnancy or related medical conditions), gender identity or expression, sexual orientation, national origin, ancestry, age, disability, genetic information, military or veteran status, citizenship status, or any other status protected by applicable law. We encourage individuals from all backgrounds to apply. We strive to provide an inclusive application and interview process. If you are a candidate with a disability and require reasonable accommodation, please contact us at View email address on click.appcast.io. Please include your full name, the title of the role you are applying for, and the accommodation necessary to assist you with the recruiting process. Recruitment Fraud At Envestnet, safeguarding the trust and safety of job seekers is a top priority. We are aware that scammers may impersonate Envestnet recruiters or create fake job opportunities to deceive candidates. Review the information on our recruitment fraud awareness page to help you recognize and avoid recruitment fraud. #J-18808-Ljbffr Envestnet