Business Intelligence Developer III

2 weeks ago


Bakersfield, United States KHS Full time

We appreciate your interest in our organization and assure you that we are sincerely interested in your qualifications. A clear understanding of your background and work history will help us potentially place you in a position that meets your objectives and those of the organization. Qualified applicants are considered for positions without regard to race, color, religion, sex (including pregnancy, childbirth and breastfeeding, or any related medical conditions), national origin, ancestry, age, marital or veteran status, sexual orientation, gender identity, genetic information, gender expression, military status, or the presence of a non-job related medical condition or disability (mental or physical).

KHS reasonably expects to pay starting compensation for the position of Business Intelligence Developer III in the range of $41.08- $53.27 hourly.

Our Mission.. Kern Health Systems is dedicated to improving the health status of our members through an integrated managed health care delivery system.

General Purpose:

This position will architect, design, and implement Business Intelligence (BI) data solutions through the creation of data warehouses, data marts, and info-marts while ensuring high levels of data availability. Using a high level of data warehouse analysis, and design experience methodologies will architect data solutions for new Info-mart development and changes to existing data solutions.

Essential Duties and Responsibilities:

General

  • Participate and contribute to the Agile and Project Management methodologies through planning to execution (i.e., requirements gathering; decomposition, development, etc.) in support of department or corporate projects.
  • Ability to manage multiple priority projects and shift priorities as needed as well as produce accurate and precise work, detect discrepancies, and resolve discrepancies all while meeting deadlines.
  • Be an organized individual that is willing to accept responsibility, demonstrate good judgment, initiative, and resourcefulness, and can adapt and learn quickly.
  • Participate in design sessions with organizational stakeholders and business owners to design and build data warehouse to meet business requirements.
  • Conduct or participate in meetings with organizational stakeholders to identify and build Infomart architectures that meet business requirements.
  • Conduct or participate in design sessions with key technical and business owners to design reporting and analytical applications that leverage the Infomart's.
Technical
  • Full understanding of the Structured Query Language (SQL) with the ability to create complex SQL statements within various data structures.
  • Ability to design, develop, implement, and support SQL products including SSIS packages, Agent jobs, RDLC solutions and more.
  • Develop and implement data solutions through the creation of data warehouses, data marts, and info-marts while ensuring high levels of data availability including the ETL used to populate those databases.
  • Develop and implement normalized and dimensional data models (logical and physical) to support reporting, analytics and data integration sources.
  • Establish methods and procedures for tracking data quality, completeness, redundancy, and improvement and will produce guidelines to ensure a manageable infrastructure.
  • Design, create, or modify database tables, indexes, constraints, links, stored procedures, and functions.
  • Implement plans for building target data architecture incrementally, over time.
  • Enforce the change control process for the data architecture artifacts.
  • Mentor and provide leadership to junior members of the team.
  • Develop logical and physical architectural data diagrams.
  • Database/SQL performance and tuning techniques
  • Develop of packages, procedures, functions and triggers
  • Develop dimensional modeling using the following techniques: Star and Snowflake schemas, bridge, dimensions and fact tables for aggregations and hierarchies.
Analytics
  • Has a deep understanding of one or more major business disciplines with a full understanding of the processes, functions, and operations of the Managed Care Organization (MCO).
  • Able to identify and describe current technology, facilities and equipment, location, products and services for one or more major business disciplines, with an understanding of the technical architecture.
  • Understanding the influence of data, created or used by a department, on operations in the assigned department and the ability to document or investigate issues as to why a certain behavior or outcomes are exhibited through department's data or reports.
  • Strong design skills in creating data solutions, easy to understand data models and business views.
  • Has good understanding of Data Vault 2.0 data modeling design pattern used to build a data warehouse for enterprise-scale analytics. The data vault has three types of entities: hubs, links, and satellites.
Communications
  • Develop of standards for best practices for data modeling and educating the company on available info-marts and business views.
  • Facilitate meetings or communications as an interface between business units, technology teams, and other support resources.
  • Strong verbal and written communication skills with the ability to interact professionally with a diverse group, executives, managers, and subject matter experts.
