Solutions Architect (Contract)

Position Summary

The Solutions Architect is responsible for designing, building, and operating the data integration and analytics infrastructure that powers Sound Physicians’ enterprise reporting and decision-making. This individual serves as the primary technical owner of the pipelines, automation, and platform plumbing that move data between Snowflake, Microsoft Fabric, Azure services, and downstream dashboards consumed by clinical and operational stakeholders. Working alongside the Technology Services Director and in close partnership with data, analytics, and application teams, the Solutions Architect translates business requirements into durable, automated solutions.

This role owns the full delivery lifecycle from architecture and source control through CI/CD deployment, monitoring, and end-user enablement. This individual is accountable for the following platform domains: Snowflake data platform integration, Microsoft Fabric and Power BI infrastructure, Azure integration services (Logic Apps, Azure Data Factory, API Management), Git-based source control and Azure DevOps pipelines, and cloud automation and operational tooling as assigned by the Technology Services Director.

Essential Duties and Responsibilities

Solution Design & Architecture

• Design and architect end-to-end data integration solutions spanning Snowflake, Microsoft Fabric, Azure services, and downstream reporting surfaces.
• Develop and maintain a coherent integration architecture that prioritizes scalability, reusability, observability, and alignment with organizational data governance standards.
• Translate complex business and analytical requirements into technical specifications, data flow diagrams, and implementation plans.
• Define and govern integration patterns, naming conventions, branching strategies, and deployment standards across the data platform.
• Evaluate emerging tools and services including Azure-native PaaS, Snowflake features, and Fabric capabilities making recommendations that balance innovation with operational stability.
• Serve as a principal technical voice for data platform decisions, providing architecture guidance to peers and stakeholders.

Data Integration & Pipeline Engineering

• Build, configure, and maintain data pipelines and orchestration workflows that move and transform data between Snowflake, Microsoft Fabric, Azure Blob Storage, and other enterprise systems.
• Develop and maintain Azure Logic Apps, Azure Data Factory pipelines, and equivalent automation to support integration between cloud platforms and business applications.
• Implement infrastructure as code and pipeline-as-code practices using Azure DevOps, Git repositories, Bicep, ARM, or equivalent tooling.
• Manage CI/CD pipelines for data platform assets including Snowflake objects, Fabric datasets, Power BI reports, and Azure integration resources ensuring repeatable, auditable deployments.
• Design and implement data models, transformations, and quality checks within Snowflake and Fabric to support reliable downstream reporting.
• Develop reusable automation scripts and utilities in Python or PowerShell to reduce manual operational burden across the data platform.

Reporting & Dashboard Delivery

• Partner with data and analytics teams to deliver Power BI and Fabric dashboards that provide accurate, performant, and accessible insights to clinical and operational users.
• Ensure data flowing from source systems through transformation layers to Power BI is well-governed, documented, and trustworthy.
• Optimize data models and dataset refresh strategies to balance dashboard performance with infrastructure cost.
• Support end users and analytics colleagues by troubleshooting data discrepancies, pipeline failures, and dashboard issues.
• Define and maintain data lineage documentation so consumers understand the origin, transformation logic, and freshness of reported data.

Operations & Support

• Perform daily monitoring of integration pipelines, Snowflake tasks and streams, Fabric data flows, and Azure Logic App runs responding proactively to failures and anomalies.
• Implement alerting, logging, and observability practices to reduce mean time to detection and resolution across the data platform.
• Investigate and resolve issues across the integration stack, coordinating with impacted stakeholders and documenting root cause and resolution.
• Provide Tier 2/3 escalation support for data platform issues to analytics teammates and internal consumers.
• Work closely with IT Security to ensure all integration patterns and data flows adhere to HIPAA requirements and organizational security standards.
• Collaborate with application development teams to facilitate data integration needs across the application development lifecycle.
• Responsibilities may occasionally require working evenings or weekends, sometimes with limited advanced notice.
• Travel: 0–4 trips per year.
• Must be able to sit at a desk and work on a computer for extended periods (with breaks).

Source Control, DevOps & Governance

• Own and maintain Git repositories for all data platform assets including Snowflake scripts, Fabric workloads, Logic Apps, and supporting automation.
• Enforce branching strategies, pull request reviews, and deployment gates across the data platform’s Azure DevOps project.
• Contribute to and maintain architecture documentation, runbooks, pipeline diagrams, and operational procedures.
• Apply platform updates, SDK upgrades, and dependency patches on a regular cadence for both cloud-hosted and on-premises components.
• Perform periodic cost and performance reviews to support capacity planning and cloud spend optimization across Snowflake, Fabric, and Azure integration services.

Values 

• Strategic thinker: Demonstrates the ability to look at the big picture and proactively develop a plan of action
• Collaborative: Demonstrates the ability to work well with others to accomplish a goal and get the work done; takes opinions of others into consideration; includes others in the decision-making process
• Intellectually curious: Demonstrates a genuine interest in learning new things and wants to know the reason “why” behind the way things are done
• Committed: Demonstrates dedication to the job, project, organization, customer/clients and co-workers
• Resourceful: Proactive willingness to utilize available information and tools to figure things out

Knowledge, Skills, and Abilities 

• Excellent written and oral communication skills
• Snowflake — including data modeling, tasks, streams, dynamic tables, Snowpark, cost governance, and cross-platform integration
• Microsoft Fabric — including Lakehouses, Warehouses, Pipelines, Dataflows Gen2, Semantic Models, and capacity operations
• Power BI — including data modeling, DAX, DirectQuery/Import optimization, deployment pipelines, and gateway management
• Azure Integration Services — Logic Apps, Azure Data Factory, API Management, Event Grid, and Service Bus
• Azure DevOps — Pipelines (YAML), Repos, Boards, and release gate configuration
•  Working knowledge of Salesforce Data 360 (formerly Data Cloud) for integrating Snowflake
• Working knowledge of Salesforce Data API's 
• Infrastructure-as-code and automation — Bicep, ARM, PowerShell, Python, or equivalent scripting and CI/CD tooling
• Git source control — branching strategies, PR workflows, and repository governance in enterprise settings
• Microsoft Azure IaaS/PaaS — Virtual Networks, Azure Storage, Azure Functions, Log Analytics, and Azure Monitor
• Microsoft Entra ID — service principals, managed identities, conditional access, and app registrations for automated workloads
• Experience supporting 1,000+ user data environments across multiple business domains
• Working knowledge of Agile/Scrum or similar delivery frameworks
• Experience translating ambiguous business requirements into actionable technical specifications
• Maintains a positive, collaborative attitude when working with Technology Services teammates, data consumers, and external partners
• Able to interpret and communicate technical concepts, data flow logic, and platform recommendations clearly to both technical and non-technical audiences
• Partners effectively with analytics, data engineering, and application development teams to deliver integrated solutions
• Provides clear documentation so that others can understand, maintain, and extend the systems built by this role
• Regularly offers data-informed recommendations on integration architecture, pipeline design, and platform optimization

Education and Experience

• Minimum: Bachelor of Science degree with a technical major such as Computer Science, Information Systems, Data Engineering, or equivalent
• Minimum: 5 years of experience in solutions architecture, data engineering, or cloud platform engineering roles, with demonstrated experience building and operating production integration pipelines
• Microsoft Certified: Azure Data Engineer Associate — Preferred
• Microsoft Certified: Fabric Analytics Engineer Associate — Preferred

Pay Range

• $75.00 to $90.00 per hour. Exact pay will be determined based on candidate experience and geographic location