Data Architect

** Facility:*
* ** City
* * San Diego

** Department*
* ** Job Status*
* Regular

** Shift*
* Day

** FTE*
* 1

** Shift Start Time*
* ** Shift End Time*
* Bachelor's Degree

** Hours**  **:*
* ** Shift Start Time:*
* Variable

** Shift End Time:*
* Variable

** AWS Hours Requirement:*
* 8/40 - 8 Hour Shift

** Additional Shift Information:*
* ** Weekend Requirements:*
* As Needed

** On-Call

Required:

*
* No

** Hourly Pay Range (Minimum - Midpoint - Maximum):*
* $67.070 - $86.540 - $96.930

The stated pay scale reflects the range that Sharp reasonably expects to pay for this position.  The actual pay rate and pay grade for this position will be dependent on a variety of factors, including an applicant's years of experience, unique skills and abilities, education, alignment with similar internal candidates, marketplace factors, other requirements for the position, and employer business practices.

** What You Will Do*
* Reviews, analyzes and designs integrated data models that will be implemented within a MS/SQL or Oracle database environment. Provides expertise in full life cycle development for the growth of the Data Warehouse environment and quality technical leadership on critical projects. Performs highly complex tasks and brings unquestioned competency to systems administration duties required to support Sharp's distributed computing environment in a highly available manner.

Provides direct support to internal Sharp Health Care (SHC) staff to evaluate and implement new technology and promote the effective and efficient use of computing resources. Will manage IS project initiatives, provide planning expertise and act as a mentor to other technical staff.

** Required Qualifications*
* + 7 Years experience that includes logical and physical data modeling in a large data warehouse environment with a database architecture comparable to Sharp's (five years of experience as a senior developer within SHC Enterprise Analytics may be substituted for external experience).

** Preferred Qualifications*
* + Bachelor's Degree in Computer Science, Business or related area (relevant experience in excess of seven years or appropriate certifications may be substituted).

** Essential Functions*
* + Data architecture

Utilizes effective analysis and design to create sustainable well performing models using Information Systems accepted framework and tools.

Develops standards and processes to insure best practices are utilized throughout the development life cycle.

Determines the strategy for system architecture design to ensure optimal system performance and throughput and implements successfully.

Utilizes IS standard ETL tools to map source system data to the data warehouse.

Adjusts ETL processes to accommodate changes to source systems and business requirements.

Designs data models for use with IS standard reporting tools according to business needs defined.

Works with technical resources to accomplish objectives.

Designs and communicates physical database designs to database administration.

Develops a process to create and maintain ODS (Operational Data Store) to support data warehouse.

Provides expertise for schema development and model design for all new data sources.

Creates documentation and release notes for thorough project tracking.

Work with team and other IT departments to leverage the data warehouse to meet strategic goals.

Assist in developing solutions for data quality issues that are discovered in the data warehouse.

+ Develop code Analyzes, designs, programs, documents, and maintains computer application software and database files using standard programming conventions.

Interprets and translates functional specifications into efficient and effective code development.

Minimizes re-write penalties as established by department via thorough analysis, creative design, and sound development of code.

Sets standard for technical team for an agile approach to development.

Uses sound judgment in performing change control management appropriately, including synchronization of test and production environments.

Performs code review using sound knowledge and judgment regarding IS principles and department specifications.

Documents file structures, programming…