Opportunity

Staff Data Engineer - AWS, Power BI & Healthcare Data in Columbus

Location Columbus
Company ProArch
Source workable
Posted 2026-11-12 16:56:20

Career & Market Insight

This is a senior-level individual contributor role requiring 8+ years of data engineering experience, placing it firmly in the Staff or Principal Engineer tier at most organizations. The dual focus on data pipeline architecture AND Power BI semantic modeling is relatively uncommon — candidates who can bridge both backend data engineering and front-end BI delivery are highly sought after.

Compensation benchmark: No salary is listed, but roles of this seniority in U.S. healthcare tech typically command $140,000–$185,000 annually, with top-of-market firms exceeding $200K total compensation including bonus and equity.

Skills you'll develop or deepen:

  • Cloud-native data architecture on AWS (Redshift, S3, EMR, Lambda)
  • Power BI advanced modeling: DAX, RLS, deployment pipelines
  • HIPAA-compliant data governance and lineage management
  • MLOps integration — a fast-growing, high-value discipline
  • Enterprise dimensional modeling (Star/Snowflake schemas)

Green flags: The 80/10/10 responsibility split shows clear prioritization; the role touches AI/ML pipelines (SageMaker, Databricks), which signals forward-looking investment in data infrastructure.

Yellow flags: No mention of team size, company name, or career progression path. No benefits disclosed. The breadth of responsibilities (architect + BI developer + governance lead) may indicate a lean team where one person wears many hats — clarify during interviews whether this role has dedicated support or is a one-person function.

Overall, this is a strong résumé-building role for professionals wanting to own the full data stack in a regulated, high-stakes industry.

Advanced Data Engineering and Solution Design (80%)

  • Architect and implement scalable data pipelines to process and integrate structured and unstructured data.
  • Design end-to-end data solutions, including Data Lake, Data Warehouse, and Data Mart, to support analytics and operational systems.
  • Leverage UDP framework to consolidate data pipelines across healthcare domains.
  • Support the integration of new data domains through standardized ingestion and transformation frameworks.
  • Collaborate with stakeholders to translate business requirements into scalable, high-performing data architectures.
  • Integrate and optimize data access across distributed systems using data federation and virtualization tools.
  • Develop reusable data assets to support self-service analytics across programs and business domains.
  • Design and maintain enterprise dimensional data models including fact tables, conformed dimensions, star schemas, snowflake schemas, and analytical data marts.
  • Translate business and reporting requirements into scalable analytical data structures and semantic data models.
  • Develop and maintain semantic layers, curated datasets, and business views to support enterprise reporting and analytics.
  • Design, develop, and maintain Power BI semantic models, datasets, dashboards, and reports for internal and external stakeholders.
  • Create and optimize DAX measures, calculated columns, KPIs, and business metrics to support operational and strategic reporting.
  • Implement Power BI best practices including Row-Level Security (RLS), deployment pipelines, performance optimization, and governance standards.
  • Partner with business users and subject matter experts to gather reporting requirements and deliver actionable analytics solutions.
  • Ensure consistency of business definitions, metrics, and calculations across enterprise reporting and analytics platforms.

Data Governance and Compliance (10%)

  • Develop and enforce data governance standards, ensuring consistency, accuracy, and compliance with regulatory frameworks (e.g., HIPAA).
  • Implement data lineage, metadata management, and auditability practices using tools like AWS Glue Data Catalog.
  • Establish and manage data stewardship frameworks to improve data quality and trust across the organization.

Performance Optimization and Security (10%)

  • Optimize system performance by designing and implementing data partitioning, indexing, and compression strategies.
  • Ensure data security through access controls, encryption, and secure design practices.

Requirements

Core Competencies

  • Experience with enterprise data modeling tools (e.g., Erwin, SQL Data Modeler) and strong expertise in dimensional modeling methodologies including Star Schema, Snowflake Schema, Fact and Dimension design, and semantic modeling.
  • Bachelor's or master's degree in Computer Science, Engineering, or related field.
  • 8+ years of experience in data engineering, with a strong emphasis on data governance and solution design.
  • Expertise in developing scalable data architectures for enterprise reporting.
  • Familiarity with MLOps and AI data pipelines leveraging cloud-native services such as AWS SageMaker, Glue ML, or Databricks for feature engineering and model deployment.
  • Advanced knowledge of data governance tools and frameworks, including AWS Glue Data Catalog, to support enterprise-wide lineage, metadata, and compliance practices.
  • Strong understanding of cloud data platforms and services – particularly AWS (Redshift, S3, EMR, Lambda) and hybrid integrations with Azure Synapse or equivalent modern data warehouse technologies.
  • Proficiency in programming and scripting languages (Python, SQL, PySpark) for building, testing, and optimizing scalable data solutions.
  • Advanced experience developing Power BI semantic models, datasets, dashboards, reports, DAX measures, Power Query transformations, Row-Level Security, and performance optimization. Experience with Tableau is a plus.

Additional Qualifications

  • Excellent analytical and troubleshooting skills with attention to detail.
  • Strong communication skills to effectively articulate technical concepts to non-technical stakeholders.
  • Ability to prioritize tasks in a dynamic environment and manage multiple initiatives simultaneously.
  • Certifications in cloud, database, and programming are a plus.

Frequently Asked Questions

Is this data engineer role fully remote or office-based?
The job posting does not specify whether the role is remote, hybrid, or on-site. It is located in the United States, so candidates should clarify the work arrangement directly with the employer during the interview process.
What cloud platforms are required for this position?
The role primarily requires expertise in AWS services including Redshift, S3, EMR, and Lambda. Familiarity with Azure Synapse or hybrid cloud integrations is also valued, along with AWS Glue Data Catalog for data governance.
What is the minimum experience required for this role?
The position requires 8+ years of experience in data engineering, with a strong emphasis on data governance, solution design, and enterprise data architecture.
Is healthcare industry experience required?
While not explicitly stated as mandatory, the role involves HIPAA compliance and healthcare domain data pipelines (via the UDP framework), so familiarity with healthcare data regulations and environments is highly advantageous.
What BI tools does this role focus on?
The primary BI tool is Power BI, with requirements covering semantic models, DAX measures, Row-Level Security, and deployment pipelines. Experience with Tableau is listed as an additional plus.
UdreamJob
Curated By

UdreamJob

Remote work & career advice that actually works.

Similar Opportunities