Data Platform Administrator - San Francisco, United States - San Francisco Health Plan

Description

The Data Platform Administrator designs and builds complex relational databases, data warehouses and data marts. Works with technical users, application developers as well as end users to understand business requirements and identify data solutions. They will develop strategies for data acquisition, archival/recovery, and enterprise level database implementation.

Designs, develops, implements, and maintains health care application systems to support business processes within the organization using modern database technologies.

The candidate works with users, data analysts and developers to understand, to define and to clarify business process and database solutions to support those processes.

Responsible for creating and maintaining routine reports and for ad hoc analyses as required by the business.

The candidate will need to understand the end-to-end business data cycle including the software applications which the business uses, how data is transformed in the enterprise data warehouse and ultimately how it is reported and used as feedback to the business.

Responsible for creating physical database tables, typically from designs provided by the database analyst, data architect or data modeler.

Administers and controls the organization's data resources, including multiple relational databases and servers, appliances, cloud services and enterprise job schedulers.

SFHP proudly supports a hybrid work environment - as such, this position will be required to be onsite, in-office a minimum of 4 days per month.

Salary range:
$112,000 - $126,000


WHAT YOU WILL DO
Work with development services staff to design database architectures, coding standards, and quality assurance policies and procedures.
Conduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development efforts.
Create physical and logical models for new database development and/or changes to existing ones.
Respond to and resolve database access and performance issues.
Monitor database system details within the database, including stored procedures and execution time, and implement efficiency improvements.
Monitor and optimize physical data storage for database systems.
Plan and coordinate data migrations between systems.
Adhere to and maintain change control and testing processes for modifications to databases.
Establish appropriate end-user database access control levels, using role-based security and OS-authentication.
Develop routines for end users to facilitate best practices database use.
Analyze, chart data and process flows, and write programs to effect revisions or enhancements to existing programs or sub-systems.
Review, manage, and resolve simple to highly complex problems involving one or more systems or functions.
Provide information for design interfaces between sub-systems where existing programs have been revised or new programs developed.

Foster an environment that solicits and enlists diverse and inclusive perspectives and approaches to better serve our staff, our members and our providers.

WHAT YOU WILL BRING
Bachelor's degree from an accredited institution.
3-7 years as a DBA with 3+ years database-specific programming experience.

Must have in-depth expertise with data security, storage solutions, database virtualization and replication as well as other complex technical tools and solutions.

Health care industry experience and knowledge (managed care operations, HIPAA, Medicare and Medi-Cal rules) with a blend of Fortune 500 and small company or not-for-profit experience is highly desirable.

Demonstrated skills using reporting tools and languages such as SSRS, SSAS, MS Excel and other data analysis tools.
Mastery of T-SQL concepts - must be sufficient to filter, aggregate, and format data using SQL only.

Must show demonstrated experience with creating the full complement of native SQL Server objects (tables, keys, indexes, constraints, views, stored procedures, table-based UDF's, scalar-based UDF's and schemas, etc.).

Mastery of SQL Server system metadata and how to leverage in building solutions.
Ability to distinguish set-based versus cursor-based solution approaches, with a bias towards operating on data with a set-based methodology.
Familiarity with programming languages such as Visual C# and ADO.NET are required.
Experience with native SQL XML capabilities.
Advanced analytical skills and problem-solving skills with the ability to formulate and communicate recommendations for improvement.

WHAT WE OFFER

A competitive and robust compensation package, including:

Medical:
You'll have a choice of medical plans, including options from Kaiser and Blue Shield of California.

Employee-only coverage in the HMO plans is currently available at no cost and dependent coverage is heavily subsidized by SFHP.

Dental:
You'll have a choice of a basic dental plan or an enhanced dental plan which includes orthodontic coverage.

Vision:
Employee vision care coverage is available through Vision Service Plan (VSP).
Retirement

– Employer-matched CalPERS Pension and 401(a) plans, 457 Plan
Time off

– 23 days of Paid Time Off (PTO) and 13 paid holidays

Professional development :
Opportunities for tuition reimbursement, professional license/membership.
An opportunity to work in a

vibrant atmosphere

with the most

amazingly talented

people who are shaping the future of healthcare
The chance to

make a difference

in the lives of many San Francisco residents
San Francisco Health Plan is an E-Verify

participating employer.

#J-18808-Ljbffr