> Markdown version of [/jobs/ext/4795444-data-solution-architect](https://www.wearedevelopers.com/jobs/ext/4795444-data-solution-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Solution Architect - **Company:** The Baker - **Location:** Madison, AL, United States - **Experience:** Expert - **Salary:** $100,000 - $182,400 - **Contract:** Permanent contract - **Skills:** Adaptable Database Systems, Agile Methodology, Amazon Web Services, Business Analytics Applications, Data Analysis, Microsoft Azure, Information Engineering, Data Infrastructure, Data Integration, Extract Transform Load (ETL), Data Transformation, Data Mining, Data Systems, Data Vault Modeling, Data Visualization, Dimensional Modeling, Github, Python (Programming Language), Microsoft Data Access Components, Power BI, Data Mesh, SQL Databases, Tableau (Software), Unstructured Data, Software Repository, Data Storage Management, Qlikview, Machine Learning Operations, Tools for Reporting, Data Pipelines - **Published:** November 20, 2026 - **Apply:** https://www.dice.com/job-detail/73d3e523-3203-42ac-9d9c-247bab015461 ## About the Role * 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., * 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. ## Description 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., * 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.