BD (Becton, Dickinson and Company) Senior Principal Data Architect in San Diego, California

Job Description Summary

Job Description

The Senior Principal Data Architect is responsible for the design and implementation of data architecture to support various product implementations and strategic objectives for the organization. This includes data modeling, architecture blueprinting, data service design, ETL development, data integration strategy and productionizing data science workloads. The position requires extensive hands-on experience developing data intensive solutions.

Responsibilities

  • Create blueprint of modern data architecture to maximize the value of data and ensure it aligns with current and future business strategy of the company

  • Define and implement data modeling, storage, movement, integration and exchange patterns/strategies

  • Understand and apply database design and development principles for both transactional and dimensional schemas to support application requirements.

  • Develop data acquisition solutions to strategic problems, driving the collection of new data and the refinement of existing data sources

  • Design, plan, and develop programs to optimally extract, transform, and load data from data sources to the target systems.

  • Collaboration with engineering teams on data selection, preprocessing and formatting

  • Follow and improve development processes including but not limited to conducting peer/code reviews, complying with organizational standards, ensuring code maintainability, following build processes, implementing unit tests, and following other industry standard best practices.

  • Evaluate and propose processes, tools and technologies to support data architecture and governance.

Education or Equivalent

  • BS in Computer Science or Information Systems

Experience or Equivalent

  • 10+ years of experience working with Microsoft SQL Server with emphasis on data modeling, ETL, high performance transactional systems, large volume data processing.

Knowledge, Skills, and Abilities Requirements

  • Strong written and verbal communication skills

  • Data modeling tools such as ER/Studio or ERWin

  • Database design skills including OLTP and OLAP design

  • T-SQL development skills

  • Excellent query optimization and performance tuning skills

  • Detailed analytical skills

  • Production troubleshooting skills

  • Experience in the healthcare industry is a plus

  • Experience with Cloud Technologies is a plus

Toolset

  • Embarcadero ER/Studio

  • SQL Azure, Microsoft SQL Server 2016-17

  • Azure Cloud Services

  • ETL Tools like Microsoft SQL Server Integration Services (SSIS)

  • Reporting tools like Qlikview, SSRS, Tableau or PowerBI

  • Microsoft Visual Studio 2015 and above

  • Cloudera Hadoop Stack (Hive, Impala, Flume, Kafka, Spark)

Physical/Mental Requirements

  • Ability to communicate clearly both verbally and in writing.

  • Ability to analyze complex application and business operational issues.

  • Ability to support multiple projects concurrently

Any Additional/Important Information

  • Analyzing business requirements in order to create software designs

  • Estimation and timely completion of tasks

  • Documenting and communicating architectures

  • Supporting application developers and software testers

  • Creating and executing unit tests for developed code

  • Resolving problems in the production system

  • Following quality assurance processes

#LI-TECH

Primary Work LocationUSA CA - San Diego TC Bldg C&D

Additional Locations

Work Shift

Becton, Dickinson and Company is an Equal Opportunity/Affirmative Action Employer. We do not unlawfully discriminate on the basis of race, color, religion, age, sex, creed, national origin, ancestry, citizenship status, marital or domestic or civil union status, familial status, affectional or sexual orientation, gender identity or expression, genetics, disability, military eligibility or veteran status