Senior Data Analyst (2007148)

Cegedim Dendrite is the world's leading CRM business provider for the pharmaceutical and life science industry. Through our unmatched suite of integrated, value-added products we ensure our clients' have access to the world's most complete healthcare professional database, as well as access to powerful, global R&D resources that stimulate development of innovative products and drive improved bottom-line performance for our customers. Our dedicated customer service is focused on life science and committed to serving the needs of this community across the globe and around the clock.DescriptionSenior Data Analyst Key Accountabilities • Designs, creates, tests, documents, and supports all code required to perform the extraction, transformation, and load process from disparate formats at the direction of client account managers, data warehouse managers and other senior managers • Independent priority management, issue resolution, project coordination and QA/QC oversight, troubleshooting, problem resolution and continuous quality improvement, including documented procedural modifications, client metadata management, client environment QC and more • Technical lead for all aspects of a large scale SQL Server environment • Provides operational support to the production database environment including building, scheduling, and monitoring the necessary support jobs, and resolving database related production problems of concern • Works with other teams to ensure corporate standards and architecture vision is realized and that the problem at hand is solved • Evaluates and assesses client requirements and delivers proper solutions within the context of client needs • Proactively manages server capacity, design • Mentor junior staff in all of the above, in time Major Responsibilities • Will perform analysis, design, development, and testing of extract, transformation, and load processes • Will analyze data to identify data cleanliness issues, e.g., missing values, duplicate meanings, and invalid data and develop cleansing routines. • Will assist in the development of project plans, setting of timelines, determining trade-offs, and task dependencies. • Will utilize ETL tools for data management, conversion, migration, and integration. • Will work to enhance the tools currently in use to gather data from sources. • Will perform additional duties as required.Required SkillsPosition Requirements • BA/BS from an accredited university required • Recognized expert in Microsoft SQL Server, T-SQL, DTS, SSIS • Proven expertise in large scale design, creation, testing, production cutover, production management, capacity management and ETL infrastructure coordination required • Ideally, all of the above combined with a process management background in QA/QC for both large scale and ad hoc data transformation and loading • 5 or more years experience highly desirable • Experience with SFA, pharmaceutical data, syndicated sales data, ETL tools and processes is a plus Please submit your application with salary requirements: http://hostedjobs.openhire.com/epostings/jobs/submit.cfm?fuseaction=dspjob&jobid=282429&company_id=15614&jobboardid=24 Cegedim Dendrite is an Equal Opportunity Employer committed to workforce diversity. M/F/D/V. www.cegedimdendrite.com Status: Full Time, Employee Job Category: IT/Software Development