BI Tool Admin Specialist
Location: Reston, VA
Prospective candidate would serve as administrator for several enterprise tools in the area of business intelligence and data analytics. These tools include but are not limited to MicroStrategy, Microsoft SQL Server Reporting Services (SSRS), SAS Grid, Tableau and integrations with various third-party tools (e.g. Visual Crossing). These tools are used to provide reporting and data analytics to external customers, business lines (Single Family, Multifamily, Investments and Capital Markets), corporate and IT constituencies. The tool administrator plans, coordinates and implements product upgrades in coordination with engineering counterparts as well as supports maintenance, troubleshoot system related problems, and will be responsible for the overall availability and enhancements of the tools infrastructure and the environment. Other responsibilities include maintaining roadmaps, presenting technical briefing to the support staff, developers and the management as well as business line representatives and leadership for IT operations. Specific duties include:
•Coordinate/perform major system upgrades and patches for monitoring infrastructure.
•Maintain configuration data, user access and control within all applications.
•Setup governance model for application monitoring
•Periodically evaluate and enhance monitoring based on changes in business and technical requirements
•Maintain the multiple environments (Production/UAT/SIT/ DEV, Performance, etc.)
•Serve as subject matter expert (SME) for monitoring the infrastructure components
•Perform minor customization and develop scripts / interfaces if required.
•On-board new monitoring rules in the tools to accomplish the business needs for monitoring.
•Create and provide reports of events and alerts for incident / problem management procedures.
•Work closely with middleware (e.g., WebLogic, Tomcat), database, UNIX, network and storage administrators for routine operations such as performance tuning, upgrades and backup.
•Manage vendor relationships (support case resolution, acquiring new patches, upgrades and promotes industry best practices)
•Maintain Service level agreements with both customer and support organizations.
•Maintain licenses and provides monthly metrics on the tool usage.
•Monitor capacity and provide monthly metrics based on the tool
•Maintain and document Data Profiles/ Engineering and architecture.
•Coordinate the Prod/Non-Prod infrastructure deployments.
•Support scheduled on-call rotation for after hour support
•Completes/Follows/Maintain the segregation of duties (SOD), Sarbanes-Oxley (SOX) and/or audit compliance.
•Troubleshoot and provide support for various reporting and analytics tools.
Successful candidate should possess the following qualifications:
o5+ years working with MicroStrategy or SAS Grid on Linux platform, of which 3+ years must be in administrative role
o3+ years of working with Linux and Windows environment.
o4+ years working with Application support / management
oAdministrative knowledge of MicroStrategy or SAS Grid required
oStrong Scripting experience (Batch/Perl/Shell)
oExperience with Apache/Tomcat
oExperience with Java and Linux shell scripting preferred
oRequired experience with Unix, Windows and Network Administration
oApplication Development background
oStrong System administration skills (Unix/Windows).
oStrong troubleshooting techniques for basic and advanced infrastructure issues.
oStrong relational database and SQL experience
oStrong skills in Microsoft Office Excel, Word
oStrong verbal and written communication skills
oMust be able to work effectively in a team environment.
oMust be able to multitask as needed working on project initiatives and service tickets concurrently as needed.
oAbility to work support administration of multiple tools concurrently (MicroStrategy, SSRS, SAS, HDF, Denodo, Tableau, etc.) will be required
o2+ years leading teams/mentoring junior staff highly desired
o10+ years of progressive IT experience.
oExperience with SAN, NFS and GPFS file systems.
o3+ years of experience working on supporting multiple medium to large size projects preferred