Web Administrator 3/ Web Support 3 (IT) -- SharePoint/Business Intelligence Developer

Vancouver, WA

Instant Apply

7 days ago

Job Description

Job Title: Web Administrator 3 (N-IT) - SharePoint/Business Intelligence Developer
Job Number: 12094
Location: Vancouver, WA
Hybrid: 2-3 days per week onsite
Overtime: 5%
Travel: Up to 5% meetings & trainings
Length: Up to 5 years

MUST be US Citizen to be eligible to apply for Federal Background Check
Requires Real ID and or Valid Passport to interview

SUMMARY

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

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

Education & Corresponding Experience

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

Required Skills & Experience

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

Preferred Skills & Experience

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

Additional Requirements:

Valid U.S. Driver’s License is required

Pre-Employment Requirement
All employment offers are contingent upon successful completion of our pre-employment screening that may include drug testing, background/criminal check, and if applicable, must meet eligibility requirements for access to classified information.

APR Staffing is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law.

About APR Staffing
APR Staffing was born from the merger of two well-respected technical staffing firms in Portland. ieSolutions and Data Resource Group. Both companies have recently been award winners for the Portland Business Journal's Fastest-Growing Private Companies. The two firms, now as APR Staffing, make for one of the fastest-growing and most-respected professional and technical staffing companies in Oregon and Southwest Washington.

Collaborating with our customers, we augment their workforce with technical and administrative professionals. We provide only high-caliber, professional-grade resources throughout the Pacific Northwest.

Numbers & Facts

Location

Vancouver, WA

Skills

Analysis Skillsunmatched
Architectural Analysisunmatched
Asset Managementunmatched
Automationunmatched
Background Investigationunmatched
Business Intelligenceunmatched
Business Servicesunmatched
Business Solutionsunmatched
Business Supportunmatched
Change Managementunmatched
Communication Skillsunmatched
Computer Scienceunmatched
Computer Skillsunmatched
Content Managementunmatched
Data Analysisunmatched
Data Managementunmatched
Data Modelingunmatched
Data Qualityunmatched
Data Recoveryunmatched
Data Setsunmatched
Data Storageunmatched
Data Warehousingunmatched
Database Extract Transform and Load (ETL)unmatched
Document Managementunmatched
Documentationunmatched
Driver's Licenseunmatched
Identify Issuesunmatched
Information Technology & Information Systemsunmatched
Information/Data Security (InfoSec)unmatched
Internet Applicationunmatched
Internet Searchunmatched
MSCE - Microsoft Certified Engineerunmatched
Maintenance Servicesunmatched
Microsoft Certificationsunmatched
Microsoft Excelunmatched
Microsoft Office InfoPathunmatched
Microsoft PowerPointunmatched
Microsoft SQL Serverunmatched
Microsoft SharePointunmatched
Microsoft Visiounmatched
Microsoft Wordunmatched
On Site Supportunmatched
Performance Tuning/Optimizationunmatched
Power BIunmatched
Presentation/Verbal Skillsunmatched
Problem Solving Skillsunmatched
Procedure Developmentunmatched
Process Developmentunmatched
Reconciliationunmatched
Records Managementunmatched
Reporting Dashboardsunmatched
Requirements Managementunmatched
SQL (Structured Query Language)unmatched
SQL Server Analysis Services (SSAS)unmatched
Server Supportunmatched
SharePoint Servicesunmatched
Software Administrationunmatched
Software Designunmatched
Software Development Lifecycle (SDLC)unmatched
Source Code/Configuration Management (SCM)unmatched
Standards Developmentunmatched
Stored Proceduresunmatched
Systems Administration/Managementunmatched
Technical Recruitingunmatched
Technical Supportunmatched
Technical Writingunmatched
Time Managementunmatched
Time Trackingunmatched
Training/Teachingunmatched
Training/Teaching Curriculumunmatched
United States Citizenunmatched
Web Partsunmatched
Web Servicesunmatched
Willing to Travelunmatched
Writing Skillsunmatched

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Free resume builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Free resume builder

Web Administrator 3/ Web Support 3 (IT) -- SharePoint/Business Intelligence Developer

Job Description

Numbers & Facts

Skills

Be found by employers

Level up your application

Professional resume templates

Free resume builder