For the safety of our employees and communities in response to COVID-19, ACADIA has implemented a temporary work from home policy. As a part of this shift, we have migrated all interviews to virtual interviewing via phone and video.

Position Summary:

This position is responsible for ensuring the delivery of daily/weekly/monthly/quarterly/ad-hoc integrations within ACADIA’s internal Data Warehouse(s) and external systems.  The position will work with Managed Service partners and other internal team members as needed to coordinate these activities.

Will participate and lead the analysis and resolution of issues related to information flow and content with our Business Customers, IT management, and staff. Develop expertise with ACADIA’s integration tools and reporting environments.  You will support day to day operational activities and at times participate in project related work.

Primary Responsibilities:

  • Understand and document business requirements and processes.
  • Function as the primary point of contact related to the day-to-day execution of Master Data Management (MDM) related tasks.
  • Work to answer questions, resolve data issues and provide analysis.
  • Conduct data investigations across multiple integrated systems.
  • Review and analyze source data and ensure data accuracy and integrity. Guide and advise data analysts to implement process and system improvements to enhance integrity and accuracy of master data.
  • Work with stakeholders to understand their available data, optimize associated data model and create business insights.
  • Supports and performs master data additions, changes and deletions in accordance with procedures and business rules as needed for day-to-day operations.
  • Ensure requests for master data maintenance are properly authorized and approved by working with appropriate Data Managers and Data Owners.
  • Educate users on master data processes and business rules.
  • Review reports and performance indicators to locate and correct data and processes where needed.
  • Serve as the SME on master data.
  • Execute change management and creation of other supporting documentation for integrations.
  • At times, extract, transform, and load data into Enterprise Systems and Reporting tools.
  • Ad Hoc Report creation as needed.
  • Participate in business process re-engineering activities, as applicable.
  • Participate in system integration testing and data verification.
  • Document all procedures related to position.

Education/Experience/Skills:

Bachelor’s degree in computer science or information systems.  An equivalent combination of relevant education and applicable job experience may be considered.  A minimum of 5 years’ experience, preferably in the pharmaceutical industry—ideally, supporting data services/integration, data warehousing, and business intelligence. 

Must Possess:

  • Experience with Master Data Management principles.
  • Experience utilizing an SDLC approach.
  • Knowledge of typical text-based file formats and tools to manipulate these ad-hoc data files.
  • Proficiency using SQL to query data residing in a database.
  • Ability to act as “technical translator” between IT and business groups.
  • Ability to explain complex data to all levels of data consumers.
  • Ability to handle a variety of task at one time.
  • Excellent problem solving skills.
  • Must enjoy working in a team environment and have good communication, organization and documentation skills.
  • Enjoy working with end users.

Preferred:

  • Data warehousing experience.
  • Pharmaceutical experience.
  • Experience with ETL tools and methods.
  • Experience with dimensional database models.
  • Experience with Reltio or another MDM platform.
  • Experience with launch of a new pharmaceutical product.
  • Experience with cloud-based databases and applications.

Scope:

Having broad expertise or unique knowledge, uses skills to contribute to development of company objectives and principles and to achieve goals in creative and effective ways, exercising independent judgment in methods, techniques and evaluation criteria for obtaining results.

Works on significant and unique issues where analysis of situations or data requires an evaluation of intangibles.  Acts independently to determine methods and procedures on new or special assignments.

Physical Requirements:

While performing the duties of this job, the employee is regularly required to stand; walk; sit; use hands to finger, handle, or feel; reach with hands and arms; climb or balance; stoop, kneel, crouch, see, talk or hear in a standard office environment and independently from remote locations. Employee must occasionally lift and/or move up to 20 pounds.  

ACADIA is an Equal Employment Opportunity/Affirmative Action Employer: Minority/Female/Disability/Veterans/Sexual Orientation and Gender Identity

Apply for this Job

* Required

  
  


U.S. Equal Opportunity Employment Information (Completion is voluntary)

Individuals seeking employment at Acadia Pharmaceuticals Inc. are considered without regards to race, color, religion, national origin, age, sex, marital status, ancestry, physical or mental disability, veteran status, gender identity, or sexual orientation. You are being given the opportunity to provide the following information in order to help us comply with federal and state Equal Employment Opportunity/Affirmative Action record keeping, reporting, and other legal requirements.

Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

Race & Ethnicity Definitions

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.


Form CC-305

OMB Control Number 1250-0005

Expires 05/31/2023

Voluntary Self-Identification of Disability

Why are you being asked to complete this form?

We are a federal contractor or subcontractor required by law to provide equal employment opportunity to qualified people with disabilities. We are also required to measure our progress toward having at least 7% of our workforce be individuals with disabilities. To do this, we must ask applicants and employees if they have a disability or have ever had a disability. Because a person may become disabled at any time, we ask all of our employees to update their information at least every five years.

Identifying yourself as an individual with a disability is voluntary, and we hope that you will choose to do so. Your answer will be maintained confidentially and not be seen by selecting officials or anyone else involved in making personnel decisions. Completing the form will not negatively impact you in any way, regardless of whether you have self-identified in the past. For more information about this form or the equal employment obligations of federal contractors under Section 503 of the Rehabilitation Act, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

You are considered to have a disability if you have a physical or mental impairment or medical condition that substantially limits a major life activity, or if you have a history or record of such an impairment or medical condition.

Disabilities include, but are not limited to:

  • Autism
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, or HIV/AIDS
  • Blind or low vision
  • Cancer
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or hard of hearing
  • Depression or anxiety
  • Diabetes
  • Epilepsy
  • Gastrointestinal disorders, for example, Crohn's Disease, or irritable bowel syndrome
  • Intellectual disability
  • Missing limbs or partially missing limbs
  • Nervous system condition for example, migraine headaches, Parkinson’s disease, or Multiple sclerosis (MS)
  • Psychiatric condition, for example, bipolar disorder, schizophrenia, PTSD, or major depression

1Section 503 of the Rehabilitation Act of 1973, as amended. For more information about this form or the equal employment obligations of Federal contractors, visit the U.S. Department of Labor's Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.