Lead Data Architect

Gaithersburg, MD, US
Nov 01, 2020
Required Education
Bachelors Degree
Position Type
Full time
Lead Data Architect

Emergent BioSolutions is currently seeking a seasoned Data Architect for its Information Management Strategy. The Data Architect will be part of the Information Management team and will be primarily responsible for architecting and designing the Enterprise Data Warehouse. S(he) will work closely with Business and the IM 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.

Essential Functions

The Data Architect is expected to have the ability to:
  • Have ownership of the Data Model, Implementation and Delivery of the Enterprise Data Warehouse
  • Analyze legacy applications, understand business requirements and develop future state data architectures
  • Determine database structural requirements by analyzing functional requirements, client business operations information, and evaluating existing system 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 IM Metadata
  • Analyze data in-depth using SQL
  • 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


Education and Years of Experience:
  • 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 yrs. of prior experience in the following areas:
    • Good to excellent understanding of SAP functional modules (SC, MM, WM, PP)
    • Delivering BI / DW solutions to end users in the Pharmaceutical industry

Required Skills/Certifications:
  • Strong written and verbal communication skills.
  • Self-starter who takes initiative to get tasks done
  • 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)

Physical/Mental Demands and Work Environment Characteristics

  • 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.

.buttontextd24067979861e38d a{ border: 1px solid transparent; } .buttontextd24067979861e38d a:focus{ border: 1px dashed #c11d4b !important; outline: none !important; }