Data Solution Architect
Madison, OH - USA
Job Summary
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 worlds 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 43000 professionals and a combined worldwide revenue of $5.2 billion. join the conversation onLinkedInFacebookandInstagram.
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 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 Tillys Talent Attraction team to submit candidates for review via our applicant tracking system.
As a Data Solutions Architect 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 the development and explain technical decisions and tradeoffs to client stakeholders. Your work will span data integration storage modeling governance and analytics across modern data platforms in Azure.
Key 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 is 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 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.
- 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 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:
- 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 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 and Administration (e.g. Fabric Data Engineer Associate Azure Administrator Associate 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 preferred.
- Familiarity with advanced analytics tools and concepts including machine learning workflows.
- Experience using approved AI-assisted development tools responsibly preferred.
- Knowledge of additional data visualization tools such as Tableau Qlik or AWS Quicksight.
- Experience with Agile methodologies for project management.
Required Experience:
Staff IC
About Company
Baker Tilly in Kuwait is an international accounting and auditing firm that provides independent professional services in assurance, tax, consulting and training, serving different business sectors and industries. In Baker Tilly, we influence and are influenced by all the elements su ... View more