Senior Business Analyst Job in Houston, Texas Us
Position Summary:
The primary duty of this position is to perform work that requires advanced knowledge of data analysis. In performing the primary duties, the Sr. Data Analyst exercises discretion and independent judgment to include the review, evaluation, design, implementation and maintenance of company databases. He/she writes codes for database access, modifications, and constructions including stored procedures.
Essential Functions:
1. Assists in collection and analysis of macroeconomic data related to IVD segments; assesses trends and highlights HMD competitive gaps
2. Works with functional areas to translate end product needs into database applications based on the requirements of the internal and/or external customers.
3. Responsible for designing, organizing, running, and implementing queries from Oracle Discoverer, SQL and Cognos and expresses data related to business performance.
4. Develops database structure to facilitate the construction of new performance reports and refinement of existing reports.
5. Imports data into databases that is used for multiple reports such as Business Reviews, History of Sales, Gap Analysis, Customer and Vendor Report Cards, GPO and Customer Incentive Reports, Territory Financial Performance; Product Category Performance, etc.
6. Creates Macros and Switchboard applications within Microsoft Access and Excel.
7. Responsible for managing and maintaining the Cognos Report Studio.
8. Processes a large number of Performance Reports for all functional areas; validates and analyzes data.
9. Performs other duties as assigned.
Minimum Requirements/Qualifications:
- Bachelors Degree in Business, Finance or Computer Science along with 5 years of related work experience or MBA
- 2+ years in a position analyzing a variety of complex data
- Wide degree of creativity and latitude is expected
Non-Negotiable Hiring Criteria:
1. Must possess strong analytical skills and intellectual ability to design databases and create queries.
2. Must have advanced working knowledge of MS Office Suite especially, Excel and Access.
3. Must have knowledge of SQL CRM (ACT or Sales Logix) software.
4. Able to create and run Oracle Discover and Cognos queries, simple and complex.
5. Understands business issues that are influencing the healthcare industry; resourceful and creative in identifying market trends and competitive intelligence sources.
- Ability to listen to complex business issues; collaborates with IT and with business data stewards to develop database solutions.
7. Must have decision making ability to perceive and evaluate data source alternatives, analyzes impact of decision before executing them, and implements decision with appropriate evidence and rationale.
8. Ability to work with large data sets - organizes, analyzes, and compares data from multiple sources relevant to customer segment, product category and supplier partners.
- Possesses high level of verbal skills to articulate complex data across multiple constituents.
10. Must be able to work independently.
Working Conditions:
Work is performed in an office environment.