Data Analyst

This role is Hybrid - Applicants MUST BE LIVING IN THE Dallas - Fort Worth Texas area

Hum Cap'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.

• Design, build, and maintain reporting pipelines using DBT and Snowflake
  , transforming raw claims and operational data into clean, modeled datasets ready for analysis
• Develop and publish interactive dashboards and reports in Power BI and Omni
  , translating complex business questions into clear visual answers
• Write performant, well‑structured SQL across both Snowflake and SQL Server environments
• Partner with finance, operations, and compliance teams to define metrics, build scorecards, and deliver ad‑hoc analyses
• Own data quality — implement tests, validations, and monitoring to catch issues before stakeholders do
• Document data models, business logic, and metric definitions so the team can scale without tribal knowledge
• Contribute to the evolution of our analytics stack, tooling, and engineering practices

• 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

• 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 Dev Ops for version control and project management
• Exposure to Python for data transformation, automation, or scripting
• Understanding of revenue cycle, regulatory reporting, or compliance analytics

• 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 Dev Ops

You 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.

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