Search jobs > Pittsburgh, PA > Solution architect

Data Solutions Architect/Engineer

Crossroads
Pittsburgh, PA
Full-time

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, Azure SQL 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

29 days ago
Related jobs
Promoted
PWC
Pittsburgh, Pennsylvania

Leading the design of improved data flows, data architecture, and data solutions in partnership with the subject matter experts and client counterparts / team members;. We help implement and effectively use broad technology offerings including Oracle Analytics and Data solutions along with enhanced ...

Promoted
GAC Solutions
Pittsburgh, Pennsylvania

Someone who worked end to end implementation of Snowflake cloud data warehouse. ...

Crossroads
Pittsburgh, Pennsylvania

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. Strong knowledge of data architecture, data warehousing, business intelligence, data integration, data analysis, reporting...

Promoted
GAC Solutions
Pittsburgh, Pennsylvania

Who can provide Data Engineer solutions using tools such as Databricks, Azure, Apache and Spark Manage end to end delivery by Investigating problem areas, working cross-functionally with product manager & other stakeholders. Looking for Azure Data Engineer who has ample experience working on Databri...

PNC Bank NA
Pittsburgh, Pennsylvania

Consulting, Data Architecture, Database Structures, Data Warehousing, IT Architecture, Logical Data Modeling, Organizational Leadership, Problem Solving, Requirements Analysis. Designs, develops and optimizes highly complex, specialized data warehouses, with flexible and scalable data and ETL archit...

Simple Solutions
Pittsburgh, Pennsylvania

Machine Learning EngineerData Scientist - Hybrid Day 1. As a Data Scientist you will be working in one of the most complex data environments in healthcare. We are looking for talented and experienced Machine Learning Engineers/Data Scientists who can apply innovative Machine Learning techniques t...

E-Solutions
Pittsburgh, Pennsylvania

Build processes supporting data transformation, data structures, metadata, dependency and workload management. Title - Snowflake Data Architect. Must have experience at least two end to end implementation of Snowflake cloud data warehouse and 3 end to end data warehouse implementations on-premise pr...

E-Solutions
Pittsburgh, Pennsylvania

Implement scalable and sustainable data engineering solutions using tools such as Databricks, Azure, Apache Spark, and Python. Experience handling large and complex sets of data from various sources and databases. Solid grasp of database engineering and design principles. At least two years of exper...

Promoted
InsideHigherEd
Pittsburgh, Pennsylvania

The data analyst will expand data availability in the college, playing a significant role in making sure that data and information produced is delivered accurately and efficiently. Able to clean, debug, and analyze complex datasets that link data from a variety of sources and rapidly create ad hoc d...

Promoted
McGuireWoods LLP
Pittsburgh, Pennsylvania

McGuireWoods is seeking a Data Analyst to join the Data Analytics team. Perform data analysis using Python (or RStudio) to extract actionable insights from complex datasets. The first one involves the client-facing and client-billable data analytics work. Develop and maintain robust ETL pipelines, l...