Senior Data Solutions Architect: Azure & Analytics

Baker Tilly Advisory Group, LP

Madison (WI)

On-site

USD 100,000 - 182,000

Full time

3 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Baker Tilly (US) seeks a seasoned Data Solutions Architect to lead secure, reliable data and analytics design for client engagements. You will translate business goals into target architectures, guide engineering teams, and remain hands-on in development across Azure-based data platforms.

Responsibilities include delivering current-state assessments, target architectures, ETL pipelines, and governance for analytics, with a focus on Power BI integration and scalable data models.

Qualifications

  • 10+ years of experience in data engineering with deep expertise in the Microsoft Data and Analytics stack.
  • Proven track record 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 such as dbt.
  • Solid understanding of dimensional modeling and its application in 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.
  • Lead discovery, select architecture patterns, document tradeoffs, guide implementations, and be 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 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 to support high-performance analytics workloads.
  • Define approaches for access, data quality, lineage, deployment, monitoring, and cost.

Skills

SQL
Python
Data modeling
Dimensional modeling
Architectural leadership
Communication
Analytics design

Tools

dbt
Azure DevOps
GitHub

Job description

Baker Tilly (US) seeks a seasoned Data Solutions Architect to lead secure, reliable data and analytics design for client engagements. You will translate business goals into target architectures, guide engineering teams, and remain hands-on in development across Azure-based data platforms.

Responsibilities include delivering current-state assessments, target architectures, ETL pipelines, and governance for analytics, with a focus on Power BI integration and scalable data models.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Engineer - Azure & Fabric
Senior Data Engineer - Azure & Fabric

Baker Tilly • Chicago (IL)

On-site
USD 86,000 - 163,000
Associate Data Engineer — Azure Data, AI & Cloud
Associate Data Engineer — Azure Data, AI & Cloud

Baker Tilly International • Madison (WI)

On-site
USD 86,000 - 163,000
Associate Data Engineer: Azure Data & AI Pipelines
Associate Data Engineer: Azure Data & AI Pipelines

Baker Tilly Advisory Group • Madison (WI)

On-site
USD 86,000 - 163,000
Senior BI & AI Solutions Developer
Senior BI & AI Solutions Developer

BakerHostetler • Texas

On-site
USD 130,000 - 165,000
Competitive Salaries
Performance Bonus Program
Generous Time Off
+1
Data Solutions Architect - Power Platform & Azure
Data Solutions Architect - Power Platform & Azure

Associate Staffing • Atlanta (GA)

Hybrid
USD 120,000 - 160,000
Azure Solutions Architect: Data Analytics & Cloud Strategy
Azure Solutions Architect: Data Analytics & Cloud Strategy

TTEC Digital • Austin (TX)

On-site
USD 140,000 - 190,000
Medical, dental, and vision
Paid time off (PTO)
Wellness time off
Senior Data Architect: Azure Fabric & Data Platform Lead
Senior Data Architect: Azure Fabric & Data Platform Lead

Datavail Infotech • United States

On-site
USD 150,000 - 190,000
Azure Analytics & Data Architect for AI-Driven Cloud
Azure Analytics & Data Architect for AI-Driven Cloud

International Business Machines Corporation • Austin (TX)

On-site
USD 120,000 - 170,000
Associate Data Engineer
Associate Data Engineer

Baker Tilly • Chicago (IL)

On-site
USD 86,000 - 163,000
Senior BI Solutions Developer - Power BI & AI (Remote)
Senior BI Solutions Developer - Power BI & AI (Remote)

BakerHostetler • Los Angeles (CA)

Remote
USD 145,000 - 165,000
Competitive Salary
Bonus Program
Generous Time Off
+6