Skip to content

Open nowPosted yesterday

Data Warehouse Architect

Hebrew SeniorLife191 open roles

Pay
$113,141 – $169,711 a year
Where
Roslindale, MA
Work mode
Hybrid
Get the CV for this job

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

Your applicationOpen nowData Warehouse ArchitectHebrew SeniorLife · Roslindale, MA
  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 Hebrew SeniorLife'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.

13.3% of postings close within 7 days. Measured by our own scanner across the market. Hebrew SeniorLife postings stay open a median of 32 days.

Share of postings closed within
  1. 2.1%1 day
  2. 4.6%3 days
  3. 13.3%7 days
  4. 21.3%14 days
  5. 35.7%30 days
  6. 59.1%60 days
This job: posted yesterday

Hebrew SeniorLife median: 32 days open

The posting

Job Description:

Position Summary:

The Data Warehouse Architect and Technology Innovation Engineer is responsible for identifying customer and organizational data needs, managing and implementing data procedures and standards, designing and developing databases and data models, distributing management practices for data, and managing information. The position will also work with the IT department and operational leaders to innovate, assess and test new technologies to the pursuit of our mission to Lead the Field of Aging. The Data Warehouse Architect designs, develops and optimizes data warehouses, with flexible and scalable data and architecture, to support business users and business intelligence (BI) applications. Daily tasks include ensuring that all data going through the system is accurate and appropriately protected and encrypted, analyzing data and presenting reports to executives, and working as a liaison between IT and other departments. Will work closely with members of the Applications, Technology Operations and IT Security group to assess and implement innovative technologies.

Core Competencies:

  • Ability to identify and understand customer requirements and then design / develop solutions that successfully address those requirements
  • Keep current on new industry trends and developing technologies
  • Ability to liaise with Operational Leaders to analyze challenges and propose technological solutions
  • Strong business and leadership acumen
  • In-depth knowledge of data warehousing concepts
  • Strong understanding of database design, structure and operational use
  • Mastery of database query and reporting tools. Able to structure queries to pull data and accurately combine the results in a logical, meaningful and efficient manner. Able to interpret the results.
  • Strong understanding of data ingestion and transformation (ETL/ELT) techniques.
  • Proficiency with analytics/dashboarding/presentation tools
  • Ability to strictly abide by patient and employee confidentiality policies, procedures and regulations.
  • Familiarity and adherence to IT and HIPAA Security regulations
  • Ability to balance workload and adjust to shifting priorities
  • Able to work well in a team atmosphere.
  • Excellent organization skills
  • Excellent interpersonal and communication skills

Responsibilities/Accountability:

  • Identifies data requirements by interviewing customers; analyzing department applications, programming, and operations; evaluating existing systems and designing proposed systems.
  • Identifies sources of data that can be used to populate the data warehouse
  • Recommends solutions by defining database physical structure and functional capabilities, database security, data back-up, and recovery specifications.
  • Installs revised or new systems by proposing specifications and flowcharts; recommending optimum access techniques; coordinating installation requirements.
  • Maintains database performance by calculating optimum values for database parameters; implementing new releases; completing maintenance requirements; evaluating computer operating systems and hardware products.
  • Prepares users by conducting training; providing information; resolving problems.
  • Provides information by answering questions and requests.
  • Maintains quality service by establishing and enforcing organization standards.
  • Maintains professional and technical knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; benchmarking state-of-the-art practices; participating in professional societies.
  • Documents and maintains detailed knowledge of the data within the HSL environment, including sources, schemas, transformations, refresh cadence and data lineage, so that internal staff can support and troubleshoot independently of third party vendors.
  • Contributes to team effort by accomplishing related results as needed.
  • Performs a variety of tasks and a wide degree of creativity and latitude is expected
  • Provides exceptional customer service.
  • Completes projects accurately and on a timely basis.

Qualifications:

Required:

  • Bachelor’s degree in Information Technology, Healthcare Informatics, Public Health or a related field. Equivalent of 10 years of relevant work experience may be considered in lieu of a degree.
  • Five or more years of related work experience, including experience designing and developing in a data warehouse environment.
  • Experience with electronic health record, health information systems and healthcare applications.
  • Requires exceptional customer service skills, attention to detail and timelinessExperience with scripting languages such as PowerShell and Python for automation and data pipeline work. Hands-on experience with Databricks (Spark, Delta Lake, notebooks, Workflows, and Unity Catalog or similar governance tooling). Advanced proficiency in SQL and in database query, reporting, and BI tools. Working knowledge of Linux environments, with experience migrating Linux-based systems and workloads to standard, supported platforms. Expertise in: database performance tuning, database security, promoting process improvement, problem solving, presenting technical information, quality focus, database management, data maintenance, operating systems, attention to detail, information security policies
  • Preferred: Workday Pro certification (Reporting, Integrations, or similar) or equivalent demonstrated experience. Experience with Workday Prism Analytics. Experience with retrieval-augmented generation (RAG), vector databases, and open-source LLM frameworks (e.g., Lang Chain, Llama Index) in a secure, on-premises environment. Databricks certification (Data Engineer Associate/Professional or similar). Experience with cloud platforms (e.g., Azure, AWS) and modern data orchestration tools (e.g., Airflow, Azure Data Factory). Familiarity with creating and structuring data cubes and web-based reporting and deployment. Experience with Microsoft SQL Server Reporting Services (SSRS), Power BI, or Crystal Reports. Familiarity with medical center/hospital and senior care activities and operations. Familiarity with Process Improvement and Lean methodologies, strong project management skills.
  • RequirementsAbility to travel to HSL local facilities. Ability to lift light computer equipment. Familiarity with Process Improvement and Lean methodologies

Remote Type:

Hybrid

Salary Range:

$113,141.00 - $169,711.00

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 Hebrew SeniorLife'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 Hebrew SeniorLife'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

    Hebrew SeniorLife'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.

By hand5–10
With CV Rocket100
applications a day

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.