Senior Software Engineer, PowerBI

Lyric is an AI-first, platform-based healthcare technology company, committed to simplifying the business of care by preventing inaccurate payments and reducing overall waste in the healthcare ecosystem, enabling more efficient use of resources to reduce the cost of care for payers, providers, and patients. Lyric, formerly ClaimsXten, is a market leader with 35 years of pre-pay editing expertise, dedicated teams, and top technology. Lyric is proud to be recognized as 2025 Best in KLAS for Pre-Payment Accuracy and Integrity and is HI-TRUST and SOC2 certified, and a recipient of the 2025 CandE Award for Candidate Experience. Interested in shaping the future of healthcare with AI? Explore opportunities at lyric.ai/careers and drive innovation with #YouToThePowerOfAI.

Job Summary
We are seeking a skilled Power BI Engineer with strong experience in designing and delivering interactive dashboards, reports, and data models. This role requires expertise in Power BI and familiarity with other open-source visualization tools (such as Plotly, Dash, or Apache Superset), along with a solid background in data analysis and data modeling. You will work closely with business stakeholders, data engineers, and analysts to transform raw data into actionable insights.

Job Responsibilities

• Dashboard & Report Development
  • Design, develop, and maintain Power BI dashboards and reports for business intelligence and analytics.
  • Implement advanced DAX calculations, measures, and KPIs for complex business logic.
  • Create data models and optimize relationships for performance and scalability.
• Data Integration & Transformation
  • Connect Power BI to various data sources (SQL Server, Snowflake, Databricks, APIs).
  • Perform data cleansing, transformation, and enrichment using Power Query and M language.
  • Collaborate with data engineering teams to ensure efficient data pipelines and refresh strategies.
• Visualization & Storytelling
  • Deliver compelling, user-friendly visualizations that communicate insights effectively.
  • Explore and implement open-source visualization frameworks (Plotly, Dash, Apache Superset) for custom analytics needs.
  • Apply best practices for UI/UX in dashboards and reports.
• Performance Optimization
  • Optimize Power BI datasets for large-scale data (DirectQuery, Aggregations, Incremental Refresh).
  • Monitor and improve report performance and query execution times.
• Data Analysis & Insights
  • Conduct exploratory data analysis to identify trends, anomalies, and actionable insights.
  • Partner with business teams to define metrics, KPIs, and analytical requirements.
• Governance & Security
  • Implement row-level security (RLS) and manage access controls.
  • Ensure compliance with organizational data governance and security standards.

Required Qualifications

• 5–7 years of experience in BI development and data visualization.
• Strong expertise in Power BI (DAX, Power Query, data modeling, performance tuning).
• Proficiency in SQL for data extraction and transformation.
• Hands-on experience with Python for data analysis and visualization (e.g., Pandas, Plotly).
• Familiarity with open-source visualization tools (Dash, Plotly, Apache Superset).
• Solid understanding of data warehousing concepts and ETL processes.
• Exposure to cloud platforms (Azure preferred) and integration with Power BI Service.
• Strong analytical and problem-solving skills with attention to detail.

Preferred Qualifications

• Experience with Snowflake, Databricks, or other modern data platforms.
• Knowledge of Azure Data Factory (ADF) or similar orchestration tools.
• Familiarity with CI/CD for BI assets and version control (Git).
• Understanding of data governance frameworks and compliance standards.
• Contributions to BI communities, blogs, or open-source projects.