Data Solutions Architect / Engineer

Crossroads; Chicago (IL); Remote; USD 90,000 - 130,000; Full time

Job summary

A leading addiction treatment provider, Crossroads is hiring for a remote Data Solutions Architect. The role involves implementing data analytics solutions and optimizing Azure technologies while supporting the data and analytics teams. The ideal candidate will have strong experience in data architecture and analytics, with opportunities for professional growth and a supportive work culture.

Benefits

Medical, Dental, and Vision Insurance

401K options with matching

Annual Continuing Education Allowance

Life Insurance

Short / Long Term Disability

Paid maternity / paternity leave

Mental Health Day

Loan repayment assistance program

Qualifications

• 5-7 years of experience required.
• Strong knowledge of data analytics and architecture.
• Experience with cloud data solutions and programming languages.

Responsibilities

• Implement end-to-end data analytics solutions for complex environments.
• Drive design and deployment of data workloads in Azure.
• Code data scripts and build ETL/ELT pipelines.

Skills

Data architecture

Data warehousing

Data integration

Data analysis

Reporting

Problem-solving

Agile teamwork

Education

BS in Computer Science

Applied Data Science Analytics

Business Administration

Tools

SQL Server

AzureSQL Database

Azure Synapse Analytics

Power BI

Python

Job description

Crossroads Treatment Centers is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.

Crossroads is a leading addiction treatment provider of outpatient medication-assisted treatment (MAT). We treat patients with opioid use disorder (OUD) using medications such as methadone and suboxone / buprenorphine. We pride ourselves in supporting our patients’ medical and personal recoveries from substance use disorder. Starting our fight against the opioid addiction crisis in 2005, Crossroads has remained physician led and patient focused as we’ve grown to 100+ clinics across nine states. As an equal opportunity employer, we celebrate diversity and are committed to an inclusive environment for all employees and patients.

Implement end-to-end data analytics solutions for large-scale, complex environments.

Support Enterprise Data & Analytics team members to ensure quality and end-user satisfaction.

Translate requirements into a technical design leveraging existing tools, services, and frameworks.

Deliver complex projects on-time, proactively identifying and mitigating gaps and / or risks.

Combine a deep understanding of Azure technologies with experience to match an architecture with a roadmap, timeline, and level of effort.

Use a deliberate, methodical approach to solving problems.

Drive design and deployment of the data and analytics workloads in Azure and optimize consumption of the platform by providing architectural (including, design, implementation, and deployment) guidance, within the current framework / model, and provide appropriate recommendations to overcome blockers.

Assist with the installation and configuration of data infrastructure and analytic tools / platforms.

Migrate large data from multiple legacy systems and translate to current ready-to-use data.

Code appropriate data scripts and build ETL / ELT pipelines.

Lead creation of collateral including reference implementations and best practices.

Foster a problem-solving culture that resolves issues through collaboration and partnerships with other parts of the organization.

Partner with company leaders and support key stakeholders and company departments by teaming on special projects.

Be an effective technical mentor to more junior level teammates.

This position is remote but may require travel to corporate as needed

BS in Computer Science, Applied Data Science Analytics, Business Administration, or equivalent with 5-7 years of experience.

Strong knowledge of data architecture, data warehousing, business intelligence, data integration, data analysis, reporting, and / or machine learning.

Experience in the design and development of cloud data solutions including data lake storage, relational data, semi-structured data, streaming data, and event-driven processing.

Hands-on experience with SQL Server, AzureSQL Database, and / or Azure Synapse Analytics required.

Hands-on experience with SQL, Python, Oracle, or similar programming languages required.

Experience with Power BI or a comparable analytics / reporting platform required.

Exposure to large data analysis and conversion.

Experience integrating internal and third-party services into solutions.

Strong analytical problem-solving ability. Experience with AI / ML and integrating algorithms into reporting is preferred.

Ability to make knowledgeable tradeoffs when translating resource and time constraints into design requirements.

Ability to work as part of an agile, collaborative team in a fast-paced environment.

Medical, Dental, and Vision Insurance

Variety of 401K options including a match program with no vesture period

Annual Continuing Education Allowance (in related field)

Life Insurance

Short / Long Term Disability

Paid maternity / paternity leave

Mental Health Day

subscription for all employees

• Crossroads is a STAR (Substance Use Disorder Treatment and Recovery) approved organization. This means our clinicians will have access to help pay off federal student loans so they can focus on what they do best : patient care!
• Please see the website at

Apply to the Substance Use Disorder Treatment and Recovery Loan Repayment Program | Bureau of Health Workforce