Engineer II, Business Intelligence

Posted 1hrs ago

Employment Information

Education
Salary
Experience
Job Type

Report this job

Job expired or something wrong with this job?

Job Description

BI Engineer II building enterprise Power BI reports and Azure data pipelines. Enabling data-driven decisions through scalable analytics, validation, optimization, and automation.

Responsibilities:

  • Design, develop, and maintain enterprise-grade Power BI reports, dashboards, and analytical solutions
  • Collaborate with stakeholders, product owners, and cross-functional teams to translate business requirements into scalable reporting solutions
  • Develop, test, deploy, monitor, and continuously improve reporting pipelines and data integration processes
  • Build and optimize ETL processes using Azure Data Factory, Databricks, SQL, and related technologies
  • Automate data collection, transformation, validation, and distribution processes
  • Perform data validation, reconciliation, and User Acceptance Testing to ensure report accuracy and quality
  • Investigate production issues, perform root cause analysis, and implement sustainable solutions
  • Develop and maintain strategic reports using data from multiple systems, databases, and platforms
  • Complete code reviews and peer reviews
  • Publish and maintain reporting solutions according to governance and publishing guidelines
  • Identify opportunities for automation, process improvement, and self-service reporting
  • Provide technical guidance and mentorship to junior BI engineers and analysts
  • Participate in Agile ceremonies including sprint planning, grooming, estimation, and retrospectives
  • Communicate project status, risks, dependencies, and delivery timelines to stakeholders

Requirements:

  • 3–6 years of experience stated for the role
  • Strong experience in Power BI report development, including advanced DAX and semantic model design
  • Proficiency in SQL development, including complex and optimized queries
  • Experience with Azure Data Factory, Azure Databricks, and Azure Data Platform services
  • Knowledge of data modeling principles, dimensional modeling, and data warehouse design
  • Experience with Python, Spark SQL, or similar technologies for data processing and automation
  • Strong understanding of ETL design patterns and best practices
  • Practical knowledge of SDLC methodologies, Agile development practices, and DevOps concepts
  • Strong analytical, problem-solving, and troubleshooting skills
  • Excellent written and verbal communication skills
  • Ability to manage multiple priorities in a fast-paced environment
  • Preferred: Microsoft Azure Certifications related to Data Engineering, Analytics, or Power Platform
  • Preferred: Experience with API development, integration, and data consumption
  • Preferred: Knowledge of healthcare revenue cycle management and healthcare analytics
  • Preferred: Experience with Azure DevOps, Git, and CI/CD practices
  • Preferred: Familiarity with Visual Studio Code and PowerShell scripting
  • Preferred: Experience with performance tuning and optimization for large-scale datasets
  • 2+ years of experience developing Power BI reports and dashboards in an enterprise environment
  • 2+ years of experience with relational databases and advanced T-SQL development
  • 2+ years of experience with Azure Data Factory, Azure Databricks, or equivalent cloud data technologies
  • 2+ years of experience designing and implementing ETL/ELT solutions
  • Experience building scalable semantic models and optimized reporting solutions
  • Experience troubleshooting and resolving production reporting and data issues
  • Experience conducting data validation, reconciliation, and quality assurance activities
  • Healthcare Revenue Cycle Management experience preferred

Benefits:

  • Full-time employment