Senior Data Architect Practice Fusion
San Francisco, CA

Job Description

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

Required Skills:

* 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

Note for Unsolicited Resumes Practice Fusion will not pay a fee to any employment agency or third party for the referral of candidates unless the agency or third party has signed a formal agreement by an authorized member of our People Operations team. Unsolicited resumes from employment agencies or third parties of any kind will become the property of Practice Fusion and will be considered gratuitous, no-fee referrals.