PasadenaCARecruiter Since 2001
the smart solution for Pasadena jobs

Database Architect, Clarity *REMOTE* *SCAL*

Company: Kaiser Permanente
Location: Pasadena
Posted on: March 18, 2023

Job Description:

The SCAL Clarity Management, Analytics and Reporting (CMAR) team primary role is to ensure the Clarity reporting database is current and available on a timely basis to allow for daily reporting needs. Our support includes ensuring the Oracle Exadata environment stability, Clarity upgrades, resolving connectivity issues for Crystal Reports and SQL Developer, user enablement, HealthConnect to Clarity research and coordinating query optimization and assistance with KPIT.
Job Summary:
This individual contributor is primarily responsible for driving strategic data-informed decisions, ensuring data and resources are available to users in an orderly and secure way through data provisioning and ongoing security, and analyzing and developing database designs, data models, and relational data definitions in support of systems requirements. This position provides ongoing database support, maintenance, and troubleshooting, informs and influences the data strategy, and develops, implements, and automates business and reporting solutions.
Essential Responsibilities:

  • Practices self-development and promotes learning in others by proactively providing information, resources, advice, and expertise with coworkers and customers; building relationships with cross-functional stakeholders; influencing others through technical explanations and examples; adapting to competing demands and new responsibilities; listening and responding to, seeking, and addressing performance feedback; providing feedback to others; creating and executing plans to capitalize on strengths and develop weaknesses; supporting team collaboration; and adapting to and learning from change, difficulties, and feedback.

  • Completes work assignments and supports business-specific projects by applying expertise in subject area; supporting the development of work plans to meet business priorities and deadlines; ensuring team follows all procedures and policies; coordinating resources to accomplish priorities and deadlines; collaborating cross-functionally to make effective business decisions; solving complex problems; escalating high priority issues or risks as appropriate; and recognizing and capitalizing on improvement opportunities.

  • Provides ongoing database support, maintenance, and troubleshooting by identifying and fixing problems; locating and correcting oversights; ensuring the database meets expectations; identifying trends in the database users; ensuring optimized database performance; recommending new ways to improve the existing database; and scheduling times for upgrades and repairs for minimal impact to the company.

  • Develops, implements, and automates business and reporting solutions by working with stakeholders in their design, planning, and implementation while ensuring consistency and coherency; evaluating and summarizing data and results; creating summary statistics; developing data reports, visualizations, and/or interactive Business Intelligence (BI) reports; reporting to stakeholders on key findings; identifying needs for the development and implementation of additional reporting solutions; and preparing documentation as appropriate.

  • Informs and influences the data strategy by establishing a means to identify and represent content; determining optimal data storage methodologies; ensuring data are packaged in a way to be reused and shared; developing and ensuring adherence to data rules and access guidelines; determining best strategy for combining data residing in disparate systems into a unified, consistent data view; and establishing, managing, and communicating information policies and mechanisms for effective data usage.

  • Drives strategic data-informed decisions by consulting with clients to identify and clarify key business needs; developing outcomes and process measures; translating business requirements; determining data/information needs and data collection methods; developing analysis plans; measuring the impact of business decisions on clients, customers, and/or members; working with clients and staff to identify opportunities and methods to improve efficiencies with analysis; supporting and training end-users; and documenting processes and deliverables.

  • Analyzes and develops database designs, data models, and relational data definitions in support of systems requirements by preparing data for analytic efforts; assessing the current data infrastructure; identifying areas in need of change; determining how the database should look and function; scoping the database using the ETL Architecture Standards; developing code to create the database; creating database security standards; and testing and maintaining data integrity across multiple internal and/or external databases.

  • Ensures data and resources are available to users in an orderly and secure way through data provisioning and ongoing security by translating business analytics needs into data access requirements; creating, preparing, and enabling systems to provide data to users; granting users access to data repositories or systems, applications, and databases based on a unique user identity; managing and monitoring data access on an ongoing basis; tracking and documenting version control; designing and generating tracking and monitoring tools; tracking and reporting on data access; and ensuring data provisioning efforts adhere to IT compliance standards, policies, and procedures.

    Minimum Qualifications:

    • Minimum one (1) year experience in a leadership role with or without direct reports.

    • Bachelors degree in Mathematics, Statistics, Computer Science, Engineering, Social/Physical/Life Science, Business, or related field and Minimum five (5) years experience in database configuration, architecture or management, or a directly related field. Additional equivalent work experience in a directly related field may be substituted for the degree requirement.

    • N/A

      Preferred Qualifications:

      • Two (2) years database maintenance experience, including performance tuning and query optimization.

      • Two (2) years experience working with SQL.

      • Two (2) years experience working with Excel.

      • Two (2) years experience in process improvement.

      • One (1) year experience in transition or change management implementation.

      • Two (2) years project management experience.

      • Two (2) years experience delivering presentations to management.

      • One (1) year health care experience.

      • Two (2) years experience working with Access.

      • Two (2) years experience working with business intelligence tools.

      • Two (2) years experience working with Open Source Tools (e g , R, Python).

      • Two (2) years experience working with data visualization tools.

      • Two (2) years experience working with SAS.

      • Two (2) years relational database experience.

      • Two (2) years experience working with quality management and data profiling tools.

      • Two (2) years experience working with data extraction and manipulation language and ETL tools (e.g., SSIS, Informatica, Ab Initio, etc.).

      • Two (2) years programming experience.

        TITLE: Database Architect, Clarity REMOTE SCAL
        LOCATION: Pasadena, California
        REQNUMBER: 1025868
        External hires must pass a background check/drug screen. Qualified applicants with arrest and/or conviction records will be considered for employment in a manner consistent with Federal, state and local laws, including but not limited to the San Francisco Fair Chance Ordinance. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, protected veteran, or disability status.

Keywords: Kaiser Permanente, Pasadena , Database Architect, Clarity *REMOTE* *SCAL*, IT / Software / Systems , Pasadena, California

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Log In or Create An Account

Get the latest California jobs by following @recnetCA on Twitter!

Pasadena RSS job feeds