Data Architect
San Francisco, CA

Job Description

Overview

We're hiring a talented Data Architect for an important hands-on role. You will be part of a Data Architecture team responsible for all aspects of data platform development. You will contribute to the full software development life cycle, including data modeling, application development, refactoring, data migrations, code reviews, unit testing, performance tuning, deployment activities, and post-deployment support. As a member of the Data Architecture team you'll implement designs with long-term objectives in mind.

Responsibilities

* Collaborate in a highly agile scrum environment working against light requirements
* Create and manage logical and physical data models using Embarcadero ER/Studio
* Implement physical data models in SQL Server, Postgres, and AWS Redshift
* Ensure Data Architecture standards and vision are followed
* Code review and provide constructive feedback on database changes from engineers
* Provide technical leadership and mentoring on database technologies and issues to engineers
* Develop stored procedures
* Work with DBA team to identify database and storage bottlenecks, propose design solutions, and tune queries
* Ensure correct source-to-target mappings and transformations between OLTP systems and data warehouses
* Participate in story writing, grooming and estimating level of effort, interoperability, reliability, availability and performance of Allscripts software products.

Qualifications

Academic and professional qualifications:

* Bachelor's or Master's Degree in Computer Science, or equivalent work experience
* 3+ years of full life cycle database development experience in a hands-on role, including writing stored procedures

Experience:

* Skills with Embarcadero ER/Studio, Erwin, or other data modeling tool for OLTP systems
* Experience developing conceptual, logical, and physical data models for relational databases
* Strong understanding of data normalization
* Complete software development life cycle-from concept to delivery
* Terabyte data sets, 100 million+ 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
* Database applications in C# .NET or Java, including data access strategies
* Collaborating in an agile software development environment
* Self-starter with strong communication skills

Bonus:

* Healthcare information technology
* Service-oriented architectures and microservices
* Distributed systems and cloud computing
* Dimensional data modeling experience
* Netezza, Redshift, Snowflake, Yellowbrick, Greenplum, Teradata or other MPP warehouse technology
* Document data stores, such as MongoDB
* Red Gate tools
* Jenkins or similar continuous integration systems
* FHIR, HL7, and other healthcare industry standards

Travel requirements:

* Ability to travel as required, expected less than 5% travel

Working arrangements

* Office environment

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 comprehensive compensation and benefits package, including holidays, vacation, medical, dental, and vision insurance, company paid life insurance and retirement savings.

Allscripts policy is to provide equal employment opportunity and affirmative action in all of its employment practices without regard to race, color, religion, sex, national origin, ancestry, marital status, protected veteran status, age, individuals with disabilities, sexual orientation or gender identity or expression or any other legally protected category. Applicants for North American based positions with Allscripts must be legally authorized to work in the United States or Canada. Verification of employment eligibility will be required as a condition of hire.

From a "VEVRAA Federal Contractor" We request Priority Referral of Protected Veterans