IT Manager (Data Systems)

LGG Industrial • Pittsburgh, PA

9d

About The Position

The IT Manager (Data Systems) is a hands-on leadership role responsible for the architecture, engineering, administration, integration, security, and governance of the company’s 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.

Requirements

• Bachelor’s degree in Information Systems, Computer Science, Data Engineering, Data Analytics, or a related technical field, or equivalent relevant 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.
• Demonstrated hands-on experience designing and supporting enterprise data pipelines, data warehouses, databases, and integrations in production environments.
• Demonstrated experience with Microsoft 365, SharePoint Online, SQL-based data platforms, and Azure or Microsoft Fabric technologies.
• Experience implementing data and platform security, access governance, operational controls, documentation, monitoring, and support standards.
• 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.
• Strong knowledge of dimensional modeling, data warehousing, lakehouse concepts, ETL/ELT, orchestration, metadata, lineage, data quality, and source-to-consumption architecture.
• 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.
• Advanced SQL skills and practical experience administering, tuning, securing, and supporting relational database platforms, preferably Microsoft SQL Server and Azure SQL.
• Experience with APIs, file-based interfaces, identity integrations, connectors, service accounts, authentication patterns, scheduling, error handling, and integration monitoring.
• Deep proficiency with SharePoint Online, ShareGate, Nintex Automation Cloud, and Microsoft 365 integration patterns.
• Working knowledge of Power BI architecture, gateways, refresh, security, semantic models, performance, deployment practices, and governance.
• 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.
• 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.
• 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.

Nice To Haves

• Experience integrating with Epicor Prophet 21 or another distribution-focused ERP, Workday, Microsoft Entra ID / Active Directory, SugarCRM, and Microsoft 365 services.
• Experience with Microsoft Fabric, SQL Server, ShareGate, Nintex Automation Cloud, Power Automate, and Power BI platform administration or governance.
• 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.
• Relevant Microsoft certifications in Azure data engineering, Fabric, database administration, Power Platform, SharePoint, security, or AI; Nintex certifications are also desirable.
• Understanding of wholesale distribution operations and data domains such as customers, products, inventory, pricing, orders, purchasing, finance, and delivery performance.
• Familiarity with Power Automate and Power Platform is desirable.

Responsibilities

• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• Implement role-based access, least-privilege controls, data protection standards, auditability, retention practices, and platform governance across data, database, integration, SharePoint, and automation environments.
• Establish monitoring, support procedures, documentation, disaster-recovery readiness, incident response, root-cause analysis, and service-level expectations for critical data and collaboration platforms.
• 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.

Benefits

• 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.

What This Job Offers

• Job Type: Full-time
• Career Level: Manager