Location: Houston, TX (Onsite – 5 days per week)
Duration: Direct Hire
Our client is seeking a Senior IT Systems Administrator with deep expertise across Microsoft SharePoint Online, Power Platform, and SQL-based Data Lake environments. This role serves as a critical member of the Web & Enterprise Applications team, leading system design, configuration, implementation, and governance for enterprise collaboration and data management solutions.
The ideal candidate will be a technical subject matter expert capable of bridging IT and business needs — driving automation, modernization, and governance initiatives within Microsoft 365 and Azure ecosystems.
Key Highlights
- Lead architecture, administration, and governance of enterprise SharePoint Online and Power Platform environments.
- Oversee implementation and optimization of SQL-based Data Lakes, including schema design, ingestion pipelines, and T-SQL optimization.
- Design, develop, and deploy Power Apps, Power Automate workflows, and Dataverse integrations.
- Serve as the primary contact for system analysis, design, and delivery of new solutions supporting collaboration and data accessibility.
- Partner with business analysts and project managers to gather requirements, conduct systems analysis, and translate business needs into technical solutions.
- Enforce governance, compliance, and lifecycle management policies across Microsoft 365.
- Provide training, support, and mentorship to “citizen developers” and business users adopting Power Platform tools.
- Collaborate globally to ensure adherence to privacy, compliance, and Works Council standards.
Core Responsibilities:
Data Lake / SQL Support
- Architect and optimize SQL-based Data Lake solutions (Azure Synapse, Data Factory, etc.).
- Develop and maintain T-SQL queries, stored procedures, and pipelines to ensure reliable data ingestion and quality.
- Support data modeling, schema design, and metadata strategies in partnership with data engineering teams.
Power Platform (Power Apps & Power Automate)
- Build, deploy, and manage model-driven and canvas apps with scalable workflows.
- Oversee Power Platform environment administration including DLP policies, user roles, and governance.
- Provide training and technical review for Power Platform solutions developed by citizen developers.
SharePoint Online (Admin / Architect Level)
- Design SharePoint Online architecture (hub sites, metadata structures, permissions).
- Modernize legacy SharePoint environments and implement SPFx, PowerShell, and PnP customizations.
- Manage tenant configuration, compliance, lifecycle management, and integrations.
Governance & Strategy
- Define and enforce Microsoft 365 governance policies and security frameworks.
- Serve as a subject matter expert for transformation initiatives involving Microsoft technologies.
- Ensure solution scalability, security, and alignment with IT and business objectives.
Qualifications:
Education & Experience
- Bachelor’s degree in Information Technology, Computer Science, or related field (advanced degree preferred).
- 8–15 years of enterprise IT experience specializing in SQL, SharePoint, and Power Platform.
- Proven success architecting and administering large-scale Microsoft 365 environments.
- Hands-on expertise with SQL Server, Azure Data Factory/Synapse, and advanced T-SQL optimization.
- Proficiency in SharePoint Online, PnP PowerShell, and solution architecture.
- Advanced experience designing and implementing Power Apps, Power Automate, and Dataverse solutions.
- Experience leading quality assurance, change management, and documentation processes.
- Familiarity with Windows Active Directory, .NET, HTML5, Drupal, and web content management systems is beneficial.
- Excellent communication, problem-solving, and cross-functional collaboration skills.
Preferred Certifications
- Microsoft Certified: Power Platform Solution Architect Expert
- Microsoft Certified: Azure Data Engineer or Solutions Architect
- Microsoft 365 Certified: SharePoint Administrator Associate or Teams Administrator Associate
- ITIL, PMP, or TOGAF certifications (preferred but not required)
Work Environment & Physical Requirements
- Full-time, onsite in Houston, TX (Monday–Friday, first shift).
- Typical office environment with occasional exposure to manufacturing settings requiring PPE.
- May occasionally require lifting up to 25 lbs and infrequent travel for project collaboration or training.
Additional Details
Start Date: Targeting December 2024
Residency Requirement: Must be authorized to work in the United States. Only U.S. citizens and Green Card holders will be considered.
EEO Policy
Allied Resources complies with all Equal Employment Opportunity (EEO) affirmative action laws and regulations. Allied Resources does not discriminate on the basis of age, race, religion, color, sex, national origin, marital status, genetic information, sexual orientation, gender identity or expression, disability, veteran status, or other status protected by law.
