Sr Data Architect
San Francisco, CA

Job Description

Overview

We're hiring a talented Senior Data Architect to fill an important hands-on role. You will be part of a Data Platform Architecture team responsible for all aspects of data platform development. You will be involved in the full development life cycle of the solution, including design, data modeling, code development, refactoring, data migrations, code reviews, unit testing, tuning, deployment activities, and post-deployment support. As a member of the Data Architecture team you'll work to ensure designs are aligned across the organization and with long-term objectives in mind.

Responsibilities

* Provide a critical role in a highly agile scrum environment working against light requirements
* Create and manage logical and physical data models using market leading ER tools
* Implement physical data models in MPP Database systems, other RDBMS platforms, and noSQL platforms (MongoDB)
* Implement processes for database code deployment and synchronization across environments
* Participate as an active member of the team to ensure Data Architecture standards and vision are followed
* Develop stored procedures and relevant data manipulation code
* Code review and provide constructive feedback on database changes from engineers
* Provide technical leadership and mentoring on database technologies and issues to engineers
* Work with DBA team to identify database and storage bottlenecks, propose design solutions and tune queries
* Work with the Data and Analytics Business team to ensure correct source-to-target mappings and transformations between source and platform systems aligned with business and operational objectives
* Participate in story writing and grooming

Qualifications

Academic and Professional Qualifications:

* Bachelor's Degree with a major in Computer Science, Mathematics, MIS or related

Experience:

* 10+ years of full life cycle database development experience in a hands on role, including stored procedure development
* Skills with Embarcadero ER/Studio, Erwin, or other data modeling tool in an OLTP environment
* Experience developing conceptual, logical, and physical data models
* Strong understanding of data normalization
* Experience with complete software development life cycle-from concept to delivery
* Experience working with terabyte data sets, billion+ row tables, and high transaction volumes in an OLTP environment
* Experience reading query execution plans, optimizing queries, and designing proper indexes
* Experience using git, svn, or other source control systems, including branching and merging
* Experience with database applications in C# .NET or Java, including data access strategies
* Self-starter with exceptional communication skills
* Experience working in an agile environment

Bonus:

* Experience in healthcare technology
* Startup experience
* Experience with service-oriented architectures and microservices
* Experience with distributed systems and cloud computing
* Dimensional data modeling experience
* Experience with Netezza, Greenplum, Teradata or other MPP warehouse technology
* Experience with Hadoop
* Experience with MongoDB
* Experience with Red Gate tools
* Experience with Jenkins or similar continuous integration systems
* Experience with FHIR

Travel Requirements:

* Little to no travel

Working Arrangements:

* Core hours are based on local time zone, but willing to be flexible in work schedule to accomodate various time zones of a global organization
* Work is performed in a standard office or home environment with minimal exposure to health or safety hazards

At Allscripts, our greatest strength comes from bringing together talented people with diverse perspectives to support the technology needs of 180,000 physicians, 1,500 hospitals and 10,000 post-acute organizations across the globe. Allscripts offers a competitive total rewards package, including holidays, vacation, and medical, disability and life insurance.

We are an Equal Opportunity Employer. No job applicant or employee shall receive less favorable treatment or be disadvantaged because of their gender, marital or family status, color, race, ethnic origin, religion, disability or age; nor be subject to less favorable treatment or be disadvantaged on any other basis prohibited by applicable law.