Job Summary/Basic Function:
Support the administrative and research functions of the Digital Futures Institute by gathering data from multiple sources, organizing data, and preparing reports. The Data Administrator is responsible for coordinating the creation of systems to manage the flow of data between applications in support of the overall mission of the Digital Futures Institute. This position is responsible for ensuring data gathered in various systems is appropriate and the configuration of these systems is coordinated to provide for the efficient and effective flow of data.

Essential Responsibilities:

• Retrieve data from various academic and administrative systems (e.g., Canvas, Zoom, YuJa, ServiceNow)
• Combine data from multiple data sources
• Database administrator for both academic and research data
• Perform basic data analysis
• Create data summary reports
• Create data visualizations
• Explore ways to enhance data quality and reliability
• Work with users and stakeholders to gather functional and technical requirements around digital asset metadata, taxonomy, organization, and workflow
• Create governance, process, and training documentation for the full range of users
• Organize and create efficient metadata structures, taxonomies, and file-naming conventions
• Assign appropriate metadata to assets, archive and delete assets as necessary, create curated groups of assets for end users as needed
• Audit system performance and gather user feedback
• Troubleshoot complex technical issues for academic platforms
• Manage DFI initiated research projects and student research projects
• Additional responsibilities as assigned

Minimum Qualifications:

• Experience in cloud services. Ideally AWS services such as EMR, Glue, Athena, RDS and Redshift
• Experience with Business Intelligence tools such as PowerBI, Tableau or SAS
• Experience with data lakes in a Hadoop or AWS environment
• Exposure to web services and APIs
• Demonstrable experience with SQL
• Understand of different data generation processes and pipelines, including for media and log files

Required Competencies:

• Attention to detail and organization skills
• Numerical and Analytical skills
• Verbal, written, and visual presentation skills
• Problem-solving skills

Preferred Qualifications:

• Previous analytics experience
• Knowledge of BI tools such as Power BI and Tableau
• Experience with statistical programming such as R
• Understand rights management and archival issues and configure policies to address current and future needs
• Experience working with geographically separate project teams
• Experience building, deploying and supporting Internet-facing applications
• Superior problem solving, organizational, decision-making, written, oral and interpersonal skills.
• Fanatical about creating order from disorder
• Outstanding attention to detail
• Ability to apply sound judgment while working independently
• Experience with the Widen Digital Asset Management System desirable

Salary Range:

$72,000 - $75,000

Competitive Compensation and Benefits

The salary range reflects the College’s good faith and reasonable estimate of the compensation for the position at the time of the job posting. Salary decisions are dependent on several factors including but not limited to market and organizational considerations, experience, and qualifications of a selected candidate as well as internal and external equity.

Our benefits contribute significantly to the total compensation package that includes medical, dental, vision, and supplemental insurance plans; flexible and hybrid work schedules; tuition remission; life insurance; short and long-term disability insurance; an exceptional employer retirement matching program; health savings accounts (HSA), flexible spending accounts (FSA), Public Service Loan Forgiveness eligibility, and a robust Employee Assistance Program (EAP).

If you would like to request any disability related accommodations to complete the job application or to participate in the interview process, please email:oasid@tc.columbia.edu.

Hybrid/Remote

Teachers College maintains a hybrid work environment, which provides employees with flexible work arrangements, while ensuring we preserve the important aspects of our unique in-person college-campus culture. Depending on role and business needs, colleagues will either work onsite or in a hybrid model (combination of in-office and virtual days). Employees are expected to live within a 150-mile radius of the College.

We will consider qualified candidates that reside beyond this radius based on the responsibilities and duties expected of the position. All qualified candidates are encouraged to apply.