Job Specific Information
The Database Analyst is responsible for data analysis and management reporting for the Brand Sales business.
Essential Duties and Responsibilities
Responsible for maintaining XXXXXX systems and databases on a Weekly/Monthly/Ad-hoc basis
Providing regular updates of XXXXXX files (e.g. Target prescriber listings, zip to territory alignment) to various XXXXXX vendors on as as-needed basis
Learning and maintaining the XXXXXX Customer Master system and regular maintenance of prescribers on the XXXXXX Customer Master system
Providing a weekly update to the Concur system in Finance so Year-end aggregate spend information can be extracted from the Concur system and reported to the Federal government.
Responsible for data analysis and Field/Home Office Management reporting as specified and required
Utilization of position-relevant programming languages and software packages to generate metrics and develops actionable recommendations
Provides support to research team or sales and marketing teams by collecting, analyzing data and reporting results
Collaborates with various functional teams such as marketing, research, IT, Database management to achieve business results
Bachelor’s Degree in Computer Science and Information Systems
Demonstrated high level of proficiency with MS Excel and/or other data computing and formatting software
SQL SERVER 2000, 2005, 2008, 2008R2
VISUAL BASIC 2010 WITH FRAMEWORK 4.5
Enterprise Management Software
SAP BUSINESS INTELLIGENCE
Business Intelligence Systems
Archi-tech Systems – D.A.R.T.
Territory Mapping Systems
ZS Associates’ Javelin Territory Mapping
TACTICIAN Corp. – Tactician Mapping