Data Engineer

HumCap’s client is looking for an Analytics / Reporting Engineer to join the Enterprise Reporting team. You’ll build and maintain the data pipelines, dashboards, and reporting infrastructure that drive decision-making across the business. This is a hands-on role -you’ll write SQL, build models, design reports, and work directly with stakeholders who depend on accurate, timely data.What You’ll DoDesign, build, and maintain reporting pipelines using dbt and Snowflake, transforming raw claims and operational data into clean, modeled datasets ready for analysisDevelop and publish interactive dashboards and reports in Power BI and Omni, translating complex business questions into clear visual answersWrite performant, well-structured SQL across both Snowflake and SQL Server environmentsPartner with finance, operations, and compliance teams to define metrics, build scorecards, and deliver ad-hoc analysesOwn data quality -implement tests, validations, and monitoring to catch issues before stakeholders doDocument data models, business logic, and metric definitions so the team can scale without tribal knowledgeContribute to the evolution of our analytics stack, tooling, and engineering practicesWhat We’re Looking ForRequired3+ years of experience in analytics engineering, BI development, or a similar data-focused roleStrong SQL skills -you can write complex queries with CTEs, window functions, and set-based logic without leaning on cursors or temp tablesHands-on experience with Snowflake (warehousing, performance tuning, schema design)Experience building and maintaining dbt models (staging, intermediate, mart layers;tests;documentation)Proficiency with Power BI (data modeling, DAX measures, report design, publishing)Experience with Omni or similar modern BI/semantic layer toolsComfort working with healthcare data concepts (claims, CPT codes, payer/provider relationships) or willingness to learn quicklyClear communicator who can explain data findings to non-technical stakeholders without jargonPreferredExperience with Claude (Anthropic’s AI assistant) for accelerating analytics workflows -prompt engineering, code generation, document analysis, or building AI-augmented reporting toolsFamiliarity with MCP (Model Context Protocol) integrations or AI-assisted development environmentsBackground in healthcare dispute resolution, arbitration, or insurance claims processingExperience with Azure DevOps for version control and project managementExposure to Python for data transformation, automation, or scriptingUnderstanding of revenue cycle, regulatory reporting, or compliance analyticsWhat You’ll Work WithData Warehouse: Snowflake (CORE.REPORTING schema and related layers)Databases: SQL Server (multiple environments)Modeling: dbt (Cloud or Core)BI & Visualization: Power BI, OmniAI Tooling: Claude Desktop, Claude Code, MCP server integrationsProject Management: Azure DevOpsWhy This RoleYou won’t be maintaining dashboards someone else designed three years ago. You’ll be building the reporting infrastructure for a fast-moving healthcare analytics operation, working with modern tools, and integrating AI into real workflows -not as a gimmick, but as a daily productivity multiplier. If you like solving hard data problems and shipping things that people actually use, this is the role.Benefits:Competitive salaryHybrid work environmentMedical, dental, and vision insurance401K matching programPTO

• 3+ years of experience in analytics engineering, BI development, or a similar data-focused role
• Strong SQL skills -you can write complex queries with CTEs, window functions, and set-based logic without leaning on cursors or temp tables
• Hands-on experience with Snowflake (warehousing, performance tuning, schema design)
• Experience building and maintaining dbt models (staging, intermediate, mart layers;tests;documentation)
• Proficiency with Power BI (data modeling, DAX measures, report design, publishing)
• Experience with Omni or similar modern BI/semantic layer tools
• Comfort working with healthcare data concepts (claims, CPT codes, payer/provider relationships) or willingness to learn quickly
• Clear communicator who can explain data findings to non-technical stakeholders without jargon

Preferred

• Experience with Claude (Anthropic’s AI assistant) for accelerating analytics workflows -prompt engineering, code generation, document analysis, or building AI-augmented reporting tools
• Familiarity with MCP (Model Context Protocol) integrations or AI-assisted development environments
• Background in healthcare dispute resolution, arbitration, or insurance claims processing
• Experience with Azure DevOps for version control and project management
• Exposure to Python for data transformation, automation, or scripting
• Understanding of revenue cycle, regulatory reporting, or compliance analytics

What You’ll Work With

• Data Warehouse: Snowflake (CORE.REPORTING schema and related layers)
• Databases: SQL Server (multiple environments)
• Modeling: dbt (Cloud or Core)
• BI & Visualization: Power BI, Omni
• AI Tooling: Claude Desktop, Claude Code, MCP server integrations
• Project Management: Azure DevOps

• Competitive salary
• Hybrid work environment
• Medical, dental, and vision insurance
• 401K matching program
• PTO