IT Manager (Data Systems)

Branham Corp; United States; On-site; USD 120,000 - 180,000; Full time

Job summary

LGG Industrial seeks an IT Manager (Data Systems) to lead the architecture, engineering, and governance of our EDW, Fabric, SharePoint Online, and Nintex automation. You will mentor a small team while hands‑on contributing to design and operations, ensuring trusted data delivery to business teams.

The role emphasizes secure integrations, data pipelines, and platform governance across data and collaboration environments, reporting to IT leadership.

Qualifications

• Bachelor’s degree in Information Systems, Computer Science, Data Engineering, Data Analytics, or a related field.
• 7+ years of progressive experience across data engineering, data warehousing, database administration, enterprise integrations, SharePoint, or related platforms.
• At least 2 years in a supervisory or lead role.
• Hands‑on experience with Microsoft Fabric, SQL Server/Azure SQL, and Power BI governance.

Responsibilities

• Lead and mentor a data and SharePoint team; balance delivery with hands‑on work.
• Own EDW architecture, modernization, and ingestion/transformation patterns.
• Design, monitor, and optimize ETL/ELT pipelines from ERP and other sources.
• Administer databases with security, performance, and recovery coordination.
• Drive secure integrations with Workday, Active Directory, SugarCRM, and Microsoft 365.
• Own SharePoint Online architecture, governance, and Nintex workflows.

Skills

Leadership & comms

Analytical problem solving

Data engineering & architecture

Microsoft data platform

Database engineering

Integration engineering

SharePoint & automation

Power BI governance

Applied AI awareness

Education

Bachelor’s degree in information systems or related field

Tools

Microsoft Fabric

Azure Data Factory

Azure Synapse

Data Lake Storage

ShareGate

Nintex Automation Cloud

Power Automate

Power BI

Microsoft 365

Job description

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

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 role’s 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: Bachelor’s 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.

Because we need you just as much as you need us. Together we are unbeatable! Opportunities for growth! LGG Industrial is growing and has room for enthusiastic, motivated employees to grow with it. LGG Industrial gives employees the opportunity to develop themselves, at both the professional and personal level. Dynamic! LGG Industrial is a healthy, growing enterprise. This brings continuity, stability and, therefore certainty. Certainty, with room for ambition, personal development and innovation. Challenges and innovation! Working at LGG Industrial means working in an innovative environment where you take on challenges and share them, come up with innovative solutions and act in a dynamic and well-considered manner. All of this as a team and as individual. Being part of a strong team! LGG Industrial is constantly working on a corporate culture where people take center stage. A friendly, open and pleasant work environment with respect for and confidence in one another. A stimulating and challenging workplace climate where knowledge is shared. As an LGG Industrial employee, you form part of a winning team; a team that helps keep LGG Industrial the undisputed market leader in its field. Work placement, traineeship opportunities for students! We offer ample opportunities, especially for students from a technical or commercial background. The wide range of trainee posts at LGG Industrial offers students the opportunity to gain practical experience at an innovative multinational company. Those in search of an informative and challenging traineeship at an organization with a friendly and open work climate need look no further than LGG Industrial.