Baker Tilly

Data Solution Architect

Baker Tilly
Apply
2 days ago
Remote, United States +3 moreStaff+

Base Salary

$100k - $182k/yr

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 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 and ETL processes for structured and unstructured data.
  • Apply dimensional modeling practices to create scalable data models for analytics and reporting.
  • Use Python, dbt, and SQL to develop data transformation and integration processes.
  • Optimize data storage and retrieval for high-performance analytics workloads.
  • Define approaches for access, sensitive data, quality, lineage, deployment, monitoring, recovery, capacity, and cost.
  • Define hybrid analytics requirements, including connectivity and security, with cloud and security specialists.
  • 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 current with data engineering and cloud analytics trends.

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 delivery teams.
  • 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.
  • Strong understanding of dimensional modeling for analytics.
  • Strong problem-solving skills focused on scalable and efficient solutions.
  • Excellent communication and collaboration skills with client-facing experience.
  • Experience with Azure Cloud infrastructure, including hybrid analytics workload configurations and networking, is preferred.
  • Azure engineering or administration certifications, including Fabric Data Engineer Associate, Azure Administrator Associate, or Azure Solutions Architect Expert, are preferred.
  • Experience with Azure DevOps or GitHub for code repositories and deployment is preferred.
  • Experience with data vault modeling and data mesh architecture concepts is preferred.
  • Familiarity with advanced analytics tools and machine learning workflows is preferred.
  • Experience using approved AI-assisted development tools responsibly is preferred.
  • Knowledge of Tableau, Qlik, or AWS QuickSight is preferred.
  • Experience with Agile methodologies for project management is preferred.

Benefits

  • Baker Tilly offers a compensation and benefits package to eligible employees.
  • The posting asks candidates to discuss work location status and requirements with a Baker Tilly talent acquisition professional.

Tech Stack

Categories

Solutions Engineering
Baker Tilly

About Baker Tilly

10,000+ employees

Baker Tilly provides audit/assurance, tax, and advisory services—including analytics, governance risk and compliance, and government contracting—to companies, public sector entities, and nonprofits. Headquartered in Chicago and organized as a partnership, it operates coast to coast in the U.S. and is an independent member of Baker Tilly International, with U.S. attest services delivered by Baker Tilly US, LLP and tax and advisory by Baker Tilly Advisory Group, LP.

Contact me