IT Manager (Data Systems)

Summary of the Role

The IT Manager (Data Systems) is a hands-on leadership role responsible for the architecture engineering administration integration security and governance of the companys database Enterprise Data Warehouse and SharePoint platforms. The position is the primary technical owner for the Enterprise Data Warehouse (EDW) Microsoft Fabric and related data pipelines database platforms SharePoint Online and Nintex automation solutions.

Reporting to the IT Director this manager leads and develops a small team of data and SharePoint professionals while remaining directly involved in design development and operational support. The role ensures reliable data movement from enterprise source systems through the EDW and data platforms to downstream consumers systems.

This position partners with report developers and business teams by providing trusted data models governed datasets performance support platform standards and reliable source-to-consumption data services.

Key Responsibilities

Team Leadership and Delivery: Manage mentor and develop Data and SharePoint team members; prioritize work assign ownership review technical solutions and balance project delivery with operational support and hands-on contribution.

EDW and Data Architecture: Own the architecture development documentation and ongoing modernization of the Enterprise Data Warehouse and Microsoft Fabric environment. Establish scalable patterns for ingestion transformation storage semantic readiness and data consumption.

Data Pipeline Engineering: Design build monitor troubleshoot and optimize ETL/ELT pipelines that move data from Epicor Prophet 21 and other enterprise applications into the EDW Fabric and downstream systems. Implement data-quality controls logging alerting and recoverability.

Database Administration: Provide hands-on administration for supported database platforms including security access performance monitoring capacity planning backup and recovery coordination patching coordination job scheduling and production issue resolution.

Enterprise Data Integrations: Lead the design development and support of secure integrations with enterprise platforms such as Workday Active Directory / Microsoft Entra ID SugarCRM Microsoft 365 Teams SharePoint Epicor Prophet 21 and other business systems and vendor platforms.

SharePoint Platform and Development: Own SharePoint Online architecture administration governance security site and information architecture custom solutions integrations and lifecycle management. Use ShareGate or comparable tools for migrations structural management reporting and security reviews.

Workflow and Process Automation: Architect build and support enterprise workflows and forms using Nintex Automation Cloud and related automation technologies. Improve reliability maintainability documentation and business continuity of critical workflows.

Power BI Enablement and Governance: Support the Power BI ecosystem through governed data sources reusable datasets or semantic models gateway and refresh coordination performance troubleshooting security alignment lineage and development standards. Business report and dashboard development remains outside this roles direct ownership.

AI and Intelligent Automation: Evaluate and apply AI technologies to data management knowledge discovery workflow automation data quality developer productivity and business-process improvement. Partner with security and business stakeholders to ensure responsible governed and practical AI adoption.

Security Governance and Compliance: Implement role-based access least-privilege controls data protection standards auditability retention practices and platform governance across data database integration SharePoint and automation environments.

Operational Reliability: Establish monitoring support procedures documentation disaster-recovery readiness incident response root-cause analysis and service-level expectations for critical data and collaboration platforms.

Roadmap and Vendor Management: Develop platform roadmaps recommend investments manage technical vendors and partners assess solution designs and communicate risks dependencies status and business impact to IT and business leadership.

Skills and Abilities

Data Engineering and Architecture: Strong knowledge of dimensional modeling data warehousing lakehouse concepts ETL/ELT orchestration metadata lineage data quality and source-to-consumption architecture.

Microsoft Data Platform: Hands-on experience with Microsoft Fabric and/or Azure data services such as Data Factory Synapse Analytics Data Lake Storage and related monitoring and security capabilities.

Database Engineering: Advanced SQL skills and practical experience administering tuning securing and supporting relational database platforms preferably Microsoft SQL Server and Azure SQL.

Integration Engineering: Experience with APIs file-based interfaces identity integrations connectors service accounts authentication patterns scheduling error handling and integration monitoring.

SharePoint and Automation: Deep proficiency with SharePoint Online ShareGate Nintex Automation Cloud and Microsoft 365 integration patterns. Familiarity with Power Automate and Power Platform is desirable.

Power BI Platform Knowledge: Working knowledge of Power BI architecture gateways refresh security semantic models performance deployment practices and governance.

Applied AI Awareness: Practical familiarity with generative AI copilots AI-assisted development retrieval-augmented generation intelligent document processing or machine-learning-enabled automation including awareness of security privacy and responsible AI considerations.

Leadership and Communication: Ability to lead a small technical team set priorities coach staff collaborate across IT and business functions and explain technical risks and decisions in clear business language.

Analytical Problem Solving: Ability to trace data discrepancies and system failures across source applications integrations pipelines databases the EDW and consuming platforms to identify root causes and sustainable corrective actions.

Minimum Qualifications

Education: Bachelors degree in Information Systems Computer Science Data Engineering Data Analytics or a related technical field or equivalent relevant experience.

Experience: 7 years of progressive experience across data engineering data warehousing database administration enterprise integrations SharePoint or related platforms including at least 2 years in a supervisory technical-lead or player-coach capacity.

Data Platform Experience: Demonstrated hands-on experience designing and supporting enterprise data pipelines data warehouses databases and integrations in production environments.

Microsoft Ecosystem: Demonstrated experience with Microsoft 365 SharePoint Online SQL-based data platforms and Azure or Microsoft Fabric technologies.

Governance and Security: Experience implementing data and platform security access governance operational controls documentation monitoring and support standards.

AI Experience: Experience using or implementing AI-enabled technologies in a business or technical environment with the ability to evaluate suitable use cases limitations data requirements and governance considerations.

Preferred Qualifications

Enterprise Applications: Experience integrating with Epicor Prophet 21 or another distribution-focused ERP Workday Microsoft Entra ID / Active Directory SugarCRM and Microsoft 365 services.

Platform Depth: Experience with Microsoft Fabric SQL Server ShareGate Nintex Automation Cloud Power Automate and Power BI platform administration or governance.

AI and Automation: Experience with Microsoft Copilot technologies Azure AI services AI Builder intelligent document processing RAG solutions or automation solutions that incorporate generative AI or machine learning.

Certifications: Relevant Microsoft certifications in Azure data engineering Fabric database administration Power Platform SharePoint security or AI; Nintex certifications are also desirable.

Industry Knowledge: Understanding of wholesale distribution operations and data domains such as customers products inventory pricing orders purchasing finance and delivery performance.

Success Measures

Reliable secure and supportable data pipelines databases integrations SharePoint solutions and Nintex workflows.

Clear ownership documentation monitoring recoverability and lifecycle management for critical platforms.

Trusted and traceable enterprise data that enables analytics and Power BI without transferring report-development ownership to this role.

A practical roadmap for Microsoft Fabric EDW modernization SharePoint automation and governed AI adoption.

Improved team capability reduced key-person dependency and effective communication with business and IT stakeholders.