Crossroads ยท 3 hours ago
Data Solutions Architect/Engineer
Crossroads Treatment Centers is dedicated to providing high-quality, evidence-based treatment for opioid use disorder. The Data Solutions Architect/Engineer will design, build, and optimize data pipelines and analytical solutions to empower business decision-making, focusing on Azure Data Factory and SQL Managed Instances.
Health Care
Responsibilities
Design, maintain code for, and implement scalable data pipelines using Azure Data Factory and Fabric to integrate and transform data from disparate sources
Integrate structured and unstructured data from various sources, including cloud, on-premises, and third-party APIs
Design, implement, and optimize query performance, data processing efficiency, and data models for Power BI reporting within Azure/Fabric stack
Ensure data quality, governance, and security across all data assets
Deliver complex projects on time, proactively identifying and mitigating gaps and/or risks
Collaborate with stakeholders to understand data requirements and translate them into effective solutions. Support Data Analytics team members to ensure quality and end-user satisfaction
Manage data integration and ETL/ELT processes, including centralized logging and alerting
Utilize Azure DevOps and CI/CD principles for data pipeline management, deployment, version control, and configuration changes
Diagnose and resolve application bottlenecks, performance issues, and production support issues via proactive identification, performance tuning, and root cause analyses for data-related issues
Combine a deep understanding of Microsoft technologies with experience to define and implement data architecture strategies that align with business goals and technology roadmaps
Create and maintain technical and functional documentation for solutions, including technical specifications, test plans, transformations, training materials, and team best practices
Foster a problem-solving culture that resolves issues timely and through collaboration
Qualification
Required
BSc in Computer Science, Applied Data Science, Information Systems, Analytics, or equivalent with 10 years of experience
10 years of experience in data warehousing, data engineering, data modeling, and data pipelines required
5 years of experience in cloud-based data solutions (e.g., Azure, AWS, or GCP) required
Expertise in Microsoft SQL, Azure Cloud, Azure Data Factory, Fabric, Visual Studio, and Azure DevOps
Strong, demonstrated experience designing and implementing data integration and transformation solutions (i.e., data lakehouse architecture, ETL/ELT processes, CI/CD pipelines, and DevOps practices)
Strong understanding of data governance policies and procedures for managing, monitoring, and optimizing data pipeline and data warehouse performance
Strong analytical problem-solving ability with an initiative-taking approach to troubleshooting
Experience with Power BI or a comparable analytics/reporting platform required
Ability to make knowledgeable tradeoffs when translating resource and time constraints into design requirements
Excellent communication and collaboration skills to support an agile team in a fast-paced environment while maintaining high-quality standards
Benefits
Medical, Dental, and Vision Insurance
PTO
Variety of 401K options including a match program with no vesture period
Life Insurance
Short/Long Term Disability
Paid maternity/paternity leave
Mental Health Day
*Calm*subscription for all employees
Company
Crossroads
Since 2005, Crossroads has been at the forefront of treating patients with substance use disorder (SUD).
H1B Sponsorship
Crossroads has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2024 (1)
Funding
Current Stage
Late StageTotal Funding
unknown2015-01-08Private Equity
Recent News
Behavioral Health Business
2025-10-28
Behavioral Health Business
2025-10-04
2025-09-12
Company data provided by crunchbase