Description
Allworth Financial (www.allworthfinancial.com) is an independent investment financial advisory firm that specializes in retirement planning, investment advising, and 401(k) management with a direct approach to financial planning. Allworth Financial delivers long- and short-term investment planning solutions and advice to help clients achieve their goals and plan strategically for retirement.
Allworth Financial is a high growth, private equity backed, multi branch Registered Investment Advisor. Founded in Sacramento, California, in 1993 Allworth is primarily a fee-based, employee-centric fiduciary advisory firm, that prides itself on emphasizing client well-being and education. The business is a multi-billion dollar firm and is on track for continued growth through both acquisitions and strong organic growth. Allworth is considered a great place to work and was once again given the prestigious “Circle of Excellence” award by the National Business Research Institute for employee and client satisfaction in 2021, placing it among the best-loved brands in America. Allworth Financial was also recognized as a Barron's Top 40 RIA in 2024.
SUMMARY:
This is an opportunity to join a high growth business as the Data Engineer. The position will work with the Analytics & Insights team at Allworth Financial to optimize the company’s existing data infrastructure to support a robust data analytics and reporting structure.
We are looking for a Senior Data Engineer, or similarly experienced data modernization professional, to help guide the next stage of our data platform evolution. This role will support the modernization of legacy SQL-based processes into scalable, maintainable cloud data pipelines, while also helping us identify architectural gaps, improve engineering standards, and mature our data governance practices.
The ideal candidate has broad hands-on experience across data engineering, cloud data platforms, ETL/ELT design, data modeling, orchestration, performance tuning, data quality, and governance. We are looking for someone who can both build and advise: someone who can write production-quality pipelines, review existing architecture, mentor team members, and point out the risks, patterns, and opportunities we may not yet know to look for.
This person will play a key role in helping us move from legacy stored procedures and fragmented reporting processes toward a more reliable, transparent, and well-governed modern data architecture.
This is a full-time Exempt location. Ideal candidate will be able to work hybrid work schedule in our Addison office.
DUTIES AND RESPONSIBILITIES:
- Design, build, and optimize data pipelines using PySpark, Delta Lake, SQL, and cloud-based data engineering tools.
- Improve data pipeline reliability, observability, logging, error handling, and restartability.
- Review existing notebooks, SQL scripts, data models, and orchestration workflows for maintainability and performance.
- Guide best practices for Azure Synapse, Spark, Delta Lake, data lake storage, and related cloud data services.
- Identify architectural gaps, technical debt, and modernization risks.
- Help design and implement data quality checks, reconciliation processes, and validation frameworks.
- Support development of canonical IDs, master data patterns, and entity resolution processes.
- Assist with data cataloging, lineage, metadata management, and governance practices.
- Partner with business stakeholders to understand reporting, analytics, and data product requirements.
- Help structure scalable data models for BI tools such as ThoughtSpot, Power BI, or similar platforms.
- Mentor data team members and help raise the overall engineering maturity of the team.
- Provide guidance on what we may be overlooking in areas such as security, performance, cost, governance, orchestration, testing, and long-term maintainability.
QUALIFICATIONS:
- 5+ years of professional experience in data engineering, analytics engineering, data architecture, or a closely related role.
- Strong SQL skills, including stored procedures, joins, window functions, CTEs, merge logic, and performance tuning.
- Hands-on experience with PySpark or distributed data processing frameworks.
- Experience designing and maintaining ETL/ELT pipelines in a cloud environment.
- Experience with data lake or lakehouse architecture, including Delta Lake or similar table formats.
- Strong understanding of data modeling concepts, including dimensional modeling, staging layers, curated layers, and semantic/reporting models.
- Experience with pipeline orchestration, scheduling, dependency management, and failure recovery.
- Ability to troubleshoot data quality issues, pipeline failures, schema drift, performance bottlenecks, and source system inconsistencies.
- Familiarity with modern data governance concepts, including cataloging, lineage, ownership, access control, data definitions, and data quality monitoring.
- Ability to communicate clearly with both technical and non-technical stakeholders.
- Experience reviewing existing systems and recommending practical, incremental improvements.
- Experience with Azure Synapse Analytics, Azure Data Lake Storage, Microsoft Fabric, Azure Data Factory, or related Azure data services.
BENEFITS
We value our associates’ time and effort. Our commitment to your success is enhanced by our competitive base pay and an extensive benefits package, including:
- Medical: Blue Shield (PPOs and HDHP with HSA) plans and Kaiser (HMO) plans for California associates
- Dental insurance with MetLife
- Vision insurance with VSP
- Optional supplemental benefits
- Healthcare savings accounts with company contribution
- Flexible spending accounts
- Flexible working arrangements
- Generous 401K contributions
- Exempt associates qualify for our flexible paid time off policy
- Non-Exempt associates will receive 15 days of paid time off annually during the first three years of employment
- 11 Paid Holidays
- Option to participate in our Equity Purchase Program (Contract, intern, and part-time employees are not eligible)
- Future growth opportunities within the company
In addition, we work to maintain the best possible environment for our associates, where people can learn and grow with the firm. We strive to provide a collaborative, creative environment where each person feels encouraged to contribute to our processes, decisions, planning and culture.
Benefits are available to full-time associates who work more than 30 hours a week.
The above statements are intended to describe the general nature and level of work being performed by people assigned to this job. Typical reporting relationships are described, but actual relationships may vary in some instances. This job description is not intended to be an exhaustive list of all responsibilities, duties, skills, or knowledge required of personnel classified in this job.
Allworth Financial participates in E-Verify. Click here for more information.
California residents, click here for our privacy policy.
Similar jobs
Est. 230,000 USD
About Us DriveWealth is on a mission to make investing easier. We believe that everyone should have the ability to control their financial future, and that access to financial markets should not be limited by geography,…
Est. 155,000 USD
About Us DriveWealth is on a mission to make investing easier. We believe that everyone should have the ability to control their financial future, and that access to financial markets should not be limited by geography,…
Est. 80,000 GBP
Spaulding Ridge is an advisory and IT implementation firm. We help global organizations get financial clarity into the complex, daily sales, and operational decisions that impact profitable revenue generations, efficient…
Est. 187,500 USD
At Beyond Finance, we've made it our mission to help everyday Americans escape the endless cycle of crippling debt and step into a brighter financial future. Through compassionate, individualized care, a culture focused…
Est. 133,525 USD
84.51° Overview: 84.51° is a retail data science, insights and media company. We help The Kroger Co., consumer packaged goods companies, agencies, publishers and affiliates create more personalized and valuable experienc…
Est. 137,500 USD
This position supports a federal client and requires US citizenship for Public Trust eligibility Attain Talent is searching for talented data engineers for our GovCon client. This is a full time position with benefits, a…
ROLE OVERVIEW We are looking for a seasoned Data Architect with deep expertise in enterprise data warehousing, ETL/ELT pipeline development, and business intelligence. You will be responsible for the end-to-end design an…
Est. 215,000 USD
Who We Are At Justworks, you’ll enjoy a welcoming and casual environment, great benefits, wellness program offerings, company retreats, and the ability to interact with and learn from leaders in the startup community. We…
Join us in bringing joy to customer experience. Five9 is a leading provider of cloud contact center software, bringing the power of cloud innovation to customers worldwide. Living our values everyday results in our team-…
Est. 80,000 GBP
(ID: 2026-2740) Axle Informatics is a bioscience and information technology company advancing translational research through biomedical informatics, data science, artificial intelligence, and intelligent automation. We p…
The key to our success is simple; we deliver the highest quality, on time, with passion and commitment, and live every day by a set of great values. We've built a company that fosters long-term careers in an environment…
Join us in bringing joy to customer experience. Five9 is a leading provider of cloud contact center software, bringing the power of cloud innovation to customers worldwide. Living our values everyday results in our team-…
About Workato Workato delivers enterprise infrastructure for the agentic era, redefining iPaaS and helping enterprises unify data, applications, processes, and AI into a single, governed platform. A leader in Enterprise…
Est. 122,500 USD
About UsCapital Bank N.A. is headquartered in Maryland and has been serving our communities since 1999. We stand as a publicly traded company (NASDAQ: CBNK) with over $3 billion in assets. We offer commercial and consume…
Est. 110,000 USD
Who we are: Strongpoint Partners is tech-enabled retirement services platform serving small- to mid-sized businesses with integrated retirement third party administration, recordkeeping, payroll, and HR solutions. Recogn…
Est. 55,000 EUR
Spaulding Ridge is an advisory and IT implementation firm. We help global organizations get financial clarity into the complex, daily sales, and operational decisions that impact profitable revenue generations, efficient…
Est. 257,000 USD
Company Overview We are the better way to work in finance. As private equity’s value creation partner, we sit at the heart of PE—where sponsors and CFOs meet. Through financial consulting rooted in data, technology, and…
Who we are DigiCert is a global leader in intelligent trust. We protect the digital world by ensuring the security, privacy, and authenticity of every interaction. Our AI-powered DigiCert ONE platform unifies PKI, DNS, a…
Est. 140,000 USD
WE’RE HIRING! If you love data and are looking for unlimited growth opportunities, we want to talk with you about joining Further. Further is a data, cloud, and AI company whose focus is helping companies turn raw data i…
Est. 175,000 USD
Caylent is an AI-first cloud services company that helps organizations turn ambitious ideas into meaningful business impact. As an AWS Premier Tier Services Partner and a charter member of Anthropic’s Claude Partner Netw…
Est. 120,000 USD
Caylent is an AI-first cloud services company that helps organizations turn ambitious ideas into meaningful business impact. As an AWS Premier Tier Services Partner and a charter member of Anthropic’s Claude Partner Netw…
Caylent is an AI-first cloud services company that helps organizations turn ambitious ideas into meaningful business impact. As an AWS Premier Tier Services Partner and a charter member of Anthropic’s Claude Partner Netw…
Est. 140,000 USD
WE’RE HIRING! If you love data and are looking for unlimited growth opportunities, we want to talk with you about joining Further. Further is a data, cloud, and AI company whose focus is helping companies turn raw data i…
Est. 140,000 USD
Caylent is an AI-first cloud services company that helps organizations turn ambitious ideas into meaningful business impact. As an AWS Premier Tier Services Partner and a charter member of Anthropic’s Claude Partner Netw…
Est. 250,000 USD
USA (Remote) with 35-40% Travel Robots & Pencils is an applied AI engineering firm building the next frontier of business architecture. We design and ship AI co-workers that integrate into enterprise operations and d…
Secure Every Identity, from AI to HumanIdentity is the key to unlocking the potential of AI. Okta secures AI by building the trusted, neutral infrastructure that enables organizations to safely embrace this new era. This…
Est. 225,000 USD
DRW is a diversified trading firm with over 3 decades of experience bringing sophisticated technology and exceptional people together to operate in markets around the world. We value autonomy and the ability to quickly p…
Est. 260,000 USD
About Us DriveWealth is on a mission to make investing easier. We believe that everyone should have the ability to control their financial future, and that access to financial markets should not be limited by geography,…
Caylent is an AI-first cloud services company that helps organizations turn ambitious ideas into meaningful business impact. As an AWS Premier Tier Services Partner and a charter member of Anthropic’s Claude Partner Netw…
Caylent is an AI-first cloud services company that helps organizations turn ambitious ideas into meaningful business impact. As an AWS Premier Tier Services Partner and a charter member of Anthropic’s Claude Partner Netw…