Employment Standards:

Bachelor's degree in Computer Science, Mathematics, or related field from an accredited school or equivalent and four (4) years progressive experience in a Database programming or Data Development position for a medium to large size organization with a structured IT department preferably with at least 2+ years of experience in Data Vault 2.0 modeling methods

-OR-

Ten (8) years progressive experience in a Database programming or Data Development for a medium to large size organization with a structured IT department preferably in healthcare.

Experience may be substituted on a year by year basis. Position is suited for a mid-level to advanced career Reporting and Data Development person.

We are an equal opportunity employer, dedicated to a policy of non-discrimination in employment on any basis.

Other details
  • Pay Type Hourly
  • Min Hiring Rate $41.08
  • Max Hiring Rate $53.27
  • Travel Required No
  • Travel % 0
  • Telecommute % 100
  • Required Education Equivalent Experience


Apply Now

  • Bakersfield, United States Unavailable Full time

    Overview ***This position is remote. The purpose of Dignity Health Management Services Organization (Dignity Health MSO) is to build a system-wide integrated physician-centric full-service management service organization structure. We offer a menu of management and business services that will leverage economies of scale across provider types and...


  • Bakersfield, United States CommonSpirit Health Full time

    Overview: ***This position is remote. The purpose of Dignity Health Management Services Organization (Dignity Health MSO) is to build a system-wide integrated physician-centric full-service management service organization structure. We offer a menu of management and business services that will leverage economies of scale across provider types and...


  • Bakersfield, United States Dignity Health Management Services Full time

    **Overview** **This position is remote.** The purpose of Dignity Health Management Services Organization (Dignity Health MSO) is to build a system-wide integrated physician-centric full-service management service organization structure. We offer a menu of management and business services that will leverage economies of scale across provider types and...


  • Bakersfield, United States Dignity Health Full time

    Overview ***This position is remote. The purpose of Dignity Health Management Services Organization (Dignity Health MSO) is to build a system-wide integrated physician-centric full-service management service organization structure. We offer a menu of management and business services that will leverage economies of scale across provider types and geographies...


  • Bakersfield, United States Dignity Health Full time

    Overview ***This position is remote. The purpose of Dignity Health Management Services Organization (Dignity Health MSO) is to build a system-wide integrated physician-centric full-service management service organization structure. We offer a menu of management and business services that will leverage economies of scale across provider types and geographies...


  • Bakersfield, United States Dignity Health Management Services Full time

    **Overview** **This position is remote.** The purpose of Dignity Health Management Services Organization (Dignity Health MSO) is to build a system-wide integrated physician-centric full-service management service organization structure. We offer a menu of management and business services that will leverage economies of scale across provider types and...


  • Bakersfield, United States Kern Health Systems Full time

    KHS reasonably expects to pay starting compensation for the position of Business Intelligence Data Analyst I in the range of $30.20-40.05 hourly. Our Mission.. Kern Health Systems is dedicated to improving the health status of our members through an integrated managed health care delivery system. **General Purpose**: This position is responsible for...


  • Bakersfield, United States Tri Counties Bank Full time

    Come to work for a company you can be proud to work for...and enjoy fantastic, comprehensive benefits. The hiring range for this opportunity is $70,000 to $95,000 annually along with incentive opportunities, creating a competitive total compensation package based on our pay scale, and may be modified by location and is commensurate with qualifications and...


  • Bakersfield, United States Tri Counties Bank Full time

    Come to work for a company you can be proud to work for...and enjoy fantastic, comprehensive benefits. The hiring range for this opportunity is $70,000 to $95,000 annually along with incentive opportunities, creating a competitive total compensation package based on our pay scale, and may be modified by location and is commensurate with qualifications and...


  • Bakersfield, United States Mark III Construction Full time

    Mark III Construction is growing, and we are looking for a Field Welder/Fitter for a project in Bakersfield. We are looking for an experienced welder proficient in TIG, SMAW welding and or Pipe Fitting. The job will be temporary and expected to go June 2024 - November 2024. Who we are:Mark III Construction is growing and we want you to grow your career with...


  • Bakersfield, California, United States KHS Full time

    We appreciate your interest in our organization and assure you that we are sincerely interested in your qualifications. A clear understanding of your background and work history will help us potentially place you in a position that meets your objectives and those of the organization. Qualified applicants are considered for positions without regard to race,...


  • Bakersfield, United States Mark III Construction Full time

    Mark III Construction is growing, and we are looking for a Field Welder/Fitter for a project in Bakersfield. We are looking for an experienced welder proficient in TIG, SMAW welding and or Pipe Fitting. The job will be temporary and expected to go June 2024 - November 2024. Who we are: Mark III Construction is growing and we want you to grow your career...


  • Bakersfield, United States Mark III Construction Full time

    Mark III Construction is growing, and we are looking for a Field Welder/Fitter for a project in Bakersfield. We are looking for an experienced welder proficient in TIG, SMAW welding and or Pipe Fitting. The job will be temporary and expected to go June 2024 - November 2024. Who we are: Mark III Construction is growing and we want you to grow your career...


  • Bakersfield, United States Mark III Construction Full time

    Job DescriptionJob DescriptionMark III Construction is growing, and we are looking for a Field Welder/Fitter for a project in Bakersfield. We are looking for an experienced welder proficient in TIG, SMAW welding and or Pipe Fitting. The job will be temporary and expected to go June 2024 - November 2024. Who we are:Mark III Construction is growing and we want...


  • Bakersfield, United States Mark III Construction Full time

    Job DescriptionJob DescriptionMark III Construction is growing, and we are looking for a Field Welder/Fitter for a project in Bakersfield. We are looking for an experienced welder proficient in TIG, SMAW welding and or Pipe Fitting. The job will be temporary and expected to go June 2024 - November 2024. Who we are:Mark III Construction is growing and we want...


  • Bakersfield, United States Tri Counties Bank Full time

    POSITION SUMMARY - Treasury Management Officer III The Treasury Management Officer III acts as a supervisor in the absence of the department manager. Completes RFPs as designated by department manager. Trains new treasury management officers and support staff. Demonstrates comprehensive knowledge and understanding of all deposit products and services....


  • Bakersfield, United States Tri Counties Bank Full time

    POSITION SUMMARY - Treasury Management Officer III The Treasury Management Officer III acts as a supervisor in the absence of the department manager. Completes RFPs as designated by department manager. Trains new treasury management officers and support staff. Demonstrates comprehensive knowledge and understanding of all deposit products and services....

  • Plumbing Journeyman

    1 month ago


    Bakersfield, United States Mark III Construction Full time

    Job DescriptionJob DescriptionMark III Construction is seeking a Journeyman Plumber for work on commercial/industrial projects in Bakersfield for a temporary job June - November. Plumbers will perform tasks associated with the assembly and installation of pipes, fixtures, and other plumbing used for water distribution and wastewater disposal.Mission: Leading...

  • Plumbing Journeyman

    4 weeks ago


    Bakersfield, United States Mark III Construction Full time

    Job DescriptionJob DescriptionMark III Construction is seeking a Journeyman Plumber for work on commercial/industrial projects in Bakersfield for a temporary job June - November. Plumbers will perform tasks associated with the assembly and installation of pipes, fixtures, and other plumbing used for water distribution and wastewater disposal.Mission: Leading...


  • Bakersfield, United States California State University Full time

    **Job no**: 539904 **Work type**: Staff **Location**: Bakersfield **Categories**: Unit 9 - CSUEU - Technical Support Services, Finance/Accounting, Probationary, Full Time, On-site (work in-person at business location) **CANDIDATES ELIGIBLE TO APPLY**:THIS RECRUITMENT IS AVAILABLE TO CURRENT ON-CAMPUS EMPLOYEES ONLY. **CLASSIFICATION TITLE**:Accountant...