Analytics Developer

Location: New York

Job Summary
:
Columbia University Irving Medical Center is seeking an Analytics Developer to enhance their analytical and reporting tools for the Primary Care and Population Health departments. The role involves designing data structures, developing SQL queries, and collaborating with stakeholders to translate business requirements into technical documentation.

Responsibilities
:

• Designs, develops, and maintains database objects using Microsoft SQL Server, and in future Snowflake, to support analytics and reporting needs.

• Engages with Primary Care and Population Health stakeholders to understand and clarify analytic and reporting needs.

• Uses Python to integrate, transform, and manipulate data from multiple internal and external data sources in support of analytics and reporting initiatives.

• Builds, enhances, and maintains client-facing business intelligence and reporting solutions using tools such as Power BI, Cognos, Excel, Epic’s proprietary reporting and analytics tools, and other supported applications.

• Manages multiple tasks simultaneously keeping sponsoring departments and team members updated on progress.

• 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.

• 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.

• Other duties as assigned.

Qualifications
:
Required
:

• Bachelor’s degree or equivalent in education and experience plus three years of experience.

• Demonstrated proficiency in writing, optimizing, and troubleshooting SQL queries in a relational database environment (e.g., MS SQL Server, Oracle, Snowflake, or other databases).

• Experience using data to support reporting, analytics, and decision-making for business or operational stakeholders.

Preferred
:

• Bachelor’s degree in computer science, statistics, information systems, or similar discipline.

• Epic clinical or revenue cycle certification (or certification within 6 months of employment).

• Proficiency in Python scripting.

• Excellent decision making, critical thinking, and problem-solving skills.

• Experience with administrative and/or operational data and reporting.

• Experience with Power BI, Cognos, and/or other Business Intelligence tools.

• Strong organizational skills with an emphasis on communication, detail, and follow-up.

• Experience with Epic or other EHR systems and the operations of a healthcare organization.

• Experience with other scripting languages for data analysis.

• Experience with Snowflake.

Company
:
Columbia University Irving Medical Center is a clinical and educational enterprise that offers medical, dental, and nursing services. It is a sub-organization of Columbia University. Founded in 1767, the company is headquartered in New York, USA, with a team of 10001+ employees. The company is currently Late Stage.