Senior BI Data Engineer

Soleo Health is seeking a Senior BI Data Engineer to design, build, and optimize scalable data and analytics solutions that empower business leaders with accurate, actionable insights. This role focuses heavily on business intelligence engineering, data modeling, and analytics enablement utilizing Azure cloud technologies and various BI tools.

Responsibilities:

• Data Platform Management: Design, build, and maintain scalable, efficient ETL/ELT data pipelines integrating data from multiple source systems (e.g., EMR, nursing, financial, CRM, and operational platforms)
• Cloud and Architecture: Build and manage modern data architectures leveraging Azure Cloud services (Azure Data Factory, Data Lake, Synapse) and Snowflake. Oversee schema design, data ingestion, and performance optimization
• Business Intelligence Engineering: Design and maintain semantic models, curated datasets, and analytics structures optimized for Power BI, Tableau, and self-service reporting initiatives
• Analytics Platform Enablement: Support and optimize BI and analytics platforms including Power BI, Tableau, Databricks notebooks, and Azure-based analytics services
• Data Modeling and Visualization Support: Develop scalable data models and reporting structures that improve analytics usability, dashboard performance, and business insights delivery
• Domain Data Modeling: Develop and maintain domain-driven data models that reflect business structures and relationships across key functional areas
• Data Marts and Consumption: Build and optimize business-unit-centric data marts that enable self-service analytics, data visualization, and decision support
• Integration and Interoperability: Design and implement integration patterns to unify data across structured and unstructured sources, APIs, and third-party systems
• AI and Advanced Analytics: Leverage large language models (LLMs) and other AI/ML techniques to analyze curated datasets, identify trends, and drive actionable insights
• Data Quality and Governance: Establish and maintain data validation, reconciliation, and governance processes to ensure accuracy, consistency, and compliance with security and regulatory requirements
• Automation and Monitoring: Automate data workflows and build proactive monitoring and alerting frameworks for data pipeline health and performance
• Visualization and Reporting: Design, develop, and optimize Power BI and Tableau dashboards, semantic models, and reporting solutions that deliver actionable executive and operational insights
• DevOps Enablement: Implement Azure DevOps and CI/CD practices for version control, testing, and automated deployment of data solutions
• Documentation and Collaboration: Maintain clear technical documentation for pipelines, data models, and architecture. Collaborate cross-functionally with business and technology teams to align data initiatives with strategic objectives

Requirements:

• Bachelor's degree in computer science, Information Technology, Engineering, Data Science, or a related field; master's degree preferred
• 5+ years of progressive experience as a Data Engineer, Data Platform Engineer, or similar data-focused role
• Strong experience with business intelligence and analytics platforms including Power BI, Tableau, semantic modeling, dashboard optimization, and analytics enablement
• Experience designing scalable data models and analytics structures to support enterprise reporting and self-service BI initiatives
• Strong experience designing and supporting Azure-based analytics and data architecture utilizing Azure Data Factory, Synapse, Data Lake, Databricks, and related cloud services
• Proficiency in SQL and scripting/programming languages such as Python and/or Scala
• Experience designing domain-driven data models and building business-unit-specific data marts for analytics and visualization
• Familiarity with data integration patterns across multiple enterprise systems (e.g., EMR, nursing, finance, CRM) and structured/unstructured data sources
• Working knowledge of Power BI, including semantic modeling, dataflows, and DAX optimization
• Experience working with Databricks notebooks and modern analytics engineering workflows
• Power BI administration experience, including workspace management, gateway configuration, security models, and governance practices