Position Summary

Under the direction of the Director of CUIMC Analytics Development Team, the Analytics Developer develops and maintains the analytical and reporting tools used for advancing the joint missions of the Primary Care and Population Health departments.

This position will design and create data structures, reports, dashboards, and related data extracts from CUIMC’s Epic electronic health record (EHR) management system, legacy EHR systems and external data sources. 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 must be able to understand business requirements and translate them into technical documentation later used for development. The ideal candidate will be personable and competent at managing relationships within the two departments and across the organization. This individual will review analytic requests, 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.

Responsibilities

Database Development: Designs, develops, and maintains database objects using Microsoft SQL Server, and in future Snowflake, to support analytics and reporting needs. Responsibilities include writing and optimizing complex SQL queries, creating and modifying tables, views, stored procedures, and functions, and ensuring data integrity, performance, and scalability. Collaborates with data engineers, analysts, and stakeholders to translate business requirements into efficient database solutions, troubleshoot data issues, and support ongoing enhancements to analytical systems. - 30%

Communication/Documentation: Engages with Primary Care and Population Health stakeholders to understand and clarify analytic and reporting needs. Advises on optimal technical and analytic solutions based on business requirements and data availability. Translates operational definitions, workflows, and reporting requirements into clear, detailed written specifications and documentation to support database development, reporting, and ongoing maintenance. Ensures documentation is accurate, standardized, and effectively communicates requirements across technical and non-technical teams. - 20%

Python Scripting: Uses Python to integrate, transform, and manipulate data from multiple internal and external data sources in support of analytics and reporting initiatives. Develops and maintains reusable scripts and workflows for data extraction, cleansing, validation, and aggregation. Collaborates with team members to automate processes, improve data quality, and ensure efficient, scalable data pipelines that align with analytic and business requirements. - 15%

Business Intelligence Development: 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. Designs intuitive, performant dashboards and reports that meet user requirements, adhere to organizational standards, and support operational and strategic decision-making. Partners with stakeholders to validate outputs, incorporate feedback, and ensure solutions are accurate, reliable, and scalable – 15%

Task Management: Manages multiple tasks simultaneously keeping sponsoring departments and team members updated on progress – 5%

Maintains Standards: 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 as assigned - 5%

Minimum Qualifications

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

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

Equal Opportunity Employer / Disability / Veteran

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