Sign upLog in
JobsJobs in WisconsinJobs in Milwaukee, WIIT Jobs in Milwaukee, WIIT Architect Jobs

Data Solution Architect

Baker Tilly Advisory Group, LP

Milwaukee, Wisconsin

Apply
JOB DETAILS
SKILLS
Accounting, American Institute of Certified Public Accountants (AICPA), Applicant Tracking System, Bakery, Best Practices, Business Intelligence, Business Services, Certified Public Accountant (CPA), Cloud Computing, Communication Skills, Customer Relations, Customer Support/Service, Data Analysis, Data Management, Data Modeling, Data Recovery, Data Storage, Database Extract Transform and Load (ETL), DevOps, Dimensional Modeling, Ecosystems, Emerging Technology, Facebook, GitHub, Identify Issues, LinkedIn, Machine Learning, Microsoft Product Family, Microsoft Windows Azure, Network Configuration Management, Network Security, Performance Analysis, Power BI, Problem Solving Skills, Professional Services, Python Programming/Scripting Language, Recruiting/Staffing Agency, Regulations, SQL (Structured Query Language), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Software Engineering, Structured Data, Team Player, Trend Analysis, Unstructured Data
LOCATION
Milwaukee, Wisconsin
POSTED
1 day ago
Overview

Baker Tilly is a leading advisory, tax and assurance firm, providing clients with a genuine coast-to-coast and global advantage in major regions of the U.S. and in many of the world's leading financial centers - New York, London, San Francisco, Los Angeles, Chicago and Boston. Baker Tilly Advisory Group, LP and Baker Tilly US, LLP (Baker Tilly) provide professional services through an alternative practice structure in accordance with the AICPA Code of Professional Conduct and applicable laws, regulations and professional standards. Baker Tilly US, LLP is a licensed independent CPA firm that provides attest services to its clients. Baker Tilly Advisory Group, LP and its subsidiary entities provide tax and business advisory services to their clients. Baker Tilly Advisory Group, LP and its subsidiary entities are not licensed CPA firms.

Baker Tilly Advisory Group, LP and Baker Tilly US, LLP, trading as Baker Tilly, are independent members of Baker Tilly International, a worldwide network of independent accounting and business advisory firms in 141 territories, with 43,000 professionals and a combined worldwide revenue of $5.2 billion. Visit bakertilly.com or join the conversation on LinkedIn, Facebook and Instagram.

Please discuss the work location status with your Baker Tilly talent acquisition professional to understand the requirements for an opportunity you are exploring.

Baker Tilly is an equal opportunity/affirmative action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability or protected veteran status, gender identity, sexual orientation, or any other legally protected basis, in accordance with applicable federal, state or local law.

Any unsolicited resumes submitted through our website or to Baker Tilly Advisory Group, LP, employee e-mail accounts are considered property of Baker Tilly Advisory Group, LP, and are not subject to payment of agency fees. In order to be an authorized recruitment agency ("search firm") for Baker Tilly Advisory Group, LP, there must be a formal written agreement in place and the agency must be invited, by Baker Tilly's Talent Attraction team, to submit candidates for review via our applicant tracking system.

Job Description:


Key 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 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.

Required Qualifications:
  • 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.

Preferred Qualifications:
  • 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

About the Company

B

Baker Tilly Advisory Group, LP

Resume Resources

Free Resume TemplatesFree Resume Builder

Similar Job Searches

Data Modeler Jobs in Milwaukee, WIStructural Engineer Jobs in Milwaukee, WI