Menu

Business Analyst | SAP Automation Analyst

Date Posted: Mar 13
Type: Contract
Wage: $40-43.50
Job Number: 6882
Location: Houston, TX

TITLE: Business Analyst | SAP Automation Analyst

CLIENT: Energy Technology Company

LOCATION: Houston, Texas (Downtown)

TYPE: Contract

RATE: $40.00-43.50/hour DOE

SUMMARY:
• Facilitate project implementations for Retail Operations Division and automation analysis SAP system
• Coordinate data analysis producing various ad-hoc and recurring reports from the SAP billing system or data warehouse equivalent
• Support business process reporting analysis for executive management team, customer operations, account management (i.e. customer requests), Marketing, and Finance divisions
• Create business support tools to assist with daily business operations process improvement and procedures
• Work with a dynamic team is to achieve an increase in the effectiveness of the Reporting data being utilized across the organization by eliminating operational redundancies
• Disseminate automation data analysis and consolidating reports where appropriate and reducing work required to push data to users by automating as many recurring reports as possible
• Develop recommendations with action plans and manage multiple automation projects simultaneously
• Manage communication efforts and ability to import, export, and manipulate data files between various IT applications and databases (e.g. Oracle, SAP, BW)


DUTIES:

• Developing reports using Microsoft SQL Server Reporting Services (SSRS) and supporting other analysts who use SQL Server Data Tools
• Create templates to manage reports analysis in PC SAS and Unix SAS environments desired
• Facilitate automation tools like worksoft and knowledge of winrunner would be an additional asset
• Participate in development and implementation of appropriate methods for monitoring, analyzing, and preparing data for management reports and statistics
• Helping to gather research data and/or clarify data and reporting requirements from business owners
• Document analysis, reviewing research and maintaining database stored procedures
• Assimilate information from various environments and develop queries or reporting solutions to fulfill business needs
• Recognize data anomalies to analyze and troubleshoot to determine cause
• Utilize thorough knowledge of table structure and reporting environments to gather data to report metrics. Generate effective reports and manipulate data in reports to provide key metrics to business operations
• Demonstrate proficiency in SAP and external systems to diagnose and correct failures and errors from a reporting perspective
• Participate in developing and implementation of new processes and tools to streamline workflow
• Provide innovative solutions. Document and communicate technical data requirements for development of system queries and reports to support ongoing root cause analysis
• Prepares documentation on business and functional processes in support of reporting activities
• Interact and consult with other areas/departments regarding Reporting issues and activities

REQUIREMENTS:
• A minimum of 2-3 years’ experience in billing, enrollments, and/or work within SAP is required
• Advanced proficient with Microsoft Office Suite (Excel, Word, Power Point, Access, Project)
• Previous work experience utilizing report writing best practices (optimization, use of joins and sub-queries)
• 2 years’ work experience in: Microsoft SQL Server (which uses the T-SQL ANSI/SQL development standards), SSRS (SQL Server Report Services), SSIS/DTS package development, Visual Studio, VisualBasic.net. Microsoft SSAS, cube development, and .NET experience is a plus.
• 2+ years’ experience in data mining, querying / accessing large data sets and developing key business reports and metrics
• Experience writing stored procedures, T-SQL, functions, and SQL queries
• Experience with manual testing to include User Acceptance Testing (UAT)
• Experience pulling data from Microsoft SQL Server 2005/2008 R2/2012/2014, Oracle, SAP, text files, excel files, MS Access databases for reports
• Experience with cubes and drill down/drill through reports
• Experience with SQL Server Data Tools (SSDT) SSRS/SSIS/SSAS, Visual Studio, and/or other (non-Microsoft) reporting platforms


EDUCATION:
• Bachelor’s degree or equivalent education and/or work experience required

Hot Jobs for the week of 04/15/2019

Clearpoint is a staffing agency for jobs in information technology, marketing, creative, and other professionals. We do business by building long-term, mutually beneficial relationships with our employees and clients.