Remote Jr Sql Developer

The primary responsibility of the Senior BI Developer is to analyze and deliver datasets in response to faculty healthcare data requests. The Senior BI Developer will contribute to Compass’ mission of serving the Anschutz research community within a HIPAA-compliant environment. The Senior BI Developer will support and mentor the data delivery team, as well as support health care investigators, faculty, and staff, internal and external to Compass. A successful Senior BI Developer candidate will own and drive requests and projects to completion, communicate expectations, be a creative problem solver, and write documentation clearly and concisely.

Supervision Received: This position will report to the Data Request Program Manager

Supervision Exercised: None

Examples of Work Performed:

• Contributes to data delivery process optimization and organizational policy refinement.
• May facilitate, process, and/or escalate user requirements for data and infrastructure in the Compass Google Cloud Platform, following organizational policies and procedures.
• Helps troubleshoot data quality concerns and helps validate novel data sources.
• Independently writes and delivers SQL queries to create high-quality data sets or data marts. The Senior BI Developer executes assigned data requests within scope, quality, and targeted timeline for delivery. As necessary the Senior BI Developer will identify and communicate data anomalies.
• Supports the team by conducting code reviews, mentoring more junior BI Developers, and disseminating knowledge to peers.
• Conducts accurate and timely documentation of project effort and status using the Compass case management system.
• Strives for positive customer experiences as determined by project completion surveys and customer interviews. The Senior BI Develop demonstrates strong reliability and responsiveness by communicating internally and externally within 24 business hours.
• Schedules and coordinates meetings with faculty or study teams as necessary to discuss data requests.
• Works closely with Compass Data Analyst for data requests where Compass Data Analyst leads customer engagement, scoping, and request documentation. For projects without an assigned Compass Data Analyst the Senior BI Developer will fulfill this role and communicate directly with clinicians or researchers.

This description is a summary only and describes the general level of work being performed, it is not intended to be all-inclusive. The duties of this position may change from time to time and/or based on business needs. We reserve the right to add or delete duties and responsibilities at the discretion of the supervisor and/or hiring authority.

Work Location:

Remote – this role is eligible to work remotely, but the employee must be in the United States.

Why Join Us:

Health Data Compass (Compass) is the technology innovation arm of the Research Informatics Office. Compass maintains, develops, and innovates within a data integration and analytics platform on cutting-edge, cloud-based technologies to support biomedical research and clinical excellence throughout the CU research enterprise and our hospital partners.

The University of Colorado offers a comprehensive benefits package that includes health insurance, life insurance, retirement plans, tuition benefits, ECO pass, paid time off – vacation, sick, holidays and more. To see what benefits are available, please visit: https://www.cu.edu/employee-services/benefits-wellness.

Diversity and Equity:

The University of Colorado Anschutz Medical Campus is committed to recruiting and supporting a diverse student body, faculty, and administrative staff. The university strives to promote a culture of inclusiveness, respect, communication and understanding. We encourage applications from women, ethnic minorities, persons with disabilities, persons within the LGBTQ+ community and all veterans. The University of Colorado is committed to diversity and equality in education and employment.

Qualifications:

Minimum Qualifications:

• Bachelor’s degree in a health science-related field (e.g., biostatistics, epidemiology, etc.) or technology (e.g., computer science, engineering, etc.), or a related field from an accredited institution.
• At least four (4) years of professional-level experience in a healthcare-related environment working with enterprise data warehouses, including data profiling, data quality assessments, data analysis/reporting, data set curation, or equivalent experience.
• At least two (2) years of SQL programming expertise.

Applicants must meet minimum qualifications at the time of hire.

PLEASE NOTE: Candidates will be responsible for travel expenses related to the interview process and any relocation expenses, if applicable.

Preferred Qualifications:

• Experience in standardized clinical code systems (e.g., SNOMED CT, LOINC, RxNorm) and common data models (OMOP).
• Experience with data manipulation languages (e.g., SAS, R, Python).
• Experience working with secure web platforms for building and managing databases (e.g., REDCAP).
• Advanced BI Developer skills.
• Master’s degree in a health science-related field (e.g., biostatistics, epidemiology, etc.) or technology (e.g., computer science, engineering, etc.), or a related field from an accredited institution.
• Epic Certified in Caboodle Data Model, Clarity Data Model, and/or Clinical Data Model.
• Experience managing terminology mapping documentation, data profiling, and data mapping documentation.

Competencies/Knowledge, Skills, & Abilities:

• Ability to support the development of BI dashboards and reports, and data analytic initiatives.
• Experience working within HIPAA-compliant and other sensitive data environments.
• Experience working in an academic core service or support service.
• BI developer skills (e.g., Tableau reports, Power BI).
• SQL skills for querying data (especially for cloud computing).
• Excellent written and oral communication skills.
• Strong analytical skills, critical thinking, attention to detail and accuracy, and strong interpersonal skills.
• Excellent customer service skills.
• Extensive experience with clinical data (e.g., Epic proficiencies or certifications).