Data Warehouse Analyst

2 weeks ago

San Francisco, California, United States San Francisco Health Plan Full time
Job DescriptionJob Description

Reporting to the Manager, Data Engineering, the Data Warehouse Analyst is responsible for providing systems analysis support for technology-enabled solutions specifically focused on the organization's data management and data warehouse programs. You will work closely with business leaders and users, subject matter experts, project managers and IT professionals. You will elicit requirements and provide clear, concise documentation, analyze systems, analyze data, troubleshoot and provide root cause analysis, and contribute to systems-related business process design and improvement.

Please note that while SFHP supports a hybrid work environment, this role will be required to be onsite and in-office a minimum of 4 days per month. This is a hybrid position, based in our Downtown San Francisco office.

Salary Range: $109,341 to $121,489

WHAT YOU WILL DO:

  • Work effectively in a team environment, utilizing Agile methodologies
  • Work directly with business partners, project managers, all levels of management, technical staff, architects and vendors to analyze Business Requirements/Need and create clear and concise Functional Specifications (supporting workflows, data analysis, etc.) according to standards and best practices
  • Actively lead and participate in requirements elicitation and apply a combination of business and technical knowledge to solve business problems with cost-effective technical solutions. Provide guidance to the business as to what is available as a technical solution
  • Understand the structure, policies, and operations of SFHP organization, and recommend solutions which enable SFHP to achieve its goals
  • Propose and design practical methods of process standardization, automation and incremental changes to drive efficiencies
  • Possess complete understanding of the SFHP data ecosystem surrounding target requirements, upstream and downstream impacts
  • Intimate knowledge of the organizations data pipelines and warehouse and how they interact with key applications
  • Use creative problem-solving skills to remove barriers and effective communication skills to keep all parties informed of status
  • Become Subject Matter Expert (over time) in MediCal/Medicare data over time
  • Support production system incidents; troubleshoot and provide root cause analysis
  • Work with end-users as needed to develop and execute test plans to verify business systems and processes work as expected
  • Adhere to SFHP's Change Management/Release Management Policies and Procedures such as submitting appropriate and timely change requests
  • Develop and recommend operational processes and /or process improvements
  • Outline comprehensive action plan to implement said process improvements.
  • Act as an advocate for business users across the organization and support the business with helping to prioritize their requests
  • Provide end-user training for implemented systems/processes as well as accompanying user guides

WHAT YOU WILL BRING:

  • A degree from a four-year college (e. g., BS) in a relevant field or equivalent work experience
  • Prior experience at a healthcare organization, particularly at a managed health plan
  • Experience in Agile Methodology and User Story refinement
  • Minimum 6 years of experience as a Business Systems Analyst, Systems Analyst, Technical Analyst or comparable position in a healthcare environment
  • 2 - 4 years' experience with relational databases, standard data warehouse concepts (dimensional models, etc) and writing SQL queries
  • Intermediate experience with Microsoft Visio or comparable business process design software preferred.
  • Familiarity in managing requirements and test suites in Azure DevOps preferred
  • Familiarity with HIPAA healthcare EDI transactions and file formats preferred
  • PC literacy required; MSOffice skills (Outlook, Word, Excel, PowerPoint)

WHAT WE OFFER:

A competitive and robust compensation package, including:

  • Health Benefits
    • 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

ABOUT SFHP:

Established in 1997, San Francisco Health Plan (SFHP) is an award winning, managed care health plan whose mission is to provide affordable health care coverage to the underserved low and moderate-income residents in San Francisco County. SFHP is chosen by eight out of every ten San Francisco Medi-Cal managed care enrollees and its 175,000+ members have access to a full spectrum of medical services including preventive care, specialty care, hospitalization, prescription drugs, and family planning services. SFHP was designed by and for the residents it serves and takes great pride in its ability to accommodate a diverse population that includes young adults, seniors, and people with disabilities.

