Data Solution Architect

Baker Tilly US; Frisco (TX); On-site; USD 123,840 - 234,770; Full time

Job summary

Baker Tilly US is hiring for a data engineering role in Frisco, Texas. The successful candidate will have over ten years of experience in the Microsoft Analytics stack and a strong proficiency in SQL and Python.

This position involves designing scalable data solutions, developing robust data pipelines, and integrating data assets into Power BI. Compensation for the role ranges from $123,840 to $234,770 based on relevant factors.

Qualifications

• 10+ years experience in data engineering with Microsoft Analytics stack.
• Strong proficiency in SQL, Python, and data modeling techniques.
• Experience with ETL tools and frameworks such as dbt.

Responsibilities

• Design and implement data engineering solutions with Microsoft Analytics.
• Develop and maintain data pipelines for ETL processes.
• Collaborate with analytics and BI teams for seamless integration.

Skills

SQL

Python

Data modeling techniques

ETL processes

Dimensional modeling

Problem-solving skills

Collaboration and communication skills

Tools

Azure Cloud

dbt

Power BI

Tableau

GitHub

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 of additional data visualization tools such as Tableau or Qlik.
• Experience with Agile methodologies for project management.

Compensation

The pay rate range for this job position is $123,840 to $234,770. Actual compensation is influenced by a variety of relevant factors including but not limited to applicant’s skills, prior experience, qualifications, degrees, professional certifications, work arrangements and geographic location.

Equal Opportunity Employer

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.