Skip to content
CV Rocket
Get started
How it worksThe enginePricingBlogContactSign in

Open nowPosted 6 days ago

IS Data Warehouse Architect II

CareOregon14 open roles

Pay
$113,940 – $139,260 a year
Where
Remote Oregon
Work mode
Remote
Get the CV for this job

From $25 per CV, paid once. No subscription.

Your applicationOpen nowIS Data Warehouse Architect IICareOregon · Remote Oregon

  1. YouYes, apply to this one.

  2. CV RocketCV written for this posting.

  3. 25 readersRecruiter, hiring manager, skeptic. Round after round.

  4. CV RocketApplied on CareOregon's own form.

The reply lands in your private mailbox

3×more interviews than doing it yourself with ChatGPT.

The clock on this job

Early applications get read.

9.8% of postings close within 7 days. Measured by our own scanner across the market. CareOregon postings stay open a median of 15 days.

Share of postings closed within
  1. 1.9%1 day
  2. 3.9%3 days
  3. 9.8%7 days
  4. 15.6%14 days
  5. 33.9%30 days
This job: posted 6 days ago

CareOregon median: 15 days open

The posting

IS Data Warehouse Architect II

---------------------------------------------------------------

This position performs Data Warehouse Architecture at an intermediate level. Essential responsibilities are focused on design and development of data models and ETL specifications, data analysis, system design and architecture, standards and policy administration, and vendor coordination and relations.

Estimated Hiring Range:

$113,940.00 - $139,260.00

Bonus Target:

Bonus - SIP Target, 5% Annual

Current CareOregon Employees: Please use the internal Workday site to submit an application for this job.

---------------------------------------------------------------

Essential Responsibilities

Data Modeling and ETL Specifications

  • Create data models for moderate to advanced subjects.
  • Create moderate to advanced ETL specifications to meet business data needs.
  • Develop and maintain appropriate documentation, including current design and operation.

Data Analysis

  • Analyze data sources; research and recommend solutions which include potential risks and mitigation.

System Design and Architecture

  • Participate in long-term data warehouse and dashboard architecture planning.
  • Participate in creating and managing moderate to advanced data warehouse and analytics architectures for use as reference and as input to solution development process

Standards and Policy Administration

  • Propose requirements, standards and best practices for data modeling, ETL specifications, and data warehouse development.
  • Participate in the ongoing review of existing systems to ensure they are designed to comply with established standards and to empower business operations.

Vendor Coordination and Relations

  • Conduct product and vendor research, and present recommendations to more advanced database developers and/or management.
  • Establish and maintain effective working relationships with vendors and related equipment suppliers, including installation and repair of services.

Experience and/or Education

Required

  • Minimum 2 years' of data design /data architecture experience and/ or minimum 2 years’ of data warehouse architecture experience. Experience should include some or all of the following: o Dimensional modeling experience o Data quality assessment o Proficiency with SQL o Agile/Scrum methodology o Source Target mapping o Data Analysis

Preferred

  • Experience in health care or managed care
  • Metadata management
  • Performance tuning and optimization
  • Cloud warehousing solutions
  • Health insurance
  • Systems analysis and design
  • Experience gathering requirements from and collaborating with both technical and non-technical business groups
  • Experience being the liaison between the business and developers
  • Experience gathering requirements and then translating that information into a specification document

Knowledge, Skills and Abilities Required

Knowledge

  • Working knowledge/skills of Microsoft SQL Server
  • Working knowledge of cloud data warehousing tools such as Snowflake or Redshift
  • Working knowledge/skills of ETL tools, such as SSIS or Azure Data Factory
  • Advanced troubleshooting of system performance issues and root cause
  • Working knowledge/skills of unit and integration testing

Skills and Abilities

  • Effective communication skills, including listening, verbal, written, and customer service
  • Ability to clearly articulate policies and instructions
  • Demonstrated progress in conveying appropriate level of detail effectively to all levels of the organization including non-technical staff
  • Ability to recommend policies, document risks, and propose solutions to information technology management and senior leadership
  • Possess a high degree of initiative and motivation
  • Ability to effectively collaborate with coworkers, staff, and leaders across all departments
  • 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 3-6 hours/day

