Data Solutions Architect/Engineer

Crossroads Treatment Centers • Greenville, SC

16h • Remote

About The Position

Crossroads Treatment Centers is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. Since 2005, Crossroads has been at the forefront of treating patients with opioid use disorder. Crossroads is a family of professionals dedicated to providing the most accessible, highest quality, evidence-based medication assisted treatment (MAT) options to combat the growing opioid epidemic and helping people with opioid use disorder start their path to recovery. This comprehensive approach to treatment, the gold standard in care for opioid use disorder, has been shown to prevent more deaths from overdose and lead to long-term recovery. We are committed to bringing critical services to communities across the U.S. to improve access to treatment for over 26,500 patients. Our clinics are all outpatient and office-based, with clinics in Georgia, Kentucky, New Jersey, North and South Carolina, Pennsylvania, Tennessee, Texas, and Virginia. As an equal opportunity employer, we celebrate diversity and are committed to an inclusive environment for all employees and patients. Day in the Life of a Data Solutions Architect/Engineer Crossroads’ Enterprise Data & Analytics is a team whose mission is to enable faster, optimized decisions for the entire business. We do this by collaboratively designing solutions and generating insights to cross-functional business problems. We focus on data, reporting, and analytical solutions to drive stronger, strategic decision-making. The Data Solutions Architect/Engineer is responsible for designing, building, and optimizing data pipelines and analytical solutions that empower business decision-making. This role will focus on developing and maintaining Azure Data Factory pipelines, SQL Managed Instances, integrating disparate data sources to support a data-driven organization. The Data Solutions Architect/Engineer will partner with Analytics’ team members to solve complex data challenges while designing and implementing data processing and transformation-at-scale, being accountable for the end-to-end development experience. 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. Location This role can be remote but will need to travel into the corporate office as needed (Greenville, SC).

Requirements

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

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.

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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 1-10 employees