Senior Data Engineer: Cloud Modernization & Governance

Allworth Airline Advisors (Formerly RAA); Dallas (TX); Hybrid; USD 110,000 - 150,000; Full time

Benefits offered by this job

Medical Insurance

Dental Insurance

Vision Insurance

Flexible working arrangements

401K contributions

Paid time off

Job summary

Allworth Financial is seeking a Senior Data Engineer to join the Analytics & Insights team in Addison, TX. The role will modernize legacy SQL-based processes into scalable cloud data pipelines and support a robust data analytics and reporting structure.

The ideal candidate has broad hands-on experience across data engineering, cloud data platforms, ETL/ELT, data modeling, governance, and data quality, and can design production pipelines, review architecture, and mentor the team as the data

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.

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.

Skills

SQL

PySpark

ETL/ELT

Delta Lake

Azure Synapse

Azure Data Factory

Data Modeling

Data Governance

Orchestration

Mentoring

Tools

Azure Synapse Analytics

Azure Data Lake Storage

Microsoft Fabric

Azure Data Factory

Job description

Allworth Financial is seeking a Senior Data Engineer to join the Analytics & Insights team in Addison, TX. The role will modernize legacy SQL-based processes into scalable cloud data pipelines and support a robust data analytics and reporting structure.

The ideal candidate has broad hands-on experience across data engineering, cloud data platforms, ETL/ELT, data modeling, governance, and data quality, and can design production pipelines, review architecture, and mentor the team as the data