• Job Type: Officer of Administration
• Bargaining Unit:
• Regular/Temporary: Regular
• End Date if Temporary:
• Hours Per Week: 35
• Standard Work Schedule:
• Building:
• Salary Range:$100,000.-$120,000.

Position Summary

Under the direction of the Director of the CUIMC Analytics Development Team, the Analytics Developer develops and maintains the tools used for advancing the mission of Mailman School of Public Health’s ICAP organization.

This position will design and create data structures, reports, dashboards, and related data extracts from various institutional data sources, including accounting, human resources, and others. 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 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: Proficiently uses MS SQL Server for queries and designing tables - 40%

Business Intelligence Development: Builds and maintains client facing business intelligence solutions using tools, such as Power BI, Cognos, Excel, and other applications – 30%

Customer Service: Partners with internal CUIMC clients to understand analytic needs, advise on optimal solutions, and help business analysts translate the operational definitions into written specifications - 10%

Task Management: Manages multiple tasks simultaneously keeping clients 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

• Requires a bachelor’s degree in computer science, statistics, information systems, or similar technical discipline, OR a bachelor’s degree in an unrelated discipline and four years of related experience.
• Experience with Power BI, Cognos, and/or other Business Intelligence tools.
• Proficiency with database design and modeling using Star Schema design.
• Proficiency in writing SQL queries.

Preferred Qualifications

• Excellent decision making, critical thinking, and problem-solving skills
• Experience with administrative and/or operational data and reporting
• Strong organizational skills with an emphasis on communication, detail, and follow-up
• Experience in academic or hospital environments
• Experience with scripting languages for data analysis, such as R or python
• Jet Data Manager and Jet Reports
• Experience with MS Fabric and Power Platform
• Experience with Peoplesoft and/or MS Business Central Dynamics 365

Equal Opportunity Employer / Disability / Veteran

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