Data Warehouse Operations Administrator

1 month ago

San Francisco, California, United States University of California Full time
Job Summary

This key position will play a critical role in providing data warehouse services to support various areas of our mission, including strategy, operations, education, and research. The successful candidate will be responsible for maintaining and growing our data warehouse technical stack, consulting with developers for smooth deployments, and ensuring data is ingested and curated into our data warehouse on schedule.

Key Responsibilities
  • Administer the systems environment for the UCSF Enterprise Data Warehouse, creating databases, provisioning users, and supporting data engineers to meet UCSF's data and analytics needs.
  • Provision users in Microsoft SQL Server and develop automation processes to eliminate manual effort where possible.
  • Create new databases in SQL Server, hosted in the UCSF Secure Enterprise Cloud - Amazon Web Services (AWS) environment.
  • Manage the environment, including EC2, EBS, DMS, S3, and Lambda.
  • Create new schemas in SQL Server with appropriate attention to data security.
  • Support 20+ ETL developers to host SSIS packages on Integration Services Server.
  • Ensure all departmental best practices for ETL packages are maintained.
  • Troubleshoot ETL errors with developers.
  • Perform day-to-day monitoring of backups/CPU/storage growth.
  • Manage replication tool (DMS) to create/sync and maintain new assets.
  • Maintain the UCSF ETL Framework tool in concert with legacy orchestration methods.
  • Automate and maintain handshakes between DMS replication and downstream data warehouse asset curation ETLs.
  • Use and support all UCSF service tools, including ServiceNow, PagerDuty, portfolio task management, and technical tools SSIS, SSMS, and GitHub.
  • Maintain thorough and detailed documentation around deployment practices, user provisioning, and database management.
  • Create and maintain ETL packages using Microsoft SQL Server Integration Services.
  • Possess excellent communication skills and the ability to articulate system designs and patterns to varying levels of leadership.
  • Participate in project planning, including scoping backlogs and determining estimates.
  • Assume on-call duties to support the operation of reporting and analytics systems.
  • Mentor other data systems analysts to share data warehouse administration knowledge.
  • Maintain appropriate business domain knowledge in healthcare, education, research, finance, or business administration.
Requirements
  • Bachelor's degree in a related area or work-related experience in information technology with an emphasis on database/data warehouse systems support.
  • Minimum 5 years of experience in the following technical areas: Microsoft SQL Server Database Administrator, T-SQL, Microsoft SQL Server Integration Services (SSIS), and administering and orchestrating Jobs in Microsoft Integration Services Server.
  • Experience developing and executing complex test plans.
  • Demonstrated familiarity with AWS tools and terms (S3, EC2, EBS, DMS).
  • Possesses working knowledge of networking and firewalls.
  • Demonstrate effective communication and interpersonal skills.
  • Demonstrate complex problem-solving skills.
  • Detail-oriented technical and process documentation writing and maintenance.
  • Must be able to work with multiple RDBMS environments such as Oracle, SQL Server, MySQL, and so on.
  • Self-motivated and works independently and as part of a team.
  • Able to learn effectively and meet deadlines.
  • Demonstrated ability to automate functions in AWS (e.g., Lambda functions, PowerShell scripts).
About UCSF

At UCSF Health, our mission of innovative patient care, advanced technology, and pioneering research is redefining what's possible for the patients we serve - a promise we share with the professionals who make up our team.

Consistently ranked among the top 10 hospitals nationwide by U.S. News & World Report - UCSF Health is committed to providing the most rewarding work experience while delivering the best care available anywhere.

Pride Values

UCSF is a diverse community made of people with many skills and talents. We seek candidates whose work experience or community service has prepared them to contribute to our commitment to professionalism, respect, integrity, diversity, and excellence - also known as our PRIDE values.

In addition to our PRIDE values, UCSF is committed to equity - both in how we deliver care as well as our workforce. We are committed to building a broadly diverse community, nurturing a culture that is welcoming and supportive, and engaging diverse ideas for the provision of culturally competent education, discovery, and patient care.

Equal Employment Opportunity

