Application Programming Interface (API), Artificial Intelligence (AI), Automation, Best Practices, Continuous Deployment/Delivery, Continuous Integration, Conversation Engine, Data Administration, Data Analysis, Data Management, Data Modeling, Data Quality, Documentation Standards, ERP (Enterprise Resource Planning), Enterprise Application Integration (EAI), Enterprise Applications, Information/Data Security (InfoSec), Knowledge Management, Metadata, Microsoft Product Family, Microsoft SharePoint, Microsoft Windows Azure, Power BI, Product Support, Prototyping, Requirements Management, Software Development, Software as a Service (SaaS), Technical/Engineering Design, Use Cases
Trinity is a highly selective, independent, nonsectarian liberal arts institution located in the capital city of Hartford, Connecticut. The college maintains a rigorous academic profile complemented by a vibrant co-curricular program. With more than 2,100 full-time undergraduate students, representing forty-three states and ninety-one countries, we consider our location in a culturally and socioeconomically diverse capital city to be among Trinity's most distinctive assets; and we cultivate strong connections with our surrounding neighbors and with institutions and organizations throughout Hartford and the region. As a preeminent liberal arts college in an urban setting, Trinity College prepares students to be bold, independent thinkers who lead transformative lives.
Our recently merged analytics and enterprise applications team is at the center of several current and planned initiatives that will enhance the College's ability to use data, analytics, and AI as strategic differentiators. As the Data & AI Integrations Engineer, you will design and build pipelines, data models, intelligent services, and the interconnectivity that power everything from our next-generation data platform and ERP to campus-wide knowledge management.
This is a hands-on, "full-stack data" role for someone who thrives on variety: one day you'll orchestrate a pipeline to load and transform new data into our Fabric lakehouse; the next you'll craft an API-driven integration, stand up a SharePoint knowledge hub, or prototype a chatbot that improves the Trinity digital experience for students, employees, and other constituents. Your work will contribute to our team's efforts to effectively manage data and reveal insights.
Duties and responsibilities include:
- Design, develop, optimize, and operate data pipelines in Microsoft Fabric and related tools for the efficient collection, storage, transformation, and presentation of data.
- Implement data quality, lineage, and metadata-driven practices to support high-quality, fit for purpose data products, supporting analytics, reporting, integration, and AI use cases.
- Design, build, and operate secure integrations among enterprise applications, SaaS, on-prem systems, and external data sources using iPaaS, ELT tools, and custom code.
- Co-administer the institutional data platform with repeatable patterns, CI/CD, and automation for enterprise-grade data solutions and maintain best practice templates for self-service development by power users.
- Partner with application developers and administrators to prototype and operationalize AI/ML services, utilizing capabilities within Microsoft Fabric, Azure, M365, and other tools.
- Partner with information security to ensure solutions align with best practices.
- Co-administer SharePoint Online with a focus on enabling knowledge management capabilities and integration with Power BI and Fabric.
- Translate business requirements from analysts and subject matter experts into resilient technical designs, while maintaining robust documentation of standards, processes, and designs.
- Perform other related duties as assigned and based on departmental need.