Revenue Business Analyst

Job Responsibilities

• Protect the stability of various Pricing and Cost Applications and ensure the integrity of the data involved.
• Assess, coordinate and review issues and impacts to support and business processes.
• Analyze, document and communicate application issues to management and programming team.
• Documents business and functional system requirements.
• Writes SIT, UAT, and regression test scripts.
• Create necessary SQL scripts and testing evidence to correct system data.
• Requests, tracks, tests for all changes needed in the Team Foundation Server Portal.
• Identifies the root of the problem being reported and provides quality support in a high volume environment.
• Escalates obstacles/issues in a timely manner.
• Reports project status according to prescribed timelines.

Data Analysis

• Develops business analytics for cost and pricing.
• Develops new insights and understanding of business performance based on data and statistical methods.
• Applies knowledge of data auditing, statistical and quantitative analysis, explanatory modeling, and fact-based management to support recommendations.
• Develops polished executive-level Power BI reports and confidently delivers information in a clear and concise fashion.
• Coincides and communicates between business users and the data warehouse organization, balancing requirements and resources to solve business problems.
• Performs extensive data validation/quality assurance analysis within large datasets.
• Writes ad hoc reports, builds tabular reports, visualizations, and Excel pivot tables or macros to review and report data.
• Communicates effectively with Corporate and Field users.

Minimum Requirement

• Bachelor’s degree in Computer Science, Information Management, or related discipline.
• Minimum of three (3) years’ experience as a Technical Analyst, Business Analyst or similar role.
• One (1) year of experience using Power BI to build metrics/KPIs dashboards with refreshable data connections.

Knowledge, Skills And Abilities

• Proficiency in SQL, including writing complex queries, aggregations, subqueries, and joins to extract and manipulate data from relational databases.
• Communicates effectively in both written and oral.
• Knowledge in operational business processes and systems.
• Proficient in various software programs, including Excel, Word, Outlook and PowerPoint.
• Experience writing TSQL, view, stored procedures, functions, and triggers.
• Demonstrates knowledge of process improvement.
• Understanding of databases, logic views, query tools, and standard file layouts for conversions and interfaces.
• Proven success in a collaborative, team-oriented environment.
• Experience writing Excel VBA macros a plus.

Work Conditions

• Work indoors during all seasons and weather conditions.
• Comply with Corporate dress code policy.
• Sitting continuously for many hours per day, up to 6 hours per day.
• May climb stairs to access buildings frequently.
• Physical effort requiring manual dexterity is required, includes paperwork, calculators, computers and phone usage.
• Working beyond “standard” hours as the need arises.
• Work Hours: Working beyond “standard” hours as the need arises.

Postal Code

77019

Category (Portal Searching)

Marketing and Advertising

Job Location

US-TX - Houston