Data Solution Architect

Baker Tilly•Madison, WI

About The Position

As a Data Solutions Architect at Baker Tilly, you will lead the design of secure, reliable, and cost-conscious data and analytics solutions for clients. You will translate business goals and existing system constraints into target architectures, guide engineering teams through implementation while remaining hands-on in development, and explain technical decisions and tradeoffs to client stakeholders. The work spans data integration, storage, modeling, governance, and analytics across modern data platforms in Azure.

Requirements

  • At least 10 years of experience in data engineering, with deep expertise in the Microsoft Data and Analytics stack.
  • Multiple years of experience leading discovery, evaluating design tradeoffs, presenting recommendations, and guiding a delivery team.
  • 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 focused on delivering scalable and efficient solutions.
  • Excellent communication and collaboration skills, with experience in client-facing roles.

Nice To Haves

  • Experience with Azure Cloud infrastructure, including hybrid analytics workload configurations and networking.
  • Certifications in Azure Engineering and Administration, such as Fabric Data Engineer Associate, Azure Administrator Associate, or Azure Solutions Architect Expert.
  • Experience with Azure DevOps or GitHub for code repositories and deployment.
  • Experience with data vault modeling and data mesh architecture concepts.
  • Familiarity with advanced analytics tools and concepts, including machine learning workflows.
  • Experience using approved AI-assisted development tools responsibly.
  • Knowledge of additional data visualization tools such as Tableau, Qlik, or AWS Quicksight.
  • Experience with Agile methodologies for project management.

Responsibilities

  • Collaborate with clients and internal stakeholders to design and implement scalable data engineering solutions using the Microsoft Analytics ecosystem.
  • Lead discovery, select architecture patterns, document tradeoffs, guide implementations, and remain accountable for the overall technical design.
  • Deliver current-state assessments, target architectures, integration patterns, data models, migration plans, estimates, and technical decision records.
  • Develop and maintain data pipelines, ensuring efficient ETL processes for structured and unstructured data.
  • Apply dimensional modeling best practices to create robust, scalable data models for analytics and reporting.
  • Use Python, dbt, and SQL to develop data transformation and integration processes.
  • Optimize data storage and retrieval mechanisms for high-performance analytics workloads.
  • Define approaches for access, sensitive data, data quality, lineage, deployment, monitoring, recovery, and capacity or cost.
  • Define hybrid analytics requirements, including connectivity and security, in partnership with cloud and security specialists.
  • Monitor and troubleshoot data pipelines and workflows to ensure accuracy, reliability, and performance.
  • Collaborate with analytics and BI teams to integrate 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.

Benefits

  • Compensation and benefits package for eligible employees.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service