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.
COMPANY: KAISER
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!
|
