Web Administrator 3
ACS Professional Staffing

• Location: Vancouver, Washington
• Type: Contract
• Job #8828

Overview:
ACS Professional Staffing is looking for an employee to work on-site with our client. This Web Administrator 3 will design, develop, and support SharePoint solutions, Power BI dashboards, SQL reporting, ETL processes, and enterprise data architecture while ensuring data integrity, system performance, and security. The role requires troubleshooting, system administration, user support, training, technical documentation, and enterprise search management. Qualified candidates should have 10+ years of enterprise web experience, 5+ years supporting SharePoint technologies, strong expertise in SQL, Power BI, SSAS, ETL design, analytics, reporting, workflow solutions, and excellent communication and training skills. This full-time position is located in Vancouver, WA.

Pay Rate: $48.61 - $69.45

Benefits:

• Paid holidays: 11
• PTO: Starting at 10 days
• Sick Leave: Up to 56 hours per year (prorated based on start date)
• EAP: Employee Assistance Program
• Benefit Options Available: Medical, Dental, Vision, FSA, DCA, LPFSA, HSA, Group Life/AD&D, Voluntary Life/AD&D, Voluntary Short-Term Disability, Voluntary Long-Term Disability, Voluntary Critical Illness, Voluntary Accident, Hospital Indemnity, 401k (immediately eligible for employee and employer contributions - employer match up to 4%)
• Other benefits include the following: Calm App, LifeBalance Discount Program

Responsibilities:

• With Manager oversight and approval:
• 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 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.
• 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
• Valid U.S. Driver's License is required.

Work sponsorship is not available at this time. Third-party candidates will not be considered for this position.

Because we are a federal government contractor, we have special restrictions placed on us for hiring foreign nationals into certain key positions within the company. This particular position requires U.S. citizenship.

ACS Professional Staffing will provide equal employment opportunities to all applicants without regard to the applicant's race, color, religion, sex, gender, genetic information, national origin, age, veteran status, disability status, or any other status protected by federal or state law. The company will provide reasonable accommodations to allow an applicant to participate in the hiring process if so requested.

If you have any questions about the job posting, please contact recruiting@acsprostaffing.com

If you have any questions about our Reasonable Accommodation Policy, please feel free to email hr@acsprostaffing.com

---