Analytics Developer - New York, United States - Columbia University

Columbia University

Verified Company

New York, United States

3 weeks ago

Posted by:

Mark Lane

beBee recruiter

Description

Job Type:
Officer of Administration

Bargaining Unit:
Regular/Temporary: Regular
End Date if Temporary:

Hours Per Week: 35

Standard Work Schedule:
Building:
Salary Range: $85,000$100,000.00
The salary of the finalist selected for this role will be set based on a variety of factors, including but not limited to departmental budgets, qualifications, experience, education, licenses, specialty, and training. The above hiring range represents the University's good faith and reasonable estimate of the range of possible compensation at the time of posting._

Position Summary

Under the direction of the Assistant Director of Clinical Research Analytics, the Analytics Developer - Anesthesiology will serve as a Clinical Data Navigator (CDN) for the Department of Anesthesiology and will be active in investigating the analytic needs of the Anesthesiology department.

This position will require the individual to design, create, and maintain data structures, reports, dashboards, and related data extracts from various institutional data sources such as Epic and CUIMC's legacy electronic health records.

This individual must be proficient in SQL coding, the use of institutional business intelligence tools, related data models, and best practices for data warehousing.

In addition to development work, this position requires the individual to work with end-users to understand analytic needs and both scope and document technical specifications for requests.

This role will require the individual to provide status updates, set user expectations, and generally demonstrate the ability to explain technical solutions to others.

This individual must be team oriented and possess strong customer service, communication, problem solving, and critical thinking skills.

Hybrid Schedule:
Subject to business needs, we may support flexible and hybrid work arrangements. Options will be discussed during the interview process.

Responsibilities:

-
Database Development: Proficiently uses MS SQL Server for queries and designing tables. (40%)
-
Project Management and Technical Writing: Scopes, develops, distributes, and provides support for content in a timely manner. Takes ownership of assigned incidents and requests by performing in-depth analysis and creating detailed specification forms. Prioritizes multiple requests and maintains a support relationship with all users. (20%)
-
Data Compliance and Best Practices: Maintains knowledge of internal and industry-wide policies, standards, and best practices, including HIPAA, IRB, and data governance policies and procedures to ensure all deliverables meet those standards. (5%)
-
Continuous Improvement: Seeks out additional training to improve skills in the team's technologies and new technologies, and to improve soft skills for better client and team relations. (5%)
-
Other Duties: Other duties as assigned. (5%)

Minimum Qualifications

Bachelor's degree in Computer Science, Analytics, Information Systems, Statistics, Health Informatics, or a similar discipline.
Three years of related fulltime work experience; significant relevant experience may substitute for a degree.
Proficiency in MS SQL, including relational database design and the use of T-SQL, subqueries, and window functions.
Epic Cogito, Caboodle, Clarity, and Clinical Data Model certification (or certification within six months of employment).
Excellent decision making, critical thinking, and problemsolving skills.
Strong organizational and technical documentation skills with an emphasis on communication, detail, and followup.

Preferred Qualifications

One year of report development experience utilizing Epic's database data structures.
Experience with Power BI and/or other popular BI tools.
Experience with reporting on AllScripts data.
Experience with common clinical data coding standards (ICD, CPT, LOINC, RxNorm, etc) and workflows.

Other Requirements

Equal Opportunity Employer / Disability / Veteran

Columbia University is committed to the hiring of qualified local residents.