We use cookies. Find out more about it here. By continuing to browse this site you are agreeing to our use of cookies.

Job posting has expired

Back to search results

Lead Data Architect

Emergent Biosolutions
United States, Massachusetts, Canton
50 Shawmut Road (Show on map)
October 04, 2022

Those who join Emergent BioSolutions feel a sense of ownership about their future. You will excel in an environment characterized by respect, innovation and growth opportunities. Here, you will join passionate professionals who advance their scientific, technical and professional skills to develop products designed-to protect life.


The Lead Data Architect will be part of the Enterprise Information Management (EIM) team reporting to the Director, Enterprise Information & Business Intelligence. The Lead Data Architect will be responsible for architecting and designing the Enterprise Data Warehouse (EDW). The Lead Data Architect will work closely with Business teams and the EIM team to understand business requirements, relate the requirements to available data, assess data from Emergent applications for quality, and build logical and physical dimensional data models to deliver the data to end users in a standard and consistent framework.

This position can be remote / virtual (but must work standard East coast work hours).


The Lead Data Architect is expected to:

  • Own the data model, implementation, and delivery of the Enterprise Data Warehouse (EDW)
  • Analyze legacy applications, understand business requirements, and develop future state data architectures
  • Determine database structural requirements by analyzing functional requirements and business processes, and evaluating existing systems or applications
  • Create and maintain data standards, lineage, and attribute mapping from data sources
  • Conduct data analysis to determine data availability and quality for purposes of reporting
  • Define / design the logical and dimensional data model for the EDW
  • Build a data dictionary that documents and exposes metadata
  • Analyze data in-depth using SQL
  • Audit data regularly to maintain quality
  • Educate other team members on the EDW data model and address questions as needed
  • Multi-task and work in a fast-paced environment with deadlines
  • Work independently

The above statements are intended to describe the nature of work performed by those in this job and are not an exhaustive list of all duties. Nothing in this job description restricts managements right to assign or reassign duties and responsibilities to this job at any time which reflects management's assignment of essential functions.


  • Bachelor's degree in Computer Science, Information Systems, Engineering, Business, or a related field or equivalent experience in a technical or business discipline.
  • 12-15 years' experience with following tools and concepts
  • Databases such as SQL Server / Oracle
  • Columnar databases such as Snowflake / Vertica
  • Data Modeling tools such as ERWin or ER Studio
  • Processing large volumes of structured and unstructured data
  • Data movement and transformation technologies
  • Version Control software such as TFS, CVS or GIT (preferred)
  • Strong analytics skills
  • Strong written and verbal communication skills.
  • Sound business and technical acumen
  • Strong time management, organization, and execution skills
  • Ability and desire to work in a fast paced, dynamic environment
  • Strong collaboration skills required to effectively work across a diverse group including executives, managers and subject matter experts
  • Self-starter who takes initiative to get tasks done
  • Prior experience in the following areas is highly desirable
  • SAP functional modules (Finance/Accounting, Supply Chain, Materials Management, Warehouse Management, Procure to Pay)
  • Delivering BI / DW solutions to end users in the pharmaceutical industry
  • Abilities: Demonstrated capabilities (e.g. able to translate strategy to action, Effective verbal and/or written communicate at all levels of organization, work effectively in ambiguous situations, ability to multi-task, proven track record of increasing customer base)

Per CDC guidelines, Emergent strongly recommends that all employees working on site are vaccinated to help ensure their safety, as well as the safety of fellow employees. This includes the use of good judgment when determining when the CDC guidelines advise that you stay home when ill.

There are physical/mental demands and work environment characteristics that must be met by an individual to successfully perform the essential functions of the job. This information is available upon request from the candidate.

Reasonable accommodations may be made to enable individuals with disabilities to perform all essential functions.

Emergent BioSolutions is an Equal Opportunity/Affirmative Action Employer and values the diversity of our workforce. Emergent does not discriminate on the basis of race, color, creed, religion, sex or gender (including pregnancy, childbirth, and related medical conditions), gender identity or gender expression (including transgender status), sexual orientation, age, national origin, ancestry, citizenship status, marital status, physical or mental disability, military service or veteran status, genetic information or any other characteristics protected by applicable federal, state or local law.

Information submitted will be used by Emergent BioSolutions for activities related to your prospective employment. Emergent BioSolutions respects your privacy and any use of the information submitted will be subject to the terms of our .

Emergent BioSolutions does not accept non-solicited resumes or candidate submittals from search/recruiting agencies not already on Emergent BioSolutions' approved agency list. Unsolicited resumes or candidate information submitted to Emergent BioSolutions by search/recruiting agencies not already on Emergent BioSolutions' approved agency list shall become the property of Emergent BioSolutions and if the candidate is subsequently hired by Emergent BioSolutions, Emergent BioSolutions shall not owe any fee to the submitting agency.