Analytics Developer - ICAP
 Columbia University | |
 United States, New York, New York | |
 Nov 07, 2024 | |
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 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
Preferred Qualifications
Equal Opportunity Employer / Disability / Veteran Columbia University is committed to the hiring of qualified local residents. | |