Lead Data Engineer

Envestnet; Raleigh (NC); Hybrid; USD 100,000 - 130,000; Full time

Benefits offered by this job

Competitive compensation

Medical insurance

Paid time off (PTO)

401k company match

Education reimbursement

Job summary

Envestnet in Raleigh, NC is seeking a Lead Data Engineer to design and develop data pipeline solutions within a hybrid work model. This role involves end-to-end analytics capabilities and optimizing data for various stakeholders.

The ideal candidate should have 8-12 years of relevant experience with strong skills in SQL, Python, and big data technologies like Hadoop and Spark. Envestnet offers competitive compensation and a commitment to inclusiveness in the workplace.

Qualifications

• 8-12 years of relevant experience or equivalent combination of experience and education.
• Expert experience in SQL, Python, and PySpark.
• Solid scripting skills in Bash or shell scripts.

Responsibilities

• Deliver end-to-end data and analytics capabilities.
• Design and deploy databases and data pipelines.
• Develop scalable and fault-tolerant workflows.

Skills

SQL

Python

Data streaming technologies

CI/CD

Big Data technologies

Education

Bachelor Degree in Computer Science or relevant field

Tools

Hadoop

Spark

AWS

Jira

Job description

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 www.envestnet.com.

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 [e-mail]. 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.