Engineer II, Business Intelligence

This is a fully remote position, open to applicants in India.

📋 Description

• Create, develop, and sustain enterprise-level Power BI reports, dashboards, and analytical solutions.

• Work collaboratively with stakeholders, product owners, and cross-functional teams to convert business requirements into scalable reporting solutions.

• Design, test, implement, monitor, and continuously enhance reporting pipelines and data integration processes.

• Construct and refine ETL processes utilizing Azure Data Factory, Databricks, SQL, and related technologies.

• Automate data collection, transformation, validation, and distribution workflows.

• Execute data validation, reconciliation, and User Acceptance Testing to guarantee report accuracy and quality.

• Investigate production issues, conduct root cause analysis, and implement sustainable solutions.

• Develop and maintain strategic reports leveraging data from various systems, databases, and platforms.

• Conduct code reviews and peer assessments.

• Publish and uphold reporting solutions in accordance with governance and publishing standards.

• Recognize opportunities for automation, process enhancement, and self-service reporting.

• Offer technical guidance and mentorship to junior BI engineers and analysts.

• Engage in Agile ceremonies such as sprint planning, grooming, estimation, and retrospectives.

• Communicate project status, risks, dependencies, and delivery timelines to stakeholders.

⛳️ Requirements

• 3–6 years of experience relevant to the role.

• Extensive experience in Power BI report development, encompassing advanced DAX and semantic model design.

• Proficient in SQL development, including complex and optimized queries.

• Familiarity with Azure Data Factory, Azure Databricks, and Azure Data Platform services.

• Understanding of data modeling principles, dimensional modeling, and data warehouse architecture.

• Experience with Python, Spark SQL, or similar technologies for data processing and automation.

• Solid grasp of ETL design patterns and best practices.

• Practical experience with SDLC methodologies, Agile development practices, and DevOps concepts.

• Strong analytical, problem-solving, and troubleshooting capabilities.

• Exceptional written and verbal communication skills.

• Ability to juggle multiple priorities in a dynamic environment.

• Preferred: Microsoft Azure Certifications linked 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 in performance tuning and optimization for large-scale datasets.

• 2+ years of experience in 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 in designing and implementing ETL/ELT solutions.

• Experience in building scalable semantic models and optimized reporting solutions.

• Experience in troubleshooting and resolving production reporting and data issues.

• Experience in conducting data validation, reconciliation, and quality assurance activities.

• Healthcare Revenue Cycle Management experience is preferred.

🏝️ Benefits

• Full-time employment.