Job Information
CareOregon IS BI Application Analyst II in Portland, Oregon
Candidates hired for remote positions must reside in Oregon, Washington, Utah, Idaho, Arizona, Nevada, Texas, Montana, or Wisconsin.
Job Title
IS Business Intelligence Application Analyst II
Exemption Status
Exempt
Management Level
n/a
Direct Reports
n/a
Manager Title
IS Business Intelligence Manager
Department
Business Intelligence
Requisition
24520
Pay & Benefits
Estimated hiring range $88,430 - $108,080 / year, 5% bonus target, full benefits. www.careoregon.org/about-us/careers/benefits.
Posting Notes
This is a fully remote role, but you must reside in one of the listed 9 states.
Job Summary
The Business Intelligence Application Analyst II ensures the security of our data and integration within our analytic applications by providing design input, testing, and supporting others. Assigned work is generally mid-level in complexity and includes the following: a wide range of core analytic applications and tools; CareOregon’s specific use of Tableau Software and row level security; Snowflake user access policies and masking; in-house business intelligence (BI) applications and dashboards; and the data catalog. Additionally, the role supports department analysts for the application of row level security.
Essential Responsibilities
Customer Support and Training Curriculum
Actively participate with EDW Snowflake Developers and Architect on row level security access policies.
Apply and test Tableau dashboards with row level security using access policies.
Build enterprise external facing dashboards with row level security applied.
Build documentation and support CareOregon analysts for applying row level security.
Create and maintain security focused documentation.
Stay current with application security trends and knowledge of application.
Partner with business and Business Intelligence Analysts to identify new row level security use cases.
Provide support of analytic applications: Tableau, Power BI, Data Catalog, and our in-house built applications: FIDO Web (user interface) and Gatekeeper (security) by providing input on enhancements and integration.
Analytic Application enhancement and upgrade testing.
Analytic Application configuration, troubleshooting and other support.
Contribute to Analytic Application and integration data governance.
Support of overall Data Governance activities including data quality.
May be responsible for analyst deployments: Power BI, CI/CD, Databricks, etc.
May support dashboard and code optimization.
Organizational Responsibilities
Perform work in alignment with the organization’s mission, vision and values.
Support the organization’s commitment to equity, diversity and inclusion by fostering a culture of open mindedness, cultural awareness, compassion and respect for all individuals.
Strive to meet annual business goals in support of the organization’s strategic goals.
Adhere to the organization’s policies, procedures and other relevant compliance needs.
Perform other duties as needed.
Experience and/or Education
Required
Minimum 3 years’ experience that includes the following:
Tableau, Power BI or similar visualization tool applying row level security
Note: Master’s or Bachelor’s degree in computer science, data analytics, or related technical areas may be acceptable in lieu of 1 year
Business intelligence experience that includes at least one of the following:
SQL server
Snowflake
Use of data catalogs
Preferred
Experience with Snowflake
RBAC experience
Role access policy experience
Experience with Application Administration
Database Experience
Experience in the healthcare or health insurance industry
Knowledge, Skills and Abilities Required
Knowledge
Advanced understanding of Business Intelligence and Analytics concepts and practices
Advanced understanding of Tableau Desktop row level security
Knowledge of row access policies
Knowledge of agile development processes
Knowledge of Managed Care helpful
Knowledge of data catalogs preferred
Knowledge of Medicaid and/or Medicare programs helpful
Skills and Abilities
Ability to provide leadership and oversight for data security within our analytic applications
Ability to independently gather, compile and present how to apply row level security, row access policies, and data masking
Skill in use of Tableau Desktop/Creator products and SQL
Ability to follow standards for data architecture and database design
Ability to maintain up-to-date knowledge of relevant technology and best practices in the BI field with focus on security
Intermediate level skill in troubleshooting BI related technical issues
Effective presentation and facilitation skills in both small and larger group settings, both in-person and virtually
Effective ability to develop training programs and delivery methods using an equity, diversity, and inclusion lens
Excellent customer service skills
Excellent spoken and written communication skills
Ability to effectively collaborate with coworkers, staff, and leaders across all departments
Ability to work independently
Ability to employ a high degree of initiative and motivation
Ability to manage multiple tasks and meet deadlines
Ability to work effectively with diverse individuals and groups
Ability to learn, focus, understand, and evaluate information and determine appropriate actions
Ability to accept direction and feedback, as well as tolerate and manage stress
Ability to see, read, and perform repetitive finger and wrist movement for at least 6 hours/day
Ability to hear and speak clearly for at least 1-3 hours/day
Working Conditions
Work Enviornment(s): ☒ Indoor/Office ☐ Community ☐ Facilities/Security ☐ Outdoor Exposure
Member/Patient Facing: ☒ No ☐ Telephonic ☐ In Person
Hazards: May include, but not limited to, physical and ergonomic hazards.Equipment: General office equipment
Travel: May include occasional required or optional travel outside of the workplace; the employee’s personal vehicle, local transit or other means of transportation may be used.
#MULTI
Candidates of color are strongly encouraged to apply. CareOregon is committed to building a linguistically and culturally diverse and inclusive work environment.
Veterans are strongly encouraged to apply.
We are an equal opportunity employer. CareOregon considers all candidates regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, age, genetic information, disability, or veteran status.
Visa sponsorship is not available at this time.