At TRC, we partner with innovative organizations to connect exceptional talent with impactful career opportunities. This opportunity is with Allworth Financial, a growing company focused on modernizing and scaling its enterprise data and analytics environment.
Allworth Financial is seeking a Senior Data Engineer to support the next phase of its data platform modernization. This role will help transition legacy SQL-based processes into scalable cloud-native data pipelines while improving data governance, reliability, and engineering standards.
The ideal candidate combines hands-on technical expertise with the ability to evaluate existing architecture, identify gaps, recommend improvements, and mentor team members. This is an opportunity to play a key role in building a modern, scalable, and well-governed data ecosystem.
Design, build, and optimize scalable data pipelines using PySpark, SQL, Delta Lake, and Azure cloud technologies
Modernize legacy SQL and stored procedure workflows into maintainable cloud-based solutions
Improve pipeline reliability, monitoring, logging, error handling, and restartability
Review and optimize notebooks, orchestration workflows, SQL scripts, and data models for performance and scalability
Provide guidance on best practices for Azure Synapse, Spark, Delta Lake, and data lake architecture
Identify technical debt, architectural risks, and modernization opportunities
Develop data quality checks, validation frameworks, and reconciliation processes
Support master data management initiatives, canonical IDs, and entity resolution processes
Assist with data governance initiatives including metadata management, lineage, and cataloging
Partner with business stakeholders to support reporting, analytics, and data product needs
Build scalable semantic and reporting models for BI tools such as Power BI and ThoughtSpot
Mentor team members and help elevate engineering standards and best practices
5+ years of experience in data engineering, analytics engineering, data architecture, or related fields
Strong SQL skills including stored procedures, joins, CTEs, window functions, merge logic, and query optimization
Hands-on experience with PySpark or distributed data processing frameworks
Experience designing and supporting ETL/ELT pipelines in cloud environments
Experience with data lake or lakehouse architectures, including Delta Lake or similar technologies
Strong understanding of dimensional modeling, staging layers, curated layers, and semantic/reporting models
Experience with orchestration, scheduling, dependency management, and pipeline recovery strategies
Ability to troubleshoot data quality issues, schema drift, source inconsistencies, and performance bottlenecks
Familiarity with modern data governance concepts including lineage, cataloging, access control, and data quality monitoring
Strong communication skills with both technical and non-technical stakeholders
Experience evaluating existing systems and recommending practical modernization strategies
Experience with Azure Synapse Analytics, Azure Data Lake Storage, Microsoft Fabric, Azure Data Factory, or related Azure services
TRC Talent Solutions is proud to be an Equal Opportunity Employer (EOE). All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, protected veteran status, disability status, sexual orientation, gender identity or expression, marital status, genetic information, or any other characteristic protected by law. At TRC, we take pride in fulfilling our opportunity to add value to our client's business as their staffing partner, while working tirelessly to connect thousands of individuals each year with work opportunities where they can meet the needs of their families and have the potential to build their careers.