Azure Data Solution Architect – Hybrid Analytics Lead

Baker Tilly; Frisco City (AL); On-site; USD 124,000 - 235,000; Full time

Job summary

Baker Tilly is seeking a Senior Data Engineer to design and implement scalable data pipelines using the Microsoft Analytics stack. You will collaborate with clients and internal teams to transform structured and unstructured data into analytics-ready assets and deliver high-performance reporting with Power BI and Azure components.

The role demands 10+ years of data engineering experience, strong SQL, Python, and data modeling skills, plus excellent communication and collaboration abilities.

Qualifications

• 10+ years of data engineering with Microsoft Analytics stack (Fabric, Synapse, SQL, SSAS, SSRS).
• Strong SQL, Python, and data modeling proficiency.
• Experience with ETL tools and frameworks, such as dbt.
• Solid understanding of dimensional modeling for analytics.
• Excellent communication and collaboration skills, with client-facing experience.

Responsibilities

• Collaborate with clients and internal stakeholders to design and implement scalable data engineering solutions using the Microsoft Analytics ecosystem.
• Develop and maintain data pipelines, ensuring efficient ETL for structured and unstructured data.
• Apply best practices in dimensional modeling to create robust data models for analytics and reporting.
• Leverage Python, dbt, and SQL to develop advanced data transformation and integration processes.
• Optimize data storage and retrieval for high-performance analytics workloads.
• Implement and manage hybrid analytics workloads using Azure Cloud infrastructure, including networking and security configurations.
• Monitor and troubleshoot data pipelines and workflows for accuracy, reliability, and performance.
• Collaborate with analytics and BI teams to integrate data assets into Power BI and other reporting platforms.
• Stay informed about trends in data engineering and cloud analytics to enhance delivery.

Skills

SQL

Python

Data modeling

ETL patterns

Problem solving

Client-facing

Collaboration

Tools

dbt

Power BI

Azure DevOps

Job description

Baker Tilly is seeking a Senior Data Engineer to design and implement scalable data pipelines using the Microsoft Analytics stack. You will collaborate with clients and internal teams to transform structured and unstructured data into analytics-ready assets and deliver high-performance reporting with Power BI and Azure components.

The role demands 10+ years of data engineering experience, strong SQL, Python, and data modeling skills, plus excellent communication and collaboration abilities.