
Data Solution Architect
Posted 1 day ago

Posted 1 day ago
This is a fully remote position, open to applicants in Illinois, +3 more states.
• 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.
• 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.
• Baker Tilly provides a compensation and benefits package to eligible employees.
Ricoh UK
Keenfinity Group
Code Metal
Ramp
Get handpicked remote jobs straight to your inbox weekly.