Working Conditions

Work Environment(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.

Work Location: Work from home

We offer a strong Total Rewards Program. This includes competitive pay, bonus opportunity, and a comprehensive benefits package. Eligibility for bonuses and benefits is dependent on factors such as the position type and the number of scheduled weekly hours. Benefits-eligible employees qualify for benefits beginning on the first of the month on or after their start date. CareOregon offers medical, dental, vision, life, AD&D, and disability insurance, as well as health savings account, flexible spending account(s), lifestyle spending account, employee assistance program, wellness program, discounts, and multiple supplemental benefits (e.g., voluntary life, critical illness, accident, hospital indemnity, identity theft protection, pre-tax parking, pet insurance, 529 College Savings, etc.). We also offer a strong retirement plan with employer contributions. Benefits-eligible employees accrue PTO and Paid State Sick Time based on hours worked/scheduled hours and the primary work state. Employees may also receive paid holidays, volunteer time, jury duty, bereavement leave, and more, depending on eligibility. Non-benefits eligible employees can enjoy 401(k) contributions, Paid State Sick Time, wellness and employee assistance program benefits, and other perks. Please contact your recruiter for more information.

We are an equal opportunity employer

CareOregon is an equal opportunity employer. The organization selects the best individual for the job based upon job related qualifications, regardless of race, color, religion, sexual orientation, national origin, gender, gender identity, gender expression, genetic information, age, veteran status, ancestry, marital status or disability. The organization will make a reasonable accommodation to known physical or mental limitations of a qualified applicant or employee with a disability unless the accommodation will impose an undue hardship on the operation of our organization.

From $25, paid onceGet the CV for this job

What happens when you press

One press. We do the rest.

  1. A CV for this posting

    Written against CareOregon's own wording, from every piece of relevant proof in your profile.

  2. 25 readers review it

    Recruiter, hiring manager, skeptic and more read every draft, round after round. You get the best round.

    The review screen in CV Rocket: how each CV was read, round by round.

  3. We apply on CareOregon's form

    Our application engine gets through the hardest forms there are. Where a question needs you, AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

    An application in CV Rocket: every answer filled in on the employer's form.

  4. Every reply, sorted

    CareOregon's answer lands in your private mailbox, and we classify it on arrival: interview, question, rejection.

    The CV Rocket inbox: each employer reply classified as an interview, an action or a rejection.

  5. Reply with AI

    AI helps you write the email, checks it and sends it. We show you whether the recruiter read it.

  6. The interview in your calendar

    Full integration with your calendar. The invitation goes straight in.

    An interview invitation in the CV Rocket inbox, added to the candidate's calendar.
Get the CV for this job

From $25 per CV, paid once. No subscription.

Why it works

3×

more interviews than doing it yourself with ChatGPT.

ChatGPT writes a CV and never learns what happened to it. We see every reply. For each CV we know:

  • How it was written, and how the review scored it
  • When we applied, and how long after the posting went up
  • Which posting, which company, which city
  • Who got the interview, and who heard nothing

That is how we know which CVs get called.

Get the CV for this job

From $25 per CV, paid once. No subscription.

The numbers game

More applications. More interviews.

Every application goes out with its own CV, written for that posting and paid once. Send enough of them and the law of large numbers finds you the job.

Get the CV for this job
By hand5–10
With CV Rocket100
applications a day

Nearby

Live postings like this one

Same employer first, then the same role elsewhere.

Before you press

Straight answers

Get the CV for this job

From $25 per CV, paid once. No subscription.

What if my background isn't good enough?

We make the most of the background you have. The CV uses every piece of relevant proof your profile holds, and one of the 25 readers reads your whole profile and flags what the CV left out.

Do you really apply for me?

Yes, on the employer's own form, the hardest ones included. Where a question needs you, you answer it right there and AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

Is it a subscription?

No. You pay once per CV, from $25. Every application goes out with its own CV, written for that posting.

One job. One CV.
Paid once.

Pick the posting you want. We write for it, apply for you and catch the reply.

Get the CV for this job

From $25 per CV, paid once. No subscription.