San Francisco Health Plan is proud to be an equal opportunity employer. We are committed to a work environment that supports, inspires, and respects all individuals and in which our people processes are applied without discrimination on the basis of race, color, religion, sex, sexual orientation, gender identity, marital status, age, disability, national or ethnic origin, military service status, citizenship, or other protected characteristics.

Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records.

San Francisco Health Plan is an E-Verify participating employer.

Hiring priority will be given to candidates residing in the San Francisco Bay Area and California.

  • Data Analyst

    4 days ago

    San Francisco, California, United States 500 Full time

    We are looking to hire a Data Analyst to join our data team. You will take responsibility for managing our master data set, developing reports, and troubleshooting data issues.To do well in this role you need a very fine eye for detail, experience as a data analyst, and a deep understanding of the popular data analysis tools and databases.Data Analyst...

  • Data Warehouse Engineer

    2 weeks ago

    San Francisco, California, United States Unreal Gigs Full time

    Company Overview: Welcome to the forefront of data-driven decision-making At our company, we're committed to harnessing the power of data to drive insights and innovation. Our mission is to develop scalable and efficient data warehouse solutions that empower organizations to make informed decisions based on high-quality data. Join us and be part of a dynamic...

  • Data Warehouse Manager

    2 weeks ago

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

    Data Warehouse ManagerIT - Enterprise Analytics Full Time 77516BR Job Summary As a preeminent health sciences campus and health system, the University of California, San Francisco (UCSF) is at the forefront of creation new knowledge from the exploding volume of clinical, discovery, and education data that it creates and manages. UCSF believes that the...

  • Lead Data Warehouse Engineer

    2 weeks ago

    San Francisco, California, United States Unreal Gigs Full time

    Company Overview: Welcome to the forefront of data-driven innovation Our company is dedicated to harnessing the power of data to drive transformative change and solve complex problems across industries. We're committed to building scalable and efficient data warehousing solutions that enable advanced analytics, reporting, and business intelligence. Join us...

  • BI Data Analyst

    2 weeks ago

    San Jose, California, United States Georgia IT Inc Full time

    BI Data Analyst San Jose, CA (Remote) Contract U.S. Citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor currently Responsibilities: nalyzes and determines information needs and elements, data relationships and attributes, data flow and storage requirements, and data output and reporting capabilities ...

  • Data Analyst

    2 weeks ago

    San Francisco, California, United States Insight Global Full time

    Data Analyst Position: The role of the Data Analyst involves conducting comprehensive data analyses to support the development of innovative analytical solutions. Leveraging their technical expertise, they ensure data accuracy and quality, and then transform, design, and present it in ways that facilitate informed, data-driven decision-making for...

  • Program Data Analyst Intern

    2 weeks ago

    San Francisco, California, United States WeaveGrid Full time

    Welcome to WeaveGrid - Shaping the Future of TransportationAbout UsThe evolution of transportation leans towards electric methods, and our cutting-edge software addresses the key challenges in grid integration, ensuring a smooth and sustainable energy shift. WeaveGrid's enterprise solutions are designed to facilitate the upcoming electrification trend...

  • Data and Reporting Analyst 1

    4 weeks ago

    San Francisco, California, United States Magellan Health Full time

    Provides data collection, data management, data analysis and reporting, and decision management tool design and development. Responsible for interfacing with IT to ensure utilization and effective use of IT sponsored tools. Provide basic programming and technical skills to support data management and reporting requirements.Works with designated department to...

  • Data and Reporting Analyst 1

    2 weeks ago

    San Francisco, California, United States Magellan Health Full time

    Provides data collection, data management, data analysis and reporting, and decision management tool design and development. Responsible for interfacing with IT to ensure utilization and effective use of IT sponsored tools. Provide basic programming and technical skills to support data management and reporting requirements.Works with designated department to...

  • Sr. Data Analyst

    2 weeks ago

    San Francisco, California, United States Windfall Full time

    At Windfall, we aim to democratize access to people data and insights. We use a vast and varied data asset to help non-profits exceed their donation goals, and commercial companies achieve higher ROI on their marketing spend. As a Sr. Data Analyst at Windfall, your role will be to contribute to a deeper understanding of these data assets, and how they can be...

  • Data Analyst with W2 and OPT

    3 months ago

    San Francisco, California, United States absolute Full time

    We're looking for a Data Analyst to join our Database team. The perfect candidate must have one year of experience found SQL and Excel. The day to day obligations for the Data Analyst prospect has validating big data sets producing reports with Microsoft Excel and operating SQL queries to help you solve issues with the database program. There'll be an...

  • Data Analyst

    2 weeks ago

    San Francisco, California, United States Ridepanda Careers Full time

    You will ensure that various stakeholders at Ridepanda can understand their data and use it to solve problems, answer questions, and make decision. You will uncover your own insights and proactively dig into data equipped with a high level of business context. You will help implement dashboards using query builders and SQL. In addition, you will work closely...

  • Senior Data Analyst

    4 weeks ago

    San Francisco, California, United States Fastly Full time

    Fastly helps people stay better connected with the things they love. Fastly's edge cloud platform enables customers to create great digital experiences quickly, securely, and reliably by processing, serving, and securing our customers' applications as close to their end-users as possible — at the edge of the Internet. The platform is designed to take...

  • Senior Data Analyst

    2 weeks ago

    San Francisco, California, United States Fastly Full time

    Fastly helps people stay better connected with the things they love. Fastly's edge cloud platform enables customers to create great digital experiences quickly, securely, and reliably by processing, serving, and securing our customers' applications as close to their end-users as possible — at the edge of the Internet. The platform is designed to take...

  • Senior Data Analyst

    4 weeks ago

    San Francisco, California, United States Fastly Full time

    Fastly helps people stay better connected with the things they love. Fastly's edge cloud platform enables customers to create great digital experiences quickly, securely, and reliably by processing, serving, and securing our customers' applications as close to their end-users as possible — at the edge of the Internet. The platform is designed to take...

  • Data Analyst

    4 weeks ago

    San Francisco, California, United States Cash App Full time

    Company DescriptionIt all started with an idea at Block in 2013. Initially built to take the pain out of peer-to-peer payments, Cash App has gone from a simple product with a single purpose to a dynamic ecosystem, developing unique financial products, including Afterpay/Clearpay, to provide a better way to send, spend, invest, borrow and save to our 47...

  • Data Analyst MX

    2 weeks ago

    San Francisco, California, United States Simera Full time

    Welcome to Simera, a leading global employment company that specializes in connecting top talent with exciting remote work opportunities from our network of US-based clients.At Simera, our cutting-edge technology creates detailed talent profiles for job seekers, focusing on their unique skills, work experience, and educational background. Our dedicated...

  • Senior Data Engineer

    3 weeks ago

    San Francisco, California, United States Nightfall AI Full time

    Nightfall AI ) is the unified platform that prevents data leaks and enables secure collaboration by protecting sensitive data and controlling how it's shared. For decades, legacy data leak prevention (DLP) solutions have failed to adequately protect sensitive information. Traditional DLP is outdated, intrusive, and complex - it wasn't designed for today's...

  • Sr. Operations Data Analyst

    2 months ago

    San Francisco, California, United States Pacific Gas and Electric Company Full time

    Summary: The Operations Data Analyst extracts operations data for analysis, leadership support and responses to ad hoc data requests. The incumbent maintains operations tools & databases ensuring that it is kept up-to-date using data from various PG&E systems. The Analyst identifies and solves current gaps in data requirements and ease of access to ensure...

  • Sr. Operations Data Analyst

    4 weeks ago

    San Francisco, California, United States Pacific Gas and Electric Company Full time

    Summary: The Operations Data Analyst extracts operations data for analysis, leadership support and responses to ad hoc data requests. The incumbent maintains operations tools & databases ensuring that it is kept up-to-date using data from various PG&E systems. The Analyst identifies and solves current gaps in data requirements and ease of access to ensure...