Data Solution Architect

Posted 1 day ago

This is a fully remote position, open to applicants in Illinois, +3 more states.

📋 Description

• Oversee the design of secure, reliable, and cost-effective data and analytics solutions for clients.

• Convert business objectives and existing system limitations into target architectures.

• Support engineering teams throughout implementation while being actively involved in development.

• Articulate technical decisions and trade-offs to client stakeholders effectively.

• Partner with clients and internal teams to design and deploy scalable data engineering solutions utilizing the Microsoft Analytics ecosystem.

• Lead discovery processes, select architectural patterns, document trade-offs, guide implementations, and take responsibility for the overall technical design.

• Provide current-state assessments, target architectures, integration patterns, data models, migration plans, estimates, and records of technical decisions.

• Create and manage data pipelines for both structured and unstructured data, ensuring efficient ETL processes.

• Implement dimensional modeling best practices to develop robust, scalable data models for analytics and reporting.

• Employ Python, dbt, and SQL to design advanced data transformation and integration processes.

• Enhance data storage and retrieval mechanisms for optimal performance in analytics workloads.

• Establish strategies for access, sensitive data handling, data quality, lineage, deployment, monitoring, recovery, and capacity or cost management.

• Define hybrid analytics requirements, including connectivity and security, in collaboration with cloud and security experts.

• Monitor and troubleshoot data pipelines and workflows to ensure accuracy, reliability, and performance.

• Work with analytics and BI teams to incorporate data assets into Power BI and other reporting platforms.

• Keep abreast of emerging trends and technologies in data engineering and cloud analytics.


⛳️ Requirements

• A minimum of 10 years of experience in data engineering, with a strong focus on the Microsoft Data and Analytics stack.

• Several years of experience leading discovery, assessing design trade-offs, offering recommendations, and mentoring a delivery team.

• High proficiency in SQL, Python, and data modeling techniques.

• Practical 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.

• Exceptional problem-solving abilities with an emphasis on delivering scalable and efficient solutions.

• Strong communication and collaboration skills, with experience in client-facing positions.

• Preferred: Familiarity with Azure Cloud infrastructure, including hybrid analytics workload configurations and networking.

• Preferred: Certifications in Azure Engineering and Administration (e.g., Fabric Data Engineer Associate, Azure Administrator Associate, Azure Solutions Architect Expert).

• Preferred: Experience with Azure DevOps or GitHub for code repositories and deployment processes.

• Preferred: Knowledge of data vault modeling and data mesh architecture concepts.

• Preferred: Understanding of advanced analytics tools and concepts, including machine learning workflows.

• Preferred: Experience responsibly utilizing approved AI-assisted development tools.

• Preferred: Proficiency in additional data visualization tools such as Tableau, Qlik, or AWS Quicksight.

• Preferred: Familiarity with Agile methodologies for project management.


🏝️ Benefits

• Baker Tilly provides a compensation and benefits package to eligible employees.

People also viewed

Ricoh UK6 hours ago

Senior Solutions Engineer

US flagUnited States OnlyFull-timeSolutions Engineer$80.3k – $85k/year
ApplyView job
Keenfinity Group6 hours ago

Technical Solutions Engineer

US flagNew York OnlyFull-timeSolutions Engineer$100k – $115k/year
ApplyView job
Code Metal6 hours ago

Solutions Architect, Financial Services

US flagUnited States OnlyFull-timeSolutions Engineer$214k – $290k/year
ApplyView job
Ramp6 hours ago

Solutions Consultant, Post Sales, Strategic

US flagUnited States OnlyFull-timeSolutions Engineer
ApplyView job
Temporal Technologies6 hours ago

Staff Solutions Architect, Digital Native

US flagUnited States OnlyFull-timeSolutions Engineer$168k – $220k/year
ApplyView job
Wavestone6 hours ago

Senior AI Solutions Consultant

RO flagRomania OnlyFull-timeSolutions Engineer
ApplyView job

Never miss a great job!

Get handpicked remote jobs straight to your inbox weekly.

Trusted by 7,400+ designers