W1siziisimnvbxbpbgvkx3rozw1lx2fzc2v0cy9rdwfsaxr5ifn0ywzmaw5nieftzxjpy2evanbnl2jhbm5lci1kzwzhdwx0lmpwzyjdxq

Data Modeler

  • Location

    Pasadena, United States

  • Sector:

    Technical

  • Job type:

    Contract

  • Contact:

    Leric Arcigal

  • Job ref:

    20387

  • Published:

    about 1 year ago

  • Expiry date:

    2020-07-15

Designs, deploys and manages systems, databases, business applications, and data relationships, content, and application to more effectively and efficiently manage KP Colorado business operations. Serves as a primary contributor in the department's vision and implementation of the KP Business Intelligence program. Partners with colleagues and customers to guide development of enterprise Data Warehouse and reporting solutions. Maintains and supports a culture of compliance, ethics and integrity. Responsible for ensuring ongoing compliance with development practices in the business intelligence program. Maintains knowledge of policies and procedures and performs in accordance with applicable regulatory requirements, external laws and accreditation standards as they relate to the BI department. Essential Functions: Leads business information modeling for large, complex projects and ensures that project information conforms to corporate information architecture standards. Demonstrates domain knowledge of claims, membership, benefits and providers and clinical healthcare. Collaborates with business clients, IT and Business Intelligence staff, and management to assess information and resource needs, identifies data sourcing, application, and maintenance, determines project impact, and ensures integration across projects. Researches and evaluates alternative solutions and recommends the most efficient and cost-effective data management solutions. Identifies, researches and recommends new methods for supporting information management as it relates to data management. Develops high-level database architectures and ensures that database designs are consistent with KP's information architecture and information management standards as well as industry standards. Works with the Data Warehouse Architect to perform source system analysis, identification of key data issues, data profiling and development of normalized and star-snowflake physical schemas. Performs other duties as assigned. Basic Qualifications: Experience Eight (8) years of information technology experience including a minimum of four (4) years experience designing, deploying, and maintaining relational (conceptual, logical, physical) and dimensional data models for data warehouse/business intelligence. Extensive experience integrating disparate systems into conformed dimensions. Strong hands-on ERwin data modeling tool experience. Experience with a range of relational database management systems (RDBMS) (Oracle, Teradata, DB2, etc.) and RDBMS tuning. Experience deploying and supporting large, complex data warehouse/business intelligence solutions (full life cycle). Education Bachelor's degree in computer information systems, computer science, business or related field. Additional Requirements: Understanding of business intelligence reporting tools (SQL query, Business Objects, Cognos, Qlikview, Tableau, etc.), data integration tools (Informatica, etc.), and metadata repository processes and tools. Proven track record coordinating with project managers, participating in project planning and coordinating with development teams using agile methodologies delivering successful business intelligence solutions with complex data sources. Strong oral, written and interpersonal skills for interacting and collaborating with analysts, physicians, and business staff throughout all levels of the organization; ability to clearly communicate complex business problems and technical solutions. Designs, deploys and manages systems, databases, business applications, and data relationships, content, and application to more effectively and efficiently manage KP business operations. Serves as a primary contributor in the department's vision and implementation of the KP Business Intelligence program. Partners with colleagues and customers to guide development of enterprise Data Warehouse and reporting solutions. Maintains and supports a culture of compliance, ethics and integrity. Responsible for ensuring ongoing compliance with development practices in the business intelligence program. Maintains knowledge of policies and procedures and performs in accordance with applicable regulatory requirements, external laws and accreditation standards as they relate to the BI department. Essential Functions: Leads business information modeling for large, complex projects and ensures that project information conforms to corporate information architecture standards. Demonstrates domain knowledge of claims, membership, benefits and providers and clinical healthcare. Collaborates with business clients, IT and Business Intelligence staff, and management to assess information and resource needs, identifies data sourcing, application, and maintenance, determines project impact, and ensures integration across projects. Researches and evaluates alternative solutions and recommends the most efficient and cost-effective data management solutions. Identifies, researches and recommends new methods for supporting information management as it relates to data management. Develops high-level database architectures and ensures that database designs are consistent with KP's information architecture and information management standards as well as industry standards. Works with the Data Warehouse Architect to perform source system analysis, identification of key data issues, data profiling and development of normalized and star-snowflake physical schemas. Performs other duties as assigned. 1) These positions are not part of Member Connect or Claims Connect project. They will be accessed EPIC data, via the backend database Clarity. 2) Daily Responsibilities: Writing SQL code, Developing Tableau Reports, Speaking with users to capture requirements for reports 3) Top 3 skills: Capture business requirements, Expert Level Tableau, Oracle SQL 4) Additional Skills: MS Sharepoint development, creating a hub for reports