Sr. Data Engineer

Join Allworth Financial as a Sr. Data Engineer to optimize the company’s data infrastructure and support a robust data analytics and reporting structure. Design, build, and optimize data pipelines using PySpark, Delta Lake, SQL, and cloud-based data engineering tools.

Requirements

• 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

• 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