Data Engineer - Business Intelligence (Remote)

Hallmark Health System, Inc.

Kansas City (MO)

Remote

USD 85,000 - 110,000

Full time

9 hours ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Medical, dental and vision plans
Paid time off
401K with company match
Profit-sharing

Job summary

Hallmark Health System, Inc. is seeking an experienced BI Engineer to design and build scalable, governed analytics solutions.

You will focus on Power BI semantic models, reusable layers, and self-service analytics, leveraging Power BI, Fabric, Snowflake, and AI-assisted development techniques. The ideal candidate has 6–8 years in BI/Analytics or Data Engineering, with hands-on SQL, Snowflake, and modern cloud data platforms, and an AI-first engineering mindset to accelerate development while

Qualifications

  • 6+ years in Business Intelligence, Analytics Engineering, Data Engineering or related tech discipline.
  • Hands-on experience with Power BI including semantic model development, DAX, Power Query/M, dimensional modelling, Power BI Service, data security, and performance optimisation.
  • Experience designing and developing dimensional data models using star schemas, facts, dimensions, aggregations, relationships, hierarchies, measures, and KPIs.
  • Demonstrated experience building shared reusable semantic/business layers rather than just reports.
  • Experience developing and implementing self-service analytics for business users.
  • Experience developing and optimising SQL queries for performance and efficiency.
  • Hands-on experience with Snowflake or a comparable cloud data platform.
  • Experience developing analytical solutions using Microsoft Fabric.
  • Understanding of modern analytical architectures spanning data platforms, analytical data products, semantic models, and visualization layers.
  • Experience translating complex business requirements into scalable technical and analytical solutions.
  • Demonstrated experience incorporating Generative AI or AI coding assistants into real-world development workflows.
  • Ability to use AI to generate, review, refine, and troubleshoot SQL, DAX, M, metadata, documentation, and other artefacts.
  • Experience using AI across design, development, testing, troubleshooting, optimisation, and documentation.
  • Ability to evaluate AI-generated solutions for correctness and governance.

Responsibilities

  • Design and build scalable, governed analytics solutions that enable trusted access to enterprise data.
  • Develop Power BI semantic models, reusable business/context layers, and self-service analytics capabilities.
  • Leverage Microsoft Power BI, Microsoft Fabric, Snowflake, and AI-assisted development practices.
  • Maintain accountability for the quality, security, and maintainability of production solutions.
  • Grow the role based on skills and experience to hit the ground running and advance career growth.

Skills

Dimensional modelling
Semantic model development
Self-service analytics
AI in development workflows
SQL proficiency

Education

6–8 years BI/Analytics/Data Engineering

Tools

Power BI
DAX
Power Query/M
Snowflake
Microsoft Fabric
AI-assisted development

Job description

Who We Are & What We Do

Hallmark’s Data & Business Intelligence organization turns enterprise data into trusted insights that help teams across Hallmark make better, faster decisions. We build and manage the data platforms, pipelines, semantic models, and analytics solutions that support critical business areas including retail, product, consumer, merchandising, planning, finance, and executive reporting.

WHAT YOU’LL BE DOING & THE IMPACT YOU’LL MAKE

We are looking for an experienced BI Engineer to design and build scalable, governed analytics solutions that enable trusted and intuitive access to enterprise data. This role will focus on developing Power BI semantic models, reusable business/context layers, and self-service analytics capabilities, leveraging Microsoft Power BI, Microsoft Fabric, Snowflake, and AI-assisted development practices. The ideal candidate will have 6–8 years of experience in Business Intelligence, Analytics Engineering, Data Engineering, or related areas, with strong hands‑on expertise in Power BI, dimensional modelling, semantic model development, SQL, and modern cloud data platforms. This role also requires an AI‑first engineering mindset. The engineer will be expected to use approved AI capabilities to accelerate development, testing, documentation, optimisation, and modernisation while maintaining accountability for the quality, security, and maintainability of production solutions.

This is a progressive role that will be filled at the level based on the skills and experience of the selected candidate.

