Data Systems Manager
BASIC PURPOSE The Data Systems Manager serves as the College's lead technical administrator for enterprise analytics systems, including Microsoft Fabric, Power BI, OneLake, semantic models, SQL data warehouse, data pipelines, and related analytics technologies. The position is responsible for the design, administration, security, governance, and continuous improvement of the College's enterprise data environment. The Data Systems Manager manages the institution's analytics architecture, including the daily integration of data from the Ellucian Colleague operational data store and other enterprise systems into Microsoft Fabric. The position develops and maintains enterprise semantic models, promotes data quality and governance standards, and expands the College's use of advanced analytics, artificial intelligence, and self-service business intelligence tools. Working collaboratively with others on the Business Intelligence team, Institutional Research, Information Technology staff, business units, and functional subject matter experts, the Data Systems Manager advances a data-informed culture through the availability of modern data analytics systems and processes. This position is approved for primarily remote work with a required number of days on campus in Blue Bell, PA. While an effort will be made to schedule these dates in advance, it may be necessary to be on campus to respond to an unplanned IT incident. Employees of the College are required to live in Pennsylvania, New Jersey, or Delaware. Relocation assistance is not available for this position. ESSENTIAL DUTIES AND RESPONSIBILITIES - Enterprise Analytics System Administration – 15% - Serve as the primary administrator for Microsoft Fabric, OneLake, Power BI, and related analytics technologies. - Configure and maintain Fabric capacities, workspaces, security settings, deployment processes, and governance controls. - Monitor system health, performance, utilization, capacity consumption, reliability, and cost. - Develop and maintain standards for workspace management, report publishing, lifecycle management, and system security. - Evaluate and implement new Microsoft Fabric and Power BI capabilities as they become available. - Data Warehouse and Data Engineering - 20% - Administer and support the College's enterprise data warehouse environment. - Manage and monitor data movement processes between the operational data store, Microsoft Fabric, and other institutional systems. - Design, develop, maintain, and optimize data pipelines, dataflows, and ingestion processes. - Expand the enterprise data system by integrating additional institutional, cloud-based, and third-party data sources into OneLake. - Ensure the availability, integrity, accuracy, and performance of enterprise analytics data. - Semantic Models and Business Intelligence – 30% - Design, develop, maintain, and document enterprise semantic models used throughout the College. - Ensure consistent data definitions, calculations, and measures across all reporting environments. - Optimize semantic models for usability, scalability, and performance. - Support report developers, power users, and departmental staff utilizing Power BI and related analytics tools. - Participate in the development and maintain of institutional dashboards, visualizations, and analytical assets as needed. - Data Governance and Stewardship - 25% - Maintain enterprise data definitions, business glossaries, metadata standards, and data dictionaries within Microsoft Purview and other tools. - Facilitate collaboration among data stewards and subject matter experts to ensure consistency of institutional reporting. - Identify and address data quality concerns and coordinate remediation activities. - Promote responsible use of institutional data in accordance with College policies and regulatory requirements. - Analytics Strategy and Innovation - 10% - Identify opportunities to improve decision-making through analytics, automation, predictive insights, and artificial intelligence. - Champion institutional adoption of Microsoft Fabric, Power BI, and modern analytics practices. - Promote the effective use of Microsoft Copilot within Power BI and other analytics workflows. - Other Duties as Assigned ESSENTIAL KNOWLEDGE AND SKILLS Knowledge - Bachelor’s degree in computer science, data analytics, or similarly applicable field required. - Minimum of two years of professional experience in data analytics, business intelligence, data engineering, systems administration, or a related technology role. - Experience should include working knowledge of data analytics platforms, data integration processes, relational databases, and business intelligence tools. - Experience with one or more of the following areas is required. Candidates with demonstrated experience across multiple areas may be given stronger consideration: - Microsoft Fabric architecture, administration, and governance. - Power BI administration, semantic modeling, DAX, reporting, and dashboard development.