Data Engineer

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.

Summary

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.

Responsibilities

• 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

Requirements

• 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.