Additional Details
  • The salary range for this role is $85,000 - $110,000. Final compensation varies based on several factors.
  • This is a U.S.-based remote role.* We’re committed to creating a connected, collaborative culture, no matter where you are. You’ll have access to virtual tools, team support, and opportunities to engage and grow with us. *Due to state-specific benefits regulations, Hallmark cannot consider candidates for remote positions who reside in Alaska, Hawaii, or Puerto Rico, or any country outside of the United States.
  • This is a progressive role designed to grow with you. We’ll match the job level to your skills and experience so you can hit the ground running and keep building your career.
  • Hallmark is committed to recognising and rewarding performance. Employees are eligible for annual merit‑based increases, aligned with individual and company performance.
  • In alignment with our culture of care, Hallmark offers a competitive benefits package, including medical, dental and vision plans, paid time off, 401K with company match, and profit‑sharing.
BASIC QUALIFICATIONS (the following is required to be considered for this role):
  • At lease 6 years of experience in Business Intelligence, Analytics Engineering, Data Engineering, or a related technology discipline.
  • Hands‑on experience with Microsoft Power BI, including semantic model development, DAX, Power Query/M, dimensional modelling, Power BI Service, data security, and performance optimisation.
  • Experience designing and developing dimensional data models using star schemas, facts, dimensions, aggregations, relationships, hierarchies, measures, and KPIs.
  • Demonstrated experience building shared and reusable semantic/business layers, rather than primarily developing individual reports.
  • Experience developing and implementing self‑service analytics capabilities for business users.
  • Experience developing and optimising SQL queries for performance and efficiency.
  • Hands‑on experience working with Snowflake or a comparable cloud data platform.
  • Experience developing analytical solutions using Microsoft Fabric.
  • Understanding of modern analytical architectures spanning data platforms, analytical data products, semantic models, and visualization layers.
  • Experience designing or developing modern analytical architectures that include data platforms, analytical data products, semantic models, and visualization layers
  • Experience translating complex business requirements into scalable technical and analytical solutions.
  • Demonstrated experience incorporating Generative AI or AI coding assistants into real‑world development workflows.
  • Ability to use AI effectively to generate, review, refine, and troubleshoot SQL, DAX, M, semantic‑model metadata, documentation, and other engineering artefacts.
  • Experience using AI across multiple stages of the development lifecycle, including design, development, testing, troubleshooting, optimisation, and documentation.
  • Ability to evaluate AI‑generated solutions for correctness rather than accepting generated code without appropriate engineering review.
  • Experience applying responsible AI development practices, including data protection, security, validation, governance, and human accountability
PREFERRED QUALIFICATIONS (your application will stand out if you have the following):
  • Advanced experience with Microsoft Fabric, including Lakehouse, Warehouse, OneLake, Direct Lake, Dataflows Gen2, and data pipelines.
  • Experience integrating and optimising Power BI with Snowflake.
  • Experience with medallion or layered data architectures and curated analytical data products.
  • Experience with CI/CD, Git integration, deployment pipelines, source control, and DevOps practices for BI and analytics solutions.
  • Experience establishing BI governance, semantic‑model standards, common metric definitions, and self‑service analytics frameworks.
  • Experience modernising legacy BI/reporting platforms to Power BI, Fabric, Snowflake, or other modern cloud analytics platforms.
  • Experience with metadata management, data catalogs, lineage, business glossaries, or Microsoft Purview.
  • Experience developing AI‑enabled accelerators, agents, reusable prompts, or automated development workflows for BI and analytics engineering.
  • Experience applying AI to accelerate BI modernisation, report migration, semantic modelling, metadata management, testing, and self‑service analytics.

In compliance with the Immigration Reform and Control Act of 1986, Hallmark Cards, Inc. and its subsidiary companies will hire only individuals lawfully authorised to work in the United States. Hallmark does not generally provide sponsorship for employment.

Employment by Hallmark is contingent upon the signing of the Employment Agreement, signing of an agreement to arbitrate in connection with the Hallmark Dispute Resolution Programme, completing Form I-9 Employment Eligibility Verification, passing the urinalysis drug screen, education verification and satisfactory reference and background checks.

