Data Solution Architect

Baker Tilly US

Data Solution Architect responsible for implementing data engineering solutions using Microsoft Analytics at Baker Tilly. Collaborating with clients and stakeholders to deliver scalable solutions in data engineering.

Posted 5/28/2026full-timeTexas, Wisconsin • 🇺🇸 United StatesSeniorLead💰 $123,840 - $234,770 per yearWebsite

Tech Stack

Tools & technologies

AzureCloudETLPythonSQLTableau

About the role

Key responsibilities & impact

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 extraction, transformation, and loading (ETL) processes for structured and unstructured data
Apply best practices in dimensional modeling to create robust and scalable data models for analytics and reporting
Leverage tools such as Python, dbt, and SQL to develop advanced data transformation and integration processes
Optimize data storage and retrieval mechanisms to support 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 to ensure accuracy, reliability, and performance
Collaborate with analytics and BI teams to ensure seamless integration of data assets into Power BI and other reporting platforms
Stay informed about emerging trends and technologies in data engineering and cloud analytics to enhance solution delivery

Requirements

What you’ll need

Ten (10) plus years experience in data engineering with expertise in the Microsoft Analytics stack (Fabric, Synapse, SQL, SSAS, SSRS)
Strong proficiency in SQL, Python, and data modeling techniques
Working knowledge of data extraction patterns and best practices
Experience with ETL tools and frameworks, such as dbt
Solid understanding of dimensional modeling and its application in analytics
Strong problem-solving skills with a focus on delivering scalable and efficient solutions
Excellent communication and collaboration skills, with experience in client-facing roles
Experience with Azure Cloud infrastructure, including hybrid analytics workload configurations and networking
Certifications in Azure Engineering (e.g., Azure Data Engineer Associate, Azure Solutions Architect Expert)
Experience with Azure DevOps or GitHub for code repositories and deployment
Familiarity with advanced analytics tools and concepts, including machine learning workflows
Knowledge of additional data visualization tools such as Tableau or Qlik
Experience with Agile methodologies for project management

Benefits

Comp & perks

Comprehensive compensation and benefits package to eligible employees

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

data engineeringETLSQLPythondimensional modelingdata transformationdata integrationdata extractiondata modeling techniquesmachine learning

Soft Skills

problem-solvingcommunicationcollaborationclient-facing experience

Certifications

Azure Data Engineer AssociateAzure Solutions Architect Expert