Offer summary

Qualifications:

5+ years of hands-on experience with SQL via SSMS/ADS., 3+ years of intermediate experience with Power BI and DAX., Strong knowledge of data visualization and reporting techniques., Proven ability to develop enterprise-level solutions and apply analytical problem-solving..

Key responsabilities:

Design and optimize database objects and reporting solutions.

Migrate and cleanse large data from multiple legacy databases.

Implement data governance practices and test for data integrity issues.

Communicate effectively with technical and nontechnical stakeholders.

Job description

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 Analyst

Design or optimize existing database objects, models, and reporting solutions.
Migrate large data from multiple legacy databases and translate to accurately segmented, cleansed, curated/formatted, ready-to-use data.
Synthesize data and implement data governance practices for enhanced reporting.
Test for data integrity issues, proactively identifying potential risks for data inconsistencies across data sources and/or reports.
Identify, recommend, and code appropriate scripts and collaboratively design, build, and test database objects (i.e., tables, stored procedures).
Participate in system change management processes to support existing solutions.
Construct and/or enhance data documentation as requested.
Communicate effectively with both technical and nontechnical stakeholders

Education and Licensure Requirements

5+ years of extensive, hands-on experience with SQL via SSMS/ADS. Exposure to large-scale data analysis, complex conversion, and related Azure SQL functions preferred.
3+ years of intermediate experience with Power BI. Must demonstrate a strong working knowledge of Power BI Desktop/Service and DAX. Sound knowledge of Power Platform.
Experience translating data into effective visualizations/reporting. Must demonstrate optimization with focus on usability, performance, flexibility, and standardization.
Proven ability to take initiative and apply a solution-oriented approach to analytical problem-solving. Demonstrated success in developing enterprise-level solutions.
End-to-end Business Intelligence architecture and analysis experience preferred.