Hallmark is an equal opportunity employer. All qualified applicants will be considered for employment without regard to race, colour, religion, sex, age, pregnancy, national origin, physical or mental disability, genetics, sexual orientation, gender identity, veteran status, or any other legally‑protected status. Principals only please.

HALLMARK – Because Connecting With Each Other Has Never Been More Important

For more than a century, Hallmark has been bringing people together and improving the relationships that matter most. That’s why millions of people all over the world connect with the Hallmark brand. It has always been a mission so much bigger than any one of us who work here. Today, we need empathetic learners, strategic thinkers, and enthusiastic visionaries with diverse experiences and skills to help us create the rest of Hallmark’s second century as we shift to a more digitally savvy, unified approach that combines the best of brick‑and‑mortar retail with the efficiency of dot‑com spaces. Help us imagine what our next hundred years could look like!

When you join Hallmark, we will go out of our way to make you feel like part of the team, even in a remote/hybrid work environment. In the day‑to‑day, we’ll make the best use of the skills and talents you already have. We’ll also give you leadership opportunities and show you multiple potential pathways to future success.

Our culture of care for our consumers and for one another shows in the way we embrace different backgrounds, identities, and working styles, deliberately seeking out ways to be more inclusive both internally among our work groups and externally through the things we make and sell to our retail partners and consumers. We believe that a broadly inclusive, equitable approach is also our best path to future success. We’re seeking out those who can bring a fresh perspective to our business and would love your input as someone new to our team! We can only change and grow when we intentionally include new perspectives–like yours.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer - Business Intelligence (Remote)
Data Engineer - Business Intelligence (Remote)

Hallmark • Kansas City (MO)

Remote
USD 85,000 - 110,000
Medical, dental & vision coverage
401K with company match
Profit-sharing
Data Engineer - Business Intelligence (Remote)
Data Engineer - Business Intelligence (Remote)

Hallmark Cards, Inc. • United States

Remote
USD 85,000 - 110,000
Production Support Specialist (36)- 2nd Shift
Production Support Specialist (36)- 2nd Shift

Hallmark Health System, Inc. • Lawrence (KS)

On-site
USD 27,000 - 31,000
Health insurance
401(k) with company match
Paid time off
HR Director - Supply Chain & Retail Strategy/Operations
HR Director - Supply Chain & Retail Strategy/Operations

Hallmark • United States

Hybrid
USD 160,000 - 210,000
Annual incentive plan
Merit-based increases
Comprehensive benefits package
HR Director - Supply Chain & Retail Strategy/Operations
HR Director - Supply Chain & Retail Strategy/Operations

Hallmark Corporate • Kansas City (MO)

Hybrid
USD 150,000 - 230,000
Hybrid work arrangement
Annual incentive plan
Merit-based increases
+3
HR Director - Supply Chain & Retail Strategy/Operations
HR Director - Supply Chain & Retail Strategy/Operations

Hallmark Cards, Inc. • Liberty City (TX)

Hybrid
USD 180,000 - 260,000
Medical insurance
Dental insurance
Vision insurance
+1
Production Support Specialist (36) - 1st Shift
Production Support Specialist (36) - 1st Shift

Hallmark • Lawrence (KS)

On-site
USD 25,000 - 33,000
Health, vision & dental plans
401(k) with company match
PTO 18 days + 10 holidays and parental
+1
Production Support Specialist (36) - 1st Shift
Production Support Specialist (36) - 1st Shift

Hallmark Health System, Inc. • Lawrence (KS)

On-site
USD 32,000 - 46,000
Health plans (medical, vision, dental)
On-site nurse health consultations
401(k) with 4% company match
+2
HR Director - Supply Chain & Retail Strategy/Operations
HR Director - Supply Chain & Retail Strategy/Operations

Hallmark • Kansas City (MO)

Hybrid
USD 120,000 - 180,000
Annual incentive plan
Merit-based increases
Medical, dental, and vision coverage
+2
Packaging Operator (37) - 3rd Shift
Packaging Operator (37) - 3rd Shift

Hallmark • Lawrence (KS)

On-site
USD 25,000 - 30,000