BD (Becton, Dickinson and Company) Senior Principal Data Architect in San Diego, California
Job Description Summary
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.
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
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)
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
Primary Work LocationUSA CA - San Diego TC Bldg C&D
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