Senior Data Engineer Cloud Data Platform & Governance

Allworth Financial ( ) 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 insurancewith 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. Interested in building your career at Allworth Financial? Get future opportunities sent straight to your email. Accepted file types: pdf, doc, docx, txt, rtf Enter manually Accepted file types: pdf, doc, docx, txt, rtf How would you like us to pronounce your first name? What is your preferred contact method? Select... Please select any licenses or certifications you currently hold. * None Series 6 Series 7 Series 66 Certified Public Accountant Other If you selected "Other" from the list of Licenses & Certifications Held, please list those here. If presented with an offer of employment, are you able to provide proof of authorization to work in the United States? * Select... Do you want to be updated with future job openings? Select... How did you hear about this job opportunity? * Select... Voluntary Self-Identification For government reporting purposes, we ask candidates to respond to the below self-identification survey.Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiringprocess or thereafter. Any information that you do provide will be recorded and maintained in aconfidential file. As set forth in Allworth Financial’s Equal Employment Opportunity policy,we do not discriminate on the basis of any protected group status under any applicable law. If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection.As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measurethe effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categoriesis as follows: A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability. A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service. An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense. An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985. Select... Voluntary Self-Identification of Disability Form CC-305 Page 1 of 1 OMB Control Number 1250-0005 Expires 04/30/2026 Voluntary Self-Identification of Disability Form CC-305 Page 1 of 1 OMB Control Number 1250-0005 Expires 04/30/2026 Why are you being asked to complete this form? We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years. Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at . How do you know if you have a disability? A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to: Alcohol or other substance use disorder (not currently using drugs illegally) Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS Blind or low vision Cancer (past or present) Cardiovascular or heart disease Celiac disease Cerebral palsy Deaf or serious difficulty hearing Diabetes Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders Epilepsy or other seizure disorder Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome Intellectual or developmental disability Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD Missing limbs or partially missing limbs Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS) Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities Partial or complete paralysis (any cause) Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema Short stature (dwarfism) Traumatic brain injury Disability Status Select... PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete. #J-18808-Ljbffr