Job Information
UCLA Health Data Engineer (flex-hybrid) in Los Angeles, California
Description
In this role, you will function as a Database engineer for DGIT Data Operations, with the mindset of securing and backing up all databases on a regular cadence. You will also work closely with our business partners and collaborate with other team members on monthly financial report releases and work closely with other DGIT groups to collaborate on existing or new server configurations.
In addition, under general supervision of the manager of DGIT Data Operations, the Database Engineer will:
be responsible for installation, configuration, database design, pipeline building, migration, capacity planning, performance tuning, security and recovery among other tasks
monitor daily ETLs as well as developing new and enhancing existing ETL packages
apply the expertise required, to build data pipelines with process in place to ensure data quality and conform to the best industry practice of data governance
maintain all VM servers as well as MS SQL Servers on premises, and MS Azure admin tasks
provide general technical support in the areas of database engineering, logical and physical data model design
be expected to work on, maintain, and manage multiple projects simultaneously over an extended period of time, collaborate with developers and appropriately prioritizing tasks and regularly showing progress
will backfill ETL developers and DBAs as needed. They should feel very comfortable covering the duties for ETL Developers and/or Database Administrators.
Our ideal candidate will have at least five years experience in MS SQL Server 2016 or higher, be an experienced database administrator, have experience in ETL development and ability to program in MS TSQL as well as meet the requirements listed in the qualifications section.
This flexible hybrid role allows for a blend of remote and on-site work, requiring presence on-site at least twice a week or as needed based on operational requirements. Please note, travel to the 'home office' location is not reimbursed. Each employee will complete a FlexWork Agreement with their manager to outline expectations and ensure mutual understanding. These arrangements are periodically reviewed and may be adjusted or terminated as necessary.
Salary offers are based on a variety of factors including qualifications, experience, and internal equity. The full salary range for this position is $92,600 - $202,200 annually. The University anticipates offering a salary between the minimum and $125,000.
Qualifications
Candidates should have a B.S. in Computer Science or 5 years' experience in database management.
Detailed experience with using RDBMS (MSSQL, MySQL, Oracle, PostGres) systems.
Experience workings as a database administrator
Mid-level experience in ETL development. Ability to modify existing ETL packages in MSSQL.
Expert level ability to program in SQL (such as PL/SQL, TSQL )
Experience with standard ETL tools such as SSIS, Informatica, ODI.
Experience and knowledge of programming/scripting languages (e.g. .Net, VB, VBA, C#, Python, JavaScript, PowerShell).
Understanding the full Business Intelligence development lifecycle.
Including an understanding of Business Intelligence tool functionality (Power BI, Tableau, SSRS); ability to install and manage BI software systems; experience architecting BI software suites.
Experience working with data used in Healthcare, Medical Education, or Finance
Experience with Big Data and cloud hosted environment (AZURE, AWS)
Strong verbal, interpersonal, and written communication skills
Experience with Window and/or Linux server management.
Demonstrated knowledge of Microsoft Windows Desktop OS.
UCLA Health welcomes all individuals, without regard to race, sex, sexual orientation, gender identity, religion, national origin or disabilities, and we proudly look to each person’s unique achievements and experiences to further set us apart.