Web Administrator 3/ Web Support 3 (IT) -- SharePoint/Business Intelligence Developer at Professional Resource Group, LLC in Vancouver, WA

Job description

• This Web Administrator assignment will provide support to the corporate Transmission Field Services, Business Controls and Information team and specifically, the Asset Data Management (ADM) team. ADM is responsible for providing an accessible, reliable and comprehensive asset data register. The Web Administrator will support the development and maintenance of the ADM Service Request System and supporting workflows, and support automation of other divisional processes

Responsibilities

• Identify Business & Data requirements and convert them into conceptual & logical data models.
• Participate in design, development, and analysis of data architecture and warehousing approaches
• Create, monitor, modify and troubleshoot necessary ETL processes needed by the BI projects
• Analyze data to ensure information is accurate and reconcilable to its source of origin
• Audits, reviews, and validates databases to ensure data integrity
• Verify proper change and version control for code and reports
• Identify, communicate, and resolve data quality and data reconciliation issues
• Develop and verify standards and procedures for the storage and retrieval of institutional data are met. Alert the corporate manager of any deviations or concerns.
• Create and maintain the documentation for each business unit’s data model and ETL processes
• Monitor and troubleshoot existing BI applications, including frameworks, cubes, and reports and ensure the availability of the systems for the end-users
• Communicate regularly with technical, applications, and operational staff to ensure database integrity, security, and optimized performance at the application and database level
• Design, build, enhance, and maintain PowerBI and dashboards working from specification documents and/or direct interaction with business users
• Design and maintain SQL Server Analysis Services (SSAS) databases used in ad-hoc analytic research and automated reporting.
• Write SQL Server queries and stored procedures to populate reporting datasets.
• Decipher existing reports and database processes to assist users and owners in understanding reports
• Design SharePoint solutions from conception to implementation
• Develop SharePoint-based solutions from “user needs” in an Internet enabled application environment
• Distinguish key interactions and connectives among enterprise Internet enabled applications solutions
• Perform typical administrative and maintenance activities such as site creation, and permission management
• Carry out assigned tasks with a professional demeanor reflected in excellent written and oral communication skills, listening skills, patience, analytical reasoning and problem solving abilities
• Meet timelines, milestones, deliverables and provide timely (weekly) status updates
• Understand and follow established processes and procedures including Change Management, Work Tracking and Time Management
• Administer general system monitoring and verification
• Act as a point-of-contact to troubleshoot SharePoint Services, sites and permissions, and other application and server issues
• Recommend and apply configuration settings to meet business needs and security requirements
• Create and administer enterprise search solutions using the SharePoint search capabilities
• Provide support for both IT and business users for SharePoint sites.
• Create Word documents, InfoPath forms, Excel spreadsheets, PowerPoint presentations and Visio flowcharts to document the designed SharePoint solutions and design appropriate training presentations and curriculum.
• Support existing business systems and their users.
• Administer general system monitoring and verification
• Communicate with a wide variety of technical and business experts in both individual and group settings.
• Provide formal training sessions to entry, mid, and advanced level users in both individual and small to large group settings
• Perform typical administrative and maintenance activities such as site creation, permission management, backup/restore
• Create and administer enterprise search solutions using the SharePoint search capabilities
• Provide support for both IT and business users for SharePoint sites.
• Support existing ADM SharePoint sites and their users.

Requirements

• Bachelor’s or Masters College Degree in computer science, information technology or a related technical field is highly preferred.
• With an applicable Bachelor’s or Master’s degree, 10 years of experience in computer/information technology is required
• Without an applicable Bachelor’s or Master’s degree, 14 years of experience in computer/information technology is required
• 10+ years of experience in an enterprise web environment with 5+ years supporting SharePoint technologies is required.
• Experience reviewing datasets, graphs, and charts for data quality
• Valid U.S. Driver’s License is required
• Microsoft certification in SharePoint and/or Web Administration (MSCE)
• Expert level knowledge of Microsoft SharePoint Server 2010 and supporting technologies
• Working experience in training, support, and trouble-shooting for end-users
• Working knowledge of content management, document management, and records management within a SharePoint environment
• Technical requirements gathering skills in the Information Technology environment
• Experience with InfoPath and workflow solutions
• Experience with SharePoint Designer 2010 Site Workflow Solutions
• Experience configuring and supporting SharePoint web applications, permissions, site collections, search, and web parts
• Experience with SharePoint 2007 and/or 2010 Enterprise Services: Excel Services, Form Services, Business Connectivity Services, Web Services
• Experience building graphs and charts to communicate information. Experience with reporting platforms like PowerBI
• Experience with SQL including joins, inserts, updates, deletes, conditional logic, subqueries, temp tables, and data transformation functions
• Demonstrated expert knowledge of BI areas including ETL design, analytics, and reporting
• Proficient in SQL queries, DAX, SSAS Tabular, PowerBI, and Excel
• Knowledge of software design concepts and methods including SDLC
• Communication skills including training and technical documentation
• Experience providing training either individually or in large groups to entry, mid, and advanced level users

Skills

Required

• Valid U.S. Driver’s License