The University of California San Francisco is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veteran or disabled status, or genetic information.

  • Data Warehouse Operations Administrator

    4 weeks ago

    San Francisco, California, United States University of California Full time

    Job SummaryThis key position will be integral in providing data warehouse services to support all areas of our mission, including strategy, operations, education, and research. The successful candidate will be responsible for the maintenance and growth of our data warehouse technical stack, consulting with developers for smooth deployments, and satisfying...

  • Data Warehouse Architect

    4 weeks ago

    San Francisco, California, United States Unreal Gigs Full time

    Job Title: Data Warehouse ArchitectAt Unreal Gigs, we're seeking a highly skilled Data Warehouse Architect to join our team. As a key member of our data engineering team, you'll be responsible for designing, building, and maintaining our data warehouse infrastructure and systems.Key Responsibilities:Design and architect scalable and efficient data warehouse...

  • Lead Data Warehouse Architect

    4 weeks ago

    San Francisco, California, United States Unreal Gigs Full time

    Job Title: Lead Data Warehouse EngineerAt Unreal Gigs, we're on a mission to harness the power of data to drive transformative change and solve complex problems across industries. As our Lead Data Warehouse Engineer, you'll play a critical role in shaping the future of data warehouse engineering.Job SummaryWe're seeking an experienced and visionary data...

  • Data Center Operations Manager

    1 month ago

    San Francisco, California, United States Amazon Data Services, Inc. Full time

    About the RoleAmazon Web Services (AWS) is seeking a highly skilled Data Center Operations Manager to join our expanding Infrastructure Operations team. As a key member of our team, you will be responsible for ensuring the overall availability and reliability of our data center operations, meeting or exceeding defined service levels.The ideal candidate will...

  • Cloud Data Engineer

    4 weeks ago

    San Francisco, California, United States Stefanini Group Full time

    Job Summary:Stefanini Group is seeking a skilled Cloud Data Engineer to join our team. As a Cloud Data Engineer, you will be responsible for designing, developing, and implementing complex data warehouse and business intelligence solutions using AWS Cloud Data Warehousing Technologies.Key Responsibilities:• Contribute to the design, development, testing,...

  • Cloud Data Engineer

    4 weeks ago

    San Francisco, California, United States Software Guidance & Assistance Full time

    Job Title: Cloud Data Engineer - Data Warehouse SolutionsJob Summary:Software Guidance & Assistance, Inc. is seeking a Cloud Data Engineer to design, develop, and implement data warehouse solutions using AWS Cloud Data Warehousing Technologies. The ideal candidate will have expertise in developing and analyzing complex SQL, data modeling, and ETL tools, as...

  • Data Center Operations Specialist

    1 day ago

    San Francisco, California, United States Amazon Data Services, Inc. Full time

    About Amazon Data Services, Inc.At Amazon Data Services, Inc., we're passionate about delivering exceptional customer experiences. As the world's most comprehensive and broadly adopted cloud platform, we're committed to innovation and excellence in all that we do.We're seeking a highly skilled Data Center Operations Specialist to join our team. In this...

  • Data Center Operations Manager

    4 weeks ago

    San Francisco, California, United States Amazon Data Services, Inc. Full time

    About the RoleWe are seeking a highly skilled Data Center Operations Manager to join our team at Amazon Data Services, Inc. The successful candidate will be responsible for ensuring the overall availability and reliability of our data center operations, meeting or exceeding defined service levels.The ideal candidate will have experience managing people in a...

  • Data Center Operations Specialist

    1 month ago

    San Francisco, California, United States Amazon Data Services, Inc. Full time

    About the RoleWe are seeking a highly skilled Data Center Operations Specialist to join our team at Amazon Data Services, Inc. As a key member of our Data Center Engineering Operations team, you will play a critical role in maintaining and operating our critical infrastructure systems to ensure 99.999% uptime of our cloud computing portfolio.Key...

  • Data Warehouse ETL Developer and Administrator

    1 month ago

    San Jose, California, United States Resource Informatics Group Full time

    Job Title: Data Warehouse ETL Developer and AdministratorLocation: Hybrid (remote and onsite - 25 up to 50% - every other week)Duration: Long termRate: $market All InclusiveNOTE:Exceptional query, SQL, SSIS and ETL skillsJob Description:This consultant will primarily provide claims and payor data (eligibility, medical, vision, lab, pharmacy) ETL services...

  • Warehouse Operations Manager

    4 weeks ago

    South San Francisco, California, United States Returnmates Full time

    About SwaySway, a fast-growing technology and logistics startup, is revolutionizing the return experience for online shoppers. Our mission is to make online shopping more enjoyable by providing a seamless return process. We combine technology and logistics to offer a white-glove service, eliminating the need for printing, boxes, and tape.Our team is...

  • Warehouse Operations Manager

    1 month ago

    San Francisco, California, United States Short Story Full time

    Job OverviewShort Story is seeking a highly skilled Warehouse Operations Manager to lead our fulfillment center in San Francisco. As a key member of our team, you will be responsible for overseeing the receiving, handling, storing, picking, and packing activities within the warehouse, ensuring quality standards are met at every turn.Key...

  • Warehouse Operations Manager

    4 weeks ago

    South San Francisco, California, United States Returnmates Full time

    About SwaySway, a fast-growing technology and logistics startup, is revolutionizing the return experience for online shoppers. Our mission is to make online shopping more enjoyable by providing a seamless return process. We combine technology and logistics to offer a white-glove service, eliminating the need for printing, boxes, and tape.The RoleWe are...

  • Warehouse Operations Specialist

    4 weeks ago

    San Francisco, California, United States Manpower Engineering Full time

    We are seeking a skilled Warehouse Operations Specialist to support our manufacturing operations in San Francisco, CA. As a key member of our team, you will be responsible for understanding and adhering to all warehouse processes, inventory integrity, and operational process improvements.Key responsibilities include:Understanding and adhering to all...

  • Enterprise Data Warehouse Business Intelligence Developer III

    4 weeks ago

    San Francisco, California, United States ShiftCode Analytics Full time

    We are seeking a highly skilled Enterprise Data Warehouse Business Intelligence Developer III to join our team at ShiftCode Analytics. In this role, you will be responsible for designing, developing, and implementing database architectures, data warehouses, data migrations, data marts, business intelligence packages, and user reporting solutions using BI...

  • Enterprise Data Warehouse Business Intelligence Developer III

    4 weeks ago

    San Francisco, California, United States ShiftCode Analytics Full time

    Job SummaryAt ShiftCode Analytics, we are seeking an experienced Enterprise Data Warehouse Business Intelligence Developer III to join our team. This role will involve designing, developing, and implementing database architectures, data warehouses, data migrations, data marts, business intelligence packages, and user reporting solutions using BI analytical &...

  • Warehouse Operations Manager

    4 weeks ago

    San Francisco, California, United States Updike Distribution Logistics Full time

    About Updike Distribution LogisticsWe are a leading logistics company dedicated to providing exceptional service to our clients.Job Title: Warehouse Operations Manager$67,500 - $82,100 per yearJob DescriptionThe Warehouse Operations Manager is responsible for overseeing the day-to-day operations of our warehouse, ensuring that all tasks are completed...

  • Data Integration Specialist

    4 weeks ago

    San Francisco, California, United States City and County of San Francisco Full time

    About the Role:This is an exciting opportunity to join the City and County of San Francisco as a Data Engineer. As a key member of our team, you will be responsible for designing, developing, and implementing data integration solutions to support our business needs.Key Responsibilities:Assist with all phases of data integration projects, including planning,...

  • Data Engineer

    4 weeks ago

    San Francisco, California, United States Bayone Full time

    Job Title: Data EngineerCompany Overview:At Bayone, we strive to create an environment where people are valued, and differences are celebrated. Our purpose is to empower our teams and inspire our customers to become the best versions of themselves.The Opportunity:Our technology team works fast and smart, developing the latest in mobile technologies, scalable...

  • Warehouse Operations Manager

    1 month ago

    San Francisco, California, United States Summit Bioservices Inc Full time

    Job DescriptionAbout Us: At Summit Bioservices, our mission is to deliver reliable, efficient, and secure storage and logistics solutions that meet the highest standards of quality and compliance. We are committed to supporting our customer's business with services that ensure the integrity and safety of their most valuable assets.Job Summary: We are seeking...