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.
- Data warehousing, dimensional modeling, and enterprise analytics architecture.
- ETL/ELT processes, data integration, and data pipeline development.
- SQL Server, relational databases, and data management principles.
- Data governance frameworks, metadata management, and data quality practices.
- Data security, privacy, and access control methodologies.
- Artificial intelligence and analytics technologies, including the construction of AI skills and agents, preferably using Microsoft Copilot capabilities.
- Higher education administrative systems and data structures, preferably including Ellucian Colleague.
Skills
- Strong analytical and problem-solving skills.
- Ability to translate business requirements into technical solutions.
- Ability to develop and maintain enterprise semantic models and reporting structures.
- Strong written and verbal communication skills.
- Ability to facilitate collaboration among technical and non-technical stakeholders.
- Project management and prioritization skills.
- Ability to present complex data concepts to diverse audiences.
- Commitment to continuous learning and innovation.
Supplemental information Montgomery County Community College is committed to assuring equal opportunity to all persons and does not discriminate on the basis of race, color, religion, religious creed, sex, pregnancy, ancestry, national origin, age, affectional or sexual orientation, genetic information, gender identity, gender presentation, veteran’s status, marital status or disability in its educational programs, activities, or employment practices as required by Title IX of the Educational Amendment of 1972, section 504 of the Rehabilitation Act of 1973, and other applicable statutes. Inquiries concerning Title IX relating to equal opportunity on the basis of sex should be referred to: Title IX Coordinator, Mikiba W. Morehead, Ed.D., TNG, LLC, at titleixcoordinator@mc3.edu. All other equal opportunity inquiries, including those based upon disability, should be referred to: The Director of Equity, Diversity & Belonging, at 504@mc3.edu or 215-619-7383.
Benefits
We offer a complete benefits package to full-time employees including health care, dental, vision, retirement, flexible spending accounts, life insurance, holidays, vacation, and sick leave. To learn more details, visit